Hi
I tried using Modify Stage for converting varchar to Date using below conversion specification :
new_date : date = StringToDate(old_date,"%yyyy-%mm-%dd")
But it gives error saying :
main_program: Error parsing modify adapter: Error in binding: Unknown conversion: StringToDate
Expected destination field selector, got: ")"; input:
new_date : date = StringToDate(old_date,"%yyyy-%mm-%dd")
But same function works when i use tht in Transformer Stage.
Why is it so.
Amit
Type Conversion Using Modify Stage
Moderators: chulett, rschirm, roy
thanks
Hirichdhan wrote:Hi Amit,
Do a search on Modify stage. Modify stage uses direct orchestrate functions. Search the Orchestrate manuals and you will find the orchestrate functions to be used in Modify stage.
In this case it will Date_From_String
HTH
--Rich
Thanks for the help.It works.
Can you suggest me where to go for these kind of things.
Amit
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are quite a few errors in this Chapter.
For example it gives the Transformer stage function for null handling rather than the Modify stage function.
There are also errors of omission, such as the fix_zero option for decimal numbers.
Be very, very careful. Check anything you propose to do with the Orchestrate Operators manual and, perhaps, by searching on this forum.
For example it gives the Transformer stage function for null handling rather than the Modify stage function.
There are also errors of omission, such as the fix_zero option for decimal numbers.
Be very, very careful. Check anything you propose to do with the Orchestrate Operators manual and, perhaps, by searching on this forum.
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.