Joe - you can get shorter headers by selecting functions on the columns,
for example -
select left(volume_name,6) as volume, left(stgpool_name,10) as stgpool -
from volumes -
where stgpool_name = '9840APOOL' -
and status = 'FULL' -
and date(last_write_date) >= current date - 7 days
om volumes.
> The parameter in quotes will be sent as the header, with that width.
> Hope this helps.
> Denny P.
>
> -Original Message-
> From: Andrew Raibeck [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 03, 2001 9:26 AM
> To: [EMAIL PROTECTED]
> S
e sent as the header, with that width.
Hope this helps.
Denny P.
-Original Message-
From: Andrew Raibeck [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 9:26 AM
To: [EMAIL PROTECTED]
Subject: Re: SQL Formatting on AIX scripts - SQLDISPLAYMODE
The SET SQLDISPLAYMODE command only
Todd, here's another way around the problem:
Add -commadelimited as a parm after -pa=.
That causes the output to come out in a wide string, with the fields
separated by commas, no wrapping.
Since you are doing this from AIX, it's very easy to handle that output in
the shell script.
You could,
The SET SQLDISPLAYMODE command only "holds" for a given session. Thus when
the admin session from which you issued that command ends, the next admin
session that issues the SELECT command uses the default SQLDISPLAYMODE.
How about combining your SET SQLDISPLAYMODE and SELECT commands into a
singl
Well Todd,
This is the TSM default. In order to get the output in the required format
you need to use the -outfile option. This way you will get the output as if
you are at the admin command line.
Like this:
dsmadmc -id= -pa= -outfile= "your select goes
here"
Ilja G. Coolen
