Hi,
I am using MODIFY STAGE and am getting syntax error for the following in specification :
MV_BASE:decimal=NullToValue(MV_BASE,0)
Please let me know the correct syntax.
Thanks in advance,
Tan
Syntax error in Modify stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
NullToValue() is a function for the Transformer stage. It is an error in the Parallel Job Developers Guide that this function is for the Modify stage. The correct function is handle_null() which you can read about in the Orchestrate Operators manual. This can be had for the asking (ask for "OEM manuals") from your support provider.
Syntax is handle_null(input_field, value) where value must be appropriate for the data type of the output field.
Syntax is handle_null(input_field, value) where value must be appropriate for the data type of the output field.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I provided a precise manual reference. Why can you look it up there? I would be perfectly happy to read the manual for you, but only as a commercial arrangement. If you wish to proceed on this basis please revert with a purchase order or request for quotation.tan1111 in private message wrote:Hi,
Please send me the exact syntax.
thanks,
Tanisha
Please also take some time to review this post about use of private message and private email facilities.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I provided a precise manual reference. Why can't you look it up there? I would be perfectly happy to read the manual for you, but only as a commercial arrangement. If you wish to proceed on this basis please revert with a purchase order or request for quotation.tan1111 in private message wrote:Hi,
Please send me the exact syntax.
thanks,
Tanisha
Please also take some time to review this post about use of private message and private email facilities.
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.