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.

> -------- Original Message --------
> Subject: RE: Accessing DB2 Data from Windows
> From: "Chris Bipes" <chris.bipes@xxxxxxxxxxxxxxx>
> Date: Thu, February 09, 2006 1:23 pm
> To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> 
> So you have your AS400 connected to your Windows system and using
> interactive SQL on your AS400 can connect to your Windows system and see
> the data.  Have you done SQLRPGLE to read data from your local AS400?
> If you have that working, it becomes a matter of setting up the
> connection within your SQLRPGLE Program.  What does your SQL statements
> look like?  Can you post your SQLRPGLE source statement that deal with
> setting up the connection?  What error are you seeing on both sides?
> Anything in the windows event viewers?
> 
> 
> 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-----
> 
> 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.
> 
> -- 
> 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.