Do a "select * from syscat.columns", that will provide you with a "Remarks"
column that is basically the description.
syscat.enumtypes & syscat.tables are others of interest...

Dwight


-----Original Message-----
From: Michael Moore [mailto:Michael_Moore AT vfc DOT com]
Sent: Friday, September 13, 2002 9:57 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Select Column Descriptions


Is there anywhere that describes what a column in a select command result
is telling you?  For example:

I issue the following select command:
select * from summary where date(start_time) = current date - 1 day and
entity='ITGCURS6'

I get the following:

   START_TIME: 2002-09-12 00:01:59.000000
     END_TIME: 2002-09-12 00:03:47.000000
     ACTIVITY: BACKUP
       NUMBER: 787
       ENTITY: ITGCURS6
     COMMMETH: Tcp/Ip
      ADDRESS: 167.64.22.242:33443
SCHEDULE_NAME:
     EXAMINED: 1
     AFFECTED: 1
       FAILED: 0
        BYTES: 2826251
         IDLE: 0
       MEDIAW: 62
    PROCESSES: 1
   SUCCESSFUL: YES
  VOLUME_NAME:
   DRIVE_NAME:
 LIBRARY_NAME:
     LAST_USE:


What are the following telling me

AFFECTED - Is this backed up? or expired?
MEDIAW - is this in seconds (I HOPE!!)  is this total time, or just the
max?

Is there somewhere in the documentation that describes each column?  If
there is, I can't find it!

I have been asked to start tracking the amount of data being backed up on a
daily basis, and I am looking for the most straight forward way.  I really
don't want to run several queries, just to get this information.
Management wants it in one neat spreadsheet.

Thanks!

Michael Moore
VF Services Inc.
121 Smith Street
Greensboro,  NC  27420-1488

Voice: 336-332-4423
Fax: 336-332-4544