Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Passing null value as parameter from Shell script to ODI scenario

Posted on 2013-11-19
4
Medium Priority
?
1,749 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 1500 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Fine Tune your automatic Updates for Ubuntu / Debian
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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…
Suggested Courses

618 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