Yes. use the SYSCAT.COLUMNS table.

   SELECT * FROM COLUMNS WHERE COLNAME='MESSAGE' AND TABNAME='ACTLOG'

See http://msgs.adsm.org/cgi-bin/get/adsm0304/121.html regarding the 250
character limitation.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Justin Bleistein <justin.bleistein AT SUNGARD DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/13/2003 13:55
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: format output



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