Re: SQL db in an RPG program - another question

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.