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

I find the SQL reference in the IBM Knowledge Center to be fine for my purposes:

https://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/db2/rbafzintro.htm?lang=en

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----JRusling@xxxxxxxxxxx wrote: -----
To: "RPG programming on the IBM i \(AS/400 and iSeries\)" <rpg400-l@xxxxxxxxxxxx>
From: JRusling@xxxxxxxxxxx
Date: 09/30/2015 11:27AM
Subject: Syntax for Insert into using an rpg data structure, 1 row

I have a data structure populated in an rpg program, and i'd like to
insert (using sql) a row into a work file, using the data structure data.
The work file definition and the rpg data structure match.

Anyone have the syntax for this?
os 7.2, free form rpg.

As well, can anyone steer me to a good iseries sql book?
One with more of a cookbook approach as in
How do i do this?
How do i do that?
Even better if theres lots of embedded sql examples.

Thanks,

John

John Rusling
Senior Developer/Analyst
Quadion LLC
Minnesota Rubber & Plastics
<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.