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