Archives of the TeradataForum

Message Posted: Tue, 21 Aug 2007 @ 13:12:36 GMT

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

What tool are you using?

SQL Assistant? The row count is in the history which is an MS-Access database.

Bteq? The activity count is output to standard output. If you save the bteq output, you can extract it using regular expressions (e.g. perl). A program you have written (e.g. ODBC/JDBC) the activity count is typically returned from the call that submits the query.

No table stores such information unless you first perform a select count(*) and insert that into a table prior to running the delete.

Hope this helps

Glenn Mc

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