I am checking how BTEQ works in ANSI mode and so below is my BTEQ script,
.set session transaction ANSI;
.run file e:\jedi_logon\mvn.ctl;
select * from jedi_mvn_db.zam_employee
But when i run this script, it is not displaying any data in LOG file but instead it is throwing returncode error as below,
*** You are now logged off from the DBC.
*** Exiting BTEQ...
*** RC (return code) = 8...
Please help me in this.
how did you call that script?
There's STDOUT and STDERR, seems like there was a problem with your logon script, which is send to STDERR.