I have tried everyone's suggestions.  I believe the fact that I have one  AS
statement in the script that it will ignore the attempts of fixing the
output into a 1 line per node output.  The -COMMAdelimited , -TABdelimited,
-OUT didn't work.   I was able to get a 1 line output, with a title line and
some other 'extra' lines of TSM header and msgs.   The only way I seem to
some other 'extra' lines of TSM header and msgs.   The only way I seem to
have in controlling this is with the suggestion from Paul, using an AS "
big area  " .   This whole 'programming' area seems to go by a lot of
undocumented rules.  Why don't they document them somewhere?  Or give a
direct reference to which other product doc to look at?   I am able to
directly control the length of a numeric output with 'decimal(xx)'
statement.  What about character output?   I am still disappointed that I
can not seem to get an output that would be nothing more than what I really
want 12 character node name delimiter 4 digit number of days since last
access  delimiter   contact field name of 20 characters,    then the next
line .... . The best I came up with is as follows.
SCRIPT...

select node_name as "NODE", -
  cast((current_timestamp-lastacc_time)days as decimal(4)) as "DAYS", -
 contact as "           CONTACT              "  from nodes where -
  cast((current_timestamp-lastacc_time)days as decimal) >= 7

OUTPUT FILE .....

ADSTAR Distributed Storage Manager

Command Line Administrative Interface - Version 3, Release 1, Level 0.7

(C) Copyright IBM Corporation, 1990, 1999, All Rights Reserved.



ANS8000I Server command: 'select node_name as "NODE",
cast((current_timestamp-


NODE                        DAYS                CONTACT

------------------                 ------
--------------------------------
--------------------------------
AG570                          58     Elliott/desktop
AG570                          58     Elliott/desktop

DEFIANT                      12     R.Schulte, D.Harrison

DSS1OLD                    343     Connie Brooks

WIN2KAD                     34     Karlene Michael

ANS8000I Server command: 'COMMIT'



ANS8002I Highest return code was 0.