Variables and Bteq

Database

Variables and Bteq

How can I do to declare variable into bteq like a MLOAD?
Exemple: With the mload utility I make:
.ACCEPT VARIABLE1, VARIABLE2
FROM FILE FILE_XXXX;
2 REPLIES

Re: Variables and Bteq

You can't, but you can use the IMPORT statement to import the fields into a volatile table. You can then join in your volatile table to get the values.

Re: Variables and Bteq

Also if you are running on Unix/Linux Systems, it's popular to use the HERE document feature of shell to expand variables ...