Re: How do I use a sql insert statement taking values from a data structure

[Jose Perez <joseenocperez.jp@xxxxxxxxx>]

I believe what you have wrong is (:ds(:Count).flda it should be
:DS.count.FLDA, :DS.count.FLDB, :DS.count.FLDC

On Thu, Jun 22, 2017 at 4:40 PM, DFreinkel <dfreinkel@xxxxxxxxxxxxxxxxx>
wrote:

> I need to convert a multi dimensional data structure into a file
>
> I am using
>
> Insert into table
> ( flda , fldb, fldc)
> Values( :ds(:count).flda,
> :ds(:count).fldb,
> :ds(:count).fldc
> );
>
> The editor and compiler do not like this
>
> How do I do the coding without moving the occurs to a simple data
> structure which is then loaded into the insert
>
> TIA
>
> Darryl Freinkel
> --
> This is the RPG programming on the IBM i (AS/400 and 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD