Re: Syntax for Insert into using an rpg data structure, 1 row

[Charles Wilt <charles.wilt@xxxxxxxxx>]

You're using a dynamic statement, Darren is using a static statement.

You should always use static statements unless you _have to_ use dynamic.

One case where dynamic has to be used, is if for instance the table name is
variable.

You CAN'T use a host variable in place of a table name like this:
exec sql insert into :MYTABLE
         values(:C2)

Charles


On Wed, Sep 30, 2015 at 2:03 PM, <JRusling@xxxxxxxxxxx> wrote:

> Oh, i like that Darren.
>
> Dont have to count question marks, as i had to. (below)
>
> I did get this to work like this - the ?'s on the insert had to match the
> number of fields in the data structure.
> data struc -
> myds           ds
>  ...field1
>  ...field2 . . ... etc
>
> the insert -
> clear sql2;
> sql2  = 'insert into qtemp/rpttossf ' +
>         'values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) with nc';
> //ec sql insert into qtemp/rpttossf using :myds;
> exec sql prepare stmt2 from :sql2;
> exec sql execute stmt2 using :myds;
>
> John Rusling
> Senior Developer/Analyst
> Quadion LLC
> Minnesota Rubber & Plastics
> 952.927.1419
> <br />
> The information in this email is confidential and may be legally
> privileged.
> It is intended solely for the addressee. Access to this email by anyone
> else is
> unauthorized. If you are not the intended recipient, any disclosure,
> copying,
> distribution or any action taken or omitted to be taken in reliance on it,
> is
> prohibited and may be unlawful.
> --
> 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.