|
No cursor. Just a simple expression: D PgmDS DS D Fld1 5 0 D Fld2 25 D .... C/Exec SQL C+ Insert Into TESTDB C+ Values ( :PgmDS ) C/End-Exec Eric DeLong Sally Beauty Company MIS-Sr. Programmer/Analyst 940-898-7863 or ext. 1863 -----Original Message----- From: Mike Naughton [mailto:mnaughton@juddwire.com] Sent: Monday, November 19, 2001 2:51 PM To: rpg400-l@midrange.com Subject: SQL RPG - How to Use INSERT? I'm trying to use INSERT in embedded SQL, and I'm running into some problems. I guess I have a basic question: do I use a cursor? When I try to declare it, I'm told that "INSERT INTO" is not valid. If I don't use a cursor, what do I do? Any help would be greatly appreciated! Thanks very much, Mike Naughton Senior Programmer/Analyst Judd Wire, Inc. 124 Turnpike Road Turners Falls, MA 01376 413-863-4357 x444 mnaughton@juddwire.com _______________________________________________ This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l or email: RPG400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
