[U2] Help with REVISE (AKA ENTRO/ENTROC)
Apparently somewhere through the years, my brain has dropped a few bits about using REVISE. In a multivalue association on screen 2 (or 3, 4, etc.), you can delete a row by selecting the row, choosing the first field, and entering ##. No problem. I *thought* to insert a row, you selected a row, chose the first field, and entered a . But when I do that, I get Line 0 has not been defined. Can someone please tell me what I've mis-remembered? How do you insert a value (not add to the end, it has to be inserted between two exiting values) in REVISE/ENTRO? Your help will be greatly appreciated! Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 225 341 1778Web: www.oliver.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
So me a person who wants* to work in RPL, and I'll show you desperate. On Nov 1, 2012, at 10:46 AM, Wjhonson wjhon...@aol.com wrote: http://simply.engcen.com/JobAdCareerJet.asp?JobID=1253361 Really don't these people get actual... you know... specs? What did they do skip some words? Show me a single person in the world who has all of : Universe, Unidata, D3, Jbase, Revelation AND RPL and I will show you a liar Clearly they meant something like either/or ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Command that turns off default command stacker
ED VOC STACKWRITE Change ON to Off I think that's what you are looking for. On May 5, 2012, at 12:11 PM, Wjhonson wjhon...@aol.com wrote: The users arent getting to TCL The stack is created simply by logging in. It doesn't matter if you are at TCL or not. -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Sat, May 5, 2012 12:06 pm Subject: Re: [U2] Command that turns off default command stacker ok, well... a reasonably written replacement is a shell. You never get to real tcl, so you don't have that problem. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 5/5/2012 12:04 PM *Subject:* Re: [U2] Command that turns off default command stacker It isn't, that's the point. It's turned on by default when you load Universe It sits there in the background creating thousands of savedlists since it makes one for every user and port combination We have thousands of ports and dozens of users and it's been this way for 8 years now Times every account they may log to and some of our users log into multiple accounts during the day The 40,000 lists i mentioend was for just *one* account. The users dont use the stacker, but that doesnt matter it merrily creates a stack that just says LOGIN ove and over and over -Original Message- From: Bill Haskettwphask...@advantos.net To: U2 Users Listu2-users@listserver.u2ug.org Sent: Sat, May 5, 2012 11:50 am Subject: Re: [U2] Command that turns off default command stacker After all of these years, it's hard for me to digest the fact that the porcine U2 stacker is even in use! :-) Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 5/5/2012 8:43 AM *Subject:* Re: [U2] Command that turns off default command stacker Well you have to do it at least once! In a single one of our accounts we had 44000 of these buggers -Original Message- From: Allen Elwood RRaelw...@socal.rr.com To: U2 Users Listu2-users@listserver.u2ug.org Sent: Sat, May 5, 2012 1:02 am Subject: Re: [U2] Command that turns off default command stacker or you could just write a program to purge the file of those entries and run it from time to time :-) On 5/4/2012 5:35 PM, Wjhonson wrote: I found the answer In the VOC is an item called STACKWRITE the first attribute is an X the second attribute says ON If you change that second attribute to OFF then universe will stop creating all these thousands of savedlists entries which are keyed to user combined with port number ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SQL Equiv to Save-list?
How about SELECT CUSTNAME, CUSTADDR, CUSTCITY FROM CUSTOMERFILE SLIST 'saved_list-name'; Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Apr 8, 2010, at 1:28 PM, Perry Taylor wrote: You might try... select custname, custaddr, custcity from customerfile where custid in (select EVAL @RECORD from SAVEDLISTS 'the_saved_list_name'); Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, April 08, 2010 8:09 AM To: U2 Users List Subject: [U2] SQL Equiv to Save-list? Is there a way in SQL without resorting to subqueries to select a table, then save the resulting field, Then use that list for a future SQL query? ex. select customerid from invoicefile; save the list of customerid for later use later get that list of customerid select cust.name , cust.addr , cust.city, etc from customerfile where cust.id=(list of customerid) and cust.st='ny' Or is this one of those pick ain't it great we can do this features? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, 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. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
In Spectrum magazine, we use the term MultiValue Basic to talk about the programming language in articles that are not platform specific. I put it in the style and usage guide for just the reasons being brought up here. I don't see any reason not to add other MultiValue generic terms. MultiValue Query comes to mind. I'm open to suggestions about that and other terms. Post them here, or if you'd rather not, just send them to me at edi...@intl-spectrum.com (or my regular e-mail address). Regards, Clif -- Clifton Oliver, Managing Editor International Spectrum Magazine Spectrum Tel: +1 720 259 1356 Clif's Direct Tel: +1 619 460 5678 On Mar 23, 2010, at 10:40 AM, Brian Leach wrote: Tony As always you make some good points. 1/ It's not the term MultiValue I have a problem with - that we should continue to support since it already has a meaning and a presence, and one worth building on. For one thing, MVDBMS is a nice abbreviation! It's the terminology used within that, that is the problem: for example, I want to put some web pages out giving an introduction to the query language. What do I call it? If I use the word 'RetrieVe' that alienates every other ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
Well, the terminology issue is something we (Spectrum magazine in particular) can promote since we are already committed to promoting the term MultiValue (note the mid-cap casing) and the MultiValue Logo. We just add such terms to our Style and Usage Guide and use them in the magazine. Side note: Is there any interest in us having our Style and Usage Guide available online? I'm interested in hearing what folks would find an acceptable term for TCL/ECL/etc. As to the idea of of a generic book, groups of experts, etc., that sounds like a fame and glory no profit Open Source kind of thing. A lot of the experts you might want to attract are dudes and dudettes trying to make a living. That goes back to some of Tony's comments. How could that be made worthwhile for said experts to forgo revenue producing time to produce a non-profit book? Considering some other Open Source documentation efforts, I'm not saying it can't be done. I'm just challenging everyone to present detailed ideas for how it could be made to work. Regards, Clif On Mar 23, 2010, at 6:09 PM, James Canale, Jr. wrote: I think it would be great do something like this. Multivalue Query [mvQuery] Multivalue Basic [mvBasic] Multivalue PROC [mvPROC] I also think it would be great if someone could write a piece of a book that is very generic (keep it at a 20,000 foot view) which covers each major topic area. Once complete, a group of experts-at-large in the various flavors add platform specific details. When complete, one or more of the know-it-alls [like some of the gurus on this list] combine the common parts, while leaving the unique areas in place. Basically, a wiki to book transformation. Many of the books sold today have two, three, and even more authors (especially the technically oriented books). Something like this could reduce the work required (just doing a piece of the whole) and increase the potential market (supports most platforms) for sales. I see a lot of talent on this list that can pull something like this off, it just needs a great leader (and I see many of them here too). Regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Tuesday, March 23, 2010 6:39 PM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide In Spectrum magazine, we use the term MultiValue Basic to talk about the programming language in articles that are not platform specific. I put it in the style and usage guide for just the reasons being brought up here. I don't see any reason not to add other MultiValue generic terms. MultiValue Query comes to mind. I'm open to suggestions about that and other terms. Post them here, or if you'd rather not, just send them to me at edi...@intl-spectrum.com (or my regular e-mail address). Regards, Clif -- Clifton Oliver, Managing Editor International Spectrum Magazine Spectrum Tel: +1 720 259 1356 Clif's Direct Tel: +1 619 460 5678 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
Got it. grin I'll get it updated with our latest revisions and get an html version up shortly. (Read: It's my part-time job. I'll get to it--promise) Regards, Clif I'll post here and elsewhere when it available. On Mar 23, 2010, at 10:34 PM, Dan McGrath wrote: My apologises, I'd be interesting in reading should have been I'd be interested in reading the Style and Usage Guide -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, 24 March 2010 4:31 PM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide Hi Clif, I'd be interesting in reading. I write the occasional piece and probably should use more encompassing terms to enhance future search-ability and to promote the database style. Regarding ECL/TCL/etc, since I'm normally in Unix/Linux land, I normally think of them as shells, which brings MultiValue Shell (MVSH) to mind. ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
Well, when the best known providers can't even get correct documentation in their manuals or examples that actually work, one wonders how suited they are to producing such literature. I'm not arguing against your point that they *should* be the leaders--like Sun, Microsoft, etc.--in literature. But really, when their own manuals have gross errors that have gone uncorrected for 5 to 10 years, who would trust them? Several years ago, I offered one of the major providers that I would re-write their course material for free just to make sure we had something to teach from that was at least correct. No charge. They weren't interested. Go figure. Regards, Clif On Mar 22, 2010, at 1:20 PM, Symeon Breen wrote: There is none of this in the MV world - the providers are the best suited to producing such literature, and in my opinion should be taking the lead in this ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Terminal Emulator and Telnet Client for a MacBook Pro
Yes. Parallels only runs on the Intel Macs. For the PowerPC Macs the option was VirtualPC. (Before Microsoft acquired it. Don't know if they kept it available for Mac after that.) It was slow, but for the most part worked. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Mar 20, 2010, at 8:42 AM, Anthony W. Youngman wrote: In message 005901cac75f$0852b8e0$18f82a...@com, Kevin Gusler kgus...@mortgagebuilder.com writes Has anyone tried running SBClient 5.3.4 - 5.4.4 in Parallels on a Mac? Are there any issues? We are running (windows) SB+ 5.3.4 and Universe 10.3.3 and have a few users that wish to use Macs for their client pc's. Just wondered if there was a downside. How new are the Macs? Does parallels only run on the new Intel Macs? (Sorry, I don't use a Mac, don't know when the switchover was. But there are probably still a fair few Power Macs still in general circulation.) Thanks in advance. Cheers, Wol -- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Terminal Emulator and Telnet Client for a MacBook Pro
Hi, Dave. I use iTerm. It's free (in both senses of the word). http://iterm.sourceforge.net/ Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Mar 17, 2010, at 2:32 PM, Dave Taylor wrote: Does anyone have a recommendation for a terminal emulator and telnet client for a MacBook Pro or any MAC OS X operating system that will connect to Universe/Unidata? Thanks, Dave Taylor Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Terminal Emulator and Telnet Client for a MacBook Pro
Aw, you're just jealous 'cause we get to use a real operating system. ;-) On Mar 17, 2010, at 2:57 PM, Symeon Breen wrote: I recommend you buy a pc and use that instead Sorry - i just don't like apple . -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor Sent: 17 March 2010 21:33 To: u2-users@listserver.u2ug.org Subject: [U2] Terminal Emulator and Telnet Client for a MacBook Pro Does anyone have a recommendation for a terminal emulator and telnet client for a MacBook Pro or any MAC OS X operating system that will connect to Universe/Unidata? Thanks, Dave Taylor Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Spectrum
I'll be there. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Mar 4, 2010, at 12:55 PM, Kevin King wrote: Anybody? Bueller? Bueller? On Wed, Mar 3, 2010 at 9:55 AM, Kevin King precisonl...@gmail.com wrote: Spectrum is just over a month away. Who's in? -Kevin http://www.PrecisOnline.com -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata PE Linux
Would you mind sharing what those tweeks were? Thanks. Regards, Clif On Nov 13, 2009, at 9:46 AM, Douglas Hedges wrote: I got a PE for Linux (RHat) from IBM before Rocket took over. I installed it on Ubuntu and am just now testing it (so far, so good). There are a few tweaks but nothing major to getting it installed. I ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Agile and Scrum
Agreed. An excellent post. And at 769 words, it's half an article. (Hint, hint.) David, if you (or anyone else reading this thread) would like to contribute an article to Spectrum magazine on this or related topics, please contact me. You can reach me at my part-time address, edi...@intl-spectrum.com, or at my regular address or phone number in the sig block below. An Agile Anecdote: I was going to try a simple form of XP (Extreme Programming) on a project several years ago. The client loved the idea and agreed to it with few reservations. I knew they just didn't get it when the next meeting they asked me to provide them with a Gantt chart showing the iteration milestones and what features would be in each iteration. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Oct 15, 2009, at 1:36 PM, Boydell, Stuart wrote: Good post! Stuart Boydell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org ] On Behalf Of David A Barrett Sent: Friday, 16 October 2009 07:01 To: u2-users@listserver.u2ug.org Subject: [U2] Agile and Scrum As a Scrum practitioner in an MV environment for the past 5 years or so, I think I can shed some light on this. First, the Agile Manifesto: ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing
I seem to recall that they added the CONCURRENT option to BUILD.INDEX several years back but didn't document it except in the patch file for that release. Does anyone else remember this? Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Sep 9, 2009, at 2:43 , Dan Fitzgerald wrote: Building indices means exclusive locks on the file, i.e., downtime. The good news is that the builds are usually very quick. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] which files have triggers
November/December 2007. www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx Regards, Clif On Jul 13, 2009, at 12:23 PM, Brian Leach wrote: Hi George I wrote about this in one of the back issues of Spectrum (you can download these from www.intl-spectrum.com). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 13 July 2009 19:51 To: U2 Users List Subject: [U2] which files have triggers Is there a way to list which tables have active triggers? I know about LIST.SICA tablename, but if I make a change to the trigger program, and I need to DROP the trigger from all the TABLES usings it, how would I find out all the TABLES that are using that trigger? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UV] UniDebugger FTP mode
Does anyone know a way to change the UniDebugger's FTP mode to Passive? Thanks. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] International Spectrum Conference - Twitter?
As the Managing Editor of International Spectrum magazine (one of my Part-Time jobs), I'm thinking of Twittering from the Conference next week. Being new this social media, I have to wonder if this is of any interest to people or just adding to the Noise of the Internet. I'd like to hear your opinions. Regards, Clif Twitter: @clifolliver -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] International Spectrum Conference - Twitter?
My last comment on this before suggesting we now move over to the u2- community list if there are further ideas of a non-technical nature. (I found Symeon's idea of using Twitter to pass along alerts from phantoms rather clever.) I want to thank everyone who shared their comments, both on list and off. There are some other attendees who responded and are now following, so I've created a hashtag #intlspec and defined it on tagal.us. If other's tweet from the Conference and include that (including the #) in their note, anyone interested can see a multi-person commentary on twitter.com (login required) or hashtags.org (no login required). I, for one, am not going to be attempting to blog all the day's events; I don't think Twitter would work very well for that. You won't be hearing (from me, anyway) what I had for breakfast. Like others, I can't wonder why anyone would think anybody but their cardiologist would care. I have in mind observations, notes, comments, and ideas for articles for those who might want to be published. Hopefully some other attendees will join in so there is a variety of opinions and ideas. This is an experiment. Could be fun, might prove useful, may be a flop. As to a blog--I've talked with Nathan Rector and passed your comments and requests along. If anyone wants to continue a discussion of this or other social media has a place in business, let's take it over to u2-community list. Looking forward to seeing some of you at the Conference! Thanks again. Regards, Clif On Mar 20, 2009, at 12:28 PM, Tony G wrote: From: Glen Batchelor Clif, Why don't you just set up a new category in the Spectrum blog for conference happenings? It has an RSS feed built-in and anyone can check on it from the intarweb. You can post video segments, if equipment is available, and sound bytes. I think the point is that there isn't a blog or other mechanism setup, but he already twitters and almost anyone can just visit that one web page. Like I said, I don't personally like the idea of Twitter (social blogs tell you what someone had for breakfast but now twitter allows them to tell you about every bite) but it _is_ a popularly accepted phenomenon and can probably be used for non-silly purposes (like trade shows) if given the chance. I'd say if he has it, do it, and if people aren't interested, tough. Ya can't please everyone all the time. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] U2.NET question
Hi, all. Is U2.NET included with (in this case) UniVerse like UniObjects.NET is, or is it a separate priced product like U2 Web DE (aka Redback)? Thanks. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Triggers
Which can get interesting if you have some of that old pre-EXECUTE legacy code that generates a Proc, writes it to the VOC, and CHAINs to it. Or that executes CREATE.FILE. Or that... Of course, you can put a trigger on the VOC to log changes. Regards, Clif On Oct 15, 2008, at 5:40 AM, Anthony Youngman wrote: But IF you can update VOC, you CAN bypass remote voc, which is what David said! As part of your security you need to make sure that users CAN'T update VOC (which is rather harder than it seems at first glance). Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ] On Behalf Of Susan Joslyn Sent: 15 October 2008 12:36 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Triggers David, With the use of remote voc you really can prevent by-pass of wrapped TCL commands. Completely, unequivocably. Regards, Susan Joslyn SJ+ Systems Associates, Inc. PRC(r) Real software configuration management for U2! -- Date: Wed, 15 Oct 2008 08:26:00 +1100 From: Hona, David S [EMAIL PROTECTED] Subject: RE: [U2] Universe Triggers You can by-pass them if you can update the VOC. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Triggers
Why not just test it? Create a file with some number of records. Write a simple program to select the file and change one character in the record. Write it back to the file. Time it. Add an AFTER UPDATE trigger calling a subroutine that does *nothing* but a RETURN. Run the program again. Time it. You have your overhead answer. Don't ask opinions of pontificators when the machine will tell you the truth. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Oct 7, 2008, at 8:22 PM, Mike Roosa wrote: We are getting ready to implement triggers on a universe system running under Windows Server 2003. I created a trigger and tested it out and it appears to do exactly what we need. My question is are there any gotchas or issues we should be concerned about with triggers? Are there any performance issues that anyone has seen related to triggers? Thanks, Mike Roosa --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Triggers
Brian wrote an excellent article about UniVerse Triggers in the Nov/ Dec 2007 of International Spectrum magazine (p. 12). You can download that issue from http://www.intl-spectrum.com/mag/NOVDEC.2007/default.aspx Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Oct 8, 2008, at 1:54 AM, Brian Leach wrote: One gotcha is that once a trigger is on there, you can't easily change/extend it unless your system has a downtime period in which everyone is logged out. For this reason on 24x7 sites I use a master trigger that can call subtriggers, held as a list in a parameter file. This means that a new subtrigger can be inserted, old subtriggers removed etc without having to log everyone out. Yes, it means an extra read and yes it is an imperfect solution in an imperfect world.. And of course remember you are running under transactional constraints when using triggers. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Triggers
Mike: Another thing to watch out for is the transaction constraints Brian mentioned. Where I've seen this most often is if your application has programs that add new records to a file without first getting a record lock with a READU. UniVerse lets you write in the dark if you want to. (Whether that is right or wrong is a different debate, but it happens.) Since triggers force transaction constraints, this will then fail. I don't remember the exact wording of the error message, something about ISO isolation level. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] .net uniobjects error 39204
Now why couldn't the manuals have said that? laughing Great explanation, Ray. Thank you very much. Regards, Clif On Sep 19, 2008, at 12:57 AM, Ray Wurlod wrote: The slave referred to here is the process that needs to log in to do the work. When you connect via uvcs (which you do from UniObjects to UniVerse) the listener is unirpcd (or uvrpcd on older versions), listening on port #31438 (by default). A request to connect has unirpcd consult its services file (unirpcservices) for the name of the service that you have requested (that is, uvcs, the UniVerse common server), checks from the services file that your IP address is eligible to request that service and, if so, starts an instance of the associated executable, in this case uvapi_server. The uvapi_server is then your connection's agent process on the server, looking after such things as maintaining communications, monitoring the inactivity timeout interval, and so on. When some work needs to be done, such as executing a query, a child process uvapi_slave is logged in to do the actual work. Its stdout and stderr are redirected back to its parent (uvapi_server) so that the results may be returned to the client. It is this slave process that has failed to start correctly. Many reasons exist why this might be so. The most common, in my experience, is that there is no clean path to TCL - that is, the LOGIN process in the account puts unexpected text on stdout. All uvcs processes must be guaranteed a clean path to TCL. You can test @TTY = uvcs in the LOGIN paragraph in a similar way that you might test @TTY = phantom to bypass application startup for PHANTOM processes. (This might not be your actual problem, of course, and I'm not suggesting that it is, but it's something that's definitely worth investigating.) - Original Message - From: Clifton Oliver [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: Re: [U2] .net uniobjects error 39204 Date: Thu, 18 Sep 2008 16:19:26 -0700 Here's the error. I got this from the UniDK/include/Uvoaif file. UVE_SR_SLAVE_EXEC_FAIL = 39204' The slave failed to start correctly Unfortunately, just as an out of context error message, I don't know what it means. Maybe someone else can pick it up from here. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] .net uniobjects error 39204
Here's the error. I got this from the UniDK/include/Uvoaif file. UVE_SR_SLAVE_EXEC_FAIL = 39204' The slave failed to start correctly Unfortunately, just as an out of context error message, I don't know what it means. Maybe someone else can pick it up from here. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Sep 18, 2008, at 11:34 AM, Doug Chanco wrote: I cannot seem to find any reference to this error number, the documentation goes from 39204 to 39210 Does anyone know what this error means? Thanks Dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Next UniVerse Release
From the UV account, you can use the TCL command SUSPEND.FILES {ON | OFF}. From the OS level use uv -admin -L and -U to resume. SUSPEND.FILES by itself or uv -admin -R will report whether suspend is on or off. UVSUSPEND.B source is in the UV account's APP.PROGS, if you want to have a look. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Sep 17, 2008, at 6:28 AM, doug chanco wrote: Clifton Oliver wrote: Based on the posting on this topic from Steve O'Neal, it appears we have our answer. Always do a sync after pausing the database. how does on pause the database in universe? thanks dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Next UniVerse Release
Based on the posting on this topic from Steve O'Neal, it appears we have our answer. Always do a sync after pausing the database. I wonder if that is true for UniData, too. Wally? You following this thread? Thanks for pointing out the issue, Brian! Regards, Clif On Sep 15, 2008, at 2:06 AM, Brian Leach wrote: Clif I've asked the question before and received no solid answer. Hence the word 'assurance' grin If someone could confirm that it does, I'll knock that off my list. Regards Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: 15 September 2008 09:36 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Next UniVerse Release Are you saying the db pause (uv -admin -L (if I recall)) we have been told to use does NOT commit T30 file headers? And the backup of the mirror is NBG? Regards, Clif On Sep 15, 2008, at 12:49 AM, Brian Leach wrote: All I'm canvassing some opinions here.. as IBM sit down to work out their priorities for release 11 of UniVerse, what do you want to see included? As an example, here is my first wishlist item: better backups for 24x7x365 sites. That means either/both of a backup agent (or API) that can be used by third party storage tools (such as IBM's own Tivoli - so a business opportunity for them) and the assurance that pausing a database to split a mirror will commit all type 30 file headers to disk before the pause completes. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Triggers
Chapter 5 of the 10.2 SQL Reference manual is correct. The file does not have to be SQLized, but you still have to use valid SQL syntax for the TCL commands used to CREATE and DROP them, ie., ' for literals (not ) and you must end the command with a semi-colon (;). Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com The information in the System Description manual is inaccurate. On Aug 27, 2008, at 8:32 AM, Tom Dodds wrote: Universe SQL Reference if I remember correctly. HTH Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alspach, Vance Sent: Wednesday, August 27, 2008 8:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers What manual contains information on creating Universe triggers for non-SQLized files? I cannot seem to find it in any manual UV 10.2.4 Pick format IBM RS6000 Vance Alspach CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to Deere Company, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing, or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3392 (20080827) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata to Universe port
The problem is that both Dave and I have spooler products that try to intercept the output and direct it to a HOLD file. This involves using an interlude to the SP.ASSIGN/SETPTR verb. Many times, this only gets executed once per login. While we both have developed work-arounds to this issue, expanding that number from has been requested FOR YEARS. One UV product manager even thought it had already been done. We've been asking for this to be corrected for almost a decade, but the request falls on deaf ears. Fer gods sake, it's not Rocket Science! It would take, what, 2 hours to code and one automated regression run to verify? Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Aug 15, 2008, at 9:20 PM, JPB-U2UG wrote: I didn't realize you were referring to the HOLD file. In that case you are correct about the numbers being only 4 digits. However, you can expand the usage by giving the hold entries names as well as numbers by using the BANNER option. Here is from the manual: --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2.NET v IBM.NET v UNIOBJECTS.NET
International Spectrum magazine, March/April 2008, page 26. Available at: http://intl-spectrum.com/mag/MARAPR.2008/default.aspx also via http://tinyurl.com/63guo7 Regards, Clif On Aug 14, 2008, at 9:58 AM, Brian Leach wrote: The other main option is the IBM ADO.NET provider, which exposes a mainstream relational view of UniVerse, but with better handling for stored procedures (AKA Basic subroutines) than some previous APIs. For details, take a look at my article in a recent Spectrum (can't remember which one). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Editing Paired Value Marks
Bill, The assumption is that you are using the standard UniVerse ED editor. What editor are you using? Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Aug 13, 2008, at 5:13 PM, Brutzman, Bill wrote: Ray: Thanks for writing but the double-carat technique did not work on what I have here. --Bill -Original Message- [mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod C/^^253^^253/^^253/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData PROC tip: DB command
UniVerse has a Proc manual, except they call it ProVerb these days. It is available for free from the IBM web site in the 10.2 (and before) documentation set. Not vouching for the quality, completeness, or accuracy, however. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Aug 2, 2008, at 10:46 AM, Susan Lynch wrote: Now, not only are there no Proc manuals ( --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OPEN fname ... ELSE STOP 3000, fname
Could it be a user (site) created ERRMSG file item? I knew one VAR that did that kind of thing for most of their packages error messages. Regards, Clif On Jul 31, 2008, at 12:20 PM, Stevenson, Charles wrote: I've got old, old code riddled with STOP 3000, filename. ERRMSG 3000 does not exist on UV 10.2.6. Did it ever exist on UV? What version of Pick did this come from. Just curious, more than anything else. cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData PROC tip: DB command
Just as a point of history, EXECUTE was invented by the Devcom team who wrote what became Prime INFORMATION. Our in-house motto was PROCs are Crocks. Regards, Clif On Jul 31, 2008, at 8:22 PM, MAJ Programming wrote: Microdata advanced PQ proc to PQN while regular Pick was advancing with EXECUTE. IMHO, EXECUTE won and Microdata faded into the sunset. (They had a few other programming shortcomings that are clearly deficient by comparison today). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OT - Pick mentioned in letter to the editor... [not-secure]
laughing That was my first reaction, too. Doesn't seem to know the difference between virtualization and platform independence. My second thought, when the editor lobe of my brain kicked in, was, My. What an 'interesting' attitude and tone to use to try to win over an editor to your viewpoint and get favorable mention in that publication. Regards, Clif On Jul 8, 2008, at 12:18 PM, George Land wrote: Interesting, it's a shame that what he says isn't really true. George On 08/07/2008 19:59, Hennessey, Mark F. [EMAIL PROTECTED] wrote: This appeared in the letters to the editor section of the July 1 Software Development Times HIS PICK FOR AN OS IS CLEAR --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UVODBC Account Activation {unclassified}
I agree with the advice given in a previous post by Kathleeni and this one by Andy. NEVER try to use UV/ODBC against the standard production account! ALWAYS create another account with F pointers that point to the product account data sections but have local CLEAN dictionaries. I also advocate these local dictionaries use IDEAL flavor D and I type descriptors, especially if you want to have any chance of associated multivalued fields getting properly handled through dynamic normalization. In defense of the product, Andy's comment is correct, but I wouldn't state it as ODBC is very picky. Rather, Pick programmers are notorious in loading up the dictionaries with multiple definitions (failure to use just ONE A definition and using S for all redefinitions) or multiple D definitions etc. It is not UV/ODBC's fault it can't read everybody's mind and make sense out the twenty to thirty year's worth of crap people have lazily slopped into the dictionary. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Jun 25, 2008, at 1:11 PM, MACK ANDREW, MR wrote: Hi, A clean account is almost necessary. ODBC is very picky and we found that our data was OK but that the dictionaries were full of 10 years worth of difficulties :) It was easier to create a new account, populate the VOC with file pointers to the data files but create the dictionary locally. Then we could put only the data items we wanted to expose into the dictionary. This allowed us to format data differently from what the users needed to see and ensure that clean dictionaries were presented. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Thursday, 26 June 2008 2:34 a.m. To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation Okay. Firstly, do you need this file in your account? Oddly enough, most of my hard to fix problems with ODBC have been caused by the various preparation/export programs crashing on system files we've never touched. If you don't need it, delete the VOC entry. I had it crash on PTERM.FILE - a system-supplied multi-part file. Secondly, go to pickwiki, find the page on Universe, and then look at the page on ODBC. You might find it useful as it describes my tribulations with 9.6. Bear in mind that these export routines process EVERYTHING, so the entire account needs to be nice and clean, not just the files you're exporting :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 14:44 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVODBC Account Activation Hi, I know it's a very old version of uv - maybye 9.5 or possibly even 9.4 Mac -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 25 Jun 2008 12:41 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UVODBC Account Activation Not that I know much about this error but ... What version of UV are you running? I've set up ODBC on both 9.6 and 10.2, and the later version seems to be a lot more robust ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mac Bhyat Sent: 25 June 2008 10:59 To: u2-users@listserver.u2ug.org Subject: [U2] UVODBC Account Activation Hi, I have a friend who is try to activate ODBC access in an account running on a unix based server and is getting the following: DICT UV_ASSOC /uv/sql/catalog/ D_UV_ASSOC2 1 CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program *LISTFILES at address 520. Any suggestions ? Thanks mac Mac Bhyat Software Engineer - Special Projects Unibase Solutions (Pty) Ltd. URL: http://www.unibase.co.za http://www.unibase.co.za/ Email: [EMAIL PROTECTED] Tel: 011 621 7000 Cell: 079 181 3266 Fax: 011 621 7029 DISCLAIMER AND CONFIDENTIALITY This message and any attachment contain information intended solely for the addressee which is confidential or private in nature and subject to legal privilege. If you receive this message in error please notify the sender immediately by email and thereafter delete the message and do not disclose the content in any way. Unibase Solutions (Pty) Ltd cannot assure the integrity of this communication, nor that it is free of errors, virus, interception or interference, and disclaims all liability for any such. Views and opinions are those of the sender unless clearly stated as being that of the company. The authority of the sender to bind the company should be verified by the recipient and not assumed. For contact and address information regarding the company please go to http://www.unibase.co.za/ www.unibase.co.za -- This message
Re: [U2] Printer errors in the error log
** Comments embedded below. ** On May 24, 2008, at 2:22 PM, Stevenson, Charles wrote: From: [EMAIL PROTECTED] We're logging many errors in the UV error log that say Too many PRINTER channels open. I know the channel numbers themselves are limited to 0-255, but I didn't know there was a limit on how many could be open at one time. What is the limit? Is there a configuration parameter somewhere that I'm missing? I vaguely remember encountering this about 10 years ago in a Sequoia/UV conversion. I think there is/was a limit of 14 or so that can be open at one time. I believe the number is 16, which includes the default unit 0, so you can use up to 15 with the numbers selected from the range of 1-255. I don't think there is/was a config param work around. There is no parameter that I have ever heard of. It is my understanding that the limit is hardcoded into both the UV run- machine and the external usp spooler daemon. Or Clif Oliver's. I think he sells a print environment handler designed to make up for UniVerse's inadequacies. Unfortunately, my package (ESP) will not help in this situation. It is more of a print job manager. But thanks for thinking of it! Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] locking code question
BP files have to be either type 1 or type 19 (directories). Not having a file header, you can't have a SICA, can you? Same reason you can't have indexes or transaction logging on them. At least that's my understanding. I'd love to find out there is a way to do it. Regards, Clif On May 15, 2008, at 4:14 PM, David Jordan wrote: You could look at SQLising the BP file. Having a SICA, you could restrict read and update to all users and have a BASIC program manager with the AUTHORIZATION command, handle check out, check in, compilation, etc. This means that programs could only be accessed through the program manager and not directly. This would only work on UniVerse as I believe UniData does not have the AUTHORIZATION Command. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Global Catalog - Recovery
Was the copy done with the COPY verb, or with the host O/S file copy? Regards, Clif On May 15, 2008, at 6:01 PM, Tom Dodds wrote: My experience says that you have to be careful copying the catdir directory. You can get some corrupt data because of the funny characters in the object code stored in catdir. Be careful and verify the content, maybe with VCATALOG, before you stash it away. You will have to verify it each time to copy it because the object may change. I lost a migration weekend because of copying catdir and getting corrupt data. Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, May 15, 2008 4:55 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Global Catalog - Recovery Cataloging locally might not be an option if there are a lot of programs that CALL *XYZ(...) or the old Prime way of XYZ = *XYZ CALL @XYZ(...) Bill, Globally cataloged programs (the ones with the * as the first character) are stored in the catalog space which is really a subdirectory in the UV account called catdir. If you copy the catdir directory, I believe you will have what you need. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 15, 2008, at 1:51 PM, Israel, John R. wrote: Catalog locally and you will never need to re-catalog (assuming local cataloging is acceptable). or Catalogging hundreds of pgms should not be a big deal. SELECT BP (or SELECT BP_O) CATALOG BP FORCE John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, May 15, 2008 4:36 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Global Catalog - Recovery I am trying to validate an emergency recovery scenario. I want to install UV on a disk and lock the disk (unpowered) in a safe. So, if our main disk has a problem, I would just insert the (cold) hot-plugable disk, copy the latest data to this disk and then we are LIVE again... rapidly. To do this, it appears that I need to reCatalog all 100 of our global subs on the new disk. Is there any way around this reCataloging hitch? Suggestions would be appreciated. We are using HP-Ux 11i v2 and UV v10.1. This scenario would also help with smoothly upgrading HP-Ux and UV versions. --Bill Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects.NET: populating ListBox from XML
I deleted the line ListBox1.DataSource = DS I got the error Cannot bind to the new value member thrown on the line .ValueMember = CUSTOMER I deleted that line, and now things work as expected. Thank you very much for the help, David. Now I need to hit the books about data bindings and figure out what I just did grin. If anyone has the title of a favorite must have VB.NET book, I'd like hearing about it. If folks want to chime in with recommendations, I'll compile a list and submit it as a item in the U2UG knowledge-base. Regards, Clif On May 13, 2008, at 10:58 PM, Hona, David S wrote: Oh, delete the line with 'ListBox1.DataSource = DS' in it, I forgot to! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: Wednesday, May 14, 2008 2:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects.NET: populating ListBox from XML Clif, Try something like this... Cmd = uvSession.CreateUniXML Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP) DS = Cmd.GetDataSet ListBox1.DataSource = DS With ListBox1 .DataSource = DS.Tables(0) .DisplayMember = COMPANY .ValueMember = CUSTOMER End With Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 14, 2008 9:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects.NET: populating ListBox from XML Having been successful last week at populating a GridDataView control using .GenerateXML, we naively thought using XML to populate a ListBox would be just as straightforward. Using the same code pattern, we've tried Cmd = uvSession.CreateUniXML Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP) DS = Cmd.GetDataSet ListBox1.DataSource = DS ListBox1.DisplayMember = CUSTOMER ListBox1.Refresh() gives us one line in the ListBox that reads System.Data.DataViewManagerListItemTypeDescriptor Are we missing something from this incantation, or is this not a valid way to try to populate a ListBox? (Yeah, I guess ComboBoxes are next.) Thanks in advance for any help, examples, or RTM references! Regards, Clif --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObjects.NET: populating ListBox from XML
Having been successful last week at populating a GridDataView control using .GenerateXML, we naively thought using XML to populate a ListBox would be just as straightforward. Using the same code pattern, we've tried Cmd = uvSession.CreateUniXML Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP) DS = Cmd.GetDataSet ListBox1.DataSource = DS ListBox1.DisplayMember = CUSTOMER ListBox1.Refresh() gives us one line in the ListBox that reads System.Data.DataViewManagerListItemTypeDescriptor Are we missing something from this incantation, or is this not a valid way to try to populate a ListBox? (Yeah, I guess ComboBoxes are next.) Thanks in advance for any help, examples, or RTM references! Regards, Clif --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Fwd: Digiboards
Posted for a non-list member. Begin forwarded message: From: hbkeultjes [EMAIL PROTECTED] Newsgroups: comp.databases.pick Subject: Digiboards Date: Tue, 13 May 2008 13:53:18 -0700 (PDT) Anyone interested in a bunch of Digiboards, many brand new, including the cables and 8-port terminations, please let me know before I put them up on eBay. I would be willing to trade all of them for an IBM RT that is running OA. Whoever sees this from the U2 list please post this there are well. Henry Keultjes Microdyne Company Mansfield Ohio USA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse Triggers
The Nov/Dec 2007 issue, available at: http://www.intl-spectrum.com/t/135520/link.aspx On May 8, 2008, at 5:35 AM, Brian Leach wrote: Mike If you check the recent issues (pdfs on their site) I wrote an article on triggers for Spectrum you might find useful. Brian -Original Message- From: Mike Randall[EMAIL PROTECTED] Sent: 08/05/08 03:58:08 To: u2-users@listserver.u2ug.orgu2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse Triggers Interesting, I actually saw the trigger reference under SQL and made the incorrect assumption that it was referring to actual SQL commands rather than calling BASIC subroutines. Thanks for correction. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 07, 2008 8:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Triggers It's a UniVerse SQL command (yes, even if the file is not an SQL table). CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON tablename FOR EACH ROW CALLING ' program ' ; Details are in chapter 5 of the UniVerse SQL Reference. [Message truncated. Tap Edit-Mark for Download to get remaining portion.] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
DQM (was [U2] Using ETL to extract data from UD to SQL)
I wanted to change the subject line to see is we Listizens have any interest in discussing Data Quality Management. How do you cleanse MultiValue non-typed data for integration with strongly datatyped non-MV applications? Anyone want to kick off the discussion? Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 8, 2008, at 6:00 PM, Boydell, Stuart wrote: nd dirty data to get to a set of data suitable for your DW/reporting requirements. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects.NET: .GenerateXML method fails
Thanks, David. I'll check those references and post a summary findings back to the list. I really appreciate the help! Regards, Clif On May 6, 2008, at 8:31 PM, Hona, David S wrote: Clif, I vaguely recall that the UniXML functionality isn't officially supported until UV 10.2.x (on the server). I could However, I have got it working at UniVerse 10.1.18 on Sun Solaris. But earlier versions of UV 10.1.x do not work with UniXML calls. This is the same U2 Webservices Developer Tool (and some other toolsets as well). I believe this may be mentioned in the UniVerse 'newfeatures.pdf' for UV 10.2 documentation set. Regards David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects.NET: .GenerateXML method fails
It's confirmed. As soon I globally cataloged that routine, DataGridView is working. We haven't gotten a list box to work, but that will be another subject line for archive purposes. Thank you! Regards, Clif On May 6, 2008, at 3:12 PM, Clifton Oliver wrote: Sure enough, that subroutine was not cataloged on the AIX system. I've cataloged it, but got my PC access expired before I could test it. (What are the odds?) I'll report back to the list (for the archives) with a verification when I get my access renewed. Thank you! Regards, Clif On May 6, 2008, at 1:50 PM, Brian Leach wrote: Hi Clif I would check to see whether the GETXMLSUB subroutine has been globally cataloged in the uv account. The code is in BP, it needs to be cataloged as *GETXMLSUB. Brian Greetings, List Citizens (Litizens?) A client of mine and I are having problems with using UniObjects.NET and the GenerateXML menthod to populate a data grid in VB.NET. The following code, almost a cut-and-paste from Brian Leach's excellent Introducing UniObject for .NET in the U2UG Knowledge Base runs perfectly on UV PE 10.2.8 on Windows XP SP2 using the 10.2 UV clients. Private Sub cmdRead_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdRead.Click Cmd = uvSession.CreateUniXML Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP) DS = Cmd.GetDataSet DataGridView1.DataSource = DS DataGridView1.DataMember = CUSTOMER DataGridView1.Refresh() End Sub But when we try the exact code against an AIX system, UV 10.1.7 using the 10.1A clients, we get the following error: [IBM U2][UODOTNET - UNICLIENT][ErrorCode=30105] Unable to load the subroutine on the server[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91] Please verify UniVerse or UniData Version. This feature may not be supported in older UniVerse or UniData version. In both cases, I am going against the CUSTOMER file in the demo HS.SALES account. I have logged into the AIX system with the same ID as is being used to connect a session and verified that I have permissions to access the file. The command SORT CUSTOMER COMPANY ID.SUP TOXML ELEMENTS issued from the TCL prompt gives the expected results. None of the dictionary descriptors are trying to call a subroutine, so I don't understand what that part of the error message is referring to. Thanks in advance for any help, ideas, or insights. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Fwd: [U2] UniVerse Triggers
Excuse me. I mistyped. That is three 90 minute sessions, not one hour. Regards, Clif Begin forwarded message: From: Clifton Oliver [EMAIL PROTECTED] Date: May 7, 2008 5:58:05 PM PDT To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Triggers It's a UniVerse SQL command (yes, even if the file is not an SQL table). CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON tablename FOR EACH ROW CALLING ' program ' ; Details are in chapter 5 of the UniVerse SQL Reference. [AD] Also, I will be conducting a webinar through Spectrum University on the topic of UniVerse Triggers starting next Thursday. The course is three one-hour sessions on three consecutive Thursdays. For more information, please see http://www.intl-spectrum.com/tabid/159/univ/15/default.aspx [/AD] Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 7, 2008, at 4:28 PM, Mike Randall wrote: On UV triggers, I've used them often on UD and now have a great application for them on UV. I searched the VOC and found no commands with the word 'trigger' in them. I was expecting the CREATE.TRIGGER of Unidata.What's the syntax for setting them up in UV? Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Friday, April 25, 2008 11:02 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] UniVerse Triggers Hello, We have received reports that UV triggers have shown some instability. Does anyone have anything to share on this? We have been using them for a couple of years with no issues but were hoping for more details from other users, if available. Thanks much, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse Triggers
It's a UniVerse SQL command (yes, even if the file is not an SQL table). CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON tablename FOR EACH ROW CALLING ' program ' ; Details are in chapter 5 of the UniVerse SQL Reference. [AD] Also, I will be conducting a webinar through Spectrum University on the topic of UniVerse Triggers starting next Thursday. The course is three one-hour sessions on three consecutive Thursdays. For more information, please see http://www.intl-spectrum.com/tabid/159/univ/15/default.aspx [/AD] Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 7, 2008, at 4:28 PM, Mike Randall wrote: On UV triggers, I've used them often on UD and now have a great application for them on UV. I searched the VOC and found no commands with the word 'trigger' in them. I was expecting the CREATE.TRIGGER of Unidata.What's the syntax for setting them up in UV? Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Friday, April 25, 2008 11:02 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] UniVerse Triggers Hello, We have received reports that UV triggers have shown some instability. Does anyone have anything to share on this? We have been using them for a couple of years with no issues but were hoping for more details from other users, if available. Thanks much, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] fixtool
Unless things have changed since February of 2004, according to a white-paper by Leroy Dreyfus: fixtool supports 3 effective verbosity levels. 0 3 are treated as level 2 and show only the summary screen described earlier. Level 4 displays the record offset, the forward pointer, the backward link, and the flag word1. Level 5 adds the record ID and data (as a multivalue array) to the display of level 4. The output of each verbosity level is directed at the screen. To save them to a file, redirect stdout (standard out) to a file name. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 5, 2008, at 10:43 PM, Craig Bennett wrote: Hi All, fixtool allows you to nominate a Diagnostic level between 1 and 10 using -level. Does anyone know what the different levels check? thanks, Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObject.NET: What are you doing for LOCATE?
Greetings again, everyone. Second question, put in a separate e-mail for ease of future searching the list archives. Since there does not appear to be any LOCATE method provided by UniObjects.NET, what are others using? Did you code your own on the VB (or other client language) side? Do a server-side subroutine and call it to do the LOCATE? Other ideas? Thanks for your recommendations. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObjects.NET: .GenerateXML method fails
Greetings, List Citizens (Litizens?) A client of mine and I are having problems with using UniObjects.NET and the GenerateXML menthod to populate a data grid in VB.NET. The following code, almost a cut-and-paste from Brian Leach's excellent Introducing UniObject for .NET in the U2UG Knowledge Base runs perfectly on UV PE 10.2.8 on Windows XP SP2 using the 10.2 UV clients. Private Sub cmdRead_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdRead.Click Cmd = uvSession.CreateUniXML Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP) DS = Cmd.GetDataSet DataGridView1.DataSource = DS DataGridView1.DataMember = CUSTOMER DataGridView1.Refresh() End Sub But when we try the exact code against an AIX system, UV 10.1.7 using the 10.1A clients, we get the following error: [IBM U2][UODOTNET - UNICLIENT][ErrorCode=30105] Unable to load the subroutine on the server[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91] Please verify UniVerse or UniData Version. This feature may not be supported in older UniVerse or UniData version. In both cases, I am going against the CUSTOMER file in the demo HS.SALES account. I have logged into the AIX system with the same ID as is being used to connect a session and verified that I have permissions to access the file. The command SORT CUSTOMER COMPANY ID.SUP TOXML ELEMENTS issued from the TCL prompt gives the expected results. None of the dictionary descriptors are trying to call a subroutine, so I don't understand what that part of the error message is referring to. Thanks in advance for any help, ideas, or insights. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] fixtool
That should read 0-3. On May 6, 2008, at 10:16 AM, Clifton Oliver wrote: 0 3 are treated as level 2 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects.NET: .GenerateXML method fails
Sure enough, that subroutine was not cataloged on the AIX system. I've cataloged it, but got my PC access expired before I could test it. (What are the odds?) I'll report back to the list (for the archives) with a verification when I get my access renewed. Thank you! Regards, Clif On May 6, 2008, at 1:50 PM, Brian Leach wrote: Hi Clif I would check to see whether the GETXMLSUB subroutine has been globally cataloged in the uv account. The code is in BP, it needs to be cataloged as *GETXMLSUB. Brian Greetings, List Citizens (Litizens?) A client of mine and I are having problems with using UniObjects.NET and the GenerateXML menthod to populate a data grid in VB.NET. The following code, almost a cut-and-paste from Brian Leach's excellent Introducing UniObject for .NET in the U2UG Knowledge Base runs perfectly on UV PE 10.2.8 on Windows XP SP2 using the 10.2 UV clients. Private Sub cmdRead_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdRead.Click Cmd = uvSession.CreateUniXML Cmd.GenerateXML(SORT CUSTOMER COMPANY ID.SUP) DS = Cmd.GetDataSet DataGridView1.DataSource = DS DataGridView1.DataMember = CUSTOMER DataGridView1.Refresh() End Sub But when we try the exact code against an AIX system, UV 10.1.7 using the 10.1A clients, we get the following error: [IBM U2][UODOTNET - UNICLIENT][ErrorCode=30105] Unable to load the subroutine on the server[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91] Please verify UniVerse or UniData Version. This feature may not be supported in older UniVerse or UniData version. In both cases, I am going against the CUSTOMER file in the demo HS.SALES account. I have logged into the AIX system with the same ID as is being used to connect a session and verified that I have permissions to access the file. The command SORT CUSTOMER COMPANY ID.SUP TOXML ELEMENTS issued from the TCL prompt gives the expected results. None of the dictionary descriptors are trying to call a subroutine, so I don't understand what that part of the error message is referring to. Thanks in advance for any help, ideas, or insights. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObject.NET: What are you doing for LOCATE?
Indeed it does! Regards, Clif On May 6, 2008, at 1:55 PM, Brian Leach wrote: I wrote my own - BUT - now I'm thinking I should recode it as a .NET 3.5 extension method to enhance the UniDynArray class. Which, strangely enough, sounds like a good topic for next month's Spectrum :) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] fixtool
That is my understanding. The different levels just change how much and what kind of detail it reported. Regards, Clif On May 6, 2008, at 4:04 PM, Craig Bennett wrote: Thanks Cliff, I didn't realise they were verbosity levels. So the actual checks performed are the same for every level? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse SQL Tables
The parameter is OPENCHK. OPENCHK - the modifies the behavior of operations upon files open via the BASIC OPEN statement. When set to zero, I/O to files open with the BASIC OPEN statement ignore integrity constraints. If non- zero those files will observe the constraints. This tunable does not affect files opened via the OPENCHECK statement. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Apr 29, 2008, at 1:56 PM, David Jordan wrote: Hi Gerry I think there is an option in UvConfig that allows bad data to be written to a table despite constraints. I have not been able to write bad data to an SQL Table as you have done in the test program. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse SQL Tables
Not unless you've written a ten line test program to prove that. On Apr 27, 2008, at 10:50 PM, u2ug wrote: Can we safely assume that any file writes on sql tables are not subject to data type checks or will this pop up to bite us at some point ? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse SQL Tables
Not unless you've written a ten line test program to prove that. On Apr 27, 2008, at 10:50 PM, u2ug wrote: Can we safely assume that any file writes on sql tables are not subject to data type checks or will this pop up to bite us at some point ? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse Triggers
I have several clients who have been using triggers for a couple of years with no reported issues, other than the performance hit. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Apr 25, 2008, at 11:42 PM, Horacio Pellegrino wrote: We started using triggers some months ago and so far no problems at all... I'm interested in what kind of instability issues you came across. Please let me know. ( We are a 370-Micro$oft Windows shop!) Horacio Pellegrino -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Friday, April 25, 2008 8:02 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] UniVerse Triggers Hello, We have received reports that UV triggers have shown some instability. Does anyone have anything to share on this? We have been using them for a couple of years with no issues but were hoping for more details from other users, if available. Thanks much, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Mar/April 2008 issue of International Spectrum magazine
The Mar/April 2008 issue of International Spectrum magazine is at the printer and is now available in PDF format for download at www.intl-spectrum.com Regards, Clif --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Question about the U2 News Flash...
The issue is in the final stages of going to press, so it's not up on the web site yet. I've made a note to post an announcement to the list as soon as it is. [AD] (kind of) Brian written several articles for Spectrum magazine. The back issues can be downloaded from the web site. [/AD] Regards, Clif On Feb 29, 2008, at 2:03 AM, Brian Leach wrote: If anyone is interested I've done a writeup of the new ADO.NET provider in the next issue of Spectrum (that's www.intl- spectrum.com for details). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Question about the U2 News Flash...
laughing Anyone want to edit the Editor? On Feb 29, 2008, at 1:52 PM, Clifton Oliver wrote: Brian written several articles for Spectrum magazine. The back issues can be downloaded from the web site. ^ has --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] release notes (was: SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong)
That's an interesting comment. If it is documented in the patchlist, I think that makes it part of the release. Plus, we found out about it being there in a public talk by LeRoy Dreyfuss at the IBM conference in Orlando a couple of years ago. At the time LeRoy was the U2 product manager (at least I think that was his title). LeRoy? You listening in and care to comment? Regards, Clif On Feb 16, 2008, at 11:59 AM, Martin Phillips wrote: Don't forget to read each releases patchlist in the UV directory. They have been known to put things in there that aren't in the New Features doc. The CONCURRENT option to BUILD.INDEX comes to mind. I queried why CONCURRENT wasn't in the manuals despite pre-release publicity. The response I got from IBM support in the UK was that it is not officially released as it doesn't work. Maybe JayJay will have an update on this. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] release notes (was: SLEEP 60 slept only 53 seconds, or else TIMEDATE() is wrong)
Don't forget to read each releases patchlist in the UV directory. They have been known to put things in there that aren't in the New Features doc. The CONCURRENT option to BUILD.INDEX comes to mind. -- Regards, Clif W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Feb 15, 2008, at 3:21 PM, Stevenson, Charles wrote: Each major release is usually accompanied with an update on the manuals, including a New Features at Release X.0 sort of thing. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] anyone seen this error before?
Because that id is used to determine the id of the printer memory segment for the process. If you have two UV processes with the same gpid, they end up sharing the memory segment. This is where your MFILE structures are stored (rotating file pool), among other things. Pointers get mixed up, and you end up getting some files data written into a completely different file, usually corrupting the group or even the file header, depending on how angry the computer gods are that day. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Dec 17, 2007, at 5:29 AM, Doug Chanco wrote: I am not sure I fully understand what's going on, why would not having a unique pgid cause this issue? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] anyone seen this error before?
That is the reason for having the cron script use the PHANTOM command. - Clif On Dec 15, 2007, at 1:46 PM, John Godzina wrote: I'm not sure, but wasn't there some discussion a while back stating that multiple UV processes initiated via cron would be fine if each process had their own unique process group id (not just a unique process id)? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] anyone seen this error before?
I don't know about perl, but I am *guessing* that would work. An early solution (circa 1997/8) was to use a little program written in C to do the same thing. I've have to search my records or the list archive to dig that out. But it begs the question, why not just use PHANTOM? Are you assuming some doubling of processes or overhead that really isn't there? I'm not understanding why you would think hammering the process grp id is preferable to letting PHANTOM take care of it for you. Maybe I'm missing a nuance here. -- Regards, Clif On Dec 15, 2007, at 5:33 PM, John Godzina wrote: Hi Cliff, Can I also simply wrap the UV process in something that changes the pgid? (e.g.: the setpgrp command in perl) John Clifton Oliver wrote: That is the reason for having the cron script use the PHANTOM command. - Clif On Dec 15, 2007, at 1:46 PM, John Godzina wrote: I'm not sure, but wasn't there some discussion a while back stating that multiple UV processes initiated via cron would be fine if each process had their own unique process group id (not just a unique process id)? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type text/x-vcard which had a name of john.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] To Ad or Not to Ad [not-secure]
chuckle When the original Devcom team was writing INFORMATION, we didn't have job titles or business cards. This was causing one of the chaps some problems in obtaining a loan, so a couple of us had a session of composing the most inflated job descriptions possible. And a lot of people think software engineers don't have any fun... On Dec 5, 2007, at 10:17 AM, Hennessey, Mark F. wrote: Wow, Cliff - Your .SIG made me flip over to wikipedia...Maybe you should add Proud to be a Humble Man... :) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] To Ad or Not to Ad
Only if you sell your opinion. Then we get to invoice you for Reuse Fees. On Dec 5, 2007, at 10:26 AM, Kevin King wrote: I agree with Chuck, Brian, Clif, Susan, and anyone else who agrees with me. :-) (Hmmm, does that make this an [AD]?) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Accessing the OS
or since the OP was asking about from within UniBasic, the syntax he would want would be execute \SH -c ls -l\ -- Regards, Clif On Dec 5, 2007, at 2:37 PM, Jeff Schasny wrote: SH For example SH -c ls -al Brutzman, Bill wrote: From a UniBasic green-screen application (using Dynamic Connect), what BASIC command(s) allow the programmer to execute an Unix command (with parameters) such that something like a SendMail command could be handled. We have UniVerse and HP-Ux. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- -- -- Jeff Schasny - Denver, Co, USA jeff at schasny dot com -- -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Deep and long indentations vs multiple exit points - AD functionality not bugs
Sorry, Stuart. I should have completely trimmed the reply quote on my post so it didn't look (as it apparently did) that I was singling out you as the main target of my comments (after the part about guard clauses). It was more of a sociological musing as to how many times over the years we've seen these threads on style, constructs, etc. go on and on. I wonder how many people really change the way they label, or indent, or whatever based on them. I frequently hear comments in my travels from people to the effect of how do people have time to write all that stuff during the work week; I don't have time to even read them! I wasn't trying to censor you or anyone else, and I probably should keep such musings to myself. At the very least, I should have worded it better. Apologies to any and all for offense given. -- Regards, Clif On Dec 3, 2007, at 2:14 AM, Boydell, Stuart wrote: Apologies to anyone who thinks I was making unacceptable 'noise' - you're welcome to filter my posts. In my defence - I have always tried to put a guard clause in my posts asserting it's MY opinion - not - thou shalt. If I haven't - it's just a bug in my assertion. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Deep and long indentations vs multiple exit points - AD NAUSEUM
Perhaps you might want to expand your search criteria to include the last ten years and examine the use of Guard Clauses. Does anyone else on the list find these discussions of style, good practice, etc. to be both out-of-date and an exercise in wasted bandwidth (not to mention having too much time on one's hands)? People being what they are, these discussions always boil down to, I'm going to do it my way because I'm right and you are wrong. Wouldn't the time be best spent retesting that A/R modification you plan to push to Production tomorrow night? -- Regards, Clif On Dec 2, 2007, at 5:12 PM, Boydell, Stuart wrote: I'm in complete agreement with the one way in/out (OWI-OWO ) rule. Out of interest, I have searched the net and of the many articles I found which cited OWI-OWO, all cited it in the scope of being good practice. I found one which cites one way in, multiple|many ways out with a scathing comment. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Cool stuff for a Friday [not-secure]
Who, me? ;-) On Nov 26, 2007, at 5:43 AM, Hennessey, Mark F. wrote: Cliff - I'm willing to bet you do it because you CAN. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Can I get some advice on triggers?
Yes. See Chapter 5 of the UV 10.2 SQL Reference. That's the documentation that works. Unfortunately, the triggers documentation in the non-SQL portions of the manuals is incorrect, and had been for some time. [AD] Watch for the next issue of International Spectrum magazine. Brian Leach has a good article on UniVerse file triggers in it. Also, International Spectrum is putting together a webinar on this topic. I'll announce it on this list when we have a schedule set. [/AD] -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Nov 26, 2007, at 8:38 PM, Keith Johnson (DSLWN) wrote: Hi, I'm hoping someone can give me some help on triggers. I want to put a trigger on a file to datestamp address changes. The system manual (25119270.pdf) says that triggers aer set up by the command CREATE TRIGGER trigger.name [BEFORE|AFTER|UPDATE] But when I try that I get an SQL prompt. We don't use SQL at all - is there some way of setting up triggers without it? Is there another manual I should look at? Thanks, Keith. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Can I get some advice on triggers?
Be sure to make that one parameter *some.subroutine. The subroutine needs to be UV globally cataloged, even if you are running in a Pick flavor account. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Nov 26, 2007, at 10:50 PM, [EMAIL PROTECTED] wrote: Try this: CREATE TRIGGER filename.trigger BEFORE INSERT OR UPDATE OR DELETE ON filename FOR EACH ROW CALLING some.subroutine; Note the semi-colon at the end (;). It is very important. Regards, Raul. Keith Johnson (DSLWN) [EMAIL PROTECTED] To o.nz u2-users@listserver.u2ug.org Sent by: cc [EMAIL PROTECTED] stserver.u2ug.org Subject [U2] [UV] Can I get some advice on triggers? 11/27/07 12:20 AM Please respond to [EMAIL PROTECTED] er.u2ug.org Hi, I'm hoping someone can give me some help on triggers. I want to put a trigger on a file to datestamp address changes. The system manual (25119270.pdf) says that triggers aer set up by the command CREATE TRIGGER trigger.name [BEFORE|AFTER|UPDATE] But when I try that I get an SQL prompt. We don't use SQL at all - is there some way of setting up triggers without it? Is there another manual I should look at? Thanks, Keith. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Time Travel
For the group's edification, at sending out 60,000+ e-mails on some days (more than that when people had nothing better to do at work than flame each other about coding styles), this was one of the problems I had when I hosted the lists. Larry is also being polite and not mentioning that he is footing the bill for this service and bandwidth. So when some people start in on this needs to be corrected, the list has to be faster, and so forth, I would suggest you show him the money. Not meaning to put words in your mouth, Larry. Most of us really (really, really!) appreciate your donation of time and money in support of these lists. Clif.button.push() On Nov 26, 2007, at 9:48 PM, Larry Hiscock wrote: b) I don't want to be blacklisted as a spammer. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Cool stuff for a Friday
Yes, Bill. I've been running on a MacBook since December of last year. I use Parallels for any Windows work I need to do. I love it. I set up a Windows VM for each client. That may be overkill, but the ability to snapshot the state of the entire machine, test, rollback, test, rollback is a real productivity booster. I haven't tried loading a VM with Linux and then putting UniVerse PE on top of that yet. But it shouldn't be a problem. Windows XP running in VM frequently out performs some of my colleagues running XP native, depending on their h/w. I don't use Skype or GoToMeeting (yet), but they do have Mac clients for them SFTP is no problem. Remember, OS X is built on top of BSD Unix. Being a Unix dude, I open a local terminal and use command line at times--not that I have to. I just prefer a Road Less Pixeled for some things. All in all, I'm a fan. I'd be hard-pressed to switch back to Windows as a full-time system. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Nov 23, 2007, at 10:33 AM, Bill Haskett wrote: This reminds me of a question I've been wanting to ask. Does anyone use an Apple (the new leopard O/S with a VM for Windows)? I've been thinking of buying one for my next PC purchase. I need Windows for .NET development, AccuTerm, U2 and mv.NET administration tools, and possibly other stuff. I wonder if I can get Skype, a SFTP client, GoToMeeting, and any other useful stuff, to replace Windows software, for Apple. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Friday, November 23, 2007 9:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] Cool stuff for a Friday All If any of you haven't seen the magnificent little Asus eee mobile pc yet - mine is now running an 'nLite' version of XP, C# Express 2008, Delphi and - of course - UniVerse :) I'll be getting one for each of the kids... Rgds Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OT: Email encryption
If the csv files are being generated by UniBasic, the language has encryption functions. Outside of basic, check out GPG. (http:// www.gnupg.org/) -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Nov 16, 2007, at 8:26 AM, Brenda Price wrote: We sometimes have to email csv files with sensitive information to our clients. Right now we are just setting a password to the zipped files. We really need to encrypt either the whole email or just the attached files. We are using Microsoft Outlook. Any ideas? Brenda L Price Senior Programmer Analyst Affiliated Acceptance Corporation Sunrise Beach, MO (800)233-8483 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OT: Email encryption
Would work if you can guarantee that all of your clients use Outlook. But a lot of folks won't go near the thing. ;-) -- Regards, Clif On Nov 16, 2007, at 1:30 PM, Jerry Banker wrote: Brenda, If I'm not mistaken Outlook has an encryption feature built into it. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV - 10.2.2 [not-secure]
Mark, Would you mind giving just a brief description of what you mean by broken please? Not in detail (unless you want to grin) but enough to let the rest of us know what to watch out for. Thanks. On Nov 6, 2007, at 12:43 , Hennessey, Mark F. wrote: Also, usa is broken at 10.2.2 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV - 10.2.2 [not-secure]
I am interpreting that to mean this is on those releases on all platforms (AIX) not just Solaris, correct? Thanks for the info! - Clif On Nov 6, 2007, at 2:51 , Richard Nuckolls wrote: usa, usm, usp (all the same executable) hang when trying certain operations. They problem evidently started with 10.2.1, and fixed at 10.2.6 (not available for Solaris yet) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Benchmark Email --BIG user count
I think that was Steve O'Neal that posted that information to the u2- users list. I see that Chuck Barouch dug out that reference for you. That was the PDSC benchmark of 15,200 users. Susie Siegesmund talks about it in my interview with her in the Jan/Feb 2007 issue of International Spectrum Magazine, p. 43, available for download at http://www.intl-spectrum.com/t/135488/link.aspx Good luck with your presentation. -- Regards, Clif ~~~ Clifton Oliver, Managing Editor International Spectrum Magazine Spectrum Tel: +1 720 259 1356 Clif's Direct Tel: +1 619 460 5678 ~~~ On Nov 5, 2007, at 7:10 , Ross Ferris wrote: I know IBM did a benchmark in the last 12-18 months for a call centre application (Lenovo) and someone (Wally?) posted a brief note to the group about 15K+ users ... I'm trying to locate for a presentation tomorrow, but can not find Is this in an online archive, or could someone sheet me an original so I can include relevant details thanks! Ross Ferris Stamina Software Visage Better by Design! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Stringing commands together on the command line. Possible?
This is evil, but does string uv commands on the TCL line. SH -c 'uv TIME; uv WHO; uv COUNT VOC' 16:42:44 29 OCT 2007 26 uv From root 927 records counted. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Green Screen Dev. Environment
Nucleus was covered by Charles Barouch in the Sep/Oct 2006 issue of International Spectrum Magazine, available on the web at the intl- spectrom.com web site (http://www.intl-spectrum.com/Magazine/ Magazine.aspx?Page=2). Or via (http://tinyurl.com/2y4nmt). [ad] While you're there, why not sign up for a subscription? There is no charge. Just click on the Join Now button. [/ad] -- Regards, Clif On Oct 10, 2007, at 7:53 , Baker Hughes wrote: You should take a look at Nucleus. It generates a characters screen, an Accuterm GUI screen, or .Net GUI all from the same code. Develop character screens in minutes, and If you ever decide to go GUI, just do it, no rollout to clients. (your desktop group will love you for this) binary-removethis-star.com Although we use their source safe solution we haven't begun using their IDE yet, but it is impressive. It appears the learning ramp is shorter than SB. I have no connection with Binary Star, just a Developer at a licensed site. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OT: Where to sell Systech serial port servers (for Serial printers/Serial Terminals)
I doubt it you will ever make anything on these. You might check you local colleges and non-profits to see if you can get them to come haul them away (or pay the shipping) and then you take a charitable contribution deduction. -- Regards, Clif On Oct 3, 2007, at 11:43 , Larry Hiscock wrote: Gabriel wrote: We also have over 100 ADDS Viewpoint terminals, but I have yet to find someone who will buy them where we make anything after shipping Look at the bright side ... At least you wouldn't have to pay someone to haul them away, which is what will happen if you hold on to them too much longer ;-) Larry Hiscock Western Computer Services --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV Printer file size limit reached
Is that UVTEMP? Or just the regular /tmp (assuming UVTEMP is stored somewhere other than in /tmp)? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Sep 26, 2007, at 11:27 , Jerry Banker wrote: No the available space on the test system temporary directory is 196452832 K bytes as opposed to 15188328 K bytes on the live system. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RES: [U2] Universe and triggers
DOH! Sorry. Overlooked that. So much for speed reading. - Clif On Sep 13, 2007, at 3:38 AM, Brian Leach wrote: See point 6 on my post grin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe and triggers
There currently isn't a .Type19 file; that's the default in the absence of a .Type1 or .Type30. But they could add one and do what you suggest. I know this has been discussed within IBM for some time. You have a similar issue for the same reason of being able to Transaction Log a type 1 or 19. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Sep 12, 2007, at 6:06 AM, Mats Carlid wrote: Clifton Oliver skrev: Since 10.0. Yes, it works on all file types except 1 and 19. Being directories, they don't have file headers, thus no place to put the SICA. It would be possible placing the SICA in a separate file .sica or in the .Type1 / .Type19 files wouldn't it? And it would really be nice and usefull to have triggers in directories too. -- mats --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?
That completely depends on how densely the index is populated. Example by extremes: If you index on a status code that has only two equally possible values, you'd have about 5.5 million records in each index. Updates to that file will grind to a near halt. If the code could have a couple of hundred equally different values, update overhead might be acceptable. The same logic applies as to whether or not to use the NO.NULLS option when creating the index. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Sep 12, 2007, at 11:39 AM, Louie Bergsagel wrote: Does anyone know the effect of adding an index to a UniVerse file? I'd like to add a date index to a type 30 file with 11 million records. ( ANALYZE.FILE Total size . 2,115,325,952 bytes) Would this have any measurable speed slowdown on applications running against the file? The file currently has 4 other indexes. -- Louie Bergsagel Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RES: [U2] Universe and triggers
Two more come to mind: If you change and recompile the subroutine, you have to drop and re- create the trigger. Files with triggers cannot be updated via UV/Net. -- Regards, Clif On Sep 12, 2007, at 2:04 AM, Brian Leach wrote: 5. Triggers impose some limitations : they all make sense if you step back and think about them except (b): --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe and triggers
Oops. Meant to type not able to TL a type 1 or 19. -C On Sep 12, 2007, at 1:15 PM, Clifton Oliver wrote: There currently isn't a .Type19 file; that's the default in the absence of a .Type1 or .Type30. But they could add one and do what you suggest. I know this has been discussed within IBM for some time. You have a similar issue for the same reason of being able to Transaction Log a type 1 or 19. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Sep 12, 2007, at 6:06 AM, Mats Carlid wrote: Clifton Oliver skrev: Since 10.0. Yes, it works on all file types except 1 and 19. Being directories, they don't have file headers, thus no place to put the SICA. It would be possible placing the SICA in a separate file .sica or in the .Type1 / .Type19 files wouldn't it? And it would really be nice and usefull to have triggers in directories too. -- mats --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RES: [U2] Universe and triggers
Oooo! Now there's a neat trick (excuse me, technique). I'd never thought of it. Have you ever used Mark Baldridge's Profiler (Travels With Mark, on the IBM Developer Works site) to quantify what I assume is a rather trivial amount of overhead in the double call? If not, I'll take a go at it and report back. It sounds like a great technique. Thanks! -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Sep 12, 2007, at 8:23 PM, Phil Walker wrote: What I do is create a wrapper trigger program which does nothing more than call the real subroutine. That way as this trigger never or rarely changes I can modify the underlying trigger program without having to drop and recreate the trigger on the file. Clifton Oliver [EMAIL PROTECTED] wrote: = Two more come to mind: If you change and recompile the subroutine, you have to drop and re- create the trigger. Files with triggers cannot be updated via UV/Net. -- Regards, Clif On Sep 12, 2007, at 2:04 AM, Brian Leach wrote: 5. Triggers impose some limitations : they all make sense if you step back and think about them except (b): --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] checking files for corruption
I, too, am not sure how thorough it is, but I do a FILE.STAT (or ANALYZE.FILE). -- Regards, Clif On Sep 11, 2007, at 11:07 AM, Bob Woodward wrote: I'm not sure how through it is but I've always found that just doing a COUNT on a file has shown when there's a problem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 11, 2007 8:20 AM To: u2-Users Subject: [U2] [UV] checking files for corruption Hi all, UV 10.1.8 What is the best way to verify the integrity of a file while users are accessing (if possible at all)? I see that fixtool will set an exclusive file lock when executing without any options. If I understand correctly, the -start and -stop options will scan the file setting group locks. Would it work to set -start to 1 and -stop to the last group in the file? If so, how do I tell what the last group of the file is? Thanks in advance, Scott Thompson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2UG Wiki article on UV's SYSTEM(n) - I need help editing it.
Naw. Ray's a *real* psychologist. He even knows statistics. grin On Sep 11, 2007, at 11:22 AM, Stevenson, Charles wrote: Maybe our resident psychologist, Ray Wurlod, can provide a Freudian explanation. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe and triggers
Since 10.0. Yes, it works on all file types except 1 and 19. Being directories, they don't have file headers, thus no place to put the SICA. -- Regards, Clif On Sep 11, 2007, at 1:59 PM, Geoffrey Mitchell wrote: I'm not sure in what version it was implemented, but you *can* have triggers on non-SQL files in Universe (and have been able to for some time now). Cataloging the subroutine so that it can be called as a trigger is somewhat weird, and not well documented, but if you search the list archives, you should be able to find what you need to know. We have been using this in production for a couple of years. Actually installing the trigger uses the same syntax as for an SQL table. I believe that this works on all hashed file types (i.e. anything but type 1 or 19 files). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RES: [U2] Universe and triggers
Not as of release 10.0. On Sep 11, 2007, at 2:24 PM, Marcos Fogaga wrote: The problem is that the TEST.FILE MUST be a UV SQL Table. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RES: [U2] Universe and triggers
I use triggers on 10.2 files frequently. What file type is GVMTA030? If it's a type 1 or 19, it won't work. If it is a static hashed 2 through 18 it will. Also works on type 30. However, if it is a distributed file, you have to create the trigger on each individual partfile; you cannot name the top level DF. Also, do a tcl .L GVMTA030 And see if there is an M in line four. Creating triggers on multi data level files requires some tricks as the comma is not valid in a file name for CREATE TRIGGER (SQL syntax restriction). -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Sep 11, 2007, at 2:53 PM, Marcos Fogaga wrote: Hi, My UV is release 10.2 and if I try convert a regular pick file there are the error message : CREATE TRIGGER T_TRIGGER AFTER INSERT OR UPDATE ON GVMTA030 FOR EACH ROW CALLING '*T_TRIGGER'; UniVerse/SQL: Invalid file type specified. Warning: SICA information could not be read properly!! T_TRIGGER 001 SUBROUTINE T_TRIGGER(PAR1,PAR2,PAR3,PAR4,PAR5,PAR6,PAR7,PAR8,PAR9,PAR10,PAR1 1,PAR12,PAR13,PAR14) 002 RETURN What type of file are you using? Thanks in advance. Regards, Marcos Fogaca -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Em nome de gerry-u2ug Enviada em: terga-feira, 11 de setembro de 2007 18:26 Para: u2-users@listserver.u2ug.org Assunto: RE: [U2] Universe and triggers Hi Marcos, what version of universe are you running ? We used to use the index w subroutine method you describe but this is now gone in favour of native universe triggers. We have many files in universe with triggers on them , there is no requirement to SQL'ize the table and believe me these tables would take a LOT of work to make them sql conformant. Universe will add a SICA for the table but that's it, any garbage hashed file works just fine afaik. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: September 11, 2007 04:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe and triggers Hi Marcos, Universe seems hellbent on invoking the entire SQL system in order to put a simple trigger on a file. UniData is MUCH more forgiving in that regard. With Universe, I have had a certain amount of success making what I call 'indexed subroutines' where by an index on a file calls a virtual Dictionary subroutine which does, in fact, operate as a rudimentary trigger. You CANNOT affect data going to the actual file record update as you might with an actual trigger, but you can write information to a tracking database and then I have a background phantom in operation which manages email distribution from the triggered events and what not. I *could* even write back to the originating file record that initiated the trigger -- I've closed off the mortal embrace between phantom and virtual subroutine -- but that will always have a lag time between the actual record update event and the final conclusion of the trigger, so I would not consider it a particularly clean solution for true database triggering. It does work well as a tracking and reporting system, though. Trey -- Original message -- From: Marcos Fogaga [EMAIL PROTECTED] Hi, It is possible create a trigger (subroutine) for a pick file (non SQL table)? On D3 we have CALLX, is there a feature like this in Universe? Thanks in advance. Best Regards, Marcos Fogaca Integral Sistemas Sao Paulo / Brazil --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: Documentation errors (was Get a grip)
Good point, though we recently had an example where a feature someone on the list knew about is not in any of the docs, at least that anyone has said they found. I know I did a full text search on the 10.2 PDFs and didn't find it. (ODBC.LOGIN paragraph was the item.) Does anyone open a case on documentation errors and omissions? As to archive indexes, I've found the archive at Nabble to be fairly good, although there are things I know are there that it misses. Try http://www.nabble.com/U2---Users-f801.html Hope that helps. -- Regards, Clif On Sep 6, 2007, at 9:42 PM, [EMAIL PROTECTED] wrote: BTW -- if ALL you want is strictly technical information -- then RTFM, Tech Connect etc...I use this list to ask others for help regarding their personal experience and opinions on subject matters where I could not get the answers via those previously mentioned methods. If the answer includes suggestions on third party tools...then that may be truly the answer I was seeking. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Get a grip - was ads - was U2 University Last Week In Denver
Chuck, please forgive me if it looks like I'm jumping into a Moderator issue; that is not my intent! As a private citizen and consultant and ex-list-host, I'd like to address this current discussion. I think that list members like Tony G and Susan J are being unfairly castigated (no R in there, so chill) for their postings. First, a brief summary of history: I hosted the u2-users list for 9+ years. It was a growing experience for all of us. We eventually hit the point where the Geeks didn't want to have their list defiled with anything non-technical. About the same time, the IBM contributors were dropping out because of the noise-to-signal ratio. That's when we split the non-technical discussions off to a different list, u2-community--much to the verbal dismay of some people yet unto this day. At the same time, the [ad] tagging was introduced to allow the purist geeks to avoid anything smelling like Real World Marketing. The usage of the tags has changed slightly since I turned the reins over to U2UG, but the intent seems to be the same. Now for the Cyber-Spanking (yes; I'm the one who coined the term): Tagging is a voluntary thing. Some people will do it, some won't. Most will try, but forget, or be inconsistent. For heaven's sake, people are human. They forget. They don't think in terms of, how can I write this in order to pussyfoot around the greatest number of underpaid geek's raw nerve endings? Yes, I've noted that Tony and Susan and others mention their services and products in their postings. So what? If you don't like it, hit the delete key. Set up a spam filter to trash their postings. Ignore their suggestions that usually proceed mention of their products (thus willfully ignoring free advice in the process). If you hate their postings, filter them. If you don't know how to do that, you really, really shouldn't be allowed access to the Internet. Let me rain on your sanctimonious parade a little bit more: In the almost ten years I hosted the list, I was asked many times, what do you get out of this? I had calls from IBM wondering what financial or marketing advantage this gave me. The answer? NONE. To my colleagues on the list who run their own businesses--don't worry about it. In 9+ years of running the list, do you know how many sales/projects I got from the effort? ZERO! (It was a work of payback to the community.) My analysis was that 95% or more of the (mostly non-posting lurkers) of the list not only do not have the authority to sign a check, their opinions are not taken into account by management when purchasing decisions are made. So to the whiners about sales pitches on The List, want us to do a statistical analysis of your postings to see how much content or technical knowledge you contribute compared to what non-AD postings you receive? To the (very few) who do mention their services and products on the list, I ask a simple question: Are you getting enough (any) leads that make putting up with this abuse from the non-check-writing members worth your harassment? Just think about it. Are you more interested in free information exchange, or coercing people to post things YOUR way? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/