Trying to convert string into a date and the job got aborted with the error message as "Error parsing modify adapter: Error in binding: Expected source field selector; got: "2007"
Expected destination field selector, got: ")"; input:"
The code that was applied in the modify stage is as below.
BIZDATE:DATE = date_from_string (#BISDATE#) [%yyyy-%mm-%dd]
Please help me by sharing your ideas.
Thanks
Elavenil
Date conversion using Modify
Moderators: chulett, rschirm, roy
Specification should be:
Code: Select all
BIZDATE:DATE = date_from_string [%yyyy-%mm-%dd] (#BISDATE#)
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Hmm is the jop parameter playing the villan? Pass BISDATE from a previous stage try.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The argument to a Modify stage specification must be the name of an input column - you can not use job parameters here. Create the column upstream of the Modify stage - perhaps using a Column Generator stage.
Note that it is the date format string that is in square brackets - the input column name is in parentheses.
Note that it is the date format string that is in square brackets - the input column name is in parentheses.
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.
Thank you all for your responses.
Yes. The conversion did not work when parameter is used in the conversion in the modify stage.
Parameter was used in the previous stage to create a column and that column was used in the modify stage and it works.
I will mark this problem as resolved.
Regards
Elavenil
Yes. The conversion did not work when parameter is used in the conversion in the modify stage.
Parameter was used in the previous stage to create a column and that column was used in the modify stage and it works.
I will mark this problem as resolved.
Regards
Elavenil