BTEQ in ANSI mode

Database
Enthusiast

BTEQ in ANSI mode

Hi,

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

;

.QUIT

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.

2 REPLIES
Enthusiast

Re: BTEQ in ANSI mode

Hi,

Please anyone reply to my query.

Senior Apprentice

Re: BTEQ in ANSI mode

Hi Mahesh,

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.

Dieter