Problem in getting environment variable in routines...

[kaps]

Hi

I am trying to use environment variables in Routine(Transform Function).
I got some idea from this forum as to use echo statements to get the env values and I use modified UtilityHashLookup Routine to read. It works fine If I hard code the path of hash file like following

HashTable=/dir/dir/dir/Translation_hsf

but it gives me "Table Not Found" error If I do the follwoing...

HashTable = HashFilePath:"/Translation_hsf"

where HashFilePath has the actual path derived from the echo command which works fine.

Does anyone know the reason ?

Thanks

[ArndW]

Could you post your code where you are getting the results of the ECHO command? Perhaps there are extraneous characters in that returned string that you aren't filtering out.

[DSguru2B]

You sure your not sending in any spaces. Try

Code: Select all

HashTable = TRIM(HashFilePath):'/Translation_hsf'

[ArndW]

I'm thinking not of spaces but of an extra @FM (which is what crlf's get converted to when calling shell commands)

[DSguru2B]

Ahh....The field markers. Then how about the OP tries this

Code: Select all

HashTable = Field(HashFilePath1,@FM,1):'/Translation_hsf' 

[vsi]

Thanks for the response.

Arnd - This is the code I am using to get the env variables...

Call DSExecute("UNIX","echo $prm_project_path$prm_path_common",UnixOutput,SystemReturnCode)
HashFilePath = Trim(UnixOutput)

DSGuru - I am getting the same error when I tried your second mathod.\

Thanks

[kaps]

Thanks for the response.

Arnd - This is the code I am using to get the env variables...

Call DSExecute("UNIX","echo $prm_project_path$prm_path_common",UnixOutput,SystemReturnCode)
HashFilePath = Trim(UnixOutput)

DSGuru - I am getting the same error when I tried your second mathod.\

Thanks

[I_Server_Whale]

Thanks for the response.

Arnd - This is the code I am using to get the env variables...

Call DSExecute("UNIX","echo $prm_project_path$prm_path_common",UnixOutput,SystemReturnCode)
HashFilePath = Trim(UnixOutput)

DSGuru - I am getting the same error when I tried your second mathod.\

Thanks

Why is the same thing being posted twice under different member_id's?

[DSguru2B]

That is because your routine says something else and the DSExecute() statement reveals something else. Tell me this, what are the values of $prm_project_path and $prm_path_common?

[kaps]

Value of $prm_project_path is /datastage/dev/srcdev/ and value of $prm_path_common is common/. It's all just directories in AIX.

So value of the the HashFilePath is /datastage/dev/srcdev/common/

Thanks

[DSguru2B]

Ok. Try one of these. They should work

Code: Select all

Call DSExecute("UNIX","echo $prm_project_path$prm_path_common",UnixOutput,SystemReturnCode) 
HashFilePath = Field(UnixOutput, @FM,1)

OR

Code: Select all

Call DSExecute("UNIX","echo $prm_project_path$prm_path_common",UnixOutput,SystemReturnCode) 
HashFilePath = UnixOutput<1>

[kaps]

I don't know what's going on...The code which worked few hours before is not working now...

Even this small piece of code is not working now...I just have the following code in a test routine...which does not give me the output...

Call DSExecute("UNIX","echo $prm_project_path",UnixOutput,SystemReturnCode)

Ans = Trim(UnixOutput)

Thanks

[DSguru2B]

Log onto your unix server and run the same command. Does it spit out the value?

[kaps]

It won't sipt out the value as the variable is DataStage environment variable. So Unix will recognize only If I run from DataStage.
Is my understanding correct ?

Thanks

[DSguru2B]

NO. It wont. Thats what i wanted to find out. If it does'nt work from command line, it wont work from DSExecute() either.
Go to your unix prompt, type env. What ever variables you see there, only they can be called.
I wonder how it was working before.