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]How would you execute the BTEQ?
in
Teradata Interview Questions
- on 03:25
- 1 comment

1 comments:
store bteq script in .sh file
Replyand go to that bteq path
and run . sh file example sh < bteq1.sh
Post a Comment