Archives of the TeradataForum

Message Posted: Wed, 16 May 2012 @ 14:21:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Is it possible to use the ErrorCode and ActivityCount within Bteq, other than with an IF statement ?

Rather than just something like :

     ".If ErrorCode <> 0 Then .Exit 12;"

I'd like to use the values to audit how many rows have been affected by a particular Sql Statement.

     ----------------------------------------------------
     INSERT INTO DEVCOADMIN_V.CORCOV01
      .....
     ,CON_SHIPPER_TYP_CD
     ,CON_ROW_UPDT_TD
      FROM CORCOW02 WRK2
     WHERE NOT EXISTS
      (SELECT 1 FROM DEVCOADMIN_V.CORCOV01 TGT1
       WHERE TGT1.CON_ID= WRK2.CON_ID
     ) ;

      *** Insert completed. No rows added.
      *** Total elapsed time was 1 second.

     INS INTO  DEVGTT_T.LOAD_LOG_GTT VALUES
     ('CORCOT01',ERRORCODE,ACTIVITYCOUNT,CURRENT_TIMESTAMP(0));
      *** Failure 5628 Column ERRORCODE not found in DEVGTT_T.LOAD_LOG_GTT.
                     Statement# 1, Info =0
     ----------------------------------------------------

It looks to me as though the ERRORCODE and ACTIVITYCOUNT can only be used for decision making but the actual number of rows affected (i.e. ACTIVITYCOUNT) cannot be used within the script.

Am I right ?

Regards

David Clough
Senior Database Designer
Database Design Group

	<Prev	Next>		<<First	<Prev	Next>	Last>>