Problem useing multiple value in parameter with where clause

shobhitj · Post by **shobhitj** » Mon Jan 18, 2010 2:27 am

Ray,
I have asked the admin of the ds env. they told me both the env. are same in term of OS and hardware.

Only diffrence i can see is that in Env 1 there are 2 nodes
and Env 2 there are 4 node configuration.

Please suggest if this can create such an issue?

chulett · Post by **chulett** » Mon Jan 18, 2010 8:46 am

No... something else is different. Operating system version, patch levels of O/S or DataStage, database client version, something. What database are we talking about here?

shobhitj · Post by **shobhitj** » Mon Jan 18, 2010 8:49 am

Here i am using Oracle Database!!

chulett · Post by **chulett** » Mon Jan 18, 2010 8:51 am

Then triple check the exact version of the Oracle client installed on the DataStage server in both environments.

shobhitj · Post by **shobhitj** » Tue Jan 19, 2010 1:03 am

Hi Craig,

I have checked on the environment variable in both env.

The difference observed is as follows in the job log environment variable of the job ran as i have listed the o/p in previous posts-

Env 1-ORACLE_HOME=/opt/oracle/lin-10.1.0.4
ORACLE_SID=ABC
CONSOLE=/dev/console
LD_LIBRARY_PATH has lot of paths with oracle path
The INIT_VERSION variable is present.
LANG=en_US.UTF-8

Env 2 -

There was no ORACLE_HOME and ORACLE_SID variable present
LD_LIBRARY_PATH do not contain oracle path in it
INIT_VERSION is not present
There is no LANG variable

Will any of these variable will make such difference? Please suggest

On point here, In sample job to capture the variable value difference using peek stage i have not even used any odbc or oracle stage i have just passed the variable from a transformer and mapped it to a column in peek stage column input. The output is posted earlier has that job results. Can this be caused by DS complier diffrence and if so then how to find the difference in version of the complier (In which location ?)

chulett · Post by **chulett** » Tue Jan 19, 2010 6:33 am

shobhitj wrote:Env 2 -

There was no ORACLE_HOME and ORACLE_SID variable present
LD_LIBRARY_PATH do not contain oracle path in it
INIT_VERSION is not present
There is no LANG variable

This makes no sense. You need to track down why these are 'missing', they are required for any native Oracle stage to work. What Oracle client is installed here? Ask your DBA if you don't know. And compare the Oracle settings in the $DSHOME/dsenv file in both environments.

shobhitj · Post by **shobhitj** » Wed Jan 20, 2010 11:27 pm

Hi,

The sample job which was created with the row generator and trasnformer and output to peek stage. There was no ODBC or oracle stage used.

In this case the output was same as mentioned earlier.

So, is there any specific env. variable which can cause this issue

Please suggest

ray.wurlod · Post by **ray.wurlod** » Thu Jan 21, 2010 12:07 am

The same issue?!! That quotes are being stripped in a parameter?

Details, please.

shobhitj · Post by **shobhitj** » Thu Jan 21, 2010 12:23 am

Yes ray. that issue is not being resolved yet.

In my previous replies, i have posted the output using peek stage and passeing only parameter value to it. with all the option i checked as suggested by you and craig

let me know if you want more detials, i will provide

ray.wurlod · Post by **ray.wurlod** » Thu Jan 21, 2010 1:41 am

Show us the value that you passed to the parameter.

Show us the value that the parameter received (get these from the job log "job starting" event).

shobhitj · Post by **shobhitj** » Thu Jan 21, 2010 3:48 am

Hi ray,

Folowing is the input and ouput parameter values in 2 env.

Input Job starting ---- Env 2 Ouptut ---- Env1 Output

AB\",\"CD ---- AB\",\"CD ---- AB","CD
AB\',\'CD ---- AB\,\CD ---- AB','CD (Desired o/p)
AB','CD ---- AB,CD ---- AB,CD
AB','CD ---- AB,CD ---- "AB,CD"
AB\',\'CD ---- AB\,\CD ---- "AB','CD"
AB'',''CD ---- AB\,\CD ---- AB,CD
AB''','''CD ---- AB\,\CD ---- AB,CD

ray.wurlod · Post by **ray.wurlod** » Thu Jan 21, 2010 3:24 pm

I need some time to digest and think about this one. Please be patient. in the meantime, keep us updated with anything useful you get from your official support provider.