Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

EXEC SQL INQUIRE_SQL - DB2 conversion from Ingres

17 views
Skip to first unread message

Carrie Marchant

unread,
Feb 8, 2002, 4:32:42 PM2/8/02
to
Hello,

I am currently converting multiple programs from Ingres to DB2. Most
are using the INQUIRE_SQL feature to check number of rows updated,
deleted or inserted into the tables. Does anyone know the syntax for
DB2 or if there is a similiar feature?

Syntax is as follows:

EXEC SQL INQUIRE_SQL (:variablename = rowcount);

Thanks,
Carrie Marchant
System Engineer
EDS - Vermont XIX
312 Hurricane Lane Suite 101
Williston, Vermont 05495

+ mailto:carrie....@eds.com

| --- _~o |
| --- _ \<,_ |
| --- ( )/ ( ) |

0 new messages