Setting uvsh directory settings

[sidharthh]

Hi,
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 anyone please let me know what are the settings that needs to be done and is it safe ?
Could some one tell me what is this uvsh command ?

Thanks a ton,

Cheers,
Sidhartha

[ArndW]

You need to "cd" to the project directory and make sure that $DSHOME/bin is in your path, then you can issue your

Code: Select all

uvsh "select NAME,CATEGORY from DS_JOBS;" > jobname.txt

[sidharthh]

Thanks, once i was in the project directory it works.

Currently, i get the below output,

Job name. Actual job Name
Category. Actual Category Name

I am trying to improvise the output format such that both the column values (DS_JOBS.NAME JobName, DS_JOBS.CATEGORY) are
1. Separated by comma (,)
2. Both the column values should appear in the same line
3. The Column heading not to displayed,

I am looking for,

Actual job Name, Actual Category Name

Am just wondering how to get this formating.
Could someone please help me out on this ?

Cheers,
Sid

[ray.wurlod]

This is non-trivial. You need to change the device width in the same dssh shell as the one in which you execute the query. Therefore your query needs to contain \xFE characters (in lieu of line feeds between commands).

Ignoring that for the moment, if your job names and category names are short enough, you could use an I-type expression.

Code: Select all

dssh "SELECT NAME || ',' || CATEGORY FROM DS_JOBS WHERE NAME NOT LIKE '\\%';"

The total number of characters must be less than 80.