RE: Accessing DB2 Data from Windows

Looks like you are connecting ok but having a cursor problem.  All I can
say is try the program using a local copy of the file.  If it works,
then there must be a cursor difference between UDB 8.2 and your AS400
version of UDB.

I have never run UDB on anything but an AS400 or my development PC in a
test environment, but never really tested SQLRPGLE.

Good luck,


Christopher Bipes
Information Services Director
CrossCheck, Inc.

707.586.0551, ext. 1102
707.585.5700 FAX

Chris.Bipes@xxxxxxxxxxxxxxx
www.Cross-Check.com

Notice of Confidentiality: This e-mail, and any attachments thereto, is
intended only for use by the addressee(s) named herein and may contain
legally privileged and/or confidential information.  If you are not the
intended recipient of this e-mail, you are hereby notified that any
dissemination, distribution or copying of this e-mail, and any
attachments thereto, is strictly prohibited.  If you have received this
e-mail in error, please immediately notify me by e-mail (by replying to
this message) or telephone (noted above) and permanently delete the
original and any copy of any e-mail and any printout thereof.  Thank you
for your cooperation with respect to this matter.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
michael@xxxxxxxxxxxxxxxxxx
Sent: Thursday, February 09, 2006 10:32 AM
To: Midrange Systems Technical Discussion
Subject: RE: Accessing DB2 Data from Windows

Yes..I can connect using interactive SQL from the iSeries (V5R3) to the
Windows server (UDB 8.2).

I can read data fine using SQLRPGLE from the local iSeries.

Here's the connect...

C/Exec SQL                                      
C+ CONNECT TO STAGING USER :SQLUsr USING :SQLPwd
C/End-Exec                                      
 /Free                                          
  doChkSQLError();                              
 /End-Free                                      

where SQLUsr and SQLPwd identify a user in the Administrator group.

I've gone through many iterations, but the SQLRPGLE program creation
creates a package on the Windows server. I look at the statement in the
package and it looks corrrect. The problem is that I immediately reach
end of file when I fetch from the cursor.

I don't see anything in the Windows event viewers. There may be
something in the UDB log (if there is one), but I don't know where that
would be.