Re: Embedded SQL question

[Jose Santana <jsantana@xxxxxxxxxxxxx>]

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 
>