Re: how to insert no of rows effected by a sql stmt in bteq script into a table with in the same script
Did some research on this. Could not find out any way to do this in BTEQ. activitycount indicates the actual number of rows affected by the request. But we can not use that in any SQL. It can just be used in "IF" statement to verify its value.
May be someone can suggest if we have any other alternative to solve this problem.