baralp
asked on
Passing null value as parameter from Shell script to ODI scenario
Hi,
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.
Please help!!
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.
Please help!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would look at:
Error parsing logLevel:BI_REPORTING.V_RE VCL should be an integer
Looks like this parameter is required.
Never having used this product it will be hard to say for sure. Can you not contact the provider for support?
Error parsing logLevel:BI_REPORTING.V_RE
Looks like this parameter is required.
Never having used this product it will be hard to say for sure. Can you not contact the provider for support?
ASKER
Hi,
I have found a solution to this. The null key word worked instead.
sh startODIScenFromCntrlM.sh DL_CHARGEOFF_DOLLAR_RANGE 001 N N 'BI_REPORTING.V_REVCL=null '
Thanks
I have found a solution to this. The null key word worked instead.
sh startODIScenFromCntrlM.sh DL_CHARGEOFF_DOLLAR_RANGE 001 N N 'BI_REPORTING.V_REVCL=null
Thanks
ASKER
Your second guess executes without any error but it still does not populates the table. I think somehow it is not interpreting the oracle nvl for '\'\''.
Your second guess errors out with the following msg:
Command: /a02/Middleware/Oracle_ODI
Error parsing logLevel:BI_REPORTING.V_RE
SYNTAX
startscen.(bat|sh) <scenario_name> <version> <context_code> [<log_level>] [-SESSION_NAME=<session_na
-ASYNC=false is default; -ASYNC=true is valid only if -AGENT_URL is specified
PREREQUISITES
The REPOSITORY CONNECTION INFORMATION section of odiparams.(bat|sh) should be
completed before running this script.