RE: Accessing DB2 Data from Windows

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.
> 
>