Import Error
Posted: Mon Feb 06, 2006 8:46 am
When extracting from a sequential text file, I am receiving the following warning message for one field. The field is has a date value but is defined Integer(7) and Null ='Y'.
In the transform I added logic to handle zero value by setting the date to our default value of 9999-12-31. This is the logic:
IF ((NUM(Source_IN.IDEAL_DUE_ITEM) = 0) OR (Source_IN.IDEAL_DUE_ITEM = 0))THEN '99991231' ELSE '200':(Source_IN.IDEAL_DUE_ITEM).
The logic works fine, I verified this in Peek.
The Warning message I get is:
SEQL_Tgt_OPALExpeditDet,0: Field "IDEAL_DUE_ITEM" has import error and no default value; data: {I D E A L _ D U E _ I T E M}, at offset: 20 [impexp/group_comp.C:6028]
Our standard are for zero warnings so I have to get this message fixed. I'm at a lost right now for a solution, any thoughts
thanks,
Charlie
In the transform I added logic to handle zero value by setting the date to our default value of 9999-12-31. This is the logic:
IF ((NUM(Source_IN.IDEAL_DUE_ITEM) = 0) OR (Source_IN.IDEAL_DUE_ITEM = 0))THEN '99991231' ELSE '200':(Source_IN.IDEAL_DUE_ITEM).
The logic works fine, I verified this in Peek.
The Warning message I get is:
SEQL_Tgt_OPALExpeditDet,0: Field "IDEAL_DUE_ITEM" has import error and no default value; data: {I D E A L _ D U E _ I T E M}, at offset: 20 [impexp/group_comp.C:6028]
Our standard are for zero warnings so I have to get this message fixed. I'm at a lost right now for a solution, any thoughts
![Question :?:](./images/smilies/icon_question.gif)
thanks,
Charlie