DSXchange

Hi Ray, Can you please tell me the solution.

Hi Ray, Thanks for your reply. Whe we execute the command touch opt/Ascential/Data/Samplefile.txt --> It works But when we use the Parameter touch #path#samplefile.txt --> Its not working in Execute command stage Can you please suggest how to use the parameter in execute command stage. Thanks and Re...

In Execute command we cant execute the shell script commands, We can call only the shell scripts files.

I have to use this in sequence job, I belive only shell scripts can be executed in the before/after execute job execsh, Is there any other option to execute the unix commands directly in datastage.

Hi All,

How to execute unix commands in Datasatge.

path/ Touch File.txt
path/ rm File.txt

Is this commands will work from datastage?

Hi,

Its not an script, I need to touch the file in the TEST folder, So i try to execute it through the execute command stage in particulat folder.

Hi, I need to create the file onces the sequence is completed successfully, So i was i trying to use the Execute command stage to create the file, But i am getting the following error is this because of the Permission. Is there any alternate option to do it. Test_Defect..JobControl (@Execute_Command...

Might be the Sh file has got restricted access for other user, I was getting this problem since i have changed user id and password

Is it because of the access problem???

Hi All,

When i try to execute the sh script using the DSU.ExecuteScript routine, Its aborted.

Error message

JobControl (@removeInputFiles): Controller problem: Unhandled failure (1) encountered calling routine DSU.ExecuteScript

Can some one please respond for it.

Regards Magesh

Hi All,

I am getting the following warning messages in all my jobs, Its a first time i am getting this warning, Any one can help me.

Unable to open ODBC trace file
DataStage Job 929 Phantom 16452
DataStage Phantom Finished

How to resolve it.

Thanks and Regards
N.Magesh

Hi My Source File 11|Anil |99|MIG |POLIC|Motor 12|Guna |66|MI |OBJEC|Home 11|baba |23|MIG |POLIC|Motor 13|Ji |77|MM |cover|Tata 11|Anil |99|MIG |POLIC|Motor 14|qqq |77|QQ |Objec|MIG 22|aaa |99|aa |Gate |zz I have used sort -u file_name.txt to eliminate duplicate records But I am not getting the expe...

Hey Dude, Its not working!!! I have checked it.

Thanks Kumar, I thought its removes duplicate in column level.
Thank you .

Some one can help to resolve this problem.