Re: Embedded SQL question

Thanks Don and Mark for your answers


Donald Whittaker wrote:

This number of rows updated is returned in field

SQLERRD(3) of SQLCA (the SQL Communications Area). Check out "DB2 Universal Database for iSeries SQL

Programming with Host Languages" (or go into debug).

HTH,
Don

--- Jose Santana <jsantana@xxxxxxxxxxxxx> wrote:

I'm running the following statement:

c/exec sql c+ update myfile set fieldB =:Var1, fieldC =:Var2,

c+ where fieldA =:someVar c/end-exec Is there a way that I can obtain the number of records updated after this statement is executed?

Jose

--
This is the RPG programming on the AS400 / iSeries
(RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the
archives
at http://archive.midrange.com/rpg400-l.

__________________________________________________
Do You Yahoo!?

Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com