There is a command to change the width of the field output: SET SQLDISPLAYMODE WIDE
But it may not do what you want. Are you talking batch output? -----Original Message----- From: Hunley, Ike [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 4:36 PM To: [EMAIL PROTECTED] Subject: Select statement Hi all, I hope someone out there has the answer for this. How do I increase the output field size for filespace_name so I can output the filespace_name along with quantity and node_name? Thanks -----Original Message----- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 3:57 PM To: [EMAIL PROTECTED] Subject: Re: TSM Database Tables Hi Pattie, I"m not aware of any updated list, but you can use the SELECT statement to find out: SELECT TABNAME FROM TABLES You can use the following to find out what columns are in the table: SELECT * FROM COLUMNS WHERE TABNAME='tablename' where tablename is the name of the table you are interested in (be sure to put the table name in uppercase). Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Patricia LeBlanc <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 02/15/2002 13:40 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: TSM Database Tables Anyone know where I can find (online) an updated copy of the TSM Database Tables? Thanks, pattie Liberty Mutual Backup and Recovery Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
