Re: Accessing DB2 Data from Windows

Thanks, Paul, for the recommendation. I'd love to sell a copy of RPG2SQL, but 
if it is DB2 on a Windows box, it should be possible to use DRDA. Esp. as the 
original poster can connect in interactive SQL.

So obviously the RDBDIR entry is there. There are statements like SET 
CONNECTION, etc., that need to be done in the SQLRPGLE program. There should be 
instructions in some manual, like distributed database programming or some 
such. There is some setup stuff to do in a program.

Perhaps the person should just call IBM - gotta have SupportLine, of course.

-------------- Original message -------------- 
From: pnelson@xxxxxxxxxx 

> Check out the RPG2SQL product from RJS Software. 
> -- 
> 
> Paul Nelson 
> Arbor Solutions, Inc. 
> 708-670-6978 Cell 
> pnelson@xxxxxxxxxx 
> 
> 
> 
> 
> michael@xxxxxxxxxxxxxxxxxx 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx 
> 02/09/2006 12:09 PM 
> Please respond to 
> Midrange Systems Technical Discussion 
> 
> 
> To 
> midrange-l , rpg400-l , 
> java400-l java400-l 
> cc 
> 
> 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 Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
>