Archives of the TeradataForum
Message Posted: Sat, 22 Jan 2005 @ 15:18:36 GMT
| Subj: || || Re: Storing Errorcode from BTEQ into table |
| From: || || Geoffrey Rommel |
| ||I am trying to store the errorcode generated by BTEQ into a table. Is it possible?|| |
No. Annoying, isn't it?
You could get around this temporarily by writing a C program with embedded SQL, or a Perl program with DBD::ODBC or DBD::Teradata. These
interfaces will allow you to capture the errorcode and activitycount and do whatever you wish with them. This question comes up pretty often, so,
in the long run, an enhancement to BTEQ is called for.