Re: RES: [U2] Universe and triggers
Clif See point 6 on my post grin It's not enough on a 24x7 site to just have a wrapper if the name of the subroutine doesn't change - UniVerse may still cache the object code in memory if the file is opened e.g. to named common. So I hold the name of the routine to call externally, and have the master trigger read it. Then I can vary it when the subroutine changes (e.g. adding a version number to the end). Brian 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Product Distribution Methods
Dave, My company markets a Universe application too, and like your company we have developed our own server-side distribution methods. When I think about the issue, it seems two-fold: (a) how do we get our software on the server in the first place, and (b) how do we keep it up to date with the latest and greatest? If I've misunderstood the problem that you want to discuss, you can just stop here and delete this email. (a) We actually keep our source code for our product in CVS, and we build new Universe accounts for our target platform. That includes creating the files, loading the dictionaries and data, compiling the programs, etc. via our build scripts. The resulting accounts are zipped or tarred to place onto distribution media. We expect Universe to be installed separately from our product. (b) Updates are a bit trickier, since they have to dovetail into existing systems that have been modified. From CVS and scripts, we can generate patch files that can be installed. The patch program can detect the conflicts, or otherwise install the newer software. Right now, ours is an on-demand process, and would greatly benefit from a windows update type of automation. Personally, I would welcome an open source approach. As a community, we need to lower the barriers to entry in all aspects of U2 training, development, and operations. rex --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] U2U UK You Need to Be There (BTW Register Now and Win an IPod)
Hi All, Following on from the successes of U2U in Denver and Sydney it's rolling it's way towards the UK and London. There are many reasons why you should be attending U2U but if need convincing here are some for you. There are over 40 Technical Tracks from which everyone will learn, no matter what their skill or experience level. It's a chance to meet the developers and engineers that you would not normally get. It's a chance to see some of the new functionality and technology's we are adopting and putting into the products before they become formally released and as such you will have a chance to influence the direction we are taking with these. Free U2 Certification tests in Administration and Application Development. Now if that's not enough, anyone attending U2U in London will be entered into a draw for an Ipod. All this for less than the cost of a formal training course ... what more can I say excellent value for money and you need to be there. For more information and how to register follow this link http://www-306.ibm.com/software/info/u2/university/index.jsp Thanks, Jonathan D Smith SWG Client Support - Software U2 Service Delivery Team Technical Support Consultant Support: UK 0800 773771; pan-EMEA 00800 2535 2535 [EMAIL PROTECTED] HOT: U2 University - Register today for the Premier U2 Event Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU [demime 1.01d removed an attachment of type image/jpeg] [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/
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 Stephen, Gee, just getting to (finally) meet Wally was worth the trip. You may have just turned it into a bargain! Bob Wyatt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] User Groups
It is spelled... tArrytown - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: And the Winner is: [U2] [UV] checking files for corruption -
Drat. I'm always coming in 2nd. Well, other than choosing a wife. I struck gold with that, just over 30 years ago. 8^} And, by the way, what does Jerry win? Karl quote who=Stephen O'Neal 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/ -- 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] Easysoft ODBC driver - Anyone had any issues with it?
What types of problems did you encounter that you had to send them code? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 12, 2007 5:09 PM To: u2-users@listserver.u2ug.org Subject: 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [OT]
Since I expect there are a number of us old Primos/Prime Information people out there, I thought you might like to check this out: http://www.gatago.org/comp/sys/prime It's a Primos emulator on a PS3 running Linux! Drew --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] User Groups
http://www.osda.org/links.htm is a good starting place (user group links at the bottom of the page). -- Louie On 9/13/07, Brian Leach [EMAIL PROTECTED] wrote: All This sounds like a good topic for a page on the new U2UG Wiki, where local user groups could advertise their presence and contact details. Anyone like to submit one? Brian 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] What is this error??
In the Editor (UV ED): : R/TREC/UPCASE(TREC TCL Case sensitivity is ON [990070] Try HELP. Does anybody know what is causing that error? It's very annoying and causes me to have to re-type the whole line. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What is this error??
Haven't seen that before. Type CASE OFF and it should go back to normal. -Original Message- From: Karen Bessel [mailto:[EMAIL PROTECTED] Sent: Thursday, September 13, 2007 11:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] What is this error?? In the Editor (UV ED): : R/TREC/UPCASE(TREC TCL Case sensitivity is ON [990070] Try HELP. Does anybody know what is causing that error? It's very annoying and causes me to have to re-type the whole line. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT]
Hmmm, I wonder if they have tried running PI on it. -Original Message- From: Drew Henderson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 13, 2007 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] [OT] Since I expect there are a number of us old Primos/Prime Information people out there, I thought you might like to check this out: http://www.gatago.org/comp/sys/prime It's a Primos emulator on a PS3 running Linux! Drew --- 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?
We weren't involved with the Windows install but the UniData install was just standard, we didn't do anything to it. It's an IBM xseries with 8 processors and 4Gb of RAM. George On 12/9/07 20:33, Marc Harbeson [EMAIL PROTECTED] wrote: 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Easysoft ODBC driver [ad/solution/sigh]
Hello, We have many products that will move data push or pull data to SQL Server, depending on the skill sets you want to use and your product roadmaps, this will determine the best product for your environment. While it's possible to pull from SQL Server, you may well wish to control the push from a Universe/BASIC program. In that case, FusionWare has a bridge product that allows you to use an API (BASIC Subroutines) to do the equivalent of BASIC's OPEN, READ, WRITE, DELETE as well as the equivalent of TCL SELECT and COPY, to/from SQL Server, Oracle, DB2, MySQL and other databases. If pull from SQL is not what you are looking for, as we mentioned above, then we have other solutions that could help you, including FusionWare Direct ADO.Net provider. [/AD] Please contact me if you would like further information. Thank you, Janet Bond FusionWare Corporation 1.866.266.2326 x159 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Wednesday, September 12, 2007 7:01 PM To: u2-users@listserver.u2ug.org Subject: 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 RD 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 RD provides the current version of all demos for free but without support to Nebula RD 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] What is this error??
I couldn't reproduce that error in ED on a Pick-flavored UniVerse site. I've always used C/old/new/ instead of R, but apparently they are synonyms. A shorter command to type would be R//UPCASE( --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [OT]
Nice. I kept my PR1MOS books for 27 years, and tossed them out in March. I was able to login and create a directory. What fun! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What is this error??
Nopeas my original email said, UV editor all the way. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Thursday, September 13, 2007 12:38 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] What is this error?? Are you using some kind of TCL wrapper? -Original Message- From: Karen Bessel [mailto:[EMAIL PROTECTED] Sent: Thursday, September 13, 2007 11:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] What is this error?? In the Editor (UV ED): : R/TREC/UPCASE(TREC TCL Case sensitivity is ON [990070] Try HELP. Does anybody know what is causing that error? It's very annoying and causes me to have to re-type the whole line. --- 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/
SAPUG Meeting September 20th (was: Re: [U2] User Groups)
Speaking of User Groups... If you're in the Northwest, you definitely want to attend the next SAPUG - Seattle Area Pick User Group meeting next Thursday September 20th. We're going to hear details about the most ambitious UV project I know of from Steve Ritchie of Market America: Join Steve Ritchie, VP of R/D and founding member of Market America to hear about how Universe is being in numerous unique ways to run their company as well as their growth financially and the steady buildup of their IT department. Steve will talk about challenges with rolling out a truly massive UniVerse project and about how the power of UniVerse has helped propel Market America to a billion dollar company in 5 countries. This is the project that elicited gasps at the U2UG Meeting at last year's Cincinnati Spectrum show. Our afternoon session will feature a technology preview from MITS looking at some of the technology underlying the advanced features in the next releases of MITS Discover and MITS Report. Special thanks to MITS for making their expertise available and underwriting this meeting. For details, see http://www.sapug.org and make sure to RSVP soon. Thanks, Ross VP Events - SAPUG --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RES: [U2] Universe and triggers
DOH! Sorry. Overlooked that. So much for speed reading. - Clif On Sep 13, 2007, at 3:38 AM, Brian Leach wrote: See point 6 on my post grin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What is this error??
In have the same problem with the editor some times, but it only happens on my Unix version and not on Windows. The is Unix. (AIX 5.2.? uv 10.1.?) ED VOC New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// TCL Case sensitivity is ON [990070] Try HELP. Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y CASE OFF TCL Case sensitivity is OFF ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// Try HELP. Bottom at line 1. : C/CASE IN/IN Try HELP. : EX * Record changed. OK to quit (Y) ? 0001: CASE IN POINT Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y But on Windows it works ok. (XP SP@ and UV 10.1.11) ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// 0001: IN POINT Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y CASE TCL Case sensitivity is ON CASE OFF TCL Case sensitivity is OFF .X3 03 ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// 0001: IN POINT Bottom at line 1. : Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: Thursday, September 13, 2007 11:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] What is this error?? In the Editor (UV ED): : R/TREC/UPCASE(TREC TCL Case sensitivity is ON [990070] Try HELP. Does anybody know what is causing that error? It's very annoying and causes me to have to re-type the whole line. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [OT]
Thanks for passing this along. What fun. I have some greenbar downstairs with Primos COBOL using MIDAS files, but I don't think I'll give it a spin. It is 30 year-old code and I had not even heard of structured programming back then. Maybe the thing I was missing regarding threads on this list was that one could put an [OT] in the subject line for items relevant to and of interest to U2 users, but not about a specific technical question in today's product. Thanks for the illustration. Maybe we can just kill u2-community by using [OT] for such postings, as you have done here. Cheers! --dawn On 9/13/07, Drew Henderson [EMAIL PROTECTED] wrote: Since I expect there are a number of us old Primos/Prime Information people out there, I thought you might like to check this out: http://www.gatago.org/comp/sys/prime It's a Primos emulator on a PS3 running Linux! Drew --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [OT] Primos Emulator
Don't know...wouldn't that be cool! Then we could run Word, Financial, and Graph Connection! hehe ;-) Drew Jerry Banker wrote: Hmmm, I wonder if they have tried running PI on it. -Original Message- From: Drew Henderson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 13, 2007 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] [OT] Since I expect there are a number of us old Primos/Prime Information people out there, I thought you might like to check this out: http://www.gatago.org/comp/sys/prime It's a Primos emulator on a PS3 running Linux! Drew --- 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] What is this error??
I think it's just us, Tom. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Thursday, September 13, 2007 3:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] What is this error?? In have the same problem with the editor some times, but it only happens on my Unix version and not on Windows. The is Unix. (AIX 5.2.? uv 10.1.?) ED VOC New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// TCL Case sensitivity is ON [990070] Try HELP. Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y CASE OFF TCL Case sensitivity is OFF ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// Try HELP. Bottom at line 1. : C/CASE IN/IN Try HELP. : EX * Record changed. OK to quit (Y) ? 0001: CASE IN POINT Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y But on Windows it works ok. (XP SP@ and UV 10.1.11) ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// 0001: IN POINT Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y CASE TCL Case sensitivity is ON CASE OFF TCL Case sensitivity is OFF .X3 03 ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// 0001: IN POINT Bottom at line 1. : Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: Thursday, September 13, 2007 11:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] What is this error?? In the Editor (UV ED): : R/TREC/UPCASE(TREC TCL Case sensitivity is ON [990070] Try HELP. Does anybody know what is causing that error? It's very annoying and causes me to have to re-type the whole line. --- 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] [OT] Primos emulator
I've still got a 300MB disk pack I use for tours (here is where we were in 1981) that came from a 750. Drew Louie Bergsagel wrote: Nice. I kept my PR1MOS books for 27 years, and tossed them out in March. I was able to login and create a directory. What fun! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [OT] Primos Emulator
Drew Henderson wrote: Don't know...wouldn't that be cool! Then we could run Word, Financial, and Graph Connection! drew your scaring me now --- 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 have legacy CALLC functions using ODBC API. One of our functions uses SQLFetchScroll with forward and backward cursors. Their ODBC cursor implementation worked only when SQL_ATTR_ROW_ARRAY_SIZE was 1 (one). That issue was found during my product evaluation time. However, one of ES Support engineers was very helpful and fixed it. According to the UniData BCI document, SQLFetchScroll() is not implemented. If you use BCI as is, it shouldn't be a problem (lucky you!). BTW, I believe that the cursor implementation of the latest version of ES Oracle ODBC driver works correctly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Thursday, September 13, 2007 10:14 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Easysoft ODBC driver - Anyone had any issues with it? What types of problems did you encounter that you had to send them code? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 12, 2007 5:09 PM To: u2-users@listserver.u2ug.org Subject: 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. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What is this error??
Take a look at the ED code - it's in the BP of the uvhome account, named ED.B There's a bunch of code relating to CASE, and there's this mod line at the top of the program: 06/01/03 E2835 LFD For 10.1 TCL Case Insensitivity project So, I guess you can blame someone with the initials LFD ;) But, what I can't believe is that some of you guys are still using ED. Why? You must have access to something better than a line editor. AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What is this error??
I have been singled out by the powers before, but usually after a few wines. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: Thursday, September 13, 2007 3:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] What is this error?? I think it's just us, Tom. ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Thursday, September 13, 2007 3:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] What is this error?? In have the same problem with the editor some times, but it only happens on my Unix version and not on Windows. The is Unix. (AIX 5.2.? uv 10.1.?) ED VOC New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// TCL Case sensitivity is ON [990070] Try HELP. Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y CASE OFF TCL Case sensitivity is OFF ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// Try HELP. Bottom at line 1. : C/CASE IN/IN Try HELP. : EX * Record changed. OK to quit (Y) ? 0001: CASE IN POINT Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y But on Windows it works ok. (XP SP@ and UV 10.1.11) ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// 0001: IN POINT Bottom at line 1. : EX * Record changed. OK to quit (Y) ? Y CASE TCL Case sensitivity is ON CASE OFF TCL Case sensitivity is OFF .X3 03 ED VOC JJJ New record. : I 0001= CASE IN POINT 0002= Bottom at line 1. : C/CASE// 0001: IN POINT Bottom at line 1. : Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: Thursday, September 13, 2007 11:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] What is this error?? In the Editor (UV ED): : R/TREC/UPCASE(TREC TCL Case sensitivity is ON [990070] Try HELP. Does anybody know what is causing that error? It's very annoying and causes me to have to re-type the whole line. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] create file
Hello group, I am a UV guy and I need some UD assistance. In UV I can OPENSEQ /path/file TO FV ELSE CREATE FV ELSE STOPM nope END Which will create the file if it doesn't exit, after which I can READEQ or READBLK to my heart's content. But UD dies at the CREATE statment. Also, instead of READBLK WRITEBLK it is OSBREAD, OSBWRITE in UD, correct ? Thanks, /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Question - retrieving file separation setting
In a Universe environment, (running either on Windows or *nix), does anyone know a fast way to determine the separation of a file? Type, Modulo, etc are easily returned via the FILEINFO function, but separation doesn't appear to be retrievable that way. Thank you. -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 University in Sydney
I recently attended the U2 University in Sydney. I would recommend everyone tries to attend whether end users, resellers or ISVs. IBM U2 division have been putting a lot of effort into RD and there are a number of new technologies that will change your thinking in development and continued use of U2 into the future. I will steal some of Susie's thunder and point out that U2 grew 14% last year so this is not losing edger technology. How many other database vendors can talk about double digit growth? The new IBM .Net provider for U2, allows you to do with U2 what you can do with other RDBMS including store procedures, etc. The EDA facility to extend to other databases is looking very mature and functional. So don't miss out learning about these new products. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] create file
There is no CREATE in UD. OPENSEQ will open the file if it exists or create it if it doesn't. If it can't create the file, STATUS() will return a reason why it can't be created. In the ELSE branch of the OPENSEQ statement, if STATUS() = 0, you can proceed to WRITESEQ (or OSBWRITE) to the file. Possible STATUS() values: 0 The record does not exist. 1 The file you specify is not a sequential-access file. 2 The file does not exist. 3 The READONLY clause was included in the command statement and the record does not exist. 4 An unknown error occurred (such as having too many files open or permission problems). OPENSEQ '/path/file' TO FV ELSE IF STATUS() NE 0 THEN STOP 'UNABLE TO OPEN SEQ FILE' END WRITESEQ test... ON FV ELSE STOP CAN'T WRITE TO SEQ FILE WEOFSEQ FV CLOSESEQ FV OSBREAD/OSBWRITE is used for block oriented access. If your file is line-oriented, you can use READSEQ/WRITESEQ. You can also use WEOFSEQ to write an End-of-file marker to the file (and truncates it at that point) before you close it (CLOSESEQ) Hope this helps Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Thursday, September 13, 2007 6:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] create file Hello group, I am a UV guy and I need some UD assistance. In UV I can OPENSEQ /path/file TO FV ELSE CREATE FV ELSE STOPM nope END Which will create the file if it doesn't exit, after which I can READEQ or READBLK to my heart's content. But UD dies at the CREATE statment. Also, instead of READBLK WRITEBLK it is OSBREAD, OSBWRITE in UD, correct ? Thanks, /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 --- 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 in Sydney
If you can, send at least two people. There are three tracks, each with 15 sessions. A few of the main ones are repeated, but one person can't learn everything he/she would want to. It was a well put-together show, even if one or two of the presenters were overworked (at least for the Sydney show), and most of the attendees to whom I spoke went away with their brains bulging - if not hurting. Also a great opportunity to catch up with the U2 community, who nowadays seem to meet far too infrequently. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] Primos emulator
Well nice to see some old (well not that old!) terms from the days of learning!! The great 300MB beast and what a sound it made during a head crash!!! Had some platters on the wall as clocks! Cheers to you Primos Gurus!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Henderson Sent: Friday, 14 September 2007 8:20 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] [OT] Primos emulator I've still got a 300MB disk pack I use for tours (here is where we were in 1981) that came from a 750. Drew Louie Bergsagel wrote: Nice. I kept my PR1MOS books for 27 years, and tossed them out in March. I was able to login and create a directory. What fun! --- 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/