Hi,
I am facing a problem while mapping two date fields in the Transformer.
The Date fields LEAD_START_DATE and LEAD_EXPIRY_DATE have been defined as DATE 10. In the Transformer I'm moving these fields into two other date fields which are defined as DATE10.
But while compiling the job i get the below error.
##E TCOS 000003 02:49:57(000) <main_program> Syntax error: Error in "transform" operator: Error in operator arg: In field "LEAD_START_DATE": The schema type "date" does not take parameters "10,0"
In field "LEAD_EXPIRY_DATE": The schema type "date" does not take parameters "10,0"
##E TCOS 000029 02:49:57(001) <main_program> Creation of a step finished with status = FAILED. (djpCLWXFMLeadsBuildProcessV3.tfbUpdateFiles)
Please let me know what can be done about the same.
Thanks,
Bhavna.
About Date fields in Transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi,
I removed the precision column and defined the fields as just DATE in the SQL type.But while compiling I got the below error.
##E TCOS 000003 04:22:57(001) <main_program> Syntax error: Error in "transform" operator: Error in operator arg: In field "LEAD_START_DATE": The schema type "date" does not take parameters "0,0"
In field "LEAD_EXPIRY_DATE": The schema type "date" does not take parameters "0,0"
##E TCOS 000029 04:22:57(002) <main_program> Creation of a step finished with status = FAILED. (djpCLWXFMLeadsBuildProcessV3.tfbUpdateFiles)
Any Solutions.
Thanks,
Bhavna
I removed the precision column and defined the fields as just DATE in the SQL type.But while compiling I got the below error.
##E TCOS 000003 04:22:57(001) <main_program> Syntax error: Error in "transform" operator: Error in operator arg: In field "LEAD_START_DATE": The schema type "date" does not take parameters "0,0"
In field "LEAD_EXPIRY_DATE": The schema type "date" does not take parameters "0,0"
##E TCOS 000029 04:22:57(002) <main_program> Creation of a step finished with status = FAILED. (djpCLWXFMLeadsBuildProcessV3.tfbUpdateFiles)
Any Solutions.
Thanks,
Bhavna
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: