Re: SQL Formatting on AIX scripts - SQLDISPLAYMODE
2001-12-03 11:49:48
Subject: |
Re: SQL Formatting on AIX scripts - SQLDISPLAYMODE |
From: |
"Poehlman, James" <James.Poehlman AT BDK DOT COM> |
Date: |
Mon, 3 Dec 2001 11:46:32 -0500 |
Within the select statement itself you can specify a header in place of the
default and make it the width desired.
IE: select
VOLUME_NAME,STGPOOL_NAME"--STORAGE`_POOL_NAME---------",LAST_WRITE_DATE"YYYY
-MM-DD_HH-MM-SS_-------" from volumes.
The parameter in quotes will be sent as the header, with that width.
The parameter in quotes will be sent as the header, with that width.
Hope this helps.
Denny P.
|
|
|