Hi Dierk,

Nope, just narrow and wide.
If you want to sort stuff or if you want a wider view try it with the
"-outfile" and import this in a spreadsheet.

Cheers,

Jop de Graaf
Certified Tivoli Consultant/Instructor

InterAccess Netherlands

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Dierk Harbort
Sent: maandag 20 juni 2005 12:23
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Antwort: Re: [ADSM-L] select

Hi,

thanks. it works, i changed sqldisplaymode from narrow to wide.
so now i can read long file names in one line.
but the next columns now are sorted line by line...
are there any other displaymodes ?

regards


Hi,

Try the following:

Set sqldisplaymode wide (you can check the settings with 'q sql' on the
server)

Or spool the output of this command to a file.
Dsmadmc -id=Userid -pa=YourPassword -outfile=NameOfYourFile 'select xxx
...'

Cheers.
Jop de Graaf

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Dierk Harbort
Sent: maandag 20 juni 2005 10:40
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] select

hi all !

a select statement in tsm brings right information, but data output was
cut
in several lines: the column is to small.
is there a way to tell tsm-select statements to make columns wider ?

any idea is welcome

regards, Dierk