Archives of the TeradataForum

Message Posted: Fri, 01 Nov 2002 @ 13:07:37 GMT

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

Hi All,

I'm using BTEQ to load data to the warehouse with bteq functionality for error handling. I also would like to store this information in audit tables in the warehouse.

For example:

.LOGON TERA101,BMG

DATABASE MARKET;

INSERT INTO INDIVIDUAL
SELECT
 *
FROM
INDEV

.IF ERRORCODE <> 0 THEN .GOTO FAILRUN

***********************************************************************
.LABEL THEEND
*** THE jOB completed SUCCESSFULLY

.QUIT 0

.LABEL FAILRUN
**************
.QUIT 99

For instance, I would like to insert the ERRORCODE and ACTIVITYCOUNT value to an Audit table.

I can do this within a stored procedure, would this be also possible within a BTEQ script.

Would much appreciate any help on this.

Best regards,

Ganesh

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