I have several warnings in my log file due to some ICONV conversions that I did to convert Char values to dates, which worked. However, since there are nulls and PeopleSoft fields all have Not Null constraints that cannot be removed, I had to use an If Else statement. See log error below:
DA_DEPT_EXTN_new..Transformer_1: At row 1, link "DataOUT", while processing column "DA_UNIT_INACTV_DT"
Value treated as NULL
Attempt to convert String value " " to Date type unsuccessful
If IsNull(Column) Then " " Else Iconv(column,"D")
What other null parameters could I use? I have tried the NullToEmpty function/routine, "", and call the empty string from a stage variable.
Null Strings
Moderators: chulett, rschirm, roy
You can't send a space to a DATE field.
If the field is required, you need to send it some kind of legitimate date, even if it's one that represents "no date". You need to find out what they are expecting... usually it's something like '9999-12-31'.
If the field is required, you need to send it some kind of legitimate date, even if it's one that represents "no date". You need to find out what they are expecting... usually it's something like '9999-12-31'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers