Archives of the TeradataForum

Message Posted: Mon, 17 Mar 2003 @ 22:47:12 GMT

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

Is there anyway I can capture the ACTIVITYCOUNT and ERRORCODE from BTEQ and INSERT it as values into another table?

My BTEQ is running a SQL Script. All SQL statements in the script are for INSERT and UPDATE. After every insert/update statement, I have an INSERT into a status table. I want to INSERT the ACTIVITYCOUNT and ERRORCODE from the execution of Previous Statement into my status table.

Is there a way?

Thanks in advance...

Ganga Palakattil

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