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

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.