The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How to setup variables in Vertica
I am basically trying to convert SAS code which hits vertica to SQL queries understood by vertica..
Can someone help me know how to store values in variable.Note:i am using Squirrel SQL to write my vertica understanble SQL queries.Trying to convert
%LET RUNOUT = 0;
%LET PERIODS = 4;
%let ENRLMNTDY = 15;
%LET RUN_DATE = %SYSFUNC(TODAY());
%LET START_DATE = %SYSFUNC(INTNX(MONTH, &RUN_DATE.,%EVAL(-12*&PERIODS.-&RUNOUT.),B));
%LET END_DATE = %SYSFUNC(INTNX(MONTH, &RUN_DATE.,%EVAL(-1-&RUNOUT.),E));
to variables in vertica
0
Comments
Check this link :
https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/ConnectingToHPVertica/vsql/Meta-Commands/setNAMEVALUE....htm?Highlight=variable