You could try using -outfile instead of redirection.

An alternative: have the script run Q DB with -DISPLAYMODE=TABLE,
redirecting to your output file. Then run Q DB F=D with -DISPLAYMODE=LIST,
appending to the output file.

With all that said, I'm curious: Q DB F=D includes what is in Q DB, so why
do you want both?

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04/05/2002 08:32
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Query Output Format



If I put a "Q DB" and a "Q DB F=D" together in a script and run it from
a terminal (AIX), the "Q DB" output is in table format and the "Q DB
F=D" output is in list format.  This is what I want.  If, however, I
redirect the output to a file, "RUN QUERY > query.txt", they both come
out in table format and the "Q DB F=D" output is unintelligible because
for the format.  I can't use the -displaymode option because I don't
want the output all one way or the other, I just want it to look like it
does when it runs on the terminal.  I searched adsm.org and saw many
similar questions going back years but no answers.  Has Tivoli really
not come up with a solution to this problem????

David