Hello,
I have a SQL Server function that I need to convert to Vertica. The function is using variables to parse and build pieces of a URL string. I see that variables can be created using VSQL in cmd shell, but I am not a Unix guy so this will be challenging and I do not have time to learn Unix shell scripting, since I have a tight deadline with this migration.
I there a way to create variables in Toad data point? I have converted a lot of SQL Stored procedures into Views using TDP, so I was hoping to do the same using a function containing variables and substrings.
I tried...
set var @MyVariable varchar(50)
set variable MyVariable varchar(50)
/set var @myvar MyVariable varchar(50)
Any help would be greatly appreciated.
Dave
