Plus UDT.OPTIONS 91 ON if you want output conversions applied to the data before writing to the text file.
Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: [email protected] Web: www.rocketsoftware.com/u2 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Matthew Strand Sent: Thursday, June 02, 2011 7:54 PM To: [email protected] Subject: Re: [U2] UniQuery Output to File > send UniQuery output to a file. Perhaps LIST TO DELIM? ------ TO [DELIM "char"] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: > I can't remember how to send UniQuery output to a file. I've looked all > through "Using UniQuery" and the "UniQuery Commands Reference" with no > luck. > > In D3, I could do whatever query I wanted and send it to a file as > tab-delimeted, which would remove any headings, footings, breaks, > subtotals, etc. I was sure UD could do something like this. When I tried > to send output TOXML, wierd things happened to data that should have > been on the same line as other data (it got separated from the line when > I opened the file in Excel). This data was an I-Descriptor (Virtual > Attribute) calling a BASIC subroutine. > > Any help would be appreciated. Thanks, > > Bill Haskett > Advantos Systems, Inc. > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
