I have several SQL books and find myself going most often to SQL/400 by example by James Coolbaugh from 29th St Press. Copyright 1999 but IBM i examples that work.
The next most bookmarks is in SQL Built-In Functions and Stored Procedures by Mike Faust and MC Press copyright 2005 and 2007 but is more specialized.
Any questions, let me know please.
Thanks,
Dave B
Everybody is ignorant, only on different subjects. - Will Rogers
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of JRusling@xxxxxxxxxxx
Sent: Tuesday, September 29, 2015 2:22 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
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.
--
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.
midrange.com
