speaking of the "varchar(#)" with the tsm database. In Oracle you can use
the "describe" command to show the attributes to a column (like in the data
dictionary). Is there something like that for the TSM database?

--Justin Richard Bleistein
Unix/TSM Systems Administrator (Sungard eSourcing)
Desk: (856) 566 - 3485
Cell:    (856) 912 - 0861
Email: justin.bleistein AT sungard DOT com



                      Bill Boyer
                      <bill.boyer@VERIZ        To:       ADSM-L AT VM.MARIST 
DOT EDU
                      ON.NET>                  cc:
                      Sent by: "ADSM:          Subject:  Re: format output
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      05/13/2003 04:36
                      PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






Be careful using the SELECT command on the activity log table. The MESSAGE
column is a max of VARCHAR(250) and some of the message text gets
truncated.
This also is true if you use the ODBC interface to access that column.

Bill Boyer
DSS, Inc.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Richard Sims
Sent: Tuesday, May 13, 2003 2:33 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: format output


>Is there a way to format the output of a dsmadmc command so that it
>doesn't wrap the text?  like when I do a:
>dsmadmc -id=admin -pass=pass q actlog begindate=now-1 msgno=1341
...

Start by exploiting all the options that dsmadmc makes available to you,
as in -DISPLaymode=LISt.
And IBM specifically made the Select command available for customers to
produce reports in the format they desire, through SQL functions.

  Richard Sims, BU