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.