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

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi John

Fellow Minnesotan here - assuming that the company name means you 
haven't moved to Arizona yet!

Have you looked at the INSERT statement in the SQL Reference? You didn't 
say what you've tried and what has not worked, nor where you've looked. 
Sorry to sound pedantic - that kind of information is always helpful here.

Your data structure is going to be called a host structure in the 
documentation. You specify your DS name with a colon before it in the 
VALUES() bit of the INSERT statement.

As to books - there is an oldie but goodie - SQL/400 Developer's Guide - 
by Mike Cravitz and Paul Conte. Still valid.

There are likely things on developerworks - you'll need to dig a bit - 
http://www.ibm.com/developerworks - and look for the IBM i stuff there - 
there's a DB2 section that has the latest enhancements and white papers 
and stuff.

The SQL Reference is a must study. It has lots of short unit examples, 
so not exactly a how-to document.

You can always look for general SQL stuff on the net - just be careful, 
as other flavors of DB2 (Windows, Unix, Linux and mainframe) have some 
differences from ours. And SQL Server and Oracle and MySQL, etc., have 
there own additions to the standards.

Still, the basic techniques are pretty universal.

You can do well eventually to look at Joe Celko's stuff, like SQL for 
Smarties - Google his name. It's not aimed at DB2 for IBM i, but still 
very good stuff.

I just looked at a favorite site for tutorials - http//www.w3schools.com 
- they have a tutorial on SQL and present it as a universal language for 
database, so it might be fine for our flavor, which is very much to the 
standards.

HTH
Vern

On 9/29/2015 2:21 PM, JRusling@xxxxxxxxxxx wrote:
> 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.