I have a DDS PF that contains a date field defined:
A DATEFLD L DATFMT(*ISO)
RPGLE, DSPPFM and QRY/400 are all fine with that and show the field correctly. SQL chokes on it however. It returns a null value and a 01534 SQLSTATE (The string representation of a datetime value is invalid).
Any ideas? Is it the DFT keyword?