I am working in 7.2 mainframe FOCUS. I have a db2 table with dates and null dates are possible. My MFD says :

FIELD=START_DATE ,START_DATE ,YYMD ,DATE ,MISSING=ON ,$

I want to use modify on this file (update and include). My questions are

What format should the date be in?

If I have a null date, what should I pass it in the modify?

Thanks!

Hello,
Since the USAGE in the MFD states YYMD, you can simply provide a value in the form of 20030710 for example. I did a simple test with CRTFORM and this worked just fine. If MISSING=ON is specified, then by not providing a value, a missing or NULL value will be provided.
Let me know if this does not address your concerns.
Regards,
Larry Civelli
iWay Software