RE: Accessing DB2 Data from Windows

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Michael,

Since you can access the data via STRSQL, I'd say the problem seems to
be RPG related.

There really shouldn't be anything special AFAIK.

Do you have the:
c/exec SQL
c+  connect to RemoteSys
c/end-exec

In your RPG program?

How about posting some code and any error message IDs you are seeing.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> michael@xxxxxxxxxxxxxxxxxx
> Sent: Thursday, February 09, 2006 1:09 PM
> To: midrange-l; rpg400-l; java400-l java400-l
> Subject: Accessing DB2 Data from Windows
> 
> (Cross posting to midrange-l, rpg400 and java - followup 
> wherever David
> indicates)
> 
> I've been trying to access DB2 data on a Windows system from 
> an SQLRPGLE
> program. I'm having major difficulties, and now I'm wondering if my
> approach (DRDA) even makes sense. I'm looking for suggestions 
> on how to
> access UDB DB2 data from an SQLRPGLE program. All ideas 
> considered. btw,
> it's simple as pie to access the data from an interactive SQL session.
> 
> Thanks...
> 
> 
> -- 
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
> 
>