RE: rnx0301 when using jdbcr4

[Scott Mildenberger <smildenberger@xxxxxxxxxxxx>]

Then that is a similar scenario that I mentioned originally, I am writing to IBM i from Sql Server.  We use the Microsoft OLE DB Provider for DB2.  I suspect you may have to insert the records in batches of some number.  In my instance I do 1000 at a time.

Scott Mildenberger | Software Developer | Washington Companies IT Services | 101 International Drive | Missoula, MT | Office: 406-523-1536 | www.washingtoncompanies.com

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Randy Cayton
Sent: Tuesday, July 14, 2020 2:17 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: rnx0301 when using jdbcr4

I am using a linked server connection ibmda400

On Tue, Jul 14, 2020 at 3:12 PM Scott Mildenberger < smildenberger@xxxxxxxxxxxx> wrote:

> Are you using Linked Server on sql server to retrieve the records from 
> IBMi or are they a parameter to the stored procedure?
>
> Scott Mildenberger | Software Developer | Washington Companies IT 
> Services
> | 101 International Drive | Missoula, MT | Office: 406-523-1536 |
> www.washingtoncompanies.com
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of 
> Randy Cayton
> Sent: Tuesday, July 14, 2020 12:54 PM
> To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: Re: rnx0301 when using jdbcr4
>
> invoking jdbc from rpg and then calling stored procedure on sql server 
> that insert records from ibmI into server tables.
>
> On Tue, Jul 14, 2020 at 12:32 PM Jack Woehr < 
> jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
> wrote:
>
> > Missed original post.
> >
> > To be clear: You're invoking JDBC thru RPG and this is all entirely 
> > on IBM i ... you're not calling in from off-platform?