Re: SQL returns "++++++++++" for MIN(DATE)

["James Newman, CDP" <newmanas400@xxxxxxxxx>]

I got the embedded statements to work.  However, I can't get the date
format option changed in the compile.  When I do:

       CHGCMDDFT CMD(CRTSQLRPGI) NEWDFT(DATFMT(*ISO))

I get a message saying "Errors detected while changing defaults".  Anyone
see what I'm typing wrong?


Jim


On Sat, Jul 19, 2014 at 10:03 AM, James Newman, CDP <newmanas400@xxxxxxxxx>
wrote:

> I have the following code in an RPG ILE program:
>
> /EXEC SQL
> +    DECLARE C1 CURSOR FOR
> +        SELECT MIN(HIDATE)
> +        FROM MHIST
> /END-EXEC
>
> FWIW, all my date fields are ISO (YYYY-MM-DD).
>
> The program was blowing up when I tried to move the result to another date
> field, saying I had an invalid date.  I looked at the dump and the date
> field contained "++++++++++".
>
> I did STRSQL, ran the command, and got the same thing.  I used Query and
> it shows the minimum (oldest) date as "1915-01-05".  Ran the SQL version
> again but this time didn't ask for MIN.  Instead asked to see the data and
> sorted by date.  All the dates prior to 1940-01-01 are "++++++++++".
>
> I know I can sort the records by date, SETLL, and READ but I figured this
> would be faster and more efficient.
>
> Is there a "Yes, I really have data before 1940 that I'd like to see"
> switch somewhere in SQL that I need to flip?
>
> TIA.
>
>
> James R. Newman