unable to run clear.file command fron a datastage job

[VineelPrem]

Hi
I am having trouble running a script whioch has command clear.file RT_LOG from Execute stage .
The output i get in the log is

: line 33: clear.file: command not found
128

[chulett]

It's not an operating system command. It needs to be run from a TCL prompt which is why you would typically use the Adminstrator client. From the command line, you'd have to leverage dssh to run it.

[ray.wurlod]

There is no table called RT_LOG. Each job has its own log, in a table named according to the convention RT_LOGnnn, where nnn is the unique job number allotted to the job and recorded in DS_JOBS table.

[chulett]

That too.

How about letting us know what you are trying to accomplish?

[VineelPrem]

Hi Chulett . I am just trying to automate a process which cleans the job logs periodically . Was trying to do it from a script

[ray.wurlod]

Then the script needs to have sourced the $DSHOME/dsenv script and then needs to invoke the $DSHOME/bin/dssh command to effect the CLEAR.FILE command within a DataStage shell. You also need to know the job number so that you can identify the correct RT_LOGnnn number.

[VineelPrem]

Thanks ray for the reply