Skip to main content

passing variables command line - from Windows VSQL client

  • September 9, 2014
  • 1 reply
  • 7 views
Srivatsan
Forum|alt.badge.img+1
my runnQuery.bat file contents
vsql -U user -w pwd -h host-p 5433  -v numvar=3 -f runSQL.sql

runSQL.sql contents
\o sqlOutput
select * from table where a=:numVar;
\o

C:\L>runnQuerypassArgs.bat
vsql:runSQL.sql:3: ERROR 4856:  Syntax error at or near ":" at character 48
vsql:runSQL.sql:3: LINE 1: select * from omniture_new.dynamic_sql where a=:numVar;
vsql:runSQL.sql:3:                                                        ^

This works well in UNIX but i am not able to get this working in Windows. Can someone please suggest any ideas? 

Also, how do i pass in multiple variables to the same SQL file?


    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • September 9, 2014

    Hello Srivatsan,

    What is the content of your "runnQuerypassArgs.bat?"

    I tested a batch file that is very similar to yours, and it worked fine.

    Here is my .bat file:

    "C:\Program Files\Vertica Systems\bin\vsql" -U dbadmin -w password -h xx.xx.xx.xx -d gr_test2 -v var1=5 -f c:\data\bat\test.sql

    and here is my test.sql file:

    select * from public.n where i = :var1;

    I also tried to pass 'var1' as an argument like this:

    "C:\Program Files\Vertica Systems\bin\vsql" -U dbadmin -w password -h 10.50.50.71 -d gr_test2 -v var1=%1 -f c:\data\bat\test.sql

    then call the batch file from command prompt:

    myvsql 5

    and it worked fine too.

    Since the .sql file doesn't take any parameter, I haven't found a way to pass multiple argument to it.


    Regards,
    Han

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement