Ralph,
1. There are some reporting tools that will do this: mvQuery for one.
2. If you are using UniVerse 10, you can generate XML out of RetrieVe and
SQL. Take a look at the TOXML ATTRIBUTES syntax. This goes to screen, but
you can divert this to file using a paragraph to do a DIVERT.OUT ON
Thanks David and everyone who responded.
I'm trying to set it up so for the user it's transparent. So when they download
the file Excel
automatically opens it.
Thanks again for the ideas. - Ralph
David Scoggins [EMAIL PROTECTED] wrote:
Ralph,
You may be looking for something a little more
Goo'day,
At 16:06 27/07/05 -0700, you wrote:
Are there any utilities to pass as comma delimited file from
Unidata/Universe and have it open/imported into Excel?
If you're using the normal terminal emulators, eg AccuTerm, wIntegrate
and whatever HostAccess is called these days, there are the
Ralph,
You may be looking for something a little more elegant, but if you generate
a comma delimited file and give it a .csv suffix, Excel will just open it.
From there you can save as any of the various file types that Excel
supports.
As for executing a command - I presume you mean *on* the
In Unidata you can do it with the LIST command using the TO and DELIM clause
hth,
Allen
LIST
Syntax
LIST [DICT] filename [record_IDs] [selection_criteria] [sorting_criteria]
[attributes | ALL] [format_options] [report_options] [TO [DELIM
char]text_file
[ELEMENTS] [WITHDTD] [XMLMAPPING
