Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Send package variable using batch script in ODI

Las071214Sep 26 2016 — edited Sep 28 2016

Hi,

We have a package where we have a variable 'period' which we change every month in batch file( like May-16,Jun-16 etc)

While generating/regenerating the scenario , we have checked this variable.

We use a batch script to run the scenario where we pass the variable through batch as below :

startscen.bat EXEC__PACKAGE_VER 001 PROD     "-KEYWORDS=abc"      "PROJECT1.PERIOD=Jun-16"

1. Scenario runs fine only if we update the period variable in package manually.

2. Scenario is getting failed if we remove the variable value in package and pass through variable only through batch (with error : ODI-17506: Variable has no value)

3. ODI is taking package variable value if the variable value given in package and batch are different.

Could any one suggest how can i pass variable value into scenario through batch.

Thank You!

Regards

Sowjanya Rayala

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2016
Added on Sep 26 2016
9 comments
674 views