RE: DDS to SQL - date definition

I simplified it down to:

A R DMEQPRC
A EQDTI L DATFMT(*ISO)

Record Format Information
Record format . . . . . . . . . . . . . . . : DMEQPRC
Format level identifier . . . . . . . . . . : 2B4A463FAFC20
Number of fields . . . . . . . . . . . . . : 1
Record length . . . . . . . . . . . . . . . : 10
Field Level Information
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
EQDTI DATE 10 10 1 Both EQDTI
Date Format . . . . . . . . . . . . . . . : *ISO
Coded Character Set Identifier . . . . . : 37


CREATE TABLE DMEQPMST
(EQDTI DATE NOT NULL DEFAULT '0001-01-01')
RCDFMT DMEQPRC

Record Format Information
Record format . . . . . . . . . . . . . . . : DMEQPRC
Format level identifier . . . . . . . . . . : 2B3B575FAFC20
Number of fields . . . . . . . . . . . . . : 1
Record length . . . . . . . . . . . . . . . : 10
Field Level Information
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
EQDTI DATE 10 10 1 Both EQDTI
Date Format . . . . . . . . . . . . . . . : *ISO
Default value . . . . . . . . . . . . . . :
'0001-01-01'
Coded Character Set Identifier . . . . . : 37

Tried dropping the "default" but still no match. It DID make a difference
though.

Record Format Information
Record format . . . . . . . . . . . . . . . : DMEQPRC
Format level identifier . . . . . . . . . . : 2B3B5767AFC20
Number of fields . . . . . . . . . . . . . : 1
Record length . . . . . . . . . . . . . . . : 10
Field Level Information
Data Field Buffer Buffer Field Column
Field Type Length Length Position Usage Heading
EQDTI DATE 10 10 1 Both EQDTI
Date Format . . . . . . . . . . . . . . . : *ISO
Default value . . . . . . . . . . . . . . : None
Coded Character Set Identifier . . . . . : 37

Even changed it to allow null. Made a difference, but still no match.

Rob Berendt