Re: column width
2005-05-12 11:40:26
Just put
SET SQLDISPLAYMODE WIDE
Before your select command.
Bill Boyer
"Some days you're the bug, some days you're the windshield" - ??
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Thursday, May 12, 2005 11:21 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: column width
Hello Everyone!
I have issued a command to find the error and warning messages and have emailed
it to myself. Here is the command:
select date_time,msgno,message from actlog where date_time>current_timestamp -
1 day and severity in ('E', 'W')
Is there a way to make the message column wider so that it isn't several lines
long? Thank you!
DATE_TIME MSGNO MESSAGE
------------------ ----------- ------------------
2005-05-11 2035 ANR2035E RUN:
10:45:55.000000 Administrator
PMSTORAGE is not
authorized to
issue this
command.
(SESSION: 320563)
2005-05-11 2035 ANR2035E RUN:
10:45:55.000000 Administrator
PMSTORAGE is not
authorized to
issue this
command.
(SESSION: 320563)
2005-05-11 1423 ANR1423W Scratch
10:46:17.000000 volume T00953 is
empty but will
not be deleted -
volume access
mode is "offsite-
".
2005-05-11 2035 ANR2035E RUN:
10:49:28.000000 Administrator
ADMQ is not
authorized to
issue this
command.
(SESSION: 320568)
2005-05-11 2035 ANR2035E RUN:
10:49:28.000000 Administrator
ADMQ is not
authorized to
issue this
command.
(SESSION: 320568)
2005-05-11 480 ANR0480W Session
11:00:21.000000 320586 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320586)
2005-05-11 480 ANR0480W Session
11:00:21.000000 320588 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320588)
2005-05-11 480 ANR0480W Session
11:00:21.000000 320590 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320590)
2005-05-11 480 ANR0480W Session
11:00:21.000000 320592 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320592)
2005-05-11 480 ANR0480W Session
11:00:21.000000 320594 for node
CS-NICE-STORAGE
(STORAGE_CENTER)
terminated -
connection with
client severed.
(SESSION: 320594)
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
|
|
|