Try using the -DISPLAYMODE=TABLE option on the dsmadmc command line..

Regards,

Andy

Andy Raibeck
IBM Tivoli Systems
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

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




"Guan, Phillip" <Guan_P AT VDOT.STATE.VA DOT US>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
09/28/2001 05:59
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        sql display output with wide format



Hi all,

Is there a way to force the SQL select results in wide format output? I
need
to put my own column names. If I use '-tab' option, the columns data are
messed up. If I run from a wide enough korn shell window, it displays in
wide format; otherwise, it displays in narrow format. I tried the
SQLDISPLAYMODE but iit doesn't work. I need to put this SQL statement in a
cron job. Any suggestions? Thanks.

Best regards,
Phillip Guan