RE: Accessing DB2 Data from Windows

Yeah..the salient ones (I think) are specified on the CRTSQLRPGI
command:

CRTSQLRPGI OBJ(NEWSYS/WCSACCR)    
           SRCFILE(NEWSYS/QRPGSRC)
           SRCMBR(WCSACCR)        
           RDB(STAGING)           
           OBJTYPE(*PGM)          
           USER(WCSDBUSR)         
           PASSWORD(WCSDBUSR) 
           OPTION(*SQL)       
           DATFMT(*ISO)           
           DATSEP(*JOB)           
           TIMFMT(*ISO)           
           REPLACE(*YES)          
           SQLPKG(STAGING/WCSACCR)


> -------- Original Message --------
> Subject: Re: Accessing DB2 Data from Windows
> From: rob@xxxxxxxxx
> Date: Thu, February 09, 2006 1:20 pm
> To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
> 
> Does the settings in
> C/EXEC SQL 
> C+ Set Option 
> C+     Naming    = *Sys, 
> C+     Commit    = *None, 
> C+     UsrPrf    = *User, 
> C+     DynUsrPrf = *User, 
> C+     Datfmt    = *iso, 
> C+     CloSqlCsr = *EndMod
> C/END-EXEC 
> 
> match your settings in STRSQL, F13, option 1?
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> michael@xxxxxxxxxxxxxxxxxx 
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 02/09/2006 01:09 PM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
> 
> 
> To
> midrange-l <midrange-l@xxxxxxxxxxxx>, rpg400-l <rpg400-l@xxxxxxxxxxxx>, 
> java400-l java400-l <java400-l@xxxxxxxxxxxx>
> cc
> 
> Fax to
> 
> 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 RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.