Norman, check out DOWNLOAD. It is a neat little utility which allows
you to convert your reports into xml, html. tab delimited, comma
delimited files --- and its free. We toyed with it a year ago and now
use it in many of our daily reports.
Barry Rogen
PNY Technologies, Inc.
Senior Programmer/Analyst
(973) 515 - 9700 ext 5327
bro...@pny.com
-----------------------------------------------------
We are continually faced with great opportunities
brilliantly disguised as insoluble problems.
John W
Gardner
----------------------------------------------------------------
P Before printing please think about your environmental responsibility
________________________________
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:59 AM
To: U2 Users List
Subject: Re: [U2] Send output from query to text file
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
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
________________________________
12/6/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING
NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN
ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY
CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING
OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC
TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF
SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS
ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO
A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A
PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.
This e-mail message from PNY Technologies, Inc. is for the sole use of the
intended recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is prohibited. If you
are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
