SQL db in an RPG program - another question

Now I have to update 3 fields in a file(table) in the SQL db from an RPG program.

I have to read an iSeries file to get a member id, and then get the member record from the table in the SQL data base and update 3 fields. Then loop back and get the next iSeries record.

Using Scott's code, I was planning on using the Prepstmt to hold the member id value and the 3 variables. Then JDBC_ExecPrepUpd subprocedure to update the 3 fields in the db. Am I understanding the code correctly? Can I have the iSeries file 'open' while I get the db record? Any other help would be appreciated. Thanks, Kim


Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any use, distribution, copying or printing of this message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and then delete the material from any computer.