Variable in Vertica using Toad data point

SlaaghSlaagh Registered User


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.