RE: Accessing DB2 Data from Windows

[michael@xxxxxxxxxxxxxxxxxx]

Thanks Charles...I posted the CONNECT TO statement...I think I should
move this to RPG400. 

> -------- Original Message --------
> Subject: RE: Accessing DB2 Data from Windows
> From: "Wilt, Charles" <CWilt@xxxxxxxxxxxx>
> Date: Thu, February 09, 2006 1:17 pm
> To: "Java Programming on and around the iSeries / AS400"
> <java400-l@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.
> > 
> > 
> 
> -- 
> 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.