delete a unix file from datastage sequence.

Veni · Post by **Veni** » Fri Dec 23, 2005 6:21 am

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.

ArndW · Post by **ArndW** » Fri Dec 23, 2005 6:23 am

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.

Veni · Post by **Veni** » Fri Dec 23, 2005 6:54 am

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

richdhan · Post by **richdhan** » Fri Dec 23, 2005 6:56 am

Veni,

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

HTH
--Rich

ray.wurlod · Post by **ray.wurlod** » Fri Dec 23, 2005 1:55 pm

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.

Veni · Post by **Veni** » Mon Dec 26, 2005 3:16 am

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?

kumar_s · Post by **kumar_s** » Mon Dec 26, 2005 4:14 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Dec 26, 2005 2:49 pm

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.

Veni · Post by **Veni** » Tue Dec 27, 2005 4:27 am

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.

chulett · Post by **chulett** » Tue Dec 27, 2005 7:59 am

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.