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: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 04/05/2002 08:32 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] 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