Solved

Passing null value as parameter from Shell script to ODI scenario

Posted on 2013-11-19
4
1,555 Views
Last Modified: 2013-11-20
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!!
0
Comment
Question by:baralp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39661142
Never used this product but taking an educated guess.

double quotes mean something special to Oracle.  Two single quotes in Oracle is a null value.  Also, null cannot '=' anything.

Two guesses:
sh startODIScenFromCntrlM.sh DL_CHARGEOFF_DOLLAR_RANGE 001 N N 'BI_REPORTING.V_REVCL='\'\''

or
sh startODIScenFromCntrlM.sh DL_CHARGEOFF_DOLLAR_RANGE 001 N N 'BI_REPORTING.V_REVCL is null'
0
 

Author Comment

by:baralp
ID: 39662659
Hi,
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_ODI2/oracledi/agent/bin/startscen.sh DL_CHARGEOFF_DOLLAR_RANGE 001 GLOBAL -AGENT_URL=http://lasfocp4.dqe.com:1029/oraclediagent BI_REPORTING.V_REVCL IS NULL
Error parsing logLevel:BI_REPORTING.V_REVCL should be an integer
 SYNTAX
     startscen.(bat|sh) <scenario_name> <version> <context_code> [<log_level>] [-SESSION_NAME=<session_name>] [-KEYWORDS=<keywords>] [-AGENT_URL=<agent_url>] [-NAME=<agent_name>] [-ASYNC=(false|true)] [<variable>=<value>]*
      -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.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39662678
I would look at:
Error parsing logLevel:BI_REPORTING.V_REVCL 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?
0
 

Author Comment

by:baralp
ID: 39663101
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
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question