DSXchange

hi,

how to delete a unix file from datastage job.
datastage job should find test.txt file in unix server if it is exists then i should delete that file...! i want to use this process in a datastage sequencer.

Veni,

are you aware that you can call up UNIX commands from sequences and jobs? This will allow you to take care of your file deletion.

ArndW wrote:Veni,

are you aware that you can call up UNIX commands from sequences and jobs? This will allow you to take care of your file deletion.

may i know how to call unix command from sequences...
i know the rm $filename how to give this command in sequences.


Thanks
Krishna

Veni,

Use the Routine Activity Stage with ExecSH routine and rm command.

HTH
--Rich

Use an Execute Command activity with rm as the command. The command arguments field can contain options (for example -fr) and a job parameter reference to the parameter containing the name of the file to be deleted.

ray.wurlod wrote:Use an Execute Command activity with rm as the command. The command arguments field can contain options (for example -fr) and a job parameter reference to the parameter containing the name of the file to be deleted.

Please can you give example?

Hi,

Ray is just making you to make use of the facility of parameterization.
First try using hardcoded values.
rm /path/filename.txt
Then you can try the parameter instead of the path and filename
rm #path#/#filename#

-Kumar

There are two fields on the Command tab in an Execute Command activity.

In the first (Command) you put simply the rm command itself.

In the other (Parameters) you put anything else that needs to appear on the rm command line. This can include references to job parameters, for example -rf #path#/#filename#

The command that is executed in the operating system is rm -rf path/filename where path and filename are resolved job parameter values.

ray.wurlod wrote:There are two fields on the Command tab in an Execute Command activity.

In the first (Command) you put simply the rm command itself.

In the other (Parameters) you put anything else that needs to appear on the rm command line. This can include references to job parameters, for example -rf #path#/#filename#

The command that is executed in the operating system is rm -rf path/filename where path and filename are resolved job parameter values.

Thanks Every one. this work fine. i need to find file is found or not how do check? if it is found then i have to go for process otherwise i need to abort the sequence ?

can any one suggest how to solve this.

First suggestion would be to find someone where you work who can help you with simple UNIX commands like this.

Second suggestion would be to start a new post as this one has been solved and we're moving off on to another topic entirely.