I want to use shell variables in bteq commands and shell commands in bteq script. e.q create table $variable (some xyz column list); and some sort of shell commands within bteq scripts.
So can you please assit me in doing it.
you may just use a 'Here-script'
create table $variable ( some xyz column list);
all UNIX-variables will be expanded before giving the text to bteq.
Hope it helps
ULICKERT : great help on this, was kinda blocked and didnt think of creating a variable for .logon command.
(that you forgot to call under your bteq command )