DSXchange

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

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.

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.

That too.

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

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

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.

Thanks ray for the reply