How to setup variables in Vertica

sau7590 · February 2017

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

[Deleted User] · February 2017

Check this link :
https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/ConnectingToHPVertica/vsql/Meta-Commands/setNAMEVALUE....htm?Highlight=variable

We're Moving!

Create My New Community Account Now

How to setup variables in Vertica

Comments

Leave a Comment