BTEQ Problem

Tools
N/A

BTEQ Problem

Hi All,
I am new to this forum.
I want to execute SQL queries from bteq based on Command Line arguments.
i.e I have several SQL queries in file but only one with execute based on Input paramter to file.
I tried using if and case statements. If the condition satisfies than the bteq login will happen and SQL query will be executed, but it looks like bteq login is not possible using if/case conditional statements.
Is it possible to execute a particular SQL query based on Input parameter passed to the file like if i pass 1 it will execute 1st query, if i pass 2 it will execute 2nd query and so on ...
Kindly help.

1 REPLY
SN
N/A

Re: BTEQ Problem

hi,

consider using a stored procedure instead.

thx,