Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.