Variable in Vertica using Toad data point
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.
Any help would be greatly appreciated.