You could do this: SETPTR ,200,10000,0,0,3,BRIEF,NHEAD,NODEFAULT,BANNER file.txt SORT VOC (FP
Then all you have to do is copy the text file from &HOLD& to wherever you want it. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, June 12, 2009 10:19 AM To: [email protected] Subject: U2-Users Digest, Vol 2, Issue 49 Send U2-Users mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of U2-Users digest..." Today's Topics: 1. Re: Send output from query to text file (Steve Romanow) 2. Re: Uni data / uni-objects connectivity (JC Ocasio) 3. Re: How do you do EDI? (Cooper, Rudy) ---------------------------------------------------------------------- Message: 1 Date: Fri, 12 Jun 2009 10:30:52 -0400 From: Steve Romanow <[email protected]> To: U2 Users List <[email protected]> Subject: Re: [U2] Send output from query to text file Message-ID: <[email protected]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed I don't recommend smart query becuase of its dependency on SB Client. We have a lot of reports done with smart query, and use OLE to transfer them to Excel. It kills the system and requires a per seat license for SB Client. If you built up a toolkit around straight ECL or the DOWNLOAD tool, it seems it will scale better. Michael Martin wrote: > How about SMART.QUERY. > > ------------------------------------------------------------------------ > *From:* [email protected] > [mailto:[email protected]] *On Behalf Of *Norman Bauer > *Sent:* Friday, June 12, 2009 8:22 AM > *To:* U2 Users List > *Subject:* [U2] Send output from query to text file > > 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 > ------------------------------ Message: 2 Date: Fri, 12 Jun 2009 08:35:10 -0600 From: JC Ocasio <[email protected]> To: 'U2 Users List' <[email protected]> Subject: Re: [U2] Uni data / uni-objects connectivity Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" Raul, Also thanks for the response and your response is in consensus with all the other responses I've received. Thanks to all! Juan Carlos Ocasio CCNA Network Planning Manager Information Technology Department County of El Paso 800 E Overland, Rm 401 El Paso, TX 79901 (915) 546-2041 ext 3385 (915) 546-2042 Fax (915) 929-0630 Mobile Mailto:[email protected]<mailto:[email protected]> From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, June 12, 2009 8:16 AM To: [email protected] Subject: Re: [U2] Uni data / uni-objects connectivity Juan, uniobjects acts as bridging software. It connects to your database via the unirpcd socket listener. If the unirpcd is running then, you are most likely missing a configuration file that has the login credentials that uniobjects needs. uniobjects needs a "server", "user", "password" and "account" in order to successfully connect. Since you set up a brand new environment, I would check to see that the user that uniobjects was using on the old system is set up on the new system and that the connection information was migrated over. Now for the caveat: I come at this from a UniVerse background. In theory, uniobjects is the same for both UniVerse and UniData, but I could be all wrong. Regards, Raul Dominguez > From: [email protected] > [mailto:[email protected]] On Behalf Of JC Ocasio > Sent: Thursday, June 11, 2009 10:35 AM > To: '[email protected]' > Subject: [U2] Uni data / uni-objects connectivity > > > > To all: > > > > I'm fairly new to IBM universe and Unidata and have been > tasked with upgrading our old PA-RISC to new Itaniums. Unfortunately we > have little documentation on the configuration and setup of specific items > on our UV database (as in unirpcd, uniobjects etc). In a recent dry test > run, we encountered that several of our external websites could not connect > to retrieve data. I was able to find unirpcd and get the daemon started, > but I also need to get uniobjects running for some of our other > applications. Where would I find this to get it running and or could > someone point me in the right direction? > > > > As mentioned, I've never administered Universe before and my predecessors > documentation is non-existent. > > > > Thanks in advance, > > > > Juan Carlos Ocasio CCNA > Network Planning Manager > Information Technology Department > County of El Paso > 800 E Overland, Rm 401 > El Paso, TX 79901 > (915) 546-2041 ext 3385 > (915) 546-2042 Fax > > (915) 929-0630 Mobile > <mailto:[email protected]> Mailto:[email protected] > > > > > > Envirionment info: > > HP-UX 11.31 > > Universe 10.2.11 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://listserver.u2ug.org/pipermail/u2-users/attachments/20090612/613c b8d8/attachment-0001.html> ------------------------------ Message: 3 Date: Fri, 12 Jun 2009 08:18:57 -0700 From: "Cooper, Rudy" <[email protected]> To: <[email protected]> Subject: Re: [U2] How do you do EDI? Message-ID: <95ddc79b7755db43b11bb33981f1a50f0dd5f...@sageexch2k3.us.sagepub.org> Content-Type: text/plain; charset="us-ascii" Norm, We process 850's, 855's and 810's. We use translation software, takes the raw edi and translates to a text file which we process. The translation software queries our van's for orders and also send's out the 810's and 855's. We have an in-house app that takes the 850 po's and creates in-house orders and poa's. All the translation software does is to convert from and to raw edi. We really don't mess with any of the edi transaction sets nor do we do any of the testing with our edi customers, that's done by our translation vendor. If your interested the name of the company is Unitech. Their pricing is very reasonable. rudy Rudy Cooper Technical Project Lead Sage Publications Inc. 2455 Teller Road Thousand Oaks, CA. 91320 USA T:805.410.7724 www.sagepub.com Los Angeles | London | New Delhi Singapore | Washington DC The natural home for authors, editors & societies Please consider the environment before printing this email -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://listserver.u2ug.org/pipermail/u2-users/attachments/20090612/bf37 1a29/attachment.html> ------------------------------ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users End of U2-Users Digest, Vol 2, Issue 49 *************************************** _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
