Variable in Vertica using Toad data point

Slaagh

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

Jim_Knicely

Hi,

I used to use TDP (Freeware) when working with Oracle

Did you try using a colon in front of a variable name instead of a @ symbol?

See:
http://www.toadworld.com/products/toad-data-point/b/weblog/archive/2013/07/24/toad-data-point-automation-series-blog-12-variables

Fyi... A better GUI tool for Vertica (IMHO) is DbVisualizer...

See:
https://www.vertica.com/partner/db-visualizer/

Slaagh

Hi Jim,

Thanks for your response. I will try DB Visualizer.