Passing null value as parameter from Shell script to ODI scenario
Posted on 2013-11-19
I have a ODI(Oracle Data integrator) scenario that has a parameter that is allowed to accept nulls. I am trying to run the scenario from the Linux command prompt. I am not very familiar with linux commands..just a little bit. The command that I am trying to run is:
sh startODIScenFromCntrlM.sh DL_CHARGEOFF_DOLLAR_RANGE 001 N N 'BI_REPORTING.V_REVCL=""'
This command runs successfully but somehow it does not populates the table that it is supposed to when the null value is passed in the parameter BI_REPORTING.V_REVCL.
When I run the same ODI scenario from ODI client passing null then it does populates the table as it is expected.