I've been using the LIST .... TO DELIM a lot lately. It works reasonably well
although I don't use it for any MV'd data. You can enter a <TAB> as the delim
and it will work. You can even put the full path for the text_file in the
statement otherwise it's created in the current directory. As Wally says turn
on UDT.OPTION 91 although I think dates are the only thing that really needs it.
hth
Colin Alfke
Calgary Canada
> From: mstrand
>
> > 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
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
