Syntax error in Modify stage

tan1111 · Post by **tan1111** » Fri Dec 05, 2008 8:07 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Dec 05, 2008 2:56 pm

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.

ray.wurlod · Post by **ray.wurlod** » Sun Dec 07, 2008 3:09 pm

tan1111 in private message wrote:Hi,
Please send me the exact syntax.
thanks,
Tanisha

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.

Please also take some time to review this post about use of private message and private email facilities.

ray.wurlod · Post by **ray.wurlod** » Sun Dec 07, 2008 3:11 pm

tan1111 in private message wrote:Hi,
Please send me the exact syntax.
thanks,
Tanisha

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.

Please also take some time to review this post about use of private message and private email facilities.