Re: Get Auto Increment Values After SQL Insert in the same command

["Raul A. Jager W." <raul@xxxxxxxxxx>]

Thank you Birgitta

Birgitta Hauser wrote:
> You'll always get the id f the current level, that means if another job
> inserts an other row into the same table, you'll get your Id while the other
> job gets its Id.
>
> Even if a trigger is activated that insert a row in the same table in the
> same job it will work correctly because the trigger gets a new level. 
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
>
> -----Ursprüngliche Nachricht-----
> Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
> Auftrag von Raul A. Jager W.
> Gesendet: Tuesday, 27. July 2010 15:05
> An: RPG programming on the IBM i / System i
> Betreff: Re: AW: Get Auto Increment Values After SQL Insert in the same
> command
>
> Curiosity: Will it still give the correct value if other jobs writes to
> the file between my write and my "select value..."?
>
> Birgitta Hauser wrote:
> > It even works if the previous statement was a WRITE-Statement (to a file
> > with an identity column) with native I/O.
> >
> > Mit freundlichen Grüßen / Best regards
> >
> > Birgitta Hauser
> >
> > "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> > Brown)
> > "If you think education is expensive, try ignorance." (Derek Bok)
> > "What is worse than training your staff and losing them? Not training them
> > and keeping them!"
> >
> > -----Ursprüngliche Nachricht-----
> > Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> Im
> > Auftrag von Dr. Stefano Mirenda
> > Gesendet: Tuesday, 27. July 2010 09:55
> > An: rpg400-l@xxxxxxxxxxxx
> > Betreff: RE: Get Auto Increment Values After SQL Insert in the same
> command
> > Thank for all.
> > I  had used the  " Exec Sql values IDENTITY_VAL_LOCAL() into :myInserId; "
> > solution .
> >
> > I did not know that this solution worked like a single atomic statement.
> >
> >
> >
> > --------------------------------
> > Dott. Stefano Mirenda
> > Cell. +393338736049
> > --------------------------------