David you have the option of doing a select command for each field one at a time. Yes, it is a kludge, but it is an option.
Select * from db Will get them all, then pick the ones that you want. You may want to format them also. Not sure what you are trying to do here. -----Original Message----- From: David E Ehresman [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 10:33 AM To: [EMAIL PROTECTED] 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
