How would you execute the BTEQ?

Consider a BTEQ script contains the following code in it.

    .logon tpid/user, pass; /* Login credentials */
    SEL  * FROM tab_a; /* Query */
    .quit
You can submit the bteq script in batch mode by .RUN FILE command.

 .RUN FILE = BTEQfile.btq

At unix prompt,Please execute in the below way.

$Sh>BTEQ<[Script Path]>[Logfile Path]
or
$Sh>BTEQ<[Script Path]| TEE [Logfile Path]

1 comments:

store bteq script in .sh file

and go to that bteq path

and run . sh file example sh < bteq1.sh

Reply

Post a Comment