Re: Rows affected?

Posted in 2005

Darren_Jacobs@carmax.com — Thu, 10 Mar 2005 16:45:50 -0500 — source: Usenet: comp.databases.informix

This is a multipart message in MIME format. --=_alternative 00778DD785256FC0_= Content-Type: text/plain; charset="US-ASCII" Thanks for the responses. I greatly appreciate it. "rkusenet" <usenet.rk@gmail.com> 03/10/2005 03:17 PM To <Darren_Jacobs@carmax.com> cc Subject Re: Rows affected? select dbinfo('sqlca.sqlerrd2') from systables where tabid = 1 will tell you how many rows were affected by the last updates/deletes. Not sure about insert though. <Darren_Jacobs@carmax.com> wrote > Greetings, > > I have an application (Power Builder) that us being used to make > inserts,updates, and deletes and the user would like to know how many rows > were affected by one of these operations. Is there a way to capture the > "rows affected" and return it to the application? (ie, similar to what is > returned if using Sql Editor) > > Info window in Sql Editor > -- Executing selected SQL statements in Untitled.sql. > update backup_log_tbl set success_failed = "failed" > where complete_dt < "2004-04-30 00:00:00.000";> -- 10 rows updated. > > > IDS 9.40 FC2 > HPUX 11 --=_alternative 00778DD785256FC0_= Content-Type: text/html; charset="US-ASCII" Thanks for the responses. I greatly appreciate it. <table width=100%> <tr valign=top> <td width=40%>"rkusenet" <usenet.rk@gmail.com> 03/10/2005 03:17 PM <td width=59%> <table width=100%> <tr> <td> <div align=right>To</div> <td valign=top><Darren_Jacobs@carmax.com> <tr> <td> <div align=right>cc</div> <td valign=top> <tr> <td> <div align=right>Subject</div> <td valign=top>Re: Rows affected?</table> <table> <tr valign=top> <td> <td></table> </table> <tt>select dbinfo('sqlca.sqlerrd2') from systables where tabid = 1 </tt> <tt>will tell you how many rows were affected by the last updates/deletes. Not sure about insert though. </tt> <tt><Darren_Jacobs@carmax.com> wrote </tt> <tt>> Greetings, > > I have an application (Power Builder) that us being used to make > inserts,updates, and deletes and the user would like to know how many rows > were affected by one of these operations.  Is there a way to capture the > "rows affected" and return it to the application?  (ie, similar to what is > returned if using Sql Editor) > > Info window in Sql Editor > -- Executing selected SQL statements in Untitled.sql. > update backup_log_tbl set success_failed = "failed" > where complete_dt < "2004-04-30 00:00:00.000"; > -- 10 rows updated. > > > IDS 9.40 FC2 > HPUX 11</tt> --=_alternative 00778DD785256FC0_=-- sending to informix-list