Re: [U2] User Groups
In the mean time, attend U2 University coming up this fall in Terrytown. I'll be there speaking on HW, O/S & the U2 Data Servers. Worth every penny of the $850 tuition. http://www-306.ibm.com/software/info/u2/university/index.jsp Bob, Sounds like time for you to start one. I suspect you could get a good group up for a quarterly meeting structure. - Chuck Bob Wyatt wrote: > Is anyone aware of any active user groups operating within 100 miles of > Philadelphia? This narrows it down to the NY/Baltimore corridor? --- 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/
And the Winner is: [U2] [UV] checking files for corruption - Humor Here - plus Do this Every Month
Scott Thompson asked ..."> What is the best way to verify the integrity of a file while users are accessing (if possible at all)?" Please note that Scott only asked for a single file... Runner Up: Karl P was extremely close with "LIST FNAME LASTATTRIBUTE". If he would have added DET.SUP, he would have been a Winner. This would have avoided the output. Karl's entry would require you to press the ENTER key as the @ID and LASTATTRIBUTE were displayed for every record. You would probably get sick of this after a while and enter a "S" to suppress the output when the PAK (Press Any Key to continue) prompt was requested. However, you would have to write a rather extensive PAragraph or PRoc to include ALL of the files. And the Winner is: Jerry Banker who stated: "You can try doing a uvbackup on the file to /dev/null. When the file is backed up it checks the integrity of the file. Jerry" uvbackup is the only utility that goes thru all of the files and reports on its integrity. uvbackup can be run with users on the system. The question that was not asked... Should I add the "uvbackup on the file to /dev/null" to my monthly processes to verify the integrity of the database? Best business practices state that this should be included every month. This is a more PC answer than "HELL YES, We're talkin' Job Security"! Nice Contest, Steve Stephen M. O'Neal U2 Lab Services Sales Specialist Information Management, IBM Software Group --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Easysoft ODBC driver [ad/solution/sigh]
Brenda Price wrote: > We will only be using to from UniVerse to access a MicroSoft SQL for > our credit card numbers this is due to PCI compliance and we wanted 1 > database for all of our different systems. From the UniVerse side of > things, we will have to access the SQL with a batch process 2 times a > day, with an average of 2-3000 records. You really don't need to push data from UV to SQL Server, you can pull it at timed intervals (seconds to hours) and encrypt it for the transfer on the way. This can be done with UO.NET and other tools. You also don't need to hardcode SQL queries into your MV BASIC code. The [ad]: Nebula R&D sells mv.NET which is a solution that you have probably not considered for this task, though it can be used to push AND pull data for any connectivity application. Feel free to contact me for information about connecting your UV/UD system to anything, including relational databases. The solution: I have a simple demo ready for anyone who wants to see it which populates SQL Server from any MV DBMS on any OS. This isn't productized, there's no need to productize something as simple as this. It's pulling data from MV without putting SQL into the MV environment or touching data or dictionaries. The data is then put into whatever database you want using whatever functions are available to the RDBMS. I'm using Insert queries to do the initial load and a Stored Procedure for the updates - just to show it can be done. The code can be used to push from MV (over Win/*nix/Linux) or to pull from any middle tier server or workstation. I haven't done any optimization on it yet but so far I'm getting about 385 Inserts per second and 485 Updates per second. That includes the time to connect, sselect, transport, perform queries, and disconnect, and I'm running this regularly with several thousand data items. I'm only doing one update at a time - someone with a clue might suggest updating 100 records or more at a time to improve throughput. Using UO.NET into UV the performance could be even better, I haven't tried yet. As MV people we know how to code and manage our environments but we can leave the RDBMS stuff to the RDBMS DBAs. There's no need to hardcode SQL queries into your MV application, buy a specific driver for some RDBMS, or modify your MV data to look relational. mv.NET is only $260 for a single runtime license. If you are doing your own development it's $635 for the developer license. That includes 2 runtime licenses, so the net cost is only $135 for the developer license - hardly taking anyone to the cleaners... Compare that to the #899 for something like the Easysoft ODBC-Oracle Driver which doesn't have a fraction of the features. Nebula R&D provides the current version of all demos for free but without support to Nebula R&D clients. Nebula developers can work with clients to enhance the demos or develop new solutions - this is where we derive our income, not really on sales of tools. More info about mv.NET starts here: remove..this..pleaseNebula-RnD.com/products/ And now, the sigh. Sigh. Thanks for your time. Tony Gravagno TG@ removethisNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Product Distribution Methods
Brian Leach and U2Logic both have client/server-style U2 installers/packaging toolsets. I haven't tried either yet. But both look interesting and have slightly different approaches. See their respective websites for more info. http://www.brianleach.co.uk http://www.u2logic.com Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Thursday, September 13, 2007 8:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Product Distribution Methods Hi Dave, > Our system is far too complex to describe here in a single email, but > I'd like to discuss the topic in general with anyone who needs to > distribute their server-based code to clients, whether external or > internal. I'm willing to provide specifics; I just don't want to bore > everyone else with a lengthy description here. > As far as you can why not keep this on the list -- I'm certainly interested. One procedure does come to mind for this if you are distributing to UV: - Create "Clean Install" Account(s) for your product. These accounts should have files dictionaries set up as though they were setup at the client just before you began any data entry or customisation for that particular client. These accounts might include only basic source code or just compiled object code (with stub files in place of the BASIC source so that you can use CATALOG). - Back these up using uvbackup - Create a customization script or program or write your install manual --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Product Distribution Methods
Hi Dave, Our system is far too complex to describe here in a single email, but I'd like to discuss the topic in general with anyone who needs to distribute their server-based code to clients, whether external or internal. I'm willing to provide specifics; I just don't want to bore everyone else with a lengthy description here. As far as you can why not keep this on the list -- I'm certainly interested. One procedure does come to mind for this if you are distributing to UV: - Create "Clean Install" Account(s) for your product. These accounts should have files dictionaries set up as though they were setup at the client just before you began any data entry or customisation for that particular client. These accounts might include only basic source code or just compiled object code (with stub files in place of the BASIC source so that you can use CATALOG). - Back these up using uvbackup - Create a customization script or program or write your install manual Now your installation procedure is: - Use uvrestore to create your clean install accounts on the client - Once this is done begin customization - compiling, cataloging, setting up UV.ACCOUNT entries etc. Either manual or via program/script. Having looked at install systems on various Unix and Linux systems and on various databases I'd say that outside Windows everything boils down to unpacking an archive, optionally compiling and scripting configuration. Sometimes with all steps controlled by a script or program, sometimes not. Examine the UV install procedure as an example of exactly this: - mount your tape/CD - restore data from this using cpio (the install script) - the install script then does further extraction and configuration - As well as this perform the other manual installation tasks (setting up users, directories etc). Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Easysoft ODBC driver - Anyone had any issues with it?
We use ES Oracle ODBC driver. We've been using it for almost a year with UniData 6.1 on 64-bit HP-UX 11.11. Before that, we were using Data Direct sequelink. I like ES because * Cheaper than SequeLink * Easy to install. * and ES Support is very responsible. ES knows about U2. You can even find BCI installation document on their site. However, when ES asks you to send an example code for debugging, you may need to write it in C, unless you give ES a right to access your UniVerse machine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Wednesday, September 12, 2007 1:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] Easysoft ODBC driver - Anyone had any issues with it? We had been trying for about a week to get DataDirect (a trial version) to work with UniVerse. It would work with Linux but not UniVerse. Because of that and its price tag, we looked for another product and found Easy Soft. We had the trial version of it up and working within hours and the price tag is very nice compared with DataDirect. We will only be using to from UniVerse to access a MicroSoft SQL for our credit card numbers this is due to PCI compliance and we wanted 1 database for all of our different systems. From the UniVerse side of things, we will have to access the SQL with a batch process 2 times a day, with an average of 2-3000 records. Just wondering if anyone has utilized it and had any issues with it that we should be aware of in making our purchasing decision. Brenda Price Affiliated Acceptance Corporation --- 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] User Groups
Bob, Sounds like time for you to start one. I suspect you could get a good group up for a quarterly meeting structure. - Chuck Bob Wyatt wrote: Is anyone aware of any active user groups operating within 100 miles of Philadelphia? This narrows it down to the NY/Baltimore corridor? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Product Distribution Methods
David, I believe Brian Leach was working on a commercial delivery system. U2UG has a discussion about developing a freeware method and [AD] I, myself have half of one written [AD]. You should talk to Brian about his, as it is most likely the most complete option of the three. - Chuck Liesse, Dave wrote: My company publishes a software product for commercial distribution. It uses Universe on the server and a combination of VB flavors for the client. Long ago we developed a distribution system for the server side of things, but that was back when we were a server-only application. Now I'm afraid we're considerably behind the state of the art in our method of distributing the server software (no problem on the client), and I'd like to explore new approaches -- - Charles Barouch [EMAIL PROTECTED] Consulting --- 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: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?
The date index would contain internal-format dates, and there would be one for every record, as it is the POST.DATE. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Product Distribution Methods
I wish I could contribute more, instead of just asking questions when I have problems beyond the documentation, but since I subscribe to the digest each question has usually been answered 16 times before I see it. Anyway, thanks to all of you who have helped with my queries in the past! Now I have another one. My company publishes a software product for commercial distribution. It uses Universe on the server and a combination of VB flavors for the client. Long ago we developed a distribution system for the server side of things, but that was back when we were a server-only application. Now I'm afraid we're considerably behind the state of the art in our method of distributing the server software (no problem on the client), and I'd like to explore new approaches. Unfortunately, a web search has turned up nothing useful. Every likely set of search terms returns advertisements, product technical descriptions, or in exactly one case a Wikipedia page. It looks like no one has ever addressed software distribution in an academic fashion. Our system is far too complex to describe here in a single email, but I'd like to discuss the topic in general with anyone who needs to distribute their server-based code to clients, whether external or internal. I'm willing to provide specifics; I just don't want to bore everyone else with a lengthy description here. Regards, Dave Liesse [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata 7.1 system requirements
Number of users?40 user Size of database? 21 Gig in Live Realm / 75 gig all Realms / Live Realm gets 99% of activity. Redundancy desired? RAID 5 or HP's RAID 6 Ratio of reads to writes today? 3/2 READ/WRITE Anticipated growth? 30% a year Expected server longevity? 3 to 7 years Michael Martin Michael, If it were me, I'd be looking at 2 - 4 GB of memory, today. If it were me, I'd be looking at about 300GB of disk capacity in a RAID-5 configuration (at the 3-year mark and at 30% growth per year, I need no less than 165 GB, not including parity). RAID-5 has two writes per database write; RAID-6 has three. I'm not of the opinion that it provides an additional level of protection worthy of that performance hit. There have been other posts regarding OS limitations, so I shall not offer my opinion there. As the server approaches it's second anniversary, I would be budgeting additional monies for an upgrade (not a replacement, but add more disk and memory) during it's third year. If it's a one-shot deal, then I'd shoot for 8 GB of memory, an OS that'll let me use it, a multi-core processor, and no less than 800 GB of storage (7 years of 30% growth has me near 500 GB, sans parity). Regards, Bob Wyatt --- 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?
I've never heard about MINIMUM.MODULUS, but then again when I did most of my operations & database work late last century, dynamic files did not exist. I've never heard of split operations either. Here are all the ANALYZE.FILE results: >ANALYZE.FILE ABC File name .. ABC ... File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 801544 current ( minimum 50021 ) Large record size .. 1619 bytes Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 2115325952 bytes --- 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] 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: [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] Easysoft ODBC driver - Anyone had any issues with it?
That was how I found out about Easysoft, just looking other opinions. Thanks, Brenda -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 12, 2007 2:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Easysoft ODBC driver - Anyone had any issues with it? Hi Brenda There was a forum post on the U2UG website about this. Forums->Success Stories->ODBC connectivity to and from Oracle It's currently in the recent list on the front page. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price > Sent: 12 September 2007 18:29 > To: u2-users@listserver.u2ug.org > Subject: [U2] Easysoft ODBC driver - Anyone had any issues with it? > > We had been trying for about a week to get DataDirect (a > trial version) to work with UniVerse. It would work with > Linux but not UniVerse. > Because of that and its price tag, we looked for another > product and found Easy Soft. We had the trial version of it > up and working within hours and the price tag is very nice > compared with DataDirect. > > > > We will only be using to from UniVerse to access a MicroSoft > SQL for our credit card numbers this is due to PCI compliance > and we wanted 1 database for all of our different systems. > From the UniVerse side of things, we will have to access the > SQL with a batch process 2 times a day, with an average of > 2-3000 records. > > > > Just wondering if anyone has utilized it and had any issues > with it that we should be aware of in making our purchasing decision. > > > > Brenda Price > > Affiliated Acceptance Corporation > --- > 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] Who has the largest Windows U2 installation?
You do have to do some configuration to address more than 2Gb of RAM (PAE set to on). Windows server 2003 standard in 32-bit can only address 4Gb max. Enterprise versions and 64-bit ones can do more.> Subject: [U2] Who has the largest Windows U2 installation?> Date: Wed, 12 Sep 2007 14:15:44 -0400> From: [EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org> > I have 45 Enterprise UniData 6.1> > Just looking for examples of just how large some of you have scaled on Win before crossing the boundary into Unix, and if you had any issues if you scaled large scale (say larger than 100 user sessions)> > :-)> > No virus found in this outgoing message.> Checked by AVG Free Edition. > Version: 7.5.485 / Virus Database: 269.13.15/1003 - Release Date: 9/12/2007 10:56 AM> ---> u2-users mailing list> u2-users@listserver.u2ug.org> To unsubscribe please visit http://listserver.u2ug.org/ _ Can you find the hidden words? Take a break and play Seekadoo! http://club.live.com/seekadoo.aspx?icid=seek_wlmailtextlink --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Easysoft ODBC driver - Anyone had any issues with it?
Hi Brenda There was a forum post on the U2UG website about this. Forums->Success Stories->ODBC connectivity to and from Oracle It's currently in the recent list on the front page. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price > Sent: 12 September 2007 18:29 > To: u2-users@listserver.u2ug.org > Subject: [U2] Easysoft ODBC driver - Anyone had any issues with it? > > We had been trying for about a week to get DataDirect (a > trial version) to work with UniVerse. It would work with > Linux but not UniVerse. > Because of that and its price tag, we looked for another > product and found Easy Soft. We had the trial version of it > up and working within hours and the price tag is very nice > compared with DataDirect. > > > > We will only be using to from UniVerse to access a MicroSoft > SQL for our credit card numbers this is due to PCI compliance > and we wanted 1 database for all of our different systems. > From the UniVerse side of things, we will have to access the > SQL with a batch process 2 times a day, with an average of > 2-3000 records. > > > > Just wondering if anyone has utilized it and had any issues > with it that we should be aware of in making our purchasing decision. > > > > Brenda Price > > Affiliated Acceptance Corporation > --- > 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?
I have seen some slight performance degradation above 4 indices. I usually recommend that you have no more than 6, but 5 or even 6 can be ok, in a pinch. So the answer is that you're approaching the point where there will be a measurable negative impact on throughput. The complete answer is test it & see if the performance hit exceeds your tolerance level. Defining the indices as NO.NULLS helps a lot (I've had folks tell me that they _had_ to index on null values. I'm unconvinced that there's much value in that unless only a tiny percentage of the records will have a null value in the field). With a dynamic file that large, I'd also be looking for ways to minimize split operations. Usually, I'll see a very high percentage of writes doing splits when a dynamic file is that large - and those are expensive writes. You may want to make sure that MINIMUM.MODULUS is not less than CURRENT.MODULUS, and increase it with an ample growth factor. Of course, if you're running in 32 bit mode, you may not have any wiggle room left there, and may want to look into converting this into either 64-bit or a distributed file.> Date: Wed, 12 Sep 2007 11:39:09 -0700> From: [EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org> Subject: [U2] Does anyone know the effect of adding an ndex to a UniVerse file?> > 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/ _ Can you find the hidden words? Take a break and play Seekadoo! http://club.live.com/seekadoo.aspx?icid=seek_wlmailtextlink --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Who has the largest Windows U2 installation?
Did you have to do anything special to the installation beyond the normal tune up to U2 paramaters? And with 250 users, how much ram is that box running? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Wednesday, September 12, 2007 2:41 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Who has the largest Windows U2 installation? We have a 250 user implementation, been running for three or four years now without any problems. We've got another with 120 users, and several more around the 100 mark. With some decent hardware it's fine. George Land www.u2uk.com On 12/9/07 19:15, "Marc Harbeson" <[EMAIL PROTECTED]> wrote: > I have 45 Enterprise UniData 6.1 > > Just looking for examples of just how large some of you have scaled on Win > before crossing the boundary into Unix, and if you had any issues if you > scaled large scale (say larger than 100 user sessions) > > :-) > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.485 / Virus Database: 269.13.15/1003 - Release Date: 9/12/2007 > 10:56 AM > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England & Wales ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.485 / Virus Database: 269.13.15/1003 - Release Date: 9/12/2007 10:56 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.485 / Virus Database: 269.13.15/1003 - Release Date: 9/12/2007 10:56 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Who has the largest Windows U2 installation?
I have 45 Enterprise UniData 6.1 Just looking for examples of just how large some of you have scaled on Win before crossing the boundary into Unix, and if you had any issues if you scaled large scale (say larger than 100 user sessions) :-) No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.485 / Virus Database: 269.13.15/1003 - Release Date: 9/12/2007 10:56 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Who has the largest Windows U2 installation?
We have a 250 user implementation, been running for three or four years now without any problems. We've got another with 120 users, and several more around the 100 mark. With some decent hardware it's fine. George Land www.u2uk.com On 12/9/07 19:15, "Marc Harbeson" <[EMAIL PROTECTED]> wrote: > I have 45 Enterprise UniData 6.1 > > Just looking for examples of just how large some of you have scaled on Win > before crossing the boundary into Unix, and if you had any issues if you > scaled large scale (say larger than 100 user sessions) > > :-) > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.485 / Virus Database: 269.13.15/1003 - Release Date: 9/12/2007 > 10:56 AM > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error. The recipient should note that the views contained or expressed within this correspondence do not necessarily reflect those of APT Solutions Limited , it subsidiaries, affiliates or associates. This email and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message or any attachments will not adversely affect their systems or data. Registered Office:- Stratum House, Stafford Park 10, Telford, Shropshire, TF3 3AB Registration Number:- 2228445 Place of Registration: England & Wales ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Does anyone know the effect of adding an ndex to a UniVerse file?
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/
RE: [U2] Easysoft ODBC driver - Anyone had any issues with it?
Brenda: We use the Easysoft ODBC driver for both UNIDATA (AIX) and UNIVERSE (WINDOW NT). We have no issues with the driver and find the company to be very supportive. Let me know if you have any further questions on this. Thanks, Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Wednesday, September 12, 2007 1:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] Easysoft ODBC driver - Anyone had any issues with it? We had been trying for about a week to get DataDirect (a trial version) to work with UniVerse. It would work with Linux but not UniVerse. Because of that and its price tag, we looked for another product and found Easy Soft. We had the trial version of it up and working within hours and the price tag is very nice compared with DataDirect. We will only be using to from UniVerse to access a MicroSoft SQL for our credit card numbers this is due to PCI compliance and we wanted 1 database for all of our different systems. From the UniVerse side of things, we will have to access the SQL with a batch process 2 times a day, with an average of 2-3000 records. Just wondering if anyone has utilized it and had any issues with it that we should be aware of in making our purchasing decision. Brenda Price Affiliated Acceptance Corporation --- 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] U2 University Last Week In Denver
I have - and it is a nice editor - but no better than the wintegrate editor or unidebugger What I am interested in is the full GUI IDE not just the editor. Thanks Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D Sent: 12 September 2007 17:11 To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver Symeon, [AD] Why wait? Try our FREE GUI editor today at www.u2logic.com [/AD] Regards, Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans Sent: Tuesday, September 11, 2007 6:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver Symeon, Sorry that would be me. I am on the road right now doing the U2 University events. I connect every now and again for brief bursts so haven't had a chance to add you yet. I will do so before the September call. We haven't yet made the GUI IDE part of the EAP drop but may be able to do so in November so you haven't missed anything yet. Jackie Burhans U2 Portfolio Manager IBM Information Management Tel: 303-773-7717 T/L 656-7717 Mobile: 719-238-1553 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2 Register Now! Tune In! --- 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 7.1 system requirements
We are upgrading to Unidata 7.1, with Window Server 2003 and purchasing a new server. I would be interested in opinions on hardware specifications from the group. Thanks, Michael Martin ** Michael, Insufficient data. Number of users? Size of database? Redundancy desired? Ratio of reads to writes today? Anticipated growth? Expected server longevity? Regards, Bob Wyatt ** Bob, Here is some additional data... Number of users?40 user Size of database? 21 Gig in Live Realm / 75 gig all Realms / Live Realm gets 99% of activity. Redundancy desired? RAID 5 or HP's RAID 6 Ratio of reads to writes today? 3/2 READ/WRITE Anticipated growth? 30% a year Expected server longevity? 3 to 7 years Michael Martin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Easysoft ODBC driver - Anyone had any issues with it?
We had been trying for about a week to get DataDirect (a trial version) to work with UniVerse. It would work with Linux but not UniVerse. Because of that and its price tag, we looked for another product and found Easy Soft. We had the trial version of it up and working within hours and the price tag is very nice compared with DataDirect. We will only be using to from UniVerse to access a MicroSoft SQL for our credit card numbers this is due to PCI compliance and we wanted 1 database for all of our different systems. From the UniVerse side of things, we will have to access the SQL with a batch process 2 times a day, with an average of 2-3000 records. Just wondering if anyone has utilized it and had any issues with it that we should be aware of in making our purchasing decision. Brenda Price Affiliated Acceptance Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 University Last Week In Denver
I would like to make a general request to anyone interested: Please add http:// before web URLs so the link will become a clickable link for all the email clients (except maybe AOL's client) group members use. Okay, it's for me. I guess I'm getting too lazy to copy and paste... Which is quite a stretch because I use Linux, and all I have to do is highlight something, and it's put in the clipboard. No right-click, select an option nonsense. (please no flames; I don't want to be shunted off to 'community' 8^} ). Karl > Symeon, > > [AD] Why wait? Try our FREE GUI editor today at www.u2logic.com [/AD] > > Regards, > Doug > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans > Sent: Tuesday, September 11, 2007 6:03 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] U2 University Last Week In Denver > > Symeon, Sorry that would be me. I am on the road right now doing the U2 > University events. I connect every now and again for brief bursts so > haven't had a chance to add you yet. I will do so before the September > call. We haven't yet made the GUI IDE part of the EAP drop but may be able > to do so in November so you haven't missed anything yet. > > Jackie Burhans > U2 Portfolio Manager > IBM Information Management > Tel: 303-773-7717 T/L 656-7717 > Mobile: 719-238-1553 > Email: [EMAIL PROTECTED] > http://www.ibm.com/software/data/u2 > Register Now! > Tune In! > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 "To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it." --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata 7.1 system requirements
Michael: We run a Dell 1435 in development...2GB memory and two 150Gb SATA raid 1 drives. In production we have a Dell 2850 with 4Gb memory and 4 75Gb SCSI RAID 10 drives. So far it's holding up nicely with 50 users and we're moving up from there. You'll need more horsepower for larger, or 24/7, operations. The big issue here is the RAID and the ability to stop the mirroring to backup then restart it. This takes additional technical know-how. Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Michael Martin >Sent: Wednesday, September 12, 2007 7:18 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] Unidata 7.1 system requirements > >We are upgrading to Unidata 7.1, with Window Server 2003 and purchasing >a new server. I would be interested in opinions on hardware >specifications from the group. > >Thanks, > >Michael Martin >Innovation Industries Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 University Last Week In Denver
Symeon, [AD] Why wait? Try our FREE GUI editor today at www.u2logic.com [/AD] Regards, Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans Sent: Tuesday, September 11, 2007 6:03 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver Symeon, Sorry that would be me. I am on the road right now doing the U2 University events. I connect every now and again for brief bursts so haven't had a chance to add you yet. I will do so before the September call. We haven't yet made the GUI IDE part of the EAP drop but may be able to do so in November so you haven't missed anything yet. Jackie Burhans U2 Portfolio Manager IBM Information Management Tel: 303-773-7717 T/L 656-7717 Mobile: 719-238-1553 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2 Register Now! Tune In! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 University Last Week In Denver
Email [EMAIL PROTECTED] and ask to be added. Jackie Burhans U2 Portfolio Manager IBM Information Management Tel: 303-773-7717 T/L 656-7717 Mobile: 719-238-1553 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2 Register Now!Tune In! "Perry Taylor" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/12/2007 07:05 AM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] U2 University Last Week In Denver How does one go about signing up for the U2 News Flash? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans Sent: Tuesday, September 11, 2007 2:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver I thought I'd give a shot at answering some of Doug's questions about the new U2 Developer (aka GUI Basic IDE). Is it backward compatible to Universe 9.6 or UniData 6.1? It will require you to install some Basic routines on the server but should work with older versions. Has it been tested by over 700 users? No, it hasn't been released yet as part of the Early Adoption Program, but it will soon. Has it been test on Mac, Windows, Linux and Fedora? No, see above. Also currently we have a dependency on a piece that runs on Windows-only. That would have to be resolved before we could run on other platforms. Can you update the product using Eclipse's Update Manager? We are looking into it. Does it work on Eclipse 3.3 and Eclipse 3.2? Runs today on Eclipse 3.2 Does it run on Java 1.5 or 1.6? Runs today on JRE 1.4 and 1.5 (aka 5.0) Can we test that Editor today in a real world environment? No, see above but watch for our announcement of its availability in our Early Adopter Program. Subscribe to the U2 News Flash if you haven't already and you should see it there soon. We are glad to have feedback from those who see this at U2U and those who will sign up for the EAP, especially those experienced in this technology. We have a number of existing and planned Eclipse-based tools and are looking forward to leveraging our experience to build this new tool and going back to our existing tools and integrating some or all of this tool as appropriate into those. And we're glad to have partners also providing modern development tools for U2--there cannot be too many good tools! Jackie Burhans U2 Portfolio Manager IBM Information Management Tel: 303-773-7717 T/L 656-7717 Mobile: 719-238-1553 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2 Register Now! Tune In! "D" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/05/2007 09:20 AM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] U2 University Last Week In Denver That U2 Editor you saw at the U2 University will not be out until first quarter 2008 for Unidata and later for Universe. Here are the questions you should be asking. Is it backward compatible to Universe 9.6 or Unidata 6.1? We doubt it! Has it been tested by over 700 users? We doubt it! Has it been test on Mac, Windows, Linux and Fedora? We doubt it! Can you update the product using Eclipse's Update Manager? We doubt it! Does it work on Eclipse 3.3 and Eclipse 3.2? We doubt it! Does it run on Java 1.5 or 1.6? We doubt it! Can we test that Editor today in a real world environment? We doubt it! We are the only company in the U2 market that has the programming expertise and the years of experience that has been producing and selling Eclipse based tools. We are updating our U2 editor and other tools on a daily basis and giving them away. What are you waiting for? Regards, Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, September 05, 2007 6:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver I'd also like to add that everyone better start looking into Eclipse because some great things are going to be built on that platform. They are also looking to recruit developers and users for an advisory group. So, if you have some things you would like to see added to the products this is your chance. Jerry --- 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 image/jpeg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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
RE: [U2] Unidata 7.1 system requirements
We are upgrading to Unidata 7.1, with Window Server 2003 and purchasing a new server. I would be interested in opinions on hardware specifications from the group. Thanks, Michael Martin Michael, Insufficient data. Number of users? Size of database? Redundancy desired? Ratio of reads to writes today? Anticipated growth? Expected server longevity? Regards, Bob Wyatt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Siging up for U2 News Flash
Per Janet, you need to send an email to [EMAIL PROTECTED] stating that you would like to receive the news flash. Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! [demime 1.01d removed an attachment of type image/jpeg which had a name of 0E007710.jpg] [demime 1.01d removed an attachment of type image/jpeg which had a name of 0E997230.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RES: RES: [U2] Universe and triggers
Hi Clif, My file is type 18 and it is multi data level. DICT GVMTA030 D_GVMTA030 18 7 DATA GVMTA030,BAIXADOS GVMTA030/BAIXADOS18 3001 DATA GVMTA030,DELETADOS GVMTA030/DELETADOS 18 3001 DATA GVMTA030,GVMTA030 GVMTA030/GVMTA03018 5001 >.L GVMTA030 GVMTA030 001 F 002 GVMTA030 003 D_GVMTA030 004 M 005 006 007 BAIXADOS}DELETADOS}GVMTA030 008 BAIXADOS}DELETADOS}GVMTA030 Do you know what must I do to create a trigger in a file with these features? Thank you. Regards Marcos Fogaga -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Em nome de Clifton Oliver Enviada em: terga-feira, 11 de setembro de 2007 19:54 Para: u2-users@listserver.u2ug.org Assunto: 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] User Groups
Is anyone aware of any active user groups operating within 100 miles of Philadelphia? This narrows it down to the NY/Baltimore corridor? Regards, Bob Wyatt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Religious Wars
I agree with the following as I do the same thing. I also think the moderators past and present have done an excellent job. I really don't care about the rules for when to put in our not. I do have to say that whether or not the is there, if the post is basically why aren't you using our product instead of product X and saying our product does this and that and does that product do this and that and you haven't even tried our product. That type of post causes me to slam and lock the door behind me where I would never unless mandated by higher authorities to even consider that product. Sorry, I happen to be passive resister who like the donkey in the cartoon sits on its rear end, you push it up, and it falls back down. (yes I realized I just called myself an A(you know what)! ;^) Brenda <> --- 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] Unidata 7.1 system requirements
We are upgrading to Unidata 7.1, with Window Server 2003 and purchasing a new server. I would be interested in opinions on hardware specifications from the group. Thanks, Michael Martin Innovation Industries Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Religious Wars
As a frequent lurker, but rare contributor to this list, I don't think my leaning towards a moderated list should carry a great deal of weight. But I think it's served us well in the past and I would like to see it continue as is. I find the list somewhat mirrors my personal life. Mostly good folks with good ideas with the occasional turd thrown in. Nevertheless, I enjoy reading the vast majority of posts as well as enjoy deleting the rest. Mick Mick Gahan Director, MIS Metropolitan Community College Omaha, NE (402) 457-2402 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker Sent: Wednesday, September 12, 2007 7:52 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Religious Wars Put me in the moderated one-list camp. I have rules that shove both u2-users and u2-community into the same inbox anyhow. And while I don't mind the occasional dead parrot reference, when the thread has devolved to the point that it's ALL MP there's very little that can be done to revive it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 University Last Week In Denver
How does one go about signing up for the U2 News Flash? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans Sent: Tuesday, September 11, 2007 2:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver I thought I'd give a shot at answering some of Doug's questions about the new U2 Developer (aka GUI Basic IDE). Is it backward compatible to Universe 9.6 or UniData 6.1? It will require you to install some Basic routines on the server but should work with older versions. Has it been tested by over 700 users? No, it hasn't been released yet as part of the Early Adoption Program, but it will soon. Has it been test on Mac, Windows, Linux and Fedora? No, see above. Also currently we have a dependency on a piece that runs on Windows-only. That would have to be resolved before we could run on other platforms. Can you update the product using Eclipse's Update Manager? We are looking into it. Does it work on Eclipse 3.3 and Eclipse 3.2? Runs today on Eclipse 3.2 Does it run on Java 1.5 or 1.6? Runs today on JRE 1.4 and 1.5 (aka 5.0) Can we test that Editor today in a real world environment? No, see above but watch for our announcement of its availability in our Early Adopter Program. Subscribe to the U2 News Flash if you haven't already and you should see it there soon. We are glad to have feedback from those who see this at U2U and those who will sign up for the EAP, especially those experienced in this technology. We have a number of existing and planned Eclipse-based tools and are looking forward to leveraging our experience to build this new tool and going back to our existing tools and integrating some or all of this tool as appropriate into those. And we're glad to have partners also providing modern development tools for U2--there cannot be too many good tools! Jackie Burhans U2 Portfolio Manager IBM Information Management Tel: 303-773-7717 T/L 656-7717 Mobile: 719-238-1553 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2 Register Now! Tune In! "D" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/05/2007 09:20 AM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] U2 University Last Week In Denver That U2 Editor you saw at the U2 University will not be out until first quarter 2008 for Unidata and later for Universe. Here are the questions you should be asking. Is it backward compatible to Universe 9.6 or Unidata 6.1? We doubt it! Has it been tested by over 700 users? We doubt it! Has it been test on Mac, Windows, Linux and Fedora? We doubt it! Can you update the product using Eclipse's Update Manager? We doubt it! Does it work on Eclipse 3.3 and Eclipse 3.2? We doubt it! Does it run on Java 1.5 or 1.6? We doubt it! Can we test that Editor today in a real world environment? We doubt it! We are the only company in the U2 market that has the programming expertise and the years of experience that has been producing and selling Eclipse based tools. We are updating our U2 editor and other tools on a daily basis and giving them away. What are you waiting for? Regards, Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, September 05, 2007 6:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver I'd also like to add that everyone better start looking into Eclipse because some great things are going to be built on that platform. They are also looking to recruit developers and users for an advisory group. So, if you have some things you would like to see added to the products this is your chance. Jerry --- 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 image/jpeg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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 To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe and triggers
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/
RE: [U2] Religious Wars
Put me in the moderated one-list camp. I have rules that shove both u2-users and u2-community into the same inbox anyhow. And while I don't mind the occasional dead parrot reference, when the thread has devolved to the point that it's ALL MP there's very little that can be done to revive it. -- Dave Walker Programmer/Analyst Ivy Hill - Louisville (502) 473-2811 *IBM Certified Solutions Expert *U2 Family Application Development > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Louie > Bergsagel > Sent: Tuesday, September 11, 2007 9:06 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Religious Wars > > > I am a subscriber to both lists, and I don't even pay attention to the > source list. > > I have Gmail forward both lists to work, where an Outlook > filter pops up a > notice, because I like to read things as they come in, again, > regardless of > the source list, and everything goes to my Saved - U2 folder. > > So it makes no difference to me if there is one list or two. > > I say give everyone a vote and the moderator veto power, > unless you want to > be the moderator. > > I have seen personal attacks on other lists, and they are ugly and > depressing. They make our moderators (past & present) worth > their weight in > gold. > > -- Louie > --- > 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] Religious Wars
I vote for moderated ( - having been in unmoderated lists.) One or two is of little importance - though I'd prefer one. -- mats --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RES: [U2] Universe and triggers
Just to clarify 1. You can add triggers to non-sql files so long as they have a header. See the HELP SQL CREATE TRIGGER for the subroutine layout. 2. You can have up to 6 main triggers -before and after each type of event (insert, update, delete). 3. triggers must be globally cataloged since the file may be updated from any account - so a local catalog wouldn't be found. 4. To globally catalog copy the CATALOG entry from the VOC of the uv account to your local VOC (under a new name) and use that. Prefix the catalog name with an asterisk. 5. Triggers impose some limitations : they all make sense if you step back and think about them except (b): a. They observe some SQL constraints for isolation - so ALL writes must be lock protected. b. You can't move the file to a new platform (format.conv won't process it) c. Some commands are disallowed. d. No interaction is allowed, including the RAID debugger. 6. A useful tip - If a trigger changes you must ensure no-one has the file open. That's not always possible on a 24x7 system so I have a master trigger read a list of subtriggers from a file and call them in turn. Then I can back out a change by removing a routine from the list, or substitute a new routine at any time. 7. Triggers slow processing if over-used. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV basic assignment error ?
> As far as I can tell, UD doesn't have a BASIC runtime-error log. Oops - haphazard reading on my part. You're correct, of course. I actually get a lot of good information from the UniData logs that do exist, but then those are things that pertain more to what I normally do. And, as you pointed out, you shouldn't be making programming errors, anyway. ;-) OK - administering self-imposed cyber-spanking... Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 University Last Week In Denver
Ok no problem Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans Sent: 12 September 2007 01:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver Symeon, Sorry that would be me. I am on the road right now doing the U2 University events. I connect every now and again for brief bursts so haven't had a chance to add you yet. I will do so before the September call. We haven't yet made the GUI IDE part of the EAP drop but may be able to do so in November so you haven't missed anything yet. Jackie Burhans U2 Portfolio Manager IBM Information Management Tel: 303-773-7717 T/L 656-7717 Mobile: 719-238-1553 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2 Register Now!Tune In! "Symeon Breen" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/11/2007 01:46 AM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] U2 University Last Week In Denver To be a part of the ud7.2 EAP would be nice - I have been asking for months but not heard anything yet, I would definitely be a good tester of the ide if only I could get hold of it .. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Burhans Sent: 11 September 2007 07:26 To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver I thought I'd give a shot at answering some of Doug's questions about the new U2 Developer (aka GUI Basic IDE). Is it backward compatible to Universe 9.6 or UniData 6.1? It will require you to install some Basic routines on the server but should work with older versions. Has it been tested by over 700 users? No, it hasn't been released yet as part of the Early Adoption Program, but it will soon. Has it been test on Mac, Windows, Linux and Fedora? No, see above. Also currently we have a dependency on a piece that runs on Windows-only. That would have to be resolved before we could run on other platforms. Can you update the product using Eclipse's Update Manager? We are looking into it. Does it work on Eclipse 3.3 and Eclipse 3.2? Runs today on Eclipse 3.2 Does it run on Java 1.5 or 1.6? Runs today on JRE 1.4 and 1.5 (aka 5.0) Can we test that Editor today in a real world environment? No, see above but watch for our announcement of its availability in our Early Adopter Program. Subscribe to the U2 News Flash if you haven't already and you should see it there soon. We are glad to have feedback from those who see this at U2U and those who will sign up for the EAP, especially those experienced in this technology. We have a number of existing and planned Eclipse-based tools and are looking forward to leveraging our experience to build this new tool and going back to our existing tools and integrating some or all of this tool as appropriate into those. And we're glad to have partners also providing modern development tools for U2--there cannot be too many good tools! Jackie Burhans U2 Portfolio Manager IBM Information Management Tel: 303-773-7717 T/L 656-7717 Mobile: 719-238-1553 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2 Register Now!Tune In! "D" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/05/2007 09:20 AM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] U2 University Last Week In Denver That U2 Editor you saw at the U2 University will not be out until first quarter 2008 for Unidata and later for Universe. Here are the questions you should be asking. Is it backward compatible to Universe 9.6 or Unidata 6.1? We doubt it! Has it been tested by over 700 users? We doubt it! Has it been test on Mac, Windows, Linux and Fedora? We doubt it! Can you update the product using Eclipse's Update Manager? We doubt it! Does it work on Eclipse 3.3 and Eclipse 3.2? We doubt it! Does it run on Java 1.5 or 1.6? We doubt it! Can we test that Editor today in a real world environment? We doubt it! We are the only company in the U2 market that has the programming expertise and the years of experience that has been producing and selling Eclipse based tools. We are updating our U2 editor and other tools on a daily basis and giving them away. What are you waiting for? Regards, Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, September 05, 2007 6:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver I'd also like to add that everyone better start looking into Eclipse because some great things are going to be built on that platform. They are also looking to recruit developers and users for an advisory group. So, if you have some things you would like to see added to the products this is your