Re: [U2] [UD] correlative syntax
Isn't there a T missing? OCONV(@ID,G*1); OCONV(@,FILE;X;0;0); @# TFILE ? should be: OCONV(@ID,G*1); OCONV(@,TFILE;X;0;0); @# another way is to do both correlatives in 1 oconv: OCONV(@ID,(G*1:@VM:TFILE;X;0;0))# On 2/28/2013 3:29 PM, bradley.sch...@usbank.com wrote: A coworker just ran across the following in one of our DICTs. The name of the item indicates it was written by someone who is no longer with the organization and was well known for knowing wonderful arcane UniData tidbits. We can't find anything describing what exactly is going on. The end result is very useful. I'm wondering if anyone can explain the @# bit. OCONV(@ID,G*1); OCONV(@,FILE;X;0;0); @# The file the DICT is in has a compound key: ACCOUNT.NUMBER*sequential. What this item does is grab the account number, attempt to read from FILE and return a 0 if the account doesn't exist in FILE or a 1 if it does. Pretty nifty. UD7.1 AIX5.3 TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData PE on Fedora 18
Thanks Bob. Sorry for the late reply - it has been one of those weeks for me :-( I have already switched to CentOS and after a bit of messing around (need to use legacy network drivers in Hyper-V) have it working. The only reason I had tried Fedora in the first place was because I read that UniData worked on Fedora and RedHat. Best regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Little Sent: Monday, February 25, 2013 6:16 PM To: U2 Users List Subject: Re: [U2] UniData PE on Fedora 18 I have UniVerse PE running just fine on Fedora 17 which uses version 4 of libgdbm.so Perhaps the newer library is perhaps backward compatible to version 2 in which case a symlink may work. ln -s /lib/libgdbm.so.4 /usr/lib/libgdbm.so.2 Its worth a try anyway bob little independent contractor market america, inc. 1302 pleasant ridge rd. greensboro, nc 27409 Cell: 248-675-5515 Skype: boblittle904 Phone: 248-504-0540 From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of James Canale, Jr. [jcan...@optonline.net] Sent: Monday, February 25, 2013 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniData PE on Fedora 18 To all that responded, Thanks for the suggestions. I'll give CentOS a shot (OpenSUSE 12.2 and Fedora 18 didn't locate libgdbm.so.2). Best, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of James Canale, Jr. Sent: Sunday, February 24, 2013 2:39 PM To: U2 Users List Subject: [U2] UniData PE on Fedora 18 I'm trying to install the latest UniData 7.3 Personal Edition on Fedora 18 (32 bit) and am not able to find the proper download that seems to be required. The install fails at the point of running systest with 'error while loading shared libraries: libgdbm.so.2: cannot open shared object file'. I tried to find libgdbm2 on rpmfind but I'm not sure which to use. Tried a few and they all seem to have additional dependencies. Any suggestions? I read that UniData on Fedora will work so that's what I tried, but, I also have OpenSUSE and Ubuntu if either of those will be better. Thanks in advance. Best regards, Jim ___ 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] UniData PE on Fedora 18
Thanks Tony. Sorry for the late reply - it has been one of those weeks for me :-( I did switch to CentOS and it was a bit of a struggle using it on Hyper-V (a little research got me going). I agree with you on stability and my plan is to actually set this up to be a local only environment where it won't need to be patched at all (can't access it except from the Hyper-V host). At this point, I'm just interested in keeping up with U2 since I've moved on to other technologies (still love UniData, just not enough opportunity in my area to work with it). Best regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, February 25, 2013 8:05 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData PE on Fedora 18 In the bigger picture, Fedora is a hobbyist system and changes very rapidly. It's not meant to be used for production applications. You could get UV to work on it this week and it will break with a core update next week, or with some tiny dependency change or profile setting that's tough to trace. MV databases aren't oriented toward agile/chaotic environments like that. Serious developers should strive for stability in their own environment, with an eye for deployment over end-user systems with equal stability. Sure, I enjoy a challenge as much as the next geek, but at some point you need to ask yourself if you're wasting time chasing drivers and patches and hacks (like symlinks) when you really want to be doing something more productive. Get CentOS or RedHat. They're stable, well supported, and certified by the DBMS providers. HTH T From: Bob Little I have UniVerse PE running just fine on Fedora 17 which uses version 4 of libgdbm.so Perhaps the newer library is perhaps backward compatible to version 2 in which case a symlink may work. From: James Canale, Jr. Thanks for the suggestions. I'll give CentOS a shot (OpenSUSE 12.2 and Fedora 18 didn't locate libgdbm.so.2). ___ 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 on Fedora 18
On 3/1/2013 8:11 AM, James Canale, Jr. wrote: Thanks Tony. Sorry for the late reply - it has been one of those weeks for me :-( I did switch to CentOS and it was a bit of a struggle using it on Hyper-V (a little research got me going). I agree with you on stability and my plan is to actually set this up to be a local only environment where it won't need to be patched at all (can't access it except from the Hyper-V host). patching a system is not only for security, there are bug fixes and improvements, so even thought its only accessible from the system that holds the VM, I would still recommend that you patch the system on a regular basic (this is the sys admin in me coming out ) dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [Announcement]International Spectrum Phoenix 2013 Conference
International Spectrum Conference and Exhibition Attend the Premier MultiValue User Event April 15th-18th Benefits International Spectrum makes a special effort to bring together the tools you need to make sure you and your MultiValue (UniVerse, UniData, D3, jBase, OpenInsight, Reality, QM, Cache') Enterprise stay on the competitive edge. Whether you are an end user, a vendor, or an independent consultant, you get to talk to MultiValue experts and see the latest products, tools, software releases, and general corporate updates from the vendors and database providers. Work Smarter, Not Harder! Join us for sessions with topics that will help you maximize your existing business system with as little effort as possible, and still stay on-time and in budget. We include sessions on Reporting and Business Intelligence, Web development, as well as many other detail technical sessions you need to manage and maintain your MultiValue Enterprise. Highlights - Learn from Premier MultiValue Consultants at your choice of in-depth educational sessions. - Expand your knowledge at vendor-sponsored training and demonstrations. - Learn about the new products, tools, and features available to the MultiValue community. Register Now - Save $300.00 before March 6th http://www.intl-spectrum.com/conference/show/13/default.aspx 6 Weeks Left Full Conference Package: $1,095.00 1 Day Conference Package: $895.00 After March 6th Full Conference Package: $1,395.00 1 Day Conference Package: $895.00 More Information: http://www.intl-spectrum.com/conference/show/13/default.aspx Hotel Information: The Wigwam 800-327-0396 Room Rate: Single/Double $170.00 Special Rate Cut-off: March 22nd ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
