Hello All,

We need to load (copy) a mainframe flat file that contains Focus smart date fields into a mainframe DB2 table.

Does anyone have any experience with this type of situation? How do we reformat the Focus smart date into a format compatible with the mainframe Date format?

Thanks to all!

IBM Z/OS
FOCUS 7.2.5

To insert DB2 dates, the format 'ccyy-mm-dd' works, if I'm not mistaken. Then DB2 stores the field for you, assumes of course the DB2 column is defined as a true date field.

Thanks.
We were able to convert the smart date to a legacy date in DB2 yyyymmdd format and load that value.