Hi If you want to create a delimited file, rather than a capture of a listing, I suggest downloading either EXPORT from my website or DOWNLOAD from Cedarville. They are both enquiry-driven and free. Brian
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Schasny Sent: 12 June 2009 14:59 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: [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] 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
