RE: Dynamic select, null dates, -183, COALESCE, CRTSQLRPGI, DATFMT(*ISO)

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

>I'm trying to solve the problem of SQL -183 errors
>when reading from a DDS PF and finding records with
>null dates (the null date is valid).
>
>After a couple of RTFM and RTFFAQ's sessions,
>I'm getting the records (using this select
>statement) as long as I specify DATFMT(*ISO) on
>the CRTSQLRPGI command.
>
>coalesce(nuucandt,''0001-01-01'')

You can also use indicator variables.  Then the compiler settings no longer
matter.  Of course, since you're using dynamic selects, that means more work
on the coding side...

>And how do you deal with SETLL and READE
>separation anxiety?

Q. How many psychiatrists does it take to change a light bulb?
A. Just one, but it really truly has to WANT to change.
  --buck