Re: [UD] Union Query
No, and Yes. Just doing a SELECT in SQL style on UV gives you a crt display of the result set. But if you use the SLIST extension, you can then access the select list (see System Description manual) as "normal" for the UV environment. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On May 1, 2004, at 18:01, Steven M Wagner wrote: I will be the first to admit that I know next to nothing about SQL in the UV/UD world. Can you use the output of the SQL SELECT in UV/UD? Thanks. Steve At 05:14 PM 5/1/04 +1000, you wrote: Gordon J. Glorfield wrote: > In that case, I'm sorry to say, there is no way to logically > do what you're asking with UD. Gordon, you should now better! ;^) sql> SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE UNION SELECT NAME ADDRESS CITY STATE ZIP FROM ORDER_FILE_OTHER; All you need here Ed is a VOC pointer to each file that is SQL compatible - ie no "." dots etc. There is no need to build a schema or set up ODBC or do anything complicated in UniData just to query a file with SQL from the command line. Cheers, Ken >> -Original Message- >> From: Burwell, Edward [mailto:[EMAIL PROTECTED] >> LIST ORDER.FILE NAME ADDRESS CITY STATE ZIP >> >> or >> >> LIST ORDER.FILE.OTHER NAME ADDRESS CITY STATE ZIP >> >> How would a virtual dictionary know which file to get the >> NAME ADDRESS CITY and STATE from? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[ADMIN] [AD] Passing the Baton (Repeat)
A repeat for those who may have missed it, and for our new subscribers. This weekend is the switch to the new host at listserver.u2ug.org. -- Regards, Clif Dear Friends, As previously announced, after about nine years of hosting what has become the u2-users list, I have decided to pass the baton to a new host. I plan to use the time to pursue some other writing projects. One of these is to resume writing my column previously published in Infocus Magazine as "Clif Notes." I will be choosing a different title and will be including it as part of a professional Information Management newsletter. If you would be interested in receiving this newsletter at no charge, just pop an e-mail to [EMAIL PROTECTED] and I will add you to the list. The U2 User Group (u2ug.org) has offered to assume the duties of host and moderator(s). They are in the process of testing their list server and setup now. We expect to be able to move the u2-user and u2-community lists to the new home May 1st. I will provide them a copy of the subscriber addresses as of April 30th. If for some reason you do not want to follow the lists to their new homes, you can unsubscribe before that time. Since we are getting new subscribers on an almost daily basis, I will be posting this message each day until the move. I apologize for the inbox clutter this causes you. I'll chat with you again before the move. -- Regards, Clif ~~~~~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Problem reactivating select list
You're not wrong. Triggers on files came in at rev 10. -- Regards, Clif On Apr 26, 2004, at 18:21, John Hester wrote: Correct me if I'm wrong, but on UV 9.6 I think I'd have to convert every UV file to a SQL table to be able to use a trigger. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: How far can U2 scale?
"X" was a benchmark available at the time. I am not certain, but I think it was written and published by Ultimate. Assuming my memory is correct on that, a 2X ADDS machine would be one that ran the Ultimate benchmark twice as fast as the original Ultimate machine did. Maybe someone with a better memory has more details. Anybody have a copy of the old X benchmark laying around? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Apr 23, 2004, at 21:54, Mark Johnson wrote: latest '14x' processor. Boy, I wish I knew what those speeds of those older systems were in today's terms. 2x, 7x, 14x...What's an 'x'? IIRC, the -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: OT: Terminal emulator for Mac (was Re: What client platform do YOU use (Parallel to GUI thread))
Oh, yeah. RTFArchive, huh? Did so. Found it. Thank you. -- Regards, Clif On Apr 21, 2004, at 17:34, Bruce Nichol wrote: Goo'day, Clif, Check your own archive! Asked this question some short time (months) ago. Was pointed at a freebie (IIRC) French product. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Terminal emulator for Mac (was Re: What client platform do YOUuse (Parallel to GUI thread))
Thanks, Larry. I will check them out. I had forgotten about Carnation. I used Rich's emulator years ago at a client on one of the Little Beige Toasters, and memory failed me. -- Regards, Clif On Apr 21, 2004, at 17:12, Larry Hiscock wrote: PowerTerm ($149) from Ericom Software (http://www.ericom.com) supports Wyse 50/60 & VT100. I've never used their Mac version, but a client of mine uses their Windows version with decent success. Carnation software (http://carnationsoftware.com) -- the folks who brought you MacToPic and SBMac -- has a lower-end terminal emulator-only product called MacWise ($95). -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
OT: Terminal emulator for Mac (was Re: What client platform do YOU use (Parallel to GUI thread))
Does anyone know of a reasonably priced terminal emulator for the Mac that does *complete* VT100 or Wyse 50 emulation? -- Regards, Clif On Apr 21, 2004, at 16:33, Stuart Boydell wrote: Steve, I run a terminal emulator (Netterm) in 165x64 mode - no more because that's the smallest font I can read on the 17" monitor here. I run this on a Windows client against an aix/UV/SB+ app. The main advantage being that it just gives me lots of read space for programs. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UV Crash on W2K3
Thanks for the report, Sara. One thing I'd like to verify--is the work-around to this to simply delete the trigger and recreate it? Or did you have to create a whole new file, copy the records, and rename the file? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Apr 19, 2004, at 17:23, Sara Burns wrote: After extensive effort, creating an example to send to IBM we believe we have found the problem. One of our files had a trigger. Due to this the big/little endian conversion, using CONVERT.FORMAT did not seem to completely work. However this was not obvious. We thought we had reconverted all files with triggers, but maybe we missed this one. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: PI Open is going away
Ah, yes. *That* one. When first shown that, my comment was, "Congratulations. You've just reinvented RPG." :-) On Apr 18, 2004, at 3:24, Matti Lamprhey wrote: Surely "The Drumheller Trick" has to be where processing is applied to records within the SELECT process itself, using I-descriptors. I met John briefly at a Vmark bash in Birmingham (UK) some years ago, and it was clear that this was the one HE assumed was meant by the phrase. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: PI Open is going away
Which "trick" was that? He had so many. On Apr 17, 2004, at 15:08, Ross Ferris wrote: Probably. Never knew the guy ... but I thought the "trick" was kinda neat, and I've still been known to use variants to this day :-) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: PI Open is going away
That would be John "60,000 lines of PMA assemby code and only 3 comments" Drumheller. -- Regards, Clif On Apr 17, 2004, at 6:15, Ross Ferris wrote: Don't forget to mention "the Drumheller(? Drumhella?) Trick !" -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: PI Open is going away
As one of the engineers of the original Prime INFORMATION, I am curious how many people on the list are still using PI Open. Anyone care to sound off? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Apr 15, 2004, at 12:10, Jerry Banker wrote: The DB2 IMS Today newsletter has the following announcement. U2 Product Lifecycle Announcement Effective October 1, 2004, IBM will withdraw from marketing the programs noted below. If available, their replacement products are listed in the second column: PI/Open -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[AD] Re: Is anyone using a spooler wrapper for universe on Windows?
I have a product called ESP (Extended SPooler) that can replace JRT. It runs on both Unix, Linux, and Windows UV systems. UD is in the works. (Did I mention that it cost a *lot* less ) Please contact me off line or at the number below for more details. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Apr 14, 2004, at 15:05, Bobby Ramirez wrote: We are migrating from a unix box, to Windows 2000 server, and have a 3rd party spooler application called JRT. There is no JRT spooler app for windows. It is a slick little app that uses SP commands to manipulate jobs in the spool queue. I know printing on windows is handled by print manager, but i could quickly use a product that manipulates &hold& files entries. I would even consider looking into vbscrips to do some of this also. I would be interested in hearing what others are doing about printing from Universe on NT. I've setup different printers with different seperator pages but this JRT programs is nice because an operator can reprint jobs that used sp-assign HS. And she can print ranges of pages. thanks. Bob -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Moderation via the moderator
Thank you, Chuck. I appreciate the nice words. -- Regards, Clif Stevenson, Charles wrote: From: ... Clif Oliver The CyberSpankings will now begin Sheesh! I am not Santa Claus and am not going to make a naughty / nice list. EVERYBODY KNOCK IT OFF! Clif, I guess this means you won't reconsider remaining the list moderator, huh? On the plus side, you go out with a bang with a final example of what a fine job you've done. May we be so blessed in our next u2ug life. Thanks again. A word to the wise, Remember that these posts are archived. I, myself, have searched posts here and in other forums when evaluating candidates. I know that at least once my own posts were looked at when I candidated. Chuck "extremely moderate" Stevenson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Memo: Re: UV: How do I determine whether a file is using 64 bit or 32 bit addressing
I would like a copy of the unix magic file, David. Would you mind posting it as text? Otherwise, you can send a copy as an attachment to [EMAIL PROTECTED] and I'll get it to the list. -- Regards, Clif On Apr 5, 2004, at 3:46 AM, Logan, David (SST - Adelaide) wrote: file. I also have a magic file (thanks to Glenn Herbert) that tells me from the files command at the unix prompt. I will publish this if you need it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Can ya run UV 10.x 3 user system on Win XP Pro box?
License? Last time I checked (and it has been a while, so I stand open for correction), you needed a connection license for each incoming connection to a box being used as a server. -- Regards, Clif Matthew Bettinger wrote: Dang. If you are going to get that cheap about it (don't get me wrong cheap is good) I'd blow that xp box away and install your UV on linux. Save that windowz lic. for someone that really needs it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: [UV] Change prompt?
It is already there at release 10. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Ray Wurlod wrote: Or you could hassle IBM to add PI/open's COMMAND.EDITOR to UniVerse. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
[Fwd: Re: UNCLASSIFIED [UV] System Error Message 100102]
I am posting this for LeRoy. The new list server doesn't seem to like Lotus Notes yet. -- Regards, Clif Original Message Subject:Re: UNCLASSIFIED [UV] System Error Message 100102 Date: Thu, 19 Feb 2004 12:57:56 -0700 From: Leroy Dreyfuss <[EMAIL PROTECTED]> To: U2 Users Discussion List <[EMAIL PROTECTED]> The message comes from our query engine and was introduced with XML. It is harmless in that the query was successful. The fix is in the our latest releases. Regards, LeRoy F. Dreyfuss Advanced Technical Services - UniVerse IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! HENDERSON MICHAEL MR <[EMAIL PROTECTED]> *HENDERSON MICHAEL MR <[EMAIL PROTECTED]>* Sent by: [EMAIL PROTECTED] 02/19/2004 12:49 PM Please respond to U2 Users Discussion List To "'U2 Users Discussion List'" <[EMAIL PROTECTED]> cc Subject UNCLASSIFIED [UV] System Error Message 100102 Folks, Our system administrators have recently seen a few examples of System Error Message 100102 "get_expbuf: illegal level 0, current level 0." appearing in the UV ERRLOG. Can anyone tell me what this means, and what (if anything) we can do about it? UV 10.0.15 on Windows 2003 Server Thanks Mike Henderson --- Senior Analyst / Programmer, Corporate Applications Communications & Information Systems Branch New Zealand Defence Force DDI: +64 4 2371 828 Fax: +64 4 2371 807 Mob: +64 21 300 654 The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: STILL HANGING
Just as another data point, I have problems with both XP Pro and XP Home with a process locking up the CPU at 99% and "freezing" the system, and I do not have UV installed on either of these machines. So you might be looking at a Windows XP issue. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Ron White wrote: I have a development machine running UniVerse on WinXP PRO. While this may not have anything to do with your problem, it is one more thing you can check. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users