Archives of the TeradataForum
Message Posted: Fri, 07 Jan 2005 @ 22:01:17 GMT
| Subj: | | Re: Return Code 8 |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Friday, January 07, 2005 15:36 -->
| | If you can't find STDERR, look for the first statement that doesn't have a typical success/activity count message. | |
Normally, when a SQL statement in BTEQ executes sucessfully, you will see something like:
*** Insert completed. One row added.
*** Total elapsed time was 1 second.
But, when an error occurs, all you will see is the time portion:
*** Total elapsed time was 1 second.
So, scan through the log and look for any "orphan" elapsed time statements.
| 
