I have 2 identical Oracle databases with a date-time field formated HYYMDI. I am loading data from one work file to the other reporting file. I can not move one HYYMDI field to the other without an error. The error I get is:

(FOC437) THE FORMAT USED WITH FIXFORM IS INCOMPATIBLE WITH THE DATA FORMAT E02
/H08

Is there a way around this?

I don't beleive that MODIFY supports DateTime, or is it that FIXFORM reading a DateTime cannot apply the value to a field.

What is the code to do this ?

I did find a work around to this in WebFocus about an hour ago. I create a hold file with FORMAT ALPHA formated as YYMD and apply it using MODIFY.