Archives of the TeradataForum
Message Posted: Thu, 16 Mar 2006 @ 18:28:19 GMT
We have a bteq, which performs insertion.
Number of rows inserted is supposed to be inserted into a log table
How to capture the activity count of the first insert statement in the same bteq?
// Some other operation..// INSERT INTO Table1 SELECT Col1,COL2 FROM Table2 WHERE
Please suggest how to capture the no of rows inserted by the first insert statement, without coming outa bteq.
In MLOAD we have &SYSINSCNT for this, but this sys variable is invalid in BTEQs.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|