Hi folks
I have a strange problem. Here goes.
We all know DataStage is strictly case-sensitive.
I thus have 2 environment variables, both pointing to the path where my .ds (dataset descriptor) files are stored - one if PathDS and the other is PathDs. this is because at some point we were using DS and eventually norms changed and we moved to the naming convention of having just the first letter in caps thus converting to Ds. No one thought about removing the PathDS from the list of environment variables.
Today, in my job I can addboth these variables in my parameter list (job properties->add environment variable) but cannot compile since I get the message Precompile failed. Found duplicate environment variable in job definition.
Is this funny? How can I add duplicate variables without any error but am only policed when i try and compile the job?
And it gets better:
If I don't declare the variable with the small s so PathDs but use it in the job, the job runs fine if launched unitarily but fails when called by a parent sequence job. However a view data on the stage does not run. This fails with the error that the dataset inidicated by PathDs/dataset does not exist - which is logical to me.
What is flabbergasting is how is the job running?
Any ideas?
Thanks
Tony
Problem compiling job due to multiple environment variables
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 288
- Joined: Tue May 27, 2008 3:42 am
- Location: Luxembourg
Problem compiling job due to multiple environment variables
Tony
BI Consultant - Datastage
BI Consultant - Datastage
-
- Premium Member
- Posts: 288
- Joined: Tue May 27, 2008 3:42 am
- Location: Luxembourg
Well.. we know certain aspects of DataStage are case-sensitive, like parameter names for example. I was just thinking that in your particular scenario that there was a mismatch between sensitivities, so to speak between the tool and the O/S level. But then in my defense it was very early in the morning and I haven't touched the tool since the end of 2009 so... perhaps someone else will step up and enlighten us both.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Problem compiling job due to multiple environment variab
Precompilation happens on the client tier, and in Windows, environment variable names are not case-sensitive. The rest of compilation takes place on the DataStage server.TonyInFrance wrote:How can I add duplicate variables without any error but am only policed when i try and compile the job?
Choose a job you love, and you will never have to work a day in your life. - Confucius