DSXchange

Hi,

In the modify stage when i am handling the null value for a date column,
for the following expression
MKTPRC_DATE=NullToValue(MKTPRC_DATE,'2222-12-12')
i was getting the following error--

main_program: Errpr passing modify adapter: Error in binding : Unknown conversion : NullToValue
Expected destination field selector, got:")": input:
MKTPRC_DT:date=NullToValue(MKTPRC_DATE,'2222-12-12')

What might be the reason for the above Error....

Hi,
Please search for date conversion only in the EE forum for some answers.
Also in the docs.
Note that all the documented routines like NullToValue that are not named in small leters seperated by underscores are not available in the modify stage despite the docs.

IHTH,

Hi dspxlearn,

Use the SEARCH facility in this forum. It has been covered before. We had a discussion 2 days back.

Just scroll down the topics list and you will find a topic "About Modify Stage" where you will find what is the correct function to be used for Null Handling as well as a weblink for getting the orchestrate manuals which describes the functions that can be used in a modify stage.

HTH
--Rich

That post also makes the point that there are some out and out errors in the Parallel Job Developer's Guide - you should not rely on it, particularly the chapter on Modify stage (which one guesses was written by someone who grew up with Transformer stages)

Hi,

In the modify stage when i am handling the null value for a date column,
for the following expression
MKTPRC_DATE=NullToValue(MKTPRC_DATE,'2222-12-12')
i was getting the following error--

main_program: Errpr passing modify adapter: Error in binding : Unknown conversion : NullToValue
Expected destination field selector, got:")": input:
MKTPRC_DT:date=NullToValue(MKTPRC_DATE,'2222-12-12')

What might be the reason for the above Error.... [/quote]

ANS:

The specification in the Modify Op would be NullToValue(_DATE,"2222-12-12") ..also i would handle the Null value as follows..

Date_Field:date = handle_null(Date_Field,"2222-12-12") in the specification...

Thanks,

Hi Srikanth,

I got the expected result...thanx for that..