 |
 |
Archives of the TeradataForum
Message Posted: Wed, 26 Jul 2006 @ 21:58:57 GMT
| Subj: | | Re: Macro call from JDBC for Tactical Queries |
| |
| From: | | McCall, Glenn David |
| | To skip empty result-set one quick way is to find-out number of columns in the current result-set. ODBC has a function SQLNumResultCols()
which can return number of result-set columns, if it returns 0 then you can skip to next result-set. | |
For interest, in JDBC the Statement.getMoreResults () does 2 things.
1) Move to the next resultSet and
2) returns true or false to indicate whether this (new) result set is a ResultSet (i.e. data) or an activity count (eg. # rows
deleted).
Glenn Mc
| |
