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
unable to run clear.file command fron a datastage job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Tue Jun 26, 2012 11:14 am
- Location: Houston
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 19
- Joined: Tue Jun 26, 2012 11:14 am
- Location: Houston
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 19
- Joined: Tue Jun 26, 2012 11:14 am
- Location: Houston