I'd also recommend the (Free!) Cedarville Download programs from here:
ftp://ftp.cedarville.edu/
From their readme file:
Create merge files, HTML files, XML files, dbf files, and ASCII files
using LIST-style syntax. Options include adding control breaks, heading
and footing records, secondary file access without the use of
I-descriptors or virtual fields. Reference manual included. Installation
procedures for Unidata, Universe, and Prime Information. Operating
system support for Unix, Windows, and Primos.
IT-Laure Hansen wrote:
Add COUNT.SUP, COL.SUP, HDR.SUP to suppress record count at the
bottom, column headers and report header. note that if longer than 32K
lines there will be a char(12) (page break) inserted. Excel does not
handle that as a page break.
Laure Hansen,
City of Redwood City I.T.
Tel: 650-780-7087
Cell: 650-207-3235
------------------------------------------------------------------------
*From*: [email protected]
<[email protected]>
*To*: 'U2 Users List' <[email protected]>
*Sent*: Fri Jun 12 06:40:53 2009
*Subject*: Re: [U2] Send output from query to text file
Exactly! But also set the page length to something huge (999999) so
that you only have 1 header. Scrape the first couple of lines (if
needed) and the reset is raw text.
**John Israel**
//Sr. Programmer/Analyst///
//Dayton Superior Corporation//
///721 Richard St////.///
///Dayton, OH 45342///
//937-866-0711 x44380///
------------------------------------------------------------------------
*From:* [email protected]
[mailto:[email protected]] *On Behalf Of *Jeff Schasny
*Sent:* Friday, June 12, 2009 9:39 AM
*To:* U2 Users List
*Subject:* Re: [U2] Send output from query to text file
Thats what the &HOLD& file is for. Use the SETPTR command to redirect
printing to the hold file by using mode 3 in the 6th parameter of your
SETPTR statement and append LPTR to your query:
>SETPTR 0,132,66,0,0,3,BANNER FILENAME.TXT,NHEAD,NFMT,BRIEF
>LIST VOC SAMPLE 10 LPTR
This will put the output of LIST VOC SAMPLE 10 into a file in &HOLD&
called FILENAME.TXT
Norman Bauer wrote:
A lot of the times I want to query UniVerse and capture that
information to a text file. I can send to an XML file no problem and
sometimes that is exactly what I want to do. However most of the time
I just want to view the info unformatted without screen scraping or
copy and pasting from Dynamic Connect.
What I really want to do is:
SORT VOC \\server\fileshare\file.txt
Thanks,
Norm
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
[email protected] <mailto:[email protected]>
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
