Heintz,

Use the command SET SQLDISPLAYFORMAT WIDE command to do this

Mike Kaczmarski
IBM Corporation
ADSM Development
kacz AT us.ibm DOT com



        ADSM-L AT VM.MARIST DOT EDU
        11/14/97 08:02 AM
Please respond to ADSM-L AT VM.MARIST DOT EDU @ internet


To: ADSM-L AT VM.MARIST DOT EDU @ internet
cc:
Subject: ADSM V3: admin command select ...

The administrator command

    select * from syscat.tables

gives an output with 7 columns:

TABSCHEMA  TABNAME  CREATE_TIME  COLCOUNT ... REMARKS

How can I force the command to give an output as
discribed on page 600 in the Admin Reference Guide?
(like FORMAT=detailed)


Heinz

-----------------------------------------------------------------------Heinz 
Flemming                             flemming AT rz DOT uni-karlsruhe.deHeinz 
Flemming                             flemming AT rz.uni-karlsruhe DOT de
Computing Center, University of Karlsruhe
Zirkel 2, P.O.Box 6980
D-76128 Karlsruhe
Germany

phone 0721 - 608 6427                                  fax 0721 - 37550
-----------------------------------------------------------------------