RE: SQL db in an RPG program - another question

I have to 'get' the member_id from the iSeries. It will be 25-30 or less records per night.

If I need to get the member_id from the iSeries each time would the addBatch API be the best. It looks like that is for adding multiple files at once?

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Friday, December 21, 2012 1:11 PM
To: RPG programming on the IBM i / System i
Subject: Re: SQL db in an RPG program - another question

Yes you can...

But this is going to be _very_ slow...

If you are doing a lot of records, my first choice would be to do this from the MS SQL Server using a "linked server" to the IBM i.

If it absolutely has to be initiated from the IBM i, I'd look into "batch"
updates via the JDBC addBatch() and executeBatch() methods. However, from a cursory glance, it doesn't appear that Scott has wrapped those methods.
You can look into wrapping them yourself or you could simply do the whole thing in Java on the i.

HTH,
Charles




On Fri, Dec 21, 2012 at 12:29 PM, Kim Massar <kmassar@xxxxxxxxx> wrote:

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.
--
This is the RPG programming on the IBM i / System i (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.

--
This is the RPG programming on the IBM i / System i (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.




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.