SQL - Data mapping error on member XXXXXX.

[Brian <iserieslists@xxxxxxxxx>]

I've got several vendor-supplied tables containing date fields that are
generating "Data mapping error on member XXXXXX" error messages. Looking at
the file definition in iNav shows that these date fields are defined as not
null capable and viewing the contents of the table in iNav shows the value
for these fields as 0001-01-01. Displaying the table with STRSQL shows the
values for these date fields as ++++++++. When I try to read these tables
into my RPG program using embedded SQL I get SQLSTT = 22007. How can I go
about initializing these date fields so that these records can be processed?
Updating them with a value of 1900-01-01 and then back to 0001-01-01 did not
solve the problem.

Kind regards,

Brian