AW: Using DataStructure in Update Query in RPG ?

["Hauser, Birgitta" <Birgitta.Hauser@xxxxxxxxxxx>]

Assuming you want to update the complete row and your data structure
contains all columns of the table in the right sequence, you may try the
following:

Update MySchema/MyFile
   Set Row = :MyDS
Where ....

You must be at least on release V5R3M0.

Birgitta

"If you think education is expensive, try ignorance"
(Derek Bok)
 
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Luqman
Gesendet: Dienstag, 18. April 2006 10:25
An: midrange-l@xxxxxxxxxxxx
Betreff: Re: Using DataStructure in Update Query in RPG ?

Yes, I am asking for Update SQL to use with Data Structure.

Best Regards,

Luqman


"Dave Odom" <Dave.Odom@xxxxxxxxxxxx> wrote in
message news:s443c29a.099@xxxxxxxxxxxxxxxxxxxxxxxxx
> Luqman,
>
> You wrote:
>
> >> I can use datastructure with Insert Query like this.
>
> Insert into myTable Values(:myDS)
>
> How can I use this datastructure for update query.<<
>
> Did you need help with an UPDATE SQL statement or something RPG?   What
> you wrote was not RPG but SQL.  If you need help with an SQL UPDATE
> statement let me know.   I'll also guide you to IBM online books on the
> subject so you'll know the four basic SQL verbs and how to put together
> their predicates.
>
> Dave Odom
> Arizona
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email:
MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>