How to read a variable in bteq

Database

How to read a variable in bteq

Hi All,

In Windows I have .bat file which generates some variables,how can i assign this variables in bteq

In unix i knew that we can assign using $ inside bteq scripts
4 REPLIES
N/A

Re: How to read a variable in bteq

Can you please try refering the variables as %VARIABLE_NAME% in windows

Re: How to read a variable in bteq

Hi,

With in .bat file we can read the variable as u mentioned %variable%,I want to read the same variable with in bteq.

I am calling the bteq in batch file..

Naidu
N/A

Re: How to read a variable in bteq

will this do?

.SET varName TO %Val1%;

In bteq use &varname to refer val1.

Where tbl1.col1=&varname;

Re: How to read a variable in bteq

Hi Bhanu,

I have tried with & also it didnt work..