DataStage Engine Commands

biswajit_paul · Post by **biswajit_paul** » Tue Dec 16, 2003 5:24 am

:D
Could someone tell me a source where I can get all the DataStage Engine Commands which I can execute from DS Administrator.

For example I want to create some table, select some records from the table, update the records using command prompt.

Any help will be highly appreciated.

dhwankim · Post by **dhwankim** » Tue Dec 16, 2003 6:38 am

How about use TCL HELP.
You can logon UVSH mode. and type HELP ore HELP SQL etc

logon to serve by telnet service (If You use Unix Server)
Example is that
cd `cat /.dshome` (If you use datastage 5.x lower ==> cd `cat /.uvhome`)
. ./dsenv
./bin/uvsh
HELP (For BASIC Command etc)
HELP SQL (For SQL)

Good Luck.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 16, 2003 3:33 pm

Most of them still coincide with UniVerse commands, though there are DataStage extensions.
UniVese manuals can be downloaded from an IBM web site
DataStage manuals are installed with your DataStage client software, in a folder called Docs.
Help (described by DaeWhan Kim) falls into six categories; commands for getting help are:

HELP topic
HELP BASIC topic
HELP SQL topic
HELP CONV topic
HELP BCI topic
HELP PICK topic

If you leave out the topic, you get a navigable list of topics.