Antwort: Re: [ADSM-L] Antwort: Re: [ADSM-L] select

hi, Jop and Richard !

the solution is easy: the linux box has to be as wide as the chracters of a
complete line need...

many thanks, best regards

Dierk




                    "ADSM: Dist
                    Stor Manager"        An:     ADSM-L AT VM.MARIST DOT EDU
                    <ADSM-L AT VM DOT MA        Kopie:
                    RIST.EDU>            Thema:  Re: [ADSM-L] Antwort: Re: 
[ADSM-L] select

                    20.06.2005
                    13:24
                    Bitte
                    antworten an
                    "ADSM: Dist
                    Stor Manager"






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