RE: SQL loval date/timestamp

[Joel Cochran <jrc@xxxxxxxxxx>]

I've tried that but with no effect, I still get SQLState = '22008'.

Still churning...

Joel
http://www.rpgnext.com

On Tue, 2003-10-14 at 15:01, DeLong, Eric wrote:
> Joel, 
> Can you simply add DATFMT(*ISO) to your Control spec (H)?
> 
> Eric DeLong
> Sally Beauty Company
> MIS-Project Manager (BSG)
> 940-898-7863 or ext. 1863
> 
> 
> 
> -----Original Message-----
> From: Joel Cochran [mailto:jrc@xxxxxxxxxx]
> Sent: Tuesday, October 14, 2003 4:31 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: SQL loval date/timestamp
> 
> 
> Here is the basic layout of the program in psuedo-code:
> 
> d mainDS        e ds                  extname( MYFILE )
> 
>  // prepare and declare the cursor...
> 
> c/exec SQL
> c+  fetch next from mainCursor into :mainDS
> c/end-exec
> 
> The layout of MYFILE includes a Date field (defined as "L" in the DDS). 
> Since Date fields themselves do not have data types this should not be
> an issue.
> 
> Just to be sure I checked the compiler settings for CRTSQLRPGI and
> DATFMT is *JOB.  Since the system always defaults to *ISO I assumed that
> so would the program ... BUT ... when I DSPSYSVAL(QDATFMT) it says that
> the value is MDY.  In fact, the option list doesn't even include ISO.
> 
> I think this must be the problem, maybe I need to specify *ISO when I
> create an SQLRPG module.  This is something you do not have to do in
> RPGIV, so to say this bothers me a little is an understatement.  I'm
> going to try and test this some more today and I'll share the results.  
> 
> Thanks Eric,
> 
> Joel
> http://www.rpgnext.com
>