Home > IT Answers > AS/400 > On the as/400 i series can one use SQL querys to update file
nitzinger
385 pts.
 On the as/400 i series can one use SQL querys to update file
AS/400, RPGLE, SQL, SQL queries
Cobol uses some kind od IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the code would like. How would the updated file be reference? Thanks

Software/Hardware used:
as/400 rpgle
ASKED: January 19, 2010  9:55 PM
UPDATED: January 20, 2010  2:27 PM
RELATED QUESTIONS
Answer Wiki:
Yes you can! You can create a member, type SQLRPGLE Sample <a href="http://wiki.midrange.com/index.php/SQLRPGLE">
Last Wiki Answer Submitted:  January 20, 2010  8:30 am  by  Michlw   30 pts.
All Answer Wiki Contributors:  Michlw   30 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _