Re: SQL db in an RPG program - another question

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hi Kim,

Sorry, I'm not sure what you mean by "member id" in this context. 
Surely, you aren't working with multiple member files on a SQL Server box?

I'm not clear on how you are reading your DB2 for IBM i table.  Are you 
reading this with embedded SQL?  JDBC? CLI?  native I/O?  I don't see 
any reason why it'd hurt to keep the file open, in any of these cases.


On 12/21/2012 11:29 AM, Kim Massar 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