DSJOBS - Command Line

[Raftsman]

When issuing the following command in administrator;

SELECT NAME FROM DS_JOBS WHERE CATEGORY = '\Jobs\EDW\ICMS'

I would like to write the results into a file for future reference. Is there a way.


Thanks in advance

[dspxguy]

You need to set COMO on in administrator

In Admin command line:

COMO ON filename

Then execute your query and output will be written to file in Projects/ProjectName/'&COMO&'/ path

Dont forget to turn off COMO.

COMO OFF

Thanks

[Raftsman]

The output column seems to be fixed. The output is wrapped. How do I expand the column length?

Thanks

[chulett]

Add FMT 'xxL' after the column name, replacing xx with the output size you want to use. So, for example to make it a 30 character string, use SELECT NAME FMT '30L' FROM etc.

[ray.wurlod]

You can use standard redirection operator. For example:

Code: Select all

cd $ProjectDir
$DSHOME/bin/dssh "SELECT NAME FMT '60L' FROM DS_JOBS WHERE CATEGORY = '\Jobs\EDW\ICMS';" > filepath