Re: [U2] [UV] File corruption error, but ON ERROR branch not taken
But Leroy, the program neither aborts nor takes the ON ERROR branch, it takes the ELSE branch and continues. That might be a problem. I guess you see something in the errlog file, but does anything display on the screen? If so, then perhaps that is a problem. The code is a bit tricky and blink errors are tested a bit deep in it, but it should probably be a non-recoverable fatal error that drops to TCL regardless of the clause used. On the other hand, it is coded such that it takes the ELSE clause, probably not being set as fatal. it has also been that way since blink checking was added to UV, and that has been for quite a few years. I am not sure why this behavior is a problem now. Regards, LeRoy F. Dreyfuss Advanced Technical Services - U2 Technology Analyst IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Craig Bennett [EMAIL PROTECTED] auTo Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc stserver.u2ug.org Subject Re: [U2] [UV] File corruption 07/25/2004 08:24 error, but ON ERROR branch not PMtaken Please respond to u2-users I am not sure I would agree that blink errors not taking ON ERROR clauses is a defect. While inconvenient to the user to have a program stop abruptly, the error needs to be dealt with as quickly as possible or the problem will perpetuate. The abort in this case is a deliberate one, i.e. it is intended to occur and not meant to be trapped programmatically. I'll address this internally as well. But Leroy, the program neither aborts nor takes the ON ERROR branch, it takes the ELSE branch and continues. Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic22473.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] AP/Pro Help
Mark, you may know all of the possible new solutions for migrations and upgrades, but this is the wrong forum for your question. This isn't a general MV forum, this is focused on the U2 products from IBM. - There are a lot of AP/D3 people in the Usenet forum comp.databases.pick. You can access Usenet via newsreaders, including Forte Agent, Outlook Express, or via your web browser by going to groups.google.com and other places. - You can also go to the Raining Data web forums at http://forums.rainingdata.com/. As far as your specific issue, no, there are no consumables on the boot floppy. I have no remedy for the specific problem. It's been way too long and I suspect for most other people have forgotten the answers to problems with that 6 year old platform too. If your client absolutely Needs to get that system going again, you can call Raining Data for Support, but it will probably cost about $500 to start - there Are, however, a lot of people there in Irvine who worked for many years with AP/Pro, so your answers Are probably there. Good Luck. Tony Gravagno, Nebula RD Former positions at Pick Systems/Raining Data: QA Manager Corporate Technical Account Manager DBMS Product Manager Mark Johnson wrote: This is the best MV forum so I'll give it a try. I still have 4-5 clients running AP/Pro or Microdata. snip So the question is: Is there some form of consumable on this floppy that would disable it after a number of uses? I don't know what the disc should look like (T-READ or DOS DIR) so I can't tell. Please keep the replies limited to my question and or related to this situation. I know full well all the possible new solutions. Thanks in advance Mark Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Remote Access File on Different Universe Version
Dear All, Facing that lower version of UniVerse ( my case is UniVerse 9.5) on Microsoft Window O/S unable to open the remote access file on Unix OS which having higher version of UniVese ( in my case is UniVerse 10) , but this having no problem in Unix OS. Is there anyway to make recognize the file in NT Server instead of upgrade the version to 10 as well ? Regards DISCLAIMER:- This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Remote Access File on Different Universe Version
What you need is to have UniVerse networking software (UV/Net) on both machines. This is how version differences are resolved. Version 10.x can talk to Version 6.x. There are still some restrictions, for example if one machine has NLS enabled and the other does not, UV/Net will not permit transfers, and there are certain 32-bit/64-bit compatibility issues at the individual file level as well. I suspect you are trying to shortcut UV/Net by using remotely mounted disks. THIS IS DANGEROUS!!! You have UniVerse on both machines so that, when a record is locked in a file that is physically on machine A, then a user on machine B has no visibility of that lock (which is in shared memory on machine A) and so can generate lost updates and other data anomalies. If you're running two versions of UniVerse, make sure that each has the ALLOWNFS configuration parameter set to 0, and use UV/Net (which handles remote locking for you). In this way your data integrity can be assured. - Original Message - From: Ang Suan Yong [EMAIL PROTECTED] Date: Mon, 26 Jul 2004 17:10:53 +0800 To: U2-Users New Lists [EMAIL PROTECTED] Subject: [U2] Remote Access File on Different Universe Version Dear All, Facing that lower version of UniVerse ( my case is UniVerse 9.5) on Microsoft Window O/S unable to open the remote access file on Unix OS which having higher version of UniVese ( in my case is UniVerse 10) , but this having no problem in Unix OS. Is there anyway to make recognize the file in NT Server instead of upgrade the version to 10 as well ? Regards DISCLAIMER:- This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Mvquery Row
Dave, You can't - it is used internally for most of the result processing routines. If it is an issue (generally only in exporting) most of the new exports will allow you to deselect it. Regards, Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: 24 July 2004 02:31 To: U2 USERS Subject: [U2] Mvquery Row Does anyone know how to prevent the column called ROW from getting created when the results are produced ? - Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] merge sort
I want a merge sort for data in BASIC, not lists. For example (] is an @VM) REC1 = A]B]C]D]15 REC2 = A]B]C]D]25 REC3 = A]B]C]D]100 REC4 = A]B]C]D]11 I want to sort by multi-value #5 .. The sorting isn't the issue .. It's when DCOUNT(REC,@AM) gets large that the whole process gets extremely slow .. I can't do something like MATPARSE, because I can't predict *HOW* big REC will get .. Anyway, I have a sneaking suspicion that it's already been done before, so I'm trying to avoid re-inventing the wheel .. -Chuck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rosenberg Ben Sent: Friday, July 23, 2004 6:34 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2] merge sort EXECUTE MERGE.LIST 0 UNION 0 TO 0 will sort and de-dupe the current select list. -Original Message- From: Chuck Mongiovi Does anyone know where I can get code for a generic BASIC Merge SORT routine? -Chuck --- The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] File corruption error, but ON ERROR branch not taken
Exactly! When I implemented the blink checking logic (wow 10 yrs ago!) it was decided that this WAS a FATAL, stopping the current process in its tracks with that nice blink error message so that it could be fixed immediately. Has the logic changed since 9.6 in uv such that a blink is no longer an immediate FATAL? It sounds that way, since there would never have been a chance to take an ELSE or ON ERROR clause. Just curious to know since I added that functionality. Thanks! At 02:13 AM 7/26/2004, you wrote: Sorry, but I have to disagree. File corruption is not something you should ever ignore, not even for a moment. You have no idea what the problem really is, and to let it go is a bad thing that will only get worse. Since UniVerse doesn't have two-phased commits, there is no way to have UV handle ROLLBACK and ABORT TRANSACTION and have a foreign database understand do the same. You must be code it yourself, which it sounds like you are doing. UV will roll back its own transactions but we cannot roll back transactions within foreign databases without the programmer forcibly doing so through coding. Since the ELSE clause is taken anyway (whether or not is moot for your purposes), you can still do your rollbacks and so forth through your code. As I mentioned in my last post (not on this particular thread), it has been this way since blink checking was introduced, and that has been for a number of years. This is really nothing new. Regards, LeRoy F. Dreyfuss Advanced Technical Services - U2 Technology Analyst IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV David Jordan [EMAIL PROTECTED] .au To Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc stserver.u2ug.org Subject RE: [U2] [UV] File corruption 07/25/2004 09:16 error, but ON ERROR branch not PMtaken Please respond to u2-users Hi LeRoy Although an immediate abort is probably ideal to prevent further damage to a situation, the ON ERROR clause enables us to identify to operators and support staff the issue that caused a problem as well as deal with transactions with 3rd party database including roll backs, issues with web services and message queques. I had a scenrio, where an upgrade of UniVerse introduced a bug that caused a fatal termination of UniVerse. Not only was this difficult to debug, but the fatal did not release the UniVerse licenses. Trying to resolve the issue remotely was a nightmare. I eventually tracked down that the UniVerse bug caused a file not to be opened when it should have been. The next step then started a transaction on an unassigned file variable and caused a fatal that terminated the session without going through an on-error clause. I think an unassigned file variable could have gone to the on error clause without causing any other damage. (although the application had been tested on the new release, the bug only occurred after the programs were compiled on the new release) Programmaticaly handling fatals, although not always easy, is highly important for mission critical applications like 24x7 banking. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss Sent: Monday, 26 July 2004 11:53 AM To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] File corruption error, but ON ERROR branch not taken When (if?) we find a solution I'll post the results. IBM have suggested that the initial corruption problem which sent us this way is patched in UV 10.0.17 or later (including 10.1), but they believe that not taking the ON ERROR clause when a blink error is encountered may be a bug. I am not sure I would agree that blink errors not taking ON ERROR clauses is a defect. While inconvenient to the user to have a program stop abruptly, the error needs to be dealt with as quickly as possible or the problem will perpetuate. The abort in this case is a deliberate one, i.e. it is intended to occur and not meant to be trapped programmatically. I'll address this internally as well. Regards, LeRoy F. Dreyfuss Advanced Technical Services - U2 Technology Analyst IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support
[U2] Unirpc problems on UD6 upgrade
We have set up a new Alpha box with Unidata 6.0 and are trying to migrate from an AIX box with Unidata 5.2. Everything looks fine, but when we swap our web application over that uses OLEDB we start getting connection drops at different points in the application. Anyone seen this type of behaviour or got any pointers where I should be looking, Unidata parameters, Kernel settings, etc? Cheers Nick This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] merge sort
Do you need this for a unix platform? This would not qualify as a generic BASIC merge/sort, but you could shell to the unix sort command for this sort of stuff. -Original Message- From: Chuck Mongiovi [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 9:04 AM To: [EMAIL PROTECTED] Subject: RE: [U2] merge sort I want a merge sort for data in BASIC, not lists. For example (] is an @VM) REC1 = A]B]C]D]15 REC2 = A]B]C]D]25 REC3 = A]B]C]D]100 REC4 = A]B]C]D]11 I want to sort by multi-value #5 .. The sorting isn't the issue .. It's when DCOUNT(REC,@AM) gets large that the whole process gets extremely slow .. I can't do something like MATPARSE, because I can't predict *HOW* big REC will get .. Anyway, I have a sneaking suspicion that it's already been done before, so I'm trying to avoid re-inventing the wheel .. -Chuck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rosenberg Ben Sent: Friday, July 23, 2004 6:34 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2] merge sort EXECUTE MERGE.LIST 0 UNION 0 TO 0 will sort and de-dupe the current select list. -Original Message- From: Chuck Mongiovi Does anyone know where I can get code for a generic BASIC Merge SORT routine? -Chuck --- The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] File corruption error, but ON ERROR branch not taken
How does the application program determine it is in the ELSE clause due to an error rather than due to record not found? -- Regards, Clif On Jul 25, 2004, at 23:13, Leroy Dreyfuss wrote: Since the ELSE clause is taken anyway (whether or not is moot for your purposes), you can still do your rollbacks and so forth through your code. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Phone/TAPI Interface, D3/W2K
Telathena ( http://www.telathena.com ) has various ways of connecting u2 PHANTOM jobs to inbound and/or outbound call distribution systems. Some old versions of Telathena also ran on non-u2 Pick systems, but I think that the current versions of Telathena aren't compatible with Pick/d3. For instance, Telathena can drive a predictive dialer that dials out on many lines at once and only connects the few lines that are answered to the pool of operators, while the PHANTOM would automatically record the status of the other calls, and optionally queue those numbers for trying again later. Predictive dialers are designed to connect the human operator's headset in the middle of the o in Hello? if a another human answers the phone, and, simultaneously, the Telathena foreground client pops up the account info (from your u2 database) on the operator's PC. But it's not good to use a predictive dialer on multiple outbound lines with just a single dispatcher, because, too often, you'll get Hello? on 2 lines at once, and annoy one of your customers by just hanging up. Predictive dialers are for call centers with dozens of operators. Telathena can also drive simple local aux-port (or internal serial port) modems or dialers, but you may be able to do that yourself, by just using your terminal emulator's aux-port option. This can shave several seconds off of the time per call, which can be significant when there are lots of busies and no answers, or when the average call length is very short. For more options, see Call Center magazine. ( http://www.callcenter.com ) -Original Message- From: Mark Johnson Perhaps someone can lead me in the right direction. One of my clients, D3/W2K, dispatches 20-24 HVAC vans daily throughout our state with upwards of 100-120 calls per day. The dispatcher calls on nextel to inform the techs of their next appointment and uses a regular phone to call the customer for the upcoming visit. The question is if there's a way to interface this system (home/cell/alt phones in database) to an external phone system that could place an automated call to that customer and return a status code (ok, busy signal, no answer, answering machine) to the dispatcher so she doesn't have to have a phone handset permanently welded to her ear. Thanks in advance. Mark Johnson The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Mvquery Row
It is an issue. When we export the file, we would prefer that column be excluded because sometimes our files must match the file layout specifications. How do you deselect it ? Brian Leach [EMAIL PROTECTED] wrote: Dave, You can't - it is used internally for most of the result processing routines. If it is an issue (generally only in exporting) most of the new exports will allow you to deselect it. Regards, Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: 24 July 2004 02:31 To: U2 USERS Subject: [U2] Mvquery Row Does anyone know how to prevent the column called ROW from getting created when the results are produced ? - Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ - Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: Infocus archives (was RE: [U2] [OT] Has anyone... )
It shouldn't index those summary pages. I'll get the problem fixed asap. Thanks Lee On Mon, 26 Jul 2004, Wendy Smoak wrote: Using the search form provided on the indexinfocus.xom site, if I sort by 'time,' which is how I want to see the results, then every hit on the first five and a half pages is: U2 List Archive: By Date Does it make sense to remove the summary pages from the index so they don't show up on searches? -- Lee J. Leitner, Ph.D. [EMAIL PROTECTED] http://www.leitner.org/~leitnerl The world can only be grasped by action, not by contemplation. The hand is the cutting edge of the mind. -- Jacob Bronowski V.13.0 --- --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] merge sort
That's been my temporary fix: CONVERT @VM TO , IN REC WRITE REC ON F.TMP,TMP.KEY1 EXECUTE ! sort -t, +4nr /tmp/:TMP.KEY1: /tmp/:TMP.KEY2 READ REC FROM F.TMP,TMP.KEY2 ELSE NULL CONVERT , TO @VM IN REC I'm going to try the Shell Sort that's on the PickWicki and see if I can modify it to work .. My question now is: how big can you dimension arrays? .. if DCOUNT(REC,@AM) = 1, will the MatParse work? .. (it did - I tried it) .. It also worked for 100,000 .. But what's my limit and what will that do to my performance and memory usage? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charlie Rubeor Sent: Monday, July 26, 2004 10:46 AM To: [EMAIL PROTECTED] Subject: RE: [U2] merge sort Do you need this for a unix platform? This would not qualify as a generic BASIC merge/sort, but you could shell to the unix sort command for this sort of stuff. -Original Message- From: Chuck Mongiovi [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 9:04 AM To: [EMAIL PROTECTED] Subject: RE: [U2] merge sort I want a merge sort for data in BASIC, not lists. For example (] is an @VM) REC1 = A]B]C]D]15 REC2 = A]B]C]D]25 REC3 = A]B]C]D]100 REC4 = A]B]C]D]11 I want to sort by multi-value #5 .. The sorting isn't the issue .. It's when DCOUNT(REC,@AM) gets large that the whole process gets extremely slow .. I can't do something like MATPARSE, because I can't predict *HOW* big REC will get .. Anyway, I have a sneaking suspicion that it's already been done before, so I'm trying to avoid re-inventing the wheel .. -Chuck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rosenberg Ben Sent: Friday, July 23, 2004 6:34 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2] merge sort EXECUTE MERGE.LIST 0 UNION 0 TO 0 will sort and de-dupe the current select list. -Original Message- From: Chuck Mongiovi Does anyone know where I can get code for a generic BASIC Merge SORT routine? -Chuck --- The information contained in this e-mail message may be privileged and confidential information and is intended only for the use of the individual and/or entity identified in the alias address of this message. If the reader of this message is not the intended recipient, or an employee or agent responsible to deliver it to the intended recipient, you are hereby requested not to distribute or copy this communication. If you have received this communication in error, please notify us immediately by telephone or return e-mail and delete the original message from your system. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] [OT] File corruption error, but ON ERROR branch not taken
I can see where this is going READ rec FROM filevar ON ERROR ... ELSE ON-REALLY-BAD-ERROR ELSE LOCKED-BY-SOMEONE ELSE LOCKED-BY-ROGUE-SYSTEM-PROCESS ELSE NOT-FOUND ELSE -SYSTEM-AFU THEN Do what I programmed OR-THEN Do what I meant to program END (mercifully) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Monday, July 26, 2004 11:05 AM To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] File corruption error, but ON ERROR branch not taken How does the application program determine it is in the ELSE clause due to an error rather than due to record not found? -- Regards, Clif On Jul 25, 2004, at 23:13, Leroy Dreyfuss wrote: Since the ELSE clause is taken anyway (whether or not is moot for your purposes), you can still do your rollbacks and so forth through your code. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: Infocus archives (was RE: [U2] [OT] Has anyone... )
Can you de-select in the search, for example your search criteria might be: indexinfocus -: By --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [UV] merge sort
From memory the maximum number of elements in a dimensioned array is 16384. This is documented in one of the manuals; again from memory I think it's the UniVerse System Description. Any reason you can't sort on an I-descriptor that extracts the fifth value? (Yes, I know you specified BASIC, but there's always EXECUTE.) UniVerse uses a heap-merge sort internally, so you'd be getting close to what you're after. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] merge sort
On Mon, 26 Jul 2004 09:03:38 -0400, you wrote: I want a merge sort for data in BASIC, not lists. For example (] is an @VM) REC1 = A]B]C]D]15 REC2 = A]B]C]D]25 REC3 = A]B]C]D]100 REC4 = A]B]C]D]11 I want to sort by multi-value #5 .. The sorting isn't the issue .. It's when DCOUNT(REC,@AM) gets large that the whole process gets extremely slow .. I can't do something like MATPARSE, because I can't predict *HOW* big REC will get .. Anyway, I have a sneaking suspicion that it's already been done before, so I'm trying to avoid re-inventing the wheel .. snip One option is a temporary work file. If you go that route, make the file static, rather than dynamic and size it appropriately. Write the records, select the file by the key, read each record and delete it as you go along. Or select it, save list, get list, process list, get list, delete file (using list). And if you're sharing the application among users, use the @userno as the leading part of the key. Even if you're not sharing the app, use the @userno, so that when you do share the work file later on you don't have to recode the app... -- Allen Egerton [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata Replication
Any opinions on Unidata replication ? We are using Unidata 6.06 and are looking for honest opinions on the replication feature. - Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] merge sort
Just to avoid the obvious question, you have tried using the LOCATE and INSERT commands? If not this is an easy to use construct. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen Egerton Sent: Monday, July 26, 2004 13:12 To: [EMAIL PROTECTED] Subject: Re: [U2] merge sort On Mon, 26 Jul 2004 09:03:38 -0400, you wrote: I want a merge sort for data in BASIC, not lists. For example (] is an @VM) REC1 = A]B]C]D]15 REC2 = A]B]C]D]25 REC3 = A]B]C]D]100 REC4 = A]B]C]D]11 I want to sort by multi-value #5 .. The sorting isn't the issue .. It's when DCOUNT(REC,@AM) gets large that the whole process gets extremely slow .. I can't do something like MATPARSE, because I can't predict *HOW* big REC will get .. Anyway, I have a sneaking suspicion that it's already been done before, so I'm trying to avoid re-inventing the wheel .. snip One option is a temporary work file. If you go that route, make the file static, rather than dynamic and size it appropriately. Write the records, select the file by the key, read each record and delete it as you go along. Or select it, save list, get list, process list, get list, delete file (using list). And if you're sharing the application among users, use the @userno as the leading part of the key. Even if you're not sharing the app, use the @userno, so that when you do share the work file later on you don't have to recode the app... -- Allen Egerton [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] File corruption error, but ON ERROR branch not taken
Leroy, But Leroy, the program neither aborts nor takes the ON ERROR branch, it takes the ELSE branch and continues. That might be a problem. I guess you see something in the errlog file, but does anything display on the screen? If so, then perhaps that is a problem. The code is a bit tricky and blink errors are tested a bit deep in it, but it should probably be a non-recoverable fatal error that drops to TCL regardless of the clause used. On the other hand, it is coded such that it takes the ELSE clause, probably not being set as fatal. it has also been that way since blink checking was added to UV, and that has been for quite a few years. I am not sure why this behavior is a problem now. The user sees a message, there is an entry in errlog and then it takes the ELSE branch -- as you say, a problem. I have a case open with techsupport in Australia and hope to supply them with more information today. regards, Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Phone/TAPI Interface, D3/W2K
Perhaps consider a headset instead of the old handsets :-) Ross Ferris Stamina Software Visage an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, 25 July 2004 4:05 AM To: [EMAIL PROTECTED] Subject: [U2] Phone/TAPI Interface, D3/W2K snip so she doesn't have to have a phone handset permanently welded to her ear. Thanks in advance. Mark Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] File corruption error, but ON ERROR branch not taken
Since it was said that the ELSE clause is being taken when a blink error occurs, I am still not sure why this cannot be dealt with as before. Recently it was stated that the need for ON ERROR in this situation was to deal with allowing foreign systems to roll back and what not. In the ELSE clause as with ON ERROR, STATUS() is set to indicate the potential problem. If the error is a write error, then the error number returned comes from SYS.MESSAGE. It does sound like in that circumstance, the issue can still be dealt with. However, as Dave Meeks said, it is intended to fall over and alert the user to the problem. I couldn't find where this anything has changed in this area of our code, nor could I reproduce the condition of it taking the ELSE clause. Regards, LeRoy F. Dreyfuss Advanced Technical Services - U2 Technology Analyst IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV David Jordan [EMAIL PROTECTED] .au To Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc stserver.u2ug.org Subject RE: [U2] [UV] File corruption 07/26/2004 04:50 error, but ON ERROR branch not PMtaken Please respond to u2-users The problem here is if the abort does not return through the On Error clause, programmers cannot force roll backs on other applications, cannot report errors to operators and support staff or in anyway gracefully stop the application. One of the main reason for the ON ERROR clause was to deal with fatal issues. If this is not possible in the current structure of Uv is there an alternative. As software developers, our applications are compared to products on Oracle, DB2, etc. Does DB2 just abort an application if it hits a corrupted table, or does it return a message for products like MQ series, two phase commits and other proceses to allow a gracefull close to an exit? I would sugggest that this is something worth reviewing in enhancements as it is becoming a major issue in mission critical applications. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss Sent: Monday, 26 July 2004 4:14 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [U2] [UV] File corruption error, but ON ERROR branch not taken Sorry, but I have to disagree. File corruption is not something you should ever ignore, not even for a moment. You have no idea what the problem really is, and to let it go is a bad thing that will only get worse. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic10949.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] File corruption error, but ON ERROR branch not taken
Perhaps it is a problem, perhaps not. Have you corrected the blink error? If you are finding you have blink issues on a somewhat frequent basis, perhaps the focus is not in the right place? I might be trying to ascertain why my files are becoming damaged and worry about how BASIC deals with it after the corruption is taken care of. That takes the pressure of you and allows you to reproduce the BASIC concern in a controlled environment for support. I am not convinced hiding behind ON ERROR when file corruption is detected is the right thing to do. But, someday putting a toggle in uvconfig might make everyone happy. Perhaps someday. Regards, LeRoy F. Dreyfuss Advanced Technical Services - U2 Technology Analyst IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Craig Bennett [EMAIL PROTECTED] auTo Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc stserver.u2ug.org Subject Re: [U2] [UV] File corruption 07/26/2004 05:05 error, but ON ERROR branch not PMtaken Please respond to u2-users Leroy, But Leroy, the program neither aborts nor takes the ON ERROR branch, it takes the ELSE branch and continues. That might be a problem. I guess you see something in the errlog file, but does anything display on the screen? If so, then perhaps that is a problem. The code is a bit tricky and blink errors are tested a bit deep in it, but it should probably be a non-recoverable fatal error that drops to TCL regardless of the clause used. On the other hand, it is coded such that it takes the ELSE clause, probably not being set as fatal. it has also been that way since blink checking was added to UV, and that has been for quite a few years. I am not sure why this behavior is a problem now. The user sees a message, there is an entry in errlog and then it takes the ELSE branch -- as you say, a problem. I have a case open with techsupport in Australia and hope to supply them with more information today. regards, Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic08619.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] File corruption error, but ON ERROR branch not taken
I couldn't find where this anything has changed in this area of our code, nor could I reproduce the condition of it taking the ELSE clause. Leroy, I have a corrupted file which reports the following on a READ from the corrupted group: File '/path/FILE': Computed blink of 0x74617C20 does not match expected blink of 0x0! Detected within group starting at address 0x172000! Program *cross*TESTCRPT: Line 10, Internal data error. And then takes the ELSE branch. STATUS is 0. No ABORT, no ON ERROR, no way to tell a group is corrupt. I'm just about to send this to Jonathan Evans in IBM Australia. regards, Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] merge sort
I did some speed tests awhile ago and dumping the data to a work file and sorting it there worked a treat even though nix shell was marginally faster. Maintenance was trumps though. S -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chuck Mongiovi Sent: Monday, 26 July 2004 23:04 To: [EMAIL PROTECTED] Subject: RE: [U2] merge sort I want a merge sort for data in BASIC, not lists. For example (] is an @VM) REC1 = A]B]C]D]15 REC2 = A]B]C]D]25 REC3 = A]B]C]D]100 REC4 = A]B]C]D]11 I want to sort by multi-value #5 .. The sorting isn't the issue .. It's when DCOUNT(REC,@AM) gets large that the whole process gets extremely slow .. I can't do something like MATPARSE, because I can't predict *HOW* big REC will get .. Anyway, I have a sneaking suspicion that it's already been done before, so I'm trying to avoid re-inventing the wheel .. -Chuck ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/