 |
 |
Archives of the TeradataForum
Message Posted: Wed, 05 Nov 2003 @ 16:53:50 GMT
| Subj: | | Re: How does queryman calculates the total number of rows? |
| |
| From: | | Dieter Noeth |
| | How does queryman calculates the total number of rows to display in the status bar ?? I guess we need to have another
count(*) query to get such an info from teradata. | |
| | Is this count from queryman a guess based on random samples or what ? | |
There's an ODBC function: SQLRowCount
From ODBC user guide:
"SQLRowCount returns the number of rows affected by an UPDATE, INSERT, or DELETE statement. After an SQLExecute or
SQLExecDirect, SQLRowCount can be called to get the DBC Activity count for any type of SQL statement, even for SELECT
statements."
Dieter
| |
