Thats a good idea too. You can also use HDR.SUP and COL.SUP to suppress
the header and column headings.
Israel, John R. wrote:
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:* u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] *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
U2-Users@listserver.u2ug.org <mailto:U2-Users@listserver.u2ug.org>
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
------------------------------------------------------------------------
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
------------------------------------------------------------------------
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users