TCL Commands

bala_135 · Post by **bala_135** » Thu Dec 11, 2008 5:29 am

Hi,

I am trying in IBM Information server the following.Just to try TCL commands through scripting.

cd to the bin directory of the dsengine
typing the following command.
./dssh.exe SELECT * FROM DS_JOBS > file4.txt

Just testing on the TCL commands.

File gets generated but could not see any data.
Anything I am missing here.Any inputs most appreciated.

Regards,
Bala.

ray.wurlod · Post by **ray.wurlod** » Thu Dec 11, 2008 2:17 pm

DataStage SQL requires the terminating semi-colon.
Also you must be working in the project directory.

Code: Select all

cd $projectdir
%DSHOME%\bin\dssh "SELECT * FROM DS_JOBS;" > file4.txt