Matt,
I'm sorry, I've lost track of which OS you are using, but on AIX if I use
dsmadmc -id=id -pass=pass -tab command >outfile
I get all fields all on one line. Using AS to rename a field is irrelevant
because all headers are gone, only the output from the command remains.
There are no fixed length fields because it is tab delimited. It is perfect
for programming with if you can split out fields on a delimiter though. This
works with ADSM 3.1 and TSM 4.2.
Kai.
>From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
>MC
Matt Cooper (2838)
>Sent: Wednesday, March 27, 2002 2:25 PM
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: Re: NEED HELP CONTROLLING SCRIPT OUTPUT, FIELD LENGTHS
>
>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
>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
>
|
