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