I have a date field from input as Start_Date(8) which has Nullabilty as "Yes".My requirement is to check whether the field is Null, if null then it should be replace with 00000000.This field is mapped to the target field Charge_Date(8) in the target dataset.
In the output derivation of the transformer stage i've used like this:-
Charge_Date:
If IsNull(Start_Date) Then StringToDate("00000000",%yy%mm%dd) Else Start_Date.
But i'm getting the warning as "Conversion error calling conversion routine data_from_ustring data may have been lost"
Please help me out..
Thanks
String to Date conversion error
Moderators: chulett, rschirm, roy
String to Date conversion error
RK Raju
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When your job is compiled the stages you use are converted into Orchstrate operators, and the functions that you use to convert data are converted to those used by the modify operator (which is also used for the Modify stage). As a general rule the "To" function names are for the Transformer stage and the "_from_" function names are for the Modify stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.