 |
 |
Archives of the TeradataForum
Message Posted: Mon, 07 Apr 2003 @ 17:59:39 GMT
| Subj: | | Re: Showing or capturing count of updated rows to user |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Monday, April 07, 2003 13:46 -->
| | If Complex Query updations are going on in bteq, Can anybody suggest as how to get the number of rows updated shown to the user other
than the outputted log in plain English. | |
| | >The idea is to capture the same and insert it into a table containing events happening in a database. | |
Run bteq from perl or python or ksh, capture the output, insert activitycount into the other table.
Or capture activitycount in a bteq notify exit (event 44, fetch start) and then write it to a file or perform an SQL insert. Say ".set
notify high". Or write a program with embedded SQL to do the original update, take the activity count from the SQLCA, and perform the
insert to the events table.
Watch out... the activity count is an integer, so if it goes above 2**31 it won't be accurate.
| |
