RPG has no concept of ResultSet. I don't think an SQL cursor is the same thing, so even if you could somehow pass it to the Java class, it wouldn't be what the class was expecting. Barbara's suggestion was a way to give you a result set object within an RPG program; still, though, you wouldn't be able to do much with it in the RPG, except pass it on to another Java class. I think you are trying to do incompatible things, really. However, your real problem appears to be the library list one, so that's probably the one you should try to address. > I am trying to do this because when i create a JDBC > connection in java program it uses the library list of > the user job description and not of the Job which is > calling it, in other words if the Library is LIB1 in > the job which is calling it, and if in user job > description of user profile if the Library is LIB2, > then the connection as LIB2 instead of LIB1 Part of the JDBC connection string is "database" which is a library in iSeries terms: jdbc:as400://iSeries-name/database-name. Plus the IBM JDBC drivers have an optional parameter for "libraries" which, if I recall correctly, allows you to specify a comma-separated list of libraries. The Connection should, I believe, treat it similarly to a library list. HTH. Cheers, Martin. -- Martin McCallion Senior Technical Consultant Misys Wholesale Banking Systems 1 St George's Road, London, SW19 4DR, UK T +44 (0)20 8486 1951 F +44 (0) 20 8947 3373 martin.mccallion@xxxxxxxxx www.misys.com This email and any attachments have been scanned for known viruses using multiple scanners. We believe that this email and any attachments are virus free, however the recipient must take full responsibility for virus checking. This email message is intended for the named recipient only. It may be privileged and/or confidential. If you are not the intended named recipient of this email then you should not copy it or use it for any purpose, nor disclose its contents to any other person. You should contact the Misys Banking and Securities Division as shown below so that we can take appropriate action at no cost to yourself. Misys Banking and Securities Division, 1 St George's Road, Wimbledon, London, SW19 4DR, England. Email: banking.postmaster@xxxxxxxxxx Tel: +44 (0) 20 8879 1188 Fax: +44 (0) 20 8947 3373
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.