I was trying to fire a simple DS repository query,
Following are the steps followed,
Code: Select all
test> pwd
/app/test/Ascential/DataStage/DSEngine/bin
test> ls -l *uv*
-rwx------ 1 test dstage 1993 Mar 22 2005 lduv
-rwxr-x--x 1 test dstage 1882200 Mar 22 2005 portuv
-rwxr-x--x 1 test dstage 1880292 Mar 22 2005 upduvtrans
-rwsr-x--x 1 root dstage 95832 Mar 22 2005 uv
-rwxr-x--x 2 test dstage 4581132 Mar 22 2005 uvbackup
-rwxr-x--x 1 test dstage 89780 Mar 22 2005 uvdls
-rwxr-x--x 1 test dstage 4514464 Mar 22 2005 uvfilefix_server
-rwxr-x--x 1 test dstage 1948560 Mar 22 2005 uvfixfile
-rwxr-x--x 1 test dstage 119464 Mar 22 2005 uvregen
-rwxr-x--x 2 test dstage 4581132 Mar 22 2005 uvrestore
-rwxr-x--x 1 test dstage 5372 Mar 22 2005 uvsetacc
-rwxr-xr-x 1 test dstage 6604412 Jun 5 2007 uvsh
-rwxr-xr-x 1 test dstage 5011136 Jun 16 2005 uvsh.ds.saved
-rwxr-x--x 1 test dstage 7084 Mar 22 2005 uvsrvhelpd
-rwxr-x--x 1 test dstage 42672 Mar 22 2005 uvtic
-rwxr-x--x 1 test dstage 1894832 Mar 22 2005 uvtidc
test> uvsh
This directory is not set up for DataStage.
Would you like to set it up (Y/N)?
It is asking me to set some parameters. Without knowing what it is, i do want to lay my hands on the repository.
I want to fire,
Code: Select all
uvsh "select NAME,CATEGORY from DS_JOBS;" > jobname.txt
Could some one tell me what is this uvsh command ?
Thanks a ton,
Cheers,
Sidhartha