Bteq didn't give error message

Tools

Bteq didn't give error message

Hi everyone,

We are calling stored procedure from bteq, sometimes it exits with bteq exit code 8 but it doesn't give any error messages.

Here is the bteq log:

.logon TD_2700/TPTLoader,

 *** Logon successfully completed.

 *** Teradata Database Release is 14.00.03.03

 *** Teradata Database Version is 14.00.03.03

 *** Transaction Semantics are BTET.

 *** Session Character Set Name is 'ASCII'.

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

call  TRANSFORM_GN(136914);

 *** Total elapsed time was 45 seconds.

+---------+---------+---------+---------+---------+---------+---------+----

.LOGOFF

 *** You are now logged off from the DBC.

+---------+---------+---------+---------+---------+---------+---------+----

.EXIT

 *** Exiting BTEQ...

 *** RC (return code) = 8

BTEQ 14.00.00.05 Fri Aug 30 00:53:41 2013

1 REPLY

Re: Bteq didn't give error message

When I queried from qrylog table for error code, it gave partition violation error but we couldn't see the error in bteq session.