EBCDIC date issue
Posted: Mon Jul 26, 2010 5:32 am
Hi,
I am new to EBCDIC file format. I am reading EBCDIC file through Seq. file stage ( not CFF).
Below properties are set : I referred exisitng simple jobs from our repository.
character set : EBCDIC
byte order : big-endian
data format : binary
Recod Type : implicit , delimiter : none.
I have below expression in Transformer.
StringToDate((Lnk_read_from_source.STM_YR):'-':Lnk_read_from_source.STM_MO:'-':Lnk_read_from_source.STM_DAY),"%yyyy-%mm-%dd")
Now , this seems to be leading to below warning.
"Invalid date value in getInputFieldAsDate() for field '1' of input dataset '0'." and further failure in Teradata Mload.Records are going to first Error table.
Can any one help me to know issue?
I can guess , i may need to convert EBCDIC year/day/month fields to ASCII format. IF true , how? Unfortunately we don't have any existing routines in repository..
Thanks in advance. Early reply welcome.
I am new to EBCDIC file format. I am reading EBCDIC file through Seq. file stage ( not CFF).
Below properties are set : I referred exisitng simple jobs from our repository.
character set : EBCDIC
byte order : big-endian
data format : binary
Recod Type : implicit , delimiter : none.
I have below expression in Transformer.
StringToDate((Lnk_read_from_source.STM_YR):'-':Lnk_read_from_source.STM_MO:'-':Lnk_read_from_source.STM_DAY),"%yyyy-%mm-%dd")
Now , this seems to be leading to below warning.
"Invalid date value in getInputFieldAsDate() for field '1' of input dataset '0'." and further failure in Teradata Mload.Records are going to first Error table.
Can any one help me to know issue?
I can guess , i may need to convert EBCDIC year/day/month fields to ASCII format. IF true , how? Unfortunately we don't have any existing routines in repository..
Thanks in advance. Early reply welcome.