Re: Using DataStructure in Update Query in RPG ?

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

I see the "set row" that birgitta mentions at V5R1 - have not tried 
it with a host structure

At 03:25 AM 4/18/2006, you wrote:

> 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.
> >
> >
>
>
>
> --
> 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.