HI All,
My requirement is like, fixed length sequential file is source, i am reading as char datatype for all columns. TRAN_DATE is the column in that, i have to load in target table as date datatype.
For some of the recordsit is coming as spaces.
i am using modify stage to convert string to date and if space comes then i have to load as null. for that below is the specification i am using, but it is throwing error.
Job is RCP enables.
Source record coming as 20110203.
TRAN_DATE:date = handle_null(date_from_string[%yyyy%mm%dd](TRAN_DATE),'')
Please let me know how to do this in one specification.
Thanks in Advance.
combined explicit conversions in a single specification
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Fri Aug 01, 2008 2:56 am
-
- Participant
- Posts: 31
- Joined: Fri Aug 01, 2008 2:56 am
Posting the error you receive would be useful.
Modify will not let you nest the conversions. You will need two different modify stages to perform this conversion.
Using the column importer stage and schema files may actually be a better solution for null handling such as this, where you can define what values constitute a null value for an incoming data column.
Regards,
Modify will not let you nest the conversions. You will need two different modify stages to perform this conversion.
Using the column importer stage and schema files may actually be a better solution for null handling such as this, where you can define what values constitute a null value for an incoming data column.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.