Re: [U2] [Universe] [Windows]
How big is the record (file actually) it's trying to read? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
If the program has not changed, then the data has. Can you do an OSREAD? Anything odd about the data or key it is reading? John Israel Sent from my iPhone On May 6, 2014, at 1:05 PM, Wjhonson wjhon...@aol.com wrote: Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/avndygw76QmjhOqemjhO-qerECXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTpBN4QsKcLZvATDQTA-LsKyMUeVZdUQsIfYJteOaqJPhOPOEuvkzaT0QSyrhdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CSjhOesdCBI9FCBQQg6y0QJxe4zfNFVFtd41Fr0mk4aCa6BQSCUrPUvS ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Each record is only maybe 200 bytes or that sort. The entire directory has about 200 of these records in it -Original Message- From: Dave Davis dda...@harriscomputer.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 10:08 am Subject: Re: [U2] [Universe] [Windows] How big is the record (file actually) it's trying to read? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
File permissions? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Maybe one of these files is actually a sub-folder in this directory? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** This email and any files transmitted with it are confidential and may be subject to copyright. They are intended solely for the use of the individual or entity to which they are addressed. If you have received this message in error please notify AFS immediately by return email. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of AFS, except where an authorized sender specifically states them to be the views of AFS. It is your responsibility to verify this email and any attachments for the presence of viruses. AFS accepts no liability for any damage caused by any virus transmitted. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
OSREAD isn't a command in Universe BASIC -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 10:09 am Subject: Re: [U2] [Universe] [Windows] If the program has not changed, then the data has. Can you do an OSREAD? Anything odd about the data or key it is reading? John Israel Sent from my iPhone On May 6, 2014, at 1:05 PM, Wjhonson wjhon...@aol.com wrote: Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/avndygw76QmjhOqemjhO-qerECXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTpBN4QsKcLZvATDQTA-LsKyMUeVZdUQsIfYJteOaqJPhOPOEuvkzaT0QSyrhdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CSjhOesdCBI9FCBQQg6y0QJxe4zfNFVFtd41Fr0mk4aCa6BQSCUrPUvS ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Check your directories, specifically any TMP/TEMP directories, for a maximum number of entries. HD Root directories, savedlists, ph, anything that would have temporary files created in them. This caught me once before and it took forever to stumble on the idea that windows does seem to have a maximum number of files condition. If you can delete a handful of temp files in a directory and the read starts to work, that's the one you need to be looking at. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 10:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Is it a particular record that errors out or can you not read any of them? On 05/06/2014 12:04 PM, Wjhonson wrote: Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Can you open the .csv file (the Windows File item within the Windows Directory) with a text editor? Does it look like text? Is there a sub-directory within this directory? Are the permissions of this .csv file the same as the rest of the items within the directory? You're not getting that stupid desktop.ini item within the directory, are you? Just a few thoughts. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 5/6/2014 10:04 AM *Subject:* [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Yes, Yes, No, Yes, No :) Here's an update. IF I open one of these in notepad, and just add an extra char to the end and then file it, the last modified date now appears for that file, but none of the other ones of course. And doing that, makes it so, in TCL, I can now EDit that particular record, but none of the other records, which still cause the fatal abort. So that's odd. But at least, I can go through and edit every single bleeping entry in the directory, file it, and make it editable again in Universe. WHY this has occurred, and WHETHER it's going to continue with new entries, is still an open question -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 11:30 am Subject: Re: [U2] [Universe] [Windows] Can you open the .csv file (the Windows File item within the Windows Directory) with a text editor? Does it look like text? Is there a sub-directory within this directory? Are the permissions of this .csv file the same as the rest of the items within the directory? You're not getting that stupid desktop.ini item within the directory, are you? Just a few thoughts. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 5/6/2014 10:04 AM *Subject:* [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Are you using open or openseq for the xls files? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 6, 2014 12:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Can't read any of them. But see my latest update message just now sent. -Original Message- From: dale kelley dalekel...@dalewkelleyinc.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 11:06 am Subject: Re: [U2] [Universe] [Windows] Is it a particular record that errors out or can you not read any of them? On 05/06/2014 12:04 PM, Wjhonson wrote: Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
csv files, not xls The OPEN works, the READNEXT works, the READ is where it fails A SELECT by the way, returns the correct number of entries, it just won't EDIT any of them. -Original Message- From: Holt, Jake jh...@samsill.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:09 pm Subject: Re: [U2] [Universe] [Windows] Are you using open or openseq for the xls files? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 6, 2014 12:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Maybe already asked, but can you pull in up in the AE editor? If so, go to up-arrow mode and see if there are any funky characters. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 4:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] csv files, not xls The OPEN works, the READNEXT works, the READ is where it fails A SELECT by the way, returns the correct number of entries, it just won't EDIT any of them. -Original Message- From: Holt, Jake jh...@samsill.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:09 pm Subject: Re: [U2] [Universe] [Windows] Are you using open or openseq for the xls files? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 6, 2014 12:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPoAd20AcCQmjhOqembzHIL6XCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTV15wQsKcLZvAkNNEVjhWZOWqbbT9IcffLsJt6OaaGdQ-l3PWApmU6CQjr9KVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04S-Dssr1vF6y0QJxdcQKCy0QJxe4zfNFVFtd41Fr0mk4aCa6BQSCqejpof10R1o ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNESyOqejhONsttBUTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zAS8R9MBie-u2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbC_88I6zBNB_HYyCed7aqfnKnjhpuVdxxVZXBHEShhlhKDOEuvkzaT0QSCrpdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CTQXzzobZ8Qg6BI9FCBQQg6BI9MAp-dfdbFEwdbo2OwxkNgQKCQPhOrsIYT ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr3wUe6jqb9EVd7b5NRSnztPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejozkD2l8XVUagQJeIadHv6loYKrgQJeIadHv6loYKrYwyMqen6n-LOaoUQsFEZuVtd5BXAS67DTKmKzp55l6WvaxVZicHs3jr9JATsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rvjKedwLQzh0qmMCCqnjh0qmMD2hDUQYQKCy0QJwba25j53iWrjd79LASUMhny ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Cannot edit it in AE either -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:13 pm Subject: Re: [U2] [Universe] [Windows] Maybe already asked, but can you pull in up in the AE editor? If so, go to up-arrow mode and see if there are any funky characters. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 4:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] csv files, not xls The OPEN works, the READNEXT works, the READ is where it fails A SELECT by the way, returns the correct number of entries, it just won't EDIT any of them. -Original Message- From: Holt, Jake jh...@samsill.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:09 pm Subject: Re: [U2] [Universe] [Windows] Are you using open or openseq for the xls files? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 6, 2014 12:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPoAd20AcCQmjhOqembzHIL6XCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTV15wQsKcLZvAkNNEVjhWZOWqbbT9IcffLsJt6OaaGdQ-l3PWApmU6CQjr9KVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04S-Dssr1vF6y0QJxdcQKCy0QJxe4zfNFVFtd41Fr0mk4aCa6BQSCqejpof10R1o ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNESyOqejhONsttBUTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zAS8R9MBie-u2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbC_88I6zBNB_HYyCed7aqfnKnjhpuVdxxVZXBHEShhlhKDOEuvkzaT0QSCrpdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CTQXzzobZ8Qg6BI9FCBQQg6BI9MAp-dfdbFEwdbo2OwxkNgQKCQPhOrsIYT ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr3wUe6jqb9EVd7b5NRSnztPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejozkD2l8XVUagQJeIadHv6loYKrgQJeIadHv6loYKrYwyMqen6n-LOaoUQsFEZuVtd5BXAS67DTKmKzp55l6WvaxVZicHs3jr9JATsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rvjKedwLQzh0qmMCCqnjh0qmMD2hDUQYQKCy0QJwba25j53iWrjd79LASUMhny ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
If it's not confidential, send it to me as an attachment: johnisr...@daytonsuperior.com JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 4:16 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] Cannot edit it in AE either -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:13 pm Subject: Re: [U2] [Universe] [Windows] Maybe already asked, but can you pull in up in the AE editor? If so, go to up-arrow mode and see if there are any funky characters. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 4:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] csv files, not xls The OPEN works, the READNEXT works, the READ is where it fails A SELECT by the way, returns the correct number of entries, it just won't EDIT any of them. -Original Message- From: Holt, Jake jh...@samsill.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:09 pm Subject: Re: [U2] [Universe] [Windows] Are you using open or openseq for the xls files? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 6, 2014 12:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPoAd20AcCQmjhOqembzHIL6XCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTV15wQsKcLZvAkNNEVjhWZOWqbbT9IcffLsJt6OaaGdQ-l3PWApmU6CQjr9KVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04S-Dssr1vF6y0QJxdcQKCy0QJxe4zfNFVFtd41Fr0mk4aCa6BQSCqejpof10R1o ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNESyOqejhONsttBUTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zAS8R9MBie-u2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbC_88I6zBNB_HYyCed7aqfnKnjhpuVdxxVZXBHEShhlhKDOEuvkzaT0QSCrpdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CTQXzzobZ8Qg6BI9FCBQQg6BI9MAp-dfdbFEwdbo2OwxkNgQKCQPhOrsIYT ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr3wUe6jqb9EVd7b5NRSnztPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejozkD2l8XVUagQJeIadHv6loYKrgQJeIadHv6loYKrYwyMqen6n-LOaoUQsFEZuVtd5BXAS67DTKmKzp55l6WvaxVZicHs3jr9JATsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rvjKedwLQzh0qmMCCqnjh0qmMD2hDUQYQKCy0QJwba25j53iWrjd79LASUMhny ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr43qb9EVd7b5NPbMUTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zAS8R9MBie-u2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbCZhpod7bzb_nV5-UWXDnKnjphvVcQsEFKfsJt6OaaJXEYG7DR8OJMddECTPtPtPo0c-l9Q-9DUYSCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09IsyMOr1vF6y0QJxdcQKCy0QJxe4zfNFVFtd41Fr0mk4aCa6BQSCqejqkL28Jqd ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCN8edEICzAQsIn7cL3ztPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejozkD2l8XVUagQJeIadHv6loYKrgQJeIadHv6loYKrR5BwQsKcLZvAnXzHKtuVtdB5_APhOyCUZORQr8EGTKzOEuvkzaT0QSCrvdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CNOb39I5-Aq83iS4QPiWq83iS4Uic_6DCBQQg6BI1pggGoEqnjqpEVdCH6EdAd2Vf6k ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Can you: SELECT filename WITH @ID = offending_key If not, then it might be control chars or corruption in the key. I've seen it before where the READNEXT can grab what it 'thinks' is the key but if it contains some funky char, when you try to READ using that key, the READ fails. Another test: SELECT filename ED filename If you can ED or AE all of them when stacked but can't when you specify the key, it might be garbage in the key that's difficult to see. You can sometimes READNEXT id then CRT OCONV( id, \MXOC\) to see the key in hex and that might lead you to the issue. Also if keys are written containing @AM, it will create multiple entries in the select stack where each part of the key becomes it's own element in the select stack. When you look at the list, it seems right but when processing in basic, it's not quite right. -BD On 5/6/2014 2:16 PM, Wjhonson wrote: Cannot edit it in AE either -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:13 pm Subject: Re: [U2] [Universe] [Windows] Maybe already asked, but can you pull in up in the AE editor? If so, go to up-arrow mode and see if there are any funky characters. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 4:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] csv files, not xls The OPEN works, the READNEXT works, the READ is where it fails A SELECT by the way, returns the correct number of entries, it just won't EDIT any of them. -Original Message- From: Holt, Jake jh...@samsill.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:09 pm Subject: Re: [U2] [Universe] [Windows] Are you using open or openseq for the xls files? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 6, 2014 12:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPoAd20AcCQmjhOqembzHIL6XCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTV15wQsKcLZvAkNNEVjhWZOWqbbT9IcffLsJt6OaaGdQ-l3PWApmU6CQjr9KVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04S-Dssr1vF6y0QJxdcQKCy0QJxe4zfNFVFtd41Fr0mk4aCa6BQSCqejpof10R1o ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNESyOqejhONsttBUTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zAS8R9MBie-u2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbC_88I6zBNB_HYyCed7aqfnKnjhpuVdxxVZXBHEShhlhKDOEuvkzaT0QSCrpdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CTQXzzobZ8Qg6BI9FCBQQg6BI9MAp-dfdbFEwdbo2OwxkNgQKCQPhOrsIYT ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr3wUe6jqb9EVd7b5NRSnztPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejozkD2l8XVUagQJeIadHv6loYKrgQJeIadHv6loYKrYwyMqen6n-LOaoUQsFEZuVtd5BXAS67DTKmKzp55l6WvaxVZicHs3jr9JATsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rvjKedwLQzh0qmMCCqnjh0qmMD2hDUQYQKCy0QJwba25j53iWrjd79LASUMhny ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Bruce you cannot ED any of it when stacked. So the SELECT finds all 115 records. Great. Then when you try to ED off that select, it immediately bombs with a fatal error. Even if I delete the first key in the select or the first twelve keys, it doesn't help. Each record fails. In fact, the error first occurred when a user was trying to read a record deep down the list. I just didn't realize right away, that every record has the same symptom To me it seems to be something wrong in the Windows setup of the entries, not in Universe. Something in Windows has screwed up the header data of the file perhaps which would explain why the Last Modified Date column is completely blank. -Original Message- From: Bruce Decker bdec...@bluepinc.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:37 pm Subject: Re: [U2] [Universe] [Windows] Can you: SELECT filename WITH @ID = offending_key If not, then it might be control chars or corruption in the key. I've seen it before where the READNEXT can grab what it 'thinks' is the key but if it contains some funky char, when you try to READ using that key, the READ fails. Another test: SELECT filename ED filename If you can ED or AE all of them when stacked but can't when you specify the key, it might be garbage in the key that's difficult to see. You can sometimes READNEXT id then CRT OCONV( id, \MXOC\) to see the key in hex and that might lead you to the issue. Also if keys are written containing @AM, it will create multiple entries in the select stack where each part of the key becomes it's own element in the select stack. When you look at the list, it seems right but when processing in basic, it's not quite right. -BD On 5/6/2014 2:16 PM, Wjhonson wrote: Cannot edit it in AE either -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:13 pm Subject: Re: [U2] [Universe] [Windows] Maybe already asked, but can you pull in up in the AE editor? If so, go to up-arrow mode and see if there are any funky characters. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 4:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] csv files, not xls The OPEN works, the READNEXT works, the READ is where it fails A SELECT by the way, returns the correct number of entries, it just won't EDIT any of them. -Original Message- From: Holt, Jake jh...@samsill.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 1:09 pm Subject: Re: [U2] [Universe] [Windows] Are you using open or openseq for the xls files? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 6, 2014 12:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPoAd20AcCQmjhOqembzHIL6XCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTV15wQsKcLZvAkNNEVjhWZOWqbbT9IcffLsJt6OaaGdQ-l3PWApmU6CQjr9KVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04S-Dssr1vF6y0QJxdcQKCy0QJxe4zfNFVFtd41Fr0mk4aCa6BQSCqejpof10R1o ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNESyOqejhONsttBUTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zAS8R9MBie-u2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbC_88I6zBNB_HYyCed7aqfnKnjhpuVdxxVZXBHEShhlhKDOEuvkzaT0QSCrpdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CTQXzzobZ8Qg6BI9FCBQQg6BI9MAp-dfdbFEwdbo2OwxkNgQKCQPhOrsIYT ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr3wUe6jqb9EVd7b5NRSnztPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejozkD2l8XVUagQJeIadHv6loYKrgQJeIadHv6loYKrYwyMqen6n-LOaoUQsFEZuVtd5BXAS67DTKmKzp55l6WvaxVZicHs3jr9JATsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q
Re: [U2] [Universe] [Windows]
This sounds like it's back to permissions. If it was UNIX, then I'd say the owner/user for the records(files) was deleted from the system and then editing them assigns a new, valid, owner. You said you're on windows, though. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] Yes, Yes, No, Yes, No :) Here's an update. IF I open one of these in notepad, and just add an extra char to the end and then file it, the last modified date now appears for that file, but none of the other ones of course. And doing that, makes it so, in TCL, I can now EDit that particular record, but none of the other records, which still cause the fatal abort. So that's odd. But at least, I can go through and edit every single bleeping entry in the directory, file it, and make it editable again in Universe. WHY this has occurred, and WHETHER it's going to continue with new entries, is still an open question -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 11:30 am Subject: Re: [U2] [Universe] [Windows] Can you open the .csv file (the Windows File item within the Windows Directory) with a text editor? Does it look like text? Is there a sub-directory within this directory? Are the permissions of this .csv file the same as the rest of the items within the directory? You're not getting that stupid desktop.ini item within the directory, are you? Just a few thoughts. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 5/6/2014 10:04 AM *Subject:* [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
I goog'd 40070 and references I found said its a windows registry error. That kind of baffles me,... unless the NSA is administering windows registry now. On 05/06/2014 12:04 PM, Wjhonson wrote: Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
I'd have to agree that it is likely going to be permissions. While I do not have UV on Windows on AIX if I create a record in a type 1 file and then change the ownership to something that I cannot read I get the following: ED PCTMP EDTEST Program ED: pc = 6952, Fatal error has occured. [~] $ CT PCTMP EDTEST Program COPYP: pc = 1A46, Fatal error has occured. [~] $ Perhaps the error you're getting is a windows equivalent of the above or something? The permissions on my file during this test were: [PCTMP] $ ls -l EDTEST -rw---1 root other 56 May 07 08:03 EDTEST [PCTMP] $ So I'd be looking at the permissions of the parent folder as well as its contents. HTH Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au From: u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org on behalf of Woodward, Bob bob_woodw...@k2sports.com Sent: Wednesday, 7 May 2014 6:53 To: U2 Users List Subject: Re: [U2] [Universe] [Windows] This sounds like it's back to permissions. If it was UNIX, then I'd say the owner/user for the records(files) was deleted from the system and then editing them assigns a new, valid, owner. You said you're on windows, though. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] Yes, Yes, No, Yes, No :) Here's an update. IF I open one of these in notepad, and just add an extra char to the end and then file it, the last modified date now appears for that file, but none of the other ones of course. And doing that, makes it so, in TCL, I can now EDit that particular record, but none of the other records, which still cause the fatal abort. So that's odd. But at least, I can go through and edit every single bleeping entry in the directory, file it, and make it editable again in Universe. WHY this has occurred, and WHETHER it's going to continue with new entries, is still an open question -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 11:30 am Subject: Re: [U2] [Universe] [Windows] Can you open the .csv file (the Windows File item within the Windows Directory) with a text editor? Does it look like text? Is there a sub-directory within this directory? Are the permissions of this .csv file the same as the rest of the items within the directory? You're not getting that stupid desktop.ini item within the directory, are you? Just a few thoughts. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 5/6/2014 10:04 AM *Subject:* [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus
Re: [U2] [Universe] [Windows]
Thanks excellent. I think you might be correct here. -Original Message- From: Peter Cheney peter.che...@firstmac.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 3:13 pm Subject: Re: [U2] [Universe] [Windows] I'd have to agree that it is likely going to be permissions. While I do not have UV on Windows on AIX if I create a record in a type 1 file and then change the ownership to something that I cannot read I get the following: ED PCTMP EDTEST Program ED: pc = 6952, Fatal error has occured. [~] $ CT PCTMP EDTEST Program COPYP: pc = 1A46, Fatal error has occured. [~] $ Perhaps the error you're getting is a windows equivalent of the above or something? The permissions on my file during this test were: [PCTMP] $ ls -l EDTEST -rw---1 root other 56 May 07 08:03 EDTEST [PCTMP] $ So I'd be looking at the permissions of the parent folder as well as its contents. HTH Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au From: u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org on behalf of Woodward, Bob bob_woodw...@k2sports.com Sent: Wednesday, 7 May 2014 6:53 To: U2 Users List Subject: Re: [U2] [Universe] [Windows] This sounds like it's back to permissions. If it was UNIX, then I'd say the owner/user for the records(files) was deleted from the system and then editing them assigns a new, valid, owner. You said you're on windows, though. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] Yes, Yes, No, Yes, No :) Here's an update. IF I open one of these in notepad, and just add an extra char to the end and then file it, the last modified date now appears for that file, but none of the other ones of course. And doing that, makes it so, in TCL, I can now EDit that particular record, but none of the other records, which still cause the fatal abort. So that's odd. But at least, I can go through and edit every single bleeping entry in the directory, file it, and make it editable again in Universe. WHY this has occurred, and WHETHER it's going to continue with new entries, is still an open question -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 11:30 am Subject: Re: [U2] [Universe] [Windows] Can you open the .csv file (the Windows File item within the Windows Directory) with a text editor? Does it look like text? Is there a sub-directory within this directory? Are the permissions of this .csv file the same as the rest of the items within the directory? You're not getting that stupid desktop.ini item within the directory, are you? Just a few thoughts. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 5/6/2014 10:04 AM *Subject:* [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient
Re: [U2] UniVerse Dictionary question
And nowadays we are lucky to have additional choices, like UniVerse allowing you to key a space in and after pressing ENTER it gets removed and we have the same thing. I like this technique better sometimes because in some versions of PICK/BASIC, control characters show up as a '.' in the Editor. You look at it, and without typing some more commands, you cannot differentiate between a control character and an actual period. But it's good to know multiple techniques in case we have to work on multiple systems. Robert Norman ROBERT NORMAN AND ASSOCIATES 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 (323) 285-7272, (951) 541-1668 i...@keyway.net http://universe-basic-programming.webstarts.com/index.html http://users.keyway.net/~ice/ http://www.affordablemultivalueprogramming.i8.com/ Computer programming software development in Universe BASIC for Rocket Universe, in PICK/BASIC for Rocket D3, in UNIBASIC for Rocket Unidata, in R/BASIC (REVELATION BASIC) for REVELATION TECHOLOGIES REVELATION, in JBASIC (JBC or JBASE BASIC) for TEMENOS JBASE, in DATA/BASIC for Northgate REALITY, in MV BASIC (Multivalue Basic) for Intersystems Cache Multivalue, and QMBASIC for Ladybridge OPENQM (QM). On 2/5/2014 4:07 PM, Martin Scholl wrote: The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
I got this from him a number of years ago: And thank you for the appreciation of AE! I really worked on that program, determined to get the best of the Pick and Prime Information editors together in one place, plus some innovations of my own, such as the EditValues (EV) command. UniData was just getting started and I wrote the program without pay, on speculation, asking for generous payment if UniData succeeded. They succeeded and honored the agreement. David Brunel proved himself to be a man of unusually high integrity. Leif Smith I was the author of AE back when (started when UniData was Ming Yue, David Brunel, and 5 chinese programmers in a basement in a home in Aurora, Colorado. I'm out of the MV programming business now and expected that AE would have long ago been completely supplanted by more powerful products. By the way, I never was a UniData employee, just a free-lance programmer playing a wild card. The whole deal was a handshake and a few notes on scraps of paper. -Original Message- From: McGowan, Ian Sent: Wednesday, February 05, 2014 6:26 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question http://www.linkedin.com/in/leifsmith - an interesting guy. Not sure if anyone remembers the old comp.databases.pick days, but Leif reminds me of Henry Eggers - I only understood 10% of what he said, but it was always interesting. -Original Message- From: Kevin King Sent: Wednesday, February 05, 2014 5:02 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question AE is the brainchild of one Leif Smith as I recall. Haven't seen him in years, but he used to stomp around here in Denver. On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian wrote: It's well worth spending some time reading the AE help pages. One of my favorites is help + which ends with the gem We could go on and on about this, but you probably get it. I'm a huge fan of AE, even though I spend most of my programming time inside a visual editor (I like joe [ http://joe-editor.sourceforge.net/], not to start a religious debate). I don't use AE prestores with the wild abandon of my misspent youth, but they're still a handy thing to know. If anyone knows the author of AE, let me know - I owe him or her several drinks... [snip] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
That's brilliant! Colin, would you mind if I steal that for www.pickwiki.com? Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Friday, February 07, 2014 2:14 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question I got this from him a number of years ago: And thank you for the appreciation of AE! I really worked on that program, determined to get the best of the Pick and Prime Information editors together in one place, plus some innovations of my own, such as the EditValues (EV) command. UniData was just getting started and I wrote the program without pay, on speculation, asking for generous payment if UniData succeeded. They succeeded and honored the agreement. David Brunel proved himself to be a man of unusually high integrity. Leif Smith I was the author of AE back when (started when UniData was Ming Yue, David Brunel, and 5 chinese programmers in a basement in a home in Aurora, Colorado. I'm out of the MV programming business now and expected that AE would have long ago been completely supplanted by more powerful products. By the way, I never was a UniData employee, just a free-lance programmer playing a wild card. The whole deal was a handshake and a few notes on scraps of paper. -Original Message- From: McGowan, Ian Sent: Wednesday, February 05, 2014 6:26 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question http://www.linkedin.com/in/leifsmith - an interesting guy. Not sure if anyone remembers the old comp.databases.pick days, but Leif reminds me of Henry Eggers - I only understood 10% of what he said, but it was always interesting. -Original Message- From: Kevin King Sent: Wednesday, February 05, 2014 5:02 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question AE is the brainchild of one Leif Smith as I recall. Haven't seen him in years, but he used to stomp around here in Denver. On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian wrote: It's well worth spending some time reading the AE help pages. One of my favorites is help + which ends with the gem We could go on and on about this, but you probably get it. I'm a huge fan of AE, even though I spend most of my programming time inside a visual editor (I like joe [ http://joe-editor.sourceforge.net/], not to start a religious debate). I don't use AE prestores with the wild abandon of my misspent youth, but they're still a handy thing to know. If anyone knows the author of AE, let me know - I owe him or her several drinks... [snip] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
I don't - but of course, I didn't actually write it :) Colin From: James.McGowan To: u2-users@listserver.u2ug.org Date: Fri, 7 Feb 2014 16:57:35 -0800 Subject: Re: [U2] UniVerse Dictionary question That's brilliant! Colin, would you mind if I steal that for www.pickwiki.com? Ian -Original Message- From: Colin Alfke Sent: Friday, February 07, 2014 2:14 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question I got this from him a number of years ago: And thank you for the appreciation of AE! I really worked on that program, determined to get the best of the Pick and Prime Information editors together in one place, plus some innovations of my own, such as the EditValues (EV) command. UniData was just getting started and I wrote the program without pay, on speculation, asking for generous payment if UniData succeeded. They succeeded and honored the agreement. David Brunel proved himself to be a man of unusually high integrity. Leif Smith I was the author of AE back when (started when UniData was Ming Yue, David Brunel, and 5 chinese programmers in a basement in a home in Aurora, Colorado. I'm out of the MV programming business now and expected that AE would have long ago been completely supplanted by more powerful products. By the way, I never was a UniData employee, just a free-lance programmer playing a wild card. The whole deal was a handshake and a few notes on scraps of paper. -Original Message- From: McGowan, Ian Sent: Wednesday, February 05, 2014 6:26 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question http://www.linkedin.com/in/leifsmith - an interesting guy. Not sure if anyone remembers the old comp.databases.pick days, but Leif reminds me of Henry Eggers - I only understood 10% of what he said, but it was always interesting. -Original Message- From: Kevin King Sent: Wednesday, February 05, 2014 5:02 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question AE is the brainchild of one Leif Smith as I recall. Haven't seen him in years, but he used to stomp around here in Denver. On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian wrote: It's well worth spending some time reading the AE help pages. One of my favorites is help + which ends with the gem We could go on and on about this, but you probably get it. I'm a huge fan of AE, even though I spend most of my programming time inside a visual editor (I like joe [ http://joe-editor.sourceforge.net/], not to start a religious debate). I don't use AE prestores with the wild abandon of my misspent youth, but they're still a handy thing to know. If anyone knows the author of AE, let me know - I owe him or her several drinks... [snip] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
Hi, I use a single space which is nulled out by the editor. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Wednesday, February 05, 2014 7:31 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question Well, I'll be a son of a biscuit eater! I never knew that. I've done it the same way Martin does for 35 years. I just checked it in Jbase and it works. You learn something new every day. Of course, I consider a day a total waste if I don't either learn something new or catch hell about something. As you can guess, I don't have many wasted days. Thanks, Dan! Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 02-05-2014 6:15 PM, Daniel McGrath wrote: A tip my original mentor taught me on the first day was that in ED/AE, the back tick (`) gets treated as an empty line so you can keep going in insert mode and not need to worry about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Wednesday, February 05, 2014 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page -- -- - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
That's not true for me, at least in Unidata - it inserts a literal space. Either there's a system option that controls it, or your application doesn't care about spaces in the data ;-) Try a CA/ /* after entering some spaces and see what you see? BOTW_DEV2ae trin.temp test Top of New TEST in TRIN.TEMP. *--: i 001= 1 002= 2 003= 3 004= 005= 5 006= 6 *--: p Top. 001: 1 002: 2 003: 3 004: 005: 5 006: 6 Bottom. *--: ca/ /* Changed all occurrences (1) of to * in record. *--: p Top. 001: 1 002: 2 003: 3 004: * 005: 5 006: 6 Bottom. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Thursday, February 06, 2014 5:10 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question Hi, I use a single space which is nulled out by the editor. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Wednesday, February 05, 2014 7:31 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question Well, I'll be a son of a biscuit eater! I never knew that. I've done it the same way Martin does for 35 years. I just checked it in Jbase and it works. You learn something new every day. Of course, I consider a day a total waste if I don't either learn something new or catch hell about something. As you can guess, I don't have many wasted days. Thanks, Dan! Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 02-05-2014 6:15 PM, Daniel McGrath wrote: A tip my original mentor taught me on the first day was that in ED/AE, the back tick (`) gets treated as an empty line so you can keep going in insert mode and not need to worry about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Wednesday, February 05, 2014 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page -- -- - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
A tip my original mentor taught me on the first day was that in ED/AE, the back tick (`) gets treated as an empty line so you can keep going in insert mode and not need to worry about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Wednesday, February 05, 2014 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
Well, I'll be a son of a biscuit eater! I never knew that. I've done it the same way Martin does for 35 years. I just checked it in Jbase and it works. You learn something new every day. Of course, I consider a day a total waste if I don't either learn something new or catch hell about something. As you can guess, I don't have many wasted days. Thanks, Dan! Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 02-05-2014 6:15 PM, Daniel McGrath wrote: A tip my original mentor taught me on the first day was that in ED/AE, the back tick (`) gets treated as an empty line so you can keep going in insert mode and not need to worry about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Wednesday, February 05, 2014 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
Unreal. This old dog just learnt a new trick. On Wed, Feb 5, 2014 at 5:15 PM, Daniel McGrath dmcgr...@rocketsoftware.comwrote: A tip my original mentor taught me on the first day was that in ED/AE, the back tick (`) gets treated as an empty line so you can keep going in insert mode and not need to worry about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Wednesday, February 05, 2014 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
It's well worth spending some time reading the AE help pages. One of my
favorites is help + which ends with the gem We could go on and on about
this, but you probably get it. I'm a huge fan of AE, even though I spend most
of my programming time inside a visual editor (I like joe
[http://joe-editor.sourceforge.net/], not to start a religious debate). I
don't use AE prestores with the wild abandon of my misspent youth, but they're
still a handy thing to know. If anyone knows the author of AE, let me know - I
owe him or her several drinks...
The backtick is just the default 'command delimiter'. You can read more about
it with:
*--: help delimiter
Command: CDelimiter (CD)
'CD' allows you to change the command delimiter to any single character.
When you enter the editor for the first time the command delimiter is
set to the ` (weirdmark, not single quote) character.
Examples:
*--: CD [displays the current command delimiter; no change]
Command delimiter is `
*--: CD# [changes the command delimiter to '#']
Command delimiter is now #
The Command Delimiter is a single character that separates multiple
editor commands when they are entered at a single editor prompt.
Valid command delimiters are:
` , ; # $ % ~ | [ ] { } / '
and then onto prestores
Example:
*--: G10`G20`G30 [go to line 10, then to 20, then to 30]
A rather pointless command, but it illustrates the principle.
Multipart commands are very useful as prestored commands. They allow
processing many records with a single command. For example, suppose
you had a select list of 100 records, and each of them needs every
occurrence of '100' changed to '250'. You can do this with a multipart
prestored command.
First create the prestored command:
=DOITALL CU/100/250`FI`=DOITALL
Then run the command '=DOITALL' by entering '=DOITALL' as a command.
The editor will then loop through the list of records, perform the
change for each of them, file each of them, and then run =DOITALL again
on the next record.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Wednesday, February 05, 2014 4:33 PM
To: U2 Users List
Subject: Re: [U2] UniVerse Dictionary question
Unreal. This old dog just learnt a new trick.
On Wed, Feb 5, 2014 at 5:15 PM, Daniel McGrath
dmcgr...@rocketsoftware.comwrote:
A tip my original mentor taught me on the first day was that in ED/AE,
the back tick (`) gets treated as an empty line so you can keep going
in insert mode and not need to worry about it.
Regards,
Dan
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:
u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl
Sent: Wednesday, February 05, 2014 5:07 PM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse Dictionary question
The dots were just there to keep the numbered list going, The same I
use dots in the Editor to enter blank lines. Later I go to the top and
do
R/.//50 to remove the dot.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, February 04, 2014 3:04 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse Dictionary question
What are the periods in 3 and 4 for?
Did you try removing those?
-Original Message-
From: Woodward, Bob bob_woodw...@k2sports.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Feb 4, 2014 11:49 am
Subject: Re: [U2] UniVerse Dictionary question
Just to make sure, you're wanting FIELD 178 and the first value of
that field. Correct? Because you have a length of 1, left justified
I want to make sure you're not looking for the first character of the 178th
field.
Maybe if you showed what you're wanting and what you're getting,
instead, then we'd be sure to give you an answer that makes sense.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill
Haskett
Sent: Tuesday, February 04, 2014 11:45 AM
To: U2 Users List
Subject: Re: [U2] UniVerse Dictionary queston
Martin:
This is the only way to do accomplish the defined task in UniData.
Maybe @RECORD178,1 is the preferred method in UV.
Bill
Untitled Page
--
--
- Original Message -
*From:* msch...@martinscholl.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 2/4/2014 11:33 AM
*Subject:* [U2] UniVerse Dictionary queston
UniVerse.
I want to create a dictionary item that extract value 178,1
I thought
1. I
2. EXTRACT(@RECORD,178,1,0)
3. .
4. .
5. 1L
6. S
Would do but it does not give me the desired result. Any suggestions?
___
U2-Users mailing list
U2-Users
Re: [U2] UniVerse Dictionary question
AE is the brainchild of one Leif Smith as I recall. Haven't seen him in
years, but he used to stomp around here in Denver.
On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian
james.mcgo...@bankofthewest.com wrote:
It's well worth spending some time reading the AE help pages. One of my
favorites is help + which ends with the gem We could go on and on about
this, but you probably get it. I'm a huge fan of AE, even though I spend
most of my programming time inside a visual editor (I like joe [
http://joe-editor.sourceforge.net/], not to start a religious debate). I
don't use AE prestores with the wild abandon of my misspent youth, but
they're still a handy thing to know. If anyone knows the author of AE, let
me know - I owe him or her several drinks...
The backtick is just the default 'command delimiter'. You can read more
about it with:
*--: help delimiter
Command: CDelimiter (CD)
'CD' allows you to change the command delimiter to any single character.
When you enter the editor for the first time the command delimiter is
set to the ` (weirdmark, not single quote) character.
Examples:
*--: CD [displays the current command delimiter; no change]
Command delimiter is `
*--: CD# [changes the command delimiter to '#']
Command delimiter is now #
The Command Delimiter is a single character that separates multiple
editor commands when they are entered at a single editor prompt.
Valid command delimiters are:
` , ; # $ % ~ | [ ] { } / '
and then onto prestores
Example:
*--: G10`G20`G30 [go to line 10, then to 20, then to 30]
A rather pointless command, but it illustrates the principle.
Multipart commands are very useful as prestored commands. They allow
processing many records with a single command. For example, suppose
you had a select list of 100 records, and each of them needs every
occurrence of '100' changed to '250'. You can do this with a multipart
prestored command.
First create the prestored command:
=DOITALL CU/100/250`FI`=DOITALL
Then run the command '=DOITALL' by entering '=DOITALL' as a command.
The editor will then loop through the list of records, perform the
change for each of them, file each of them, and then run =DOITALL again
on the next record.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:
u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Wednesday, February 05, 2014 4:33 PM
To: U2 Users List
Subject: Re: [U2] UniVerse Dictionary question
Unreal. This old dog just learnt a new trick.
On Wed, Feb 5, 2014 at 5:15 PM, Daniel McGrath
dmcgr...@rocketsoftware.comwrote:
A tip my original mentor taught me on the first day was that in ED/AE,
the back tick (`) gets treated as an empty line so you can keep going
in insert mode and not need to worry about it.
Regards,
Dan
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:
u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl
Sent: Wednesday, February 05, 2014 5:07 PM
To: 'U2 Users List'
Subject: Re: [U2] UniVerse Dictionary question
The dots were just there to keep the numbered list going, The same I
use dots in the Editor to enter blank lines. Later I go to the top and
do
R/.//50 to remove the dot.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, February 04, 2014 3:04 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse Dictionary question
What are the periods in 3 and 4 for?
Did you try removing those?
-Original Message-
From: Woodward, Bob bob_woodw...@k2sports.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Feb 4, 2014 11:49 am
Subject: Re: [U2] UniVerse Dictionary question
Just to make sure, you're wanting FIELD 178 and the first value of
that field. Correct? Because you have a length of 1, left justified
I want to make sure you're not looking for the first character of the
178th field.
Maybe if you showed what you're wanting and what you're getting,
instead, then we'd be sure to give you an answer that makes sense.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill
Haskett
Sent: Tuesday, February 04, 2014 11:45 AM
To: U2 Users List
Subject: Re: [U2] UniVerse Dictionary queston
Martin:
This is the only way to do accomplish the defined task in UniData.
Maybe @RECORD178,1 is the preferred method in UV.
Bill
Untitled Page
--
--
- Original Message -
*From:* msch...@martinscholl.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 2/4/2014 11:33 AM
*Subject:* [U2] UniVerse Dictionary queston
UniVerse.
I want to create
Re: [U2] UniVerse Dictionary question
The UniVerse ED verb in input mode accepts a *single* space as a null line indicator. Regards, Clif On Feb 5, 2014, at 6:15 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: A tip my original mentor taught me on the first day was that in ED/AE, the back tick (`) gets treated as an empty line so you can keep going in insert mode and not need to worry about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: Wednesday, February 05, 2014 5:07 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary question The dots were just there to keep the numbered list going, The same I use dots in the Editor to enter blank lines. Later I go to the top and do R/.//50 to remove the dot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, February 04, 2014 3:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Dictionary question What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
http://www.linkedin.com/in/leifsmith - an interesting guy. Not sure if anyone remembers the old comp.databases.pick days, but Leif reminds me of Henry Eggers - I only understood 10% of what he said, but it was always interesting. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, February 05, 2014 5:02 PM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary question AE is the brainchild of one Leif Smith as I recall. Haven't seen him in years, but he used to stomp around here in Denver. On Wed, Feb 5, 2014 at 5:53 PM, McGowan, Ian james.mcgo...@bankofthewest.com wrote: It's well worth spending some time reading the AE help pages. One of my favorites is help + which ends with the gem We could go on and on about this, but you probably get it. I'm a huge fan of AE, even though I spend most of my programming time inside a visual editor (I like joe [ http://joe-editor.sourceforge.net/], not to start a religious debate). I don't use AE prestores with the wild abandon of my misspent youth, but they're still a handy thing to know. If anyone knows the author of AE, let me know - I owe him or her several drinks... [snip] - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary queston
In line 2 put @RECORD178,1 Regards JLGP -Mensaje original- De: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] En nombre de Martin Scholl Enviado el: martes, 4 de febrero de 2014 01:33 p. m. Para: U2 Users List Asunto: [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary queston
Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
What are the periods in 3 and 4 for? Did you try removing those? -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Feb 4, 2014 11:49 am Subject: Re: [U2] UniVerse Dictionary question Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary queston
Another option to this would be to define field 178 in one dictionary @ID=ITEMWHOLE D 178 DESCRIPTION 1L S And then @ID=ITEMPART I ITEMWHOLE ; @11,1 PIECEofITEM 1L S This way if you ever move where the ITEM is stored, just change the D Item. BUT You might still Have to recompile the I descriptor - I don't think it will automatically sense the ITEMWHOLE Reference changed. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of José Luis Gutiérrez de la Peza Sent: Tuesday, February 04, 2014 2:39 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Dictionary queston In line 2 put @RECORD178,1 Regards JLGP -Mensaje original- De: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] En nombre de Martin Scholl Enviado el: martes, 4 de febrero de 2014 01:33 p. m. Para: U2 Users List Asunto: [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Install on HP-Ux
Peter: Thanks... I will try this... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Sunday, December 15, 2013 5:35 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Install on HP-Ux How about making a copy of the cd/dvd to an iso and installing from that? Somewhere in *nix land where it's easier to mount and use the cd... # dd if=/dev/cdrom of=/var/tmp/uv.iso bs=8000 transport the resulting ISO to your HPUX machine # mount -F lofs /some/dir/to/uv.iso /tmp/mount You should then be able to cd to /tmp/mount and run the cpio command as root (or uvadm?) and follow the install instructions for hpux. # cpio -ivcBdum uv.load ./STARTUP # ./uv.load -longnames HTH Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Saturday, 14 December 2013 10:49 To: U2 Users List Subject: [U2] UniVerse Install on HP-Ux 1. I am having some problems trying to get to first base. 2. There is this cpio command. 3. Is it necessary to install from a CD or DVD? 4. I would rather install from FTP'd files. 5. Mounting the media is a hassle... so is CDFS on a DVD. 6. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Install on HP-Ux
Also, check your uv.load to see if it does an uncompress Then make sure your OS has that command If not, I changed mine from uncompress to gunzip in the uv.load I guess you could also cp gunzip uncompress as well To make things easier if you have a problem. Make a copy of the uv.load to something like uv.load.bu This way if the install fails, you won't have to cpio it back off The CD (just cp it from uv.load.bu to uv.load) George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Monday, December 16, 2013 12:54 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Install on HP-Ux Peter: Thanks... I will try this... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Sunday, December 15, 2013 5:35 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse Install on HP-Ux How about making a copy of the cd/dvd to an iso and installing from that? Somewhere in *nix land where it's easier to mount and use the cd... # dd if=/dev/cdrom of=/var/tmp/uv.iso bs=8000 transport the resulting ISO to your HPUX machine # mount -F lofs /some/dir/to/uv.iso /tmp/mount You should then be able to cd to /tmp/mount and run the cpio command as root (or uvadm?) and follow the install instructions for hpux. # cpio -ivcBdum uv.load ./STARTUP # ./uv.load -longnames HTH Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Saturday, 14 December 2013 10:49 To: U2 Users List Subject: [U2] UniVerse Install on HP-Ux 1. I am having some problems trying to get to first base. 2. There is this cpio command. 3. Is it necessary to install from a CD or DVD? 4. I would rather install from FTP'd files. 5. Mounting the media is a hassle... so is CDFS on a DVD. 6. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Install on HP-Ux
On 16/12/2013 18:14, George Gallen wrote: Also, check your uv.load to see if it does an uncompress Then make sure your OS has that command If not, I changed mine from uncompress to gunzip in the uv.load I guess you could also cp gunzip uncompress as well Ummm. If you've got that problem ... I know when I was installing it, I was installing it on SuSE, for which it isn't certified. And the options to cpio changed - the default of some option was inverted! - so with UV certified for the old cpio and me running the new one, it was quite a mess :-) But at the end of the day it was pretty easy to go in and edit the script. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Install on HP-Ux
How about making a copy of the cd/dvd to an iso and installing from that? Somewhere in *nix land where it's easier to mount and use the cd... # dd if=/dev/cdrom of=/var/tmp/uv.iso bs=8000 transport the resulting ISO to your HPUX machine # mount -F lofs /some/dir/to/uv.iso /tmp/mount You should then be able to cd to /tmp/mount and run the cpio command as root (or uvadm?) and follow the install instructions for hpux. # cpio -ivcBdum uv.load ./STARTUP # ./uv.load -longnames HTH Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Saturday, 14 December 2013 10:49 To: U2 Users List Subject: [U2] UniVerse Install on HP-Ux 1. I am having some problems trying to get to first base. 2. There is this cpio command. 3. Is it necessary to install from a CD or DVD? 4. I would rather install from FTP'd files. 5. Mounting the media is a hassle... so is CDFS on a DVD. 6. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Install on HP-Ux
Inline below... Bob Wyatt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Friday, December 13, 2013 7:49 PM To: U2 Users List Subject: [U2] UniVerse Install on HP-Ux 1. I am having some problems trying to get to first base. Have you considered stepping into the ball? Taunting the pitcher? 2. There is this cpio command. Yup. 3. Is it necessary to install from a CD or DVD? Nope. 4. I would rather install from FTP'd files. No problem. 5. Mounting the media is a hassle... so is CDFS on a DVD. Can be... but not if you know how... 6. Suggestions would be appreciated. Download the NEWINSTALL.pdf guide from the Rocket Web Site... http://www3.rocketsoftware.com/marketing-files/uv112doc.zip --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Training
I seem to remember reading recently that the next u2 university is planned for 2014 but no dates yet. -Dianne On 10/25/2013 9:25 AM, Mike Pflugfelder wrote: Does anyone know if the UniVerse internals class is being offered anymore? It something that I've always wanted to attend, but I was never able to get approved. I think I can get it approved now, but it seems like the course isn't being taught anymore. If it's not available, is there any option to get the course materials? I've tried reaching out to u2train...@rocketsoftware.commailto:u2train...@rocketsoftware.com and haven't gotten any response. On a somewhat similar topic, does anyone know anything about U2 UniVersity? The information on their web page (http://www.rocketsoftware.com/u2-university) is a little out of date, mentioning University 2012. Nothing about 2013 or 2014. Thanks! -Mike ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Training
I believe the internals class you are referring to is now called UV910 - Universe theory and practice. I've included a link, but it doesn't look like they are offering it anytime soon. http://www.rocketsoftware.com/u2-training-uv910-universe-theory-and-practice Ryan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Pflugfelder Sent: Friday, October 25, 2013 8:25 AM To: U2-Users@listserver.u2ug.org Subject: [U2] UniVerse Training Does anyone know if the UniVerse internals class is being offered anymore? It something that I've always wanted to attend, but I was never able to get approved. I think I can get it approved now, but it seems like the course isn't being taught anymore. If it's not available, is there any option to get the course materials? I've tried reaching out to u2train...@rocketsoftware.commailto:u2train...@rocketsoftware.com and haven't gotten any response. On a somewhat similar topic, does anyone know anything about U2 UniVersity? The information on their web page (http://www.rocketsoftware.com/u2-university) is a little out of date, mentioning University 2012. Nothing about 2013 or 2014. Thanks! -Mike ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Training
I've signed up for it a couple of times in the past only to have it cancelled due to lack of participation :( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ladd, Ryan Sent: Friday, October 25, 2013 8:53 AM To: U2-Users@listserver.u2ug.org Subject: Re: [U2] UniVerse Training I believe the internals class you are referring to is now called UV910 - Universe theory and practice. I've included a link, but it doesn't look like they are offering it anytime soon. http://www.rocketsoftware.com/u2-training-uv910-universe-theory-and-practice Ryan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Pflugfelder Sent: Friday, October 25, 2013 8:25 AM To: U2-Users@listserver.u2ug.org Subject: [U2] UniVerse Training Does anyone know if the UniVerse internals class is being offered anymore? It something that I've always wanted to attend, but I was never able to get approved. I think I can get it approved now, but it seems like the course isn't being taught anymore. If it's not available, is there any option to get the course materials? I've tried reaching out to u2train...@rocketsoftware.commailto:u2train...@rocketsoftware.com and haven't gotten any response. On a somewhat similar topic, does anyone know anything about U2 UniVersity? The information on their web page (http://www.rocketsoftware.com/u2-university) is a little out of date, mentioning University 2012. Nothing about 2013 or 2014. Thanks! -Mike ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Training
Perry, you could just teach it instead. Actually, there's some significant changes in user management at 11.1. It looks like the Unidata-based Data Replication is pretty tightly integrated. There are some new logs, but that's pretty straightforward. I think I took an internals class back at maybe 9.6 or so. I'd like to to take it again. Chuck On 10/25/2013 8:25 PM, Perry Taylor wrote: I've signed up for it a couple of times in the past only to have it cancelled due to lack of participation :( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ladd, Ryan Sent: Friday, October 25, 2013 8:53 AM To: U2-Users@listserver.u2ug.org Subject: Re: [U2] UniVerse Training I believe the internals class you are referring to is now called UV910 - Universe theory and practice. I've included a link, but it doesn't look like they are offering it anytime soon. http://www.rocketsoftware.com/u2-training-uv910-universe-theory-and-practice Ryan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Pflugfelder Sent: Friday, October 25, 2013 8:25 AM To: U2-Users@listserver.u2ug.org Subject: [U2] UniVerse Training Does anyone know if the UniVerse internals class is being offered anymore? It something that I've always wanted to attend, but I was never able to get approved. I think I can get it approved now, but it seems like the course isn't being taught anymore. If it's not available, is there any option to get the course materials? I've tried reaching out to u2train...@rocketsoftware.commailto:u2train...@rocketsoftware.com and haven't gotten any response. On a somewhat similar topic, does anyone know anything about U2 UniVersity? The information on their web page (http://www.rocketsoftware.com/u2-university) is a little out of date, mentioning University 2012. Nothing about 2013 or 2014. Thanks! -Mike ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Resize 30
What's even more twisted, is I tried the same scenario on my development box (Linux uv 10.2), and the RESIZE XXX 30 * * actually corrupted my test file LIST XXX XXX... Read operation failure. Internal file corruption detected. File must be repaired. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of LeRoy Dreyfuss Sent: Friday, October 11, 2013 9:55 AM To: U2 Users List Subject: Re: [U2] UniVerse Resize 30 What resize should have done was create the dynamic file, but preserve the current modulo of 11 and the group size. Perhaps it got itself in a twist because it was coming from a static-hashed structure and somehow couldn't work out the mod and sep like it should have. I am pretty sure this used to work back in 10.1.x- we had requests to make that work correctly. Cheers, LeRoy On Fri, Oct 11, 2013 at 8:50 AM, Mark Eastwood ma...@afsi.com wrote: I had an interesting call from a customer this morning - he was resizing some files, making them Dynamic using the command RESIZE FILENAME 30 * * (normally you wouldn't enter the * * after 30) But then his session was comsuming all of the CPU for over 20 minutes (until I killed it). Just curious if anyone knows what the system was trying to do? We resized using the correct command format and everything is fine. The files in question were type 18, empty and very small modulo 11. Thanks, Mark Uv 10 Windows ** This email and any files transmitted with it are confidential and may be subject to copyright. They are intended solely for the use of the individual or entity to which they are addressed. If you have received this message in error please notify AFS immediately by return email. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of AFS, except where an authorized sender specifically states them to be the views of AFS. It is your responsibility to verify this email and any attachments for the presence of viruses. AFS accepts no liability for any damage caused by any virus transmitted. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Resize 30
My testing on an empty type 18 file: :RESIZE DUMMY 30 * * :LIST DUMMY 0 records listed. :ANALYZE.FILE DUMMY File name .. DUMMY Pathname ... DUMMY File type .. DYNAMIC File style and revision 32BIT Revision 12 NLS Character Set Mapping .. ISO8859-1+MARKS Hashing Algorithm .. GENERAL No. of groups (modulus) 3 current ( minimum 3 ) Large record size .. 809 bytes Group size . 1024 bytes Load factors ... 80% (split), 50% (merge) and 0% (actual) Total size . 5120 bytes : It kept the mod and sep. Notice that the minimum and current modulo are the same and at 3. Note the group size is 1 K, which you cannot do when you create the file initially. I tried it again with a file that had data but otherwise the same. It worked fine there two. It shouldn't matter that we use NLS here. AIX 6.1/11.1.11 On Fri, Oct 11, 2013 at 1:02 PM, Mark Eastwood ma...@afsi.com wrote: What's even more twisted, is I tried the same scenario on my development box (Linux uv 10.2), and the RESIZE XXX 30 * * actually corrupted my test file LIST XXX XXX... Read operation failure. Internal file corruption detected. File must be repaired. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of LeRoy Dreyfuss Sent: Friday, October 11, 2013 9:55 AM To: U2 Users List Subject: Re: [U2] UniVerse Resize 30 What resize should have done was create the dynamic file, but preserve the current modulo of 11 and the group size. Perhaps it got itself in a twist because it was coming from a static-hashed structure and somehow couldn't work out the mod and sep like it should have. I am pretty sure this used to work back in 10.1.x- we had requests to make that work correctly. Cheers, LeRoy On Fri, Oct 11, 2013 at 8:50 AM, Mark Eastwood ma...@afsi.com wrote: I had an interesting call from a customer this morning - he was resizing some files, making them Dynamic using the command RESIZE FILENAME 30 * * (normally you wouldn't enter the * * after 30) But then his session was comsuming all of the CPU for over 20 minutes (until I killed it). Just curious if anyone knows what the system was trying to do? We resized using the correct command format and everything is fine. The files in question were type 18, empty and very small modulo 11. Thanks, Mark Uv 10 Windows ** This email and any files transmitted with it are confidential and may be subject to copyright. They are intended solely for the use of the individual or entity to which they are addressed. If you have received this message in error please notify AFS immediately by return email. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of AFS, except where an authorized sender specifically states them to be the views of AFS. It is your responsibility to verify this email and any attachments for the presence of viruses. AFS accepts no liability for any damage caused by any virus transmitted. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe errlog reader
Huh, Will, thanks for the heads up - haven't seen this message before: Invalid UserID 111, preferences not saved. (Preferences require cookies, but no cookie was sent.). Checking into that. Another suggestion is to share code on www.github.com. Which I think applies to anyone that codes - even in such a, ahem, mature language as we do. If you don't want to go to the trouble of packaging code into an honest-to-goodness project, there's always https://gist.github.com/ which is for those less well formed ideas. Is anyone using github for MV code? Is there any way to tag a project so it's easy to find other Pick Basic diehards? I've never been really happy with the way pickwiki handles code submissions, but not unhappy enough to do something about it... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, October 01, 2013 11:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe errlog reader I can't figure out why I can't log into the Pickwiki, so I went ahead and put this routine up at https://sites.google.com/site/pickuniverse/codeexamples/errlog-reader It displays the errlog in a more readable fashion (at least in my opinion). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe errlog reader
Ian, Rocket is: https://github.com/RocketSoftware/ Regards, Dan McGrath Managing Director, U2 Servers Lab Rocket Software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of McGowan, Ian Sent: Tuesday, October 01, 2013 1:21 PM To: U2 Users List Subject: Re: [U2] Universe errlog reader Huh, Will, thanks for the heads up - haven't seen this message before: Invalid UserID 111, preferences not saved. (Preferences require cookies, but no cookie was sent.). Checking into that. Another suggestion is to share code on www.github.com. Which I think applies to anyone that codes - even in such a, ahem, mature language as we do. If you don't want to go to the trouble of packaging code into an honest-to-goodness project, there's always https://gist.github.com/ which is for those less well formed ideas. Is anyone using github for MV code? Is there any way to tag a project so it's easy to find other Pick Basic diehards? I've never been really happy with the way pickwiki handles code submissions, but not unhappy enough to do something about it... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, October 01, 2013 11:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe errlog reader I can't figure out why I can't log into the Pickwiki, so I went ahead and put this routine up at https://sites.google.com/site/pickuniverse/codeexamples/errlog-reader It displays the errlog in a more readable fashion (at least in my opinion). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse v11.2 Public Beta - Personal Edition
Reading the first part, regarding the Auditing, it appears that if a site ignores the auditing entirely and progresses along with their normal activity, *that*, ignoring that auditing, which is on and cannot be turned off, will eventually result in their system halting and being unstartable. Am I mistaken? However the introduction of local subroutines is certainly a game changer for many of us. That along might be worth the upgrade hassle. -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Fri, Sep 13, 2013 1:48 pm Subject: [U2] UniVerse v11.2 Public Beta - Personal Edition Hi all, I'm excited to announce that Rocket is doing its first ever public beta for UniVerse v11.2. As our first public beta, this will be a learning experience for us. We will use this experience to shape how we conduct subsequent public betas. This will be a Personal Edition, so while it won't enable you to play with all the new features currently being tested in our private beta, you will get to see some significant new additions. It has the same restrictions of our regular personal edition that can be found here: http://www.rocketsoftware.com/products/rocket-universe/try-now So, before I mention the new features, some quick housekeeping. While we learn about how much interest a public beta will generate, we want to prevent overwhelming our support team as to not affect customers. To this end, will accept bugs and regressions via our u2supp...@rs.com email channel with the following guidelines: 1) All issues submitted to u2supp...@rs.com need to have the subject UniVerse v11.2 Public Beta 2) Rocket requires any regressions not associated with new features to be confirmed not to exist in the current UniVerse v11.1 Personal Edition 3) Rocket will record issues sent in via a bug tracking system, but will not respond to the reporter unless further clarification is required. Some of the new features you can expect to see UniVerse v11.2 (that you can play with in the Personal Edition) are: 1) Local subroutines functions 2) Additions to XDOM, such as XDOMQuery 3) XML support in U2 Dynamic Objects 4) Compiler DEFINES to enable condition compile basic on database type and version $IFDEF U2_UNIVERSE $IFDEF U2_UNIVERSEv11 $IFDEF U2_UNIVERSEv11.2 5) 64-bit Windows Port 6) SHA-256 support stat = DIGEST(SHA256,data,DATA__STRING,result) 7) nbasic returns exit code 1 for success, 0 for failure 8) New compiler directive $DIM.IN.SUB to support redimensioning in subroutines 9) CLEARCOMMON /named/ now supported. Note: As mentioned before, this is only a subset of the new features that will be released for UniVerse v11.2. Keep a look out for the official release of UniVerse v11.2 later this year were you can find out everything! Downloads for Windows Personal Edition: 32bit PE: https://myshare.rocketsoftware.com/myshare/d/0FECA68828544D92B2F6322EDE56E154 64bit PE: https://myshare.rocketsoftware.com/myshare/d/ADD04F9D82F44182B6983E7DBDE4849C Part of our private beta documentation to help with local subroutines, XDOM changes and XML support in U2 Dynamic Objects: https://myshare.rocketsoftware.com/myshare/d/D71648D5C05E4BBD8A5A36C830CEF3B1 I'm looking forward to hearing your thoughts and will be working to post examples for some of these on our GitHub site: https://github.com/RocketSoftware/u2-servers-lab As a starting point, you can find 2 example implementations of an HMAC function using local functions here: https://github.com/RocketSoftware/u2-servers-lab/tree/master/Security-Demos/HMAC Regards, Dan McGrath Managing Director, U2 Servers Lab Rocket Software ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse v11.2 Public Beta - Personal Edition
Hi Will - great question. As you've noted, Audit Logging is one of the new features coming out with UV 11.2, but not available in the Public Beta. As there are only a few events that are always on, I don't believe any site will run into that issue. The always on events are: 1) SYS.CONFIG.CHANGE A system-level configuration changed, such and a uvconfig, audit configuration, replication configuration change, and so forth. 2) SYS.SECURITY SQL GRANT, REVOKE, future security operations. 3) SYS.ADE Automatic Data Encryption operations: master key, key store, key creation, key deletion, file encryption, index encryption, password related operations. 4) SYS.DAEMON Starting or stopping of UniVerse background processes, such as U2Rep services. It is hard to conceive (although granted, not impossible) a site managing to run out of disk-space through the logging of those events. Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, September 13, 2013 3:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse v11.2 Public Beta - Personal Edition Reading the first part, regarding the Auditing, it appears that if a site ignores the auditing entirely and progresses along with their normal activity, *that*, ignoring that auditing, which is on and cannot be turned off, will eventually result in their system halting and being unstartable. Am I mistaken? However the introduction of local subroutines is certainly a game changer for many of us. That along might be worth the upgrade hassle. -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Fri, Sep 13, 2013 1:48 pm Subject: [U2] UniVerse v11.2 Public Beta - Personal Edition Hi all, I'm excited to announce that Rocket is doing its first ever public beta for UniVerse v11.2. As our first public beta, this will be a learning experience for us. We will use this experience to shape how we conduct subsequent public betas. This will be a Personal Edition, so while it won't enable you to play with all the new features currently being tested in our private beta, you will get to see some significant new additions. It has the same restrictions of our regular personal edition that can be found here: http://www.rocketsoftware.com/products/rocket-universe/try-now So, before I mention the new features, some quick housekeeping. While we learn about how much interest a public beta will generate, we want to prevent overwhelming our support team as to not affect customers. To this end, will accept bugs and regressions via our u2supp...@rs.com email channel with the following guidelines: 1) All issues submitted to u2supp...@rs.com need to have the subject UniVerse v11.2 Public Beta 2) Rocket requires any regressions not associated with new features to be confirmed not to exist in the current UniVerse v11.1 Personal Edition 3) Rocket will record issues sent in via a bug tracking system, but will not respond to the reporter unless further clarification is required. Some of the new features you can expect to see UniVerse v11.2 (that you can play with in the Personal Edition) are: 1) Local subroutines functions 2) Additions to XDOM, such as XDOMQuery 3) XML support in U2 Dynamic Objects 4) Compiler DEFINES to enable condition compile basic on database type and version $IFDEF U2_UNIVERSE $IFDEF U2_UNIVERSEv11 $IFDEF U2_UNIVERSEv11.2 5) 64-bit Windows Port 6) SHA-256 support stat = DIGEST(SHA256,data,DATA__STRING,result) 7) nbasic returns exit code 1 for success, 0 for failure 8) New compiler directive $DIM.IN.SUB to support redimensioning in subroutines 9) CLEARCOMMON /named/ now supported. Note: As mentioned before, this is only a subset of the new features that will be released for UniVerse v11.2. Keep a look out for the official release of UniVerse v11.2 later this year were you can find out everything! Downloads for Windows Personal Edition: 32bit PE: https://myshare.rocketsoftware.com/myshare/d/0FECA68828544D92B2F6322EDE56E154 64bit PE: https://myshare.rocketsoftware.com/myshare/d/ADD04F9D82F44182B6983E7DBDE4849C Part of our private beta documentation to help with local subroutines, XDOM changes and XML support in U2 Dynamic Objects: https://myshare.rocketsoftware.com/myshare/d/D71648D5C05E4BBD8A5A36C830CEF3B1 I'm looking forward to hearing your thoughts and will be working to post examples for some of these on our GitHub site: https://github.com/RocketSoftware/u2-servers-lab As a starting point, you can find 2 example implementations of an HMAC function using local functions here: https://github.com/RocketSoftware/u2
Re: [U2] UniVerse v11.2 Public Beta - Personal Edition
On a busy system the AUDLOGn file can grow over time, but you can work out archive capabilities with the command-line tools provided. It's not a big deal, really. Regards, LeRoy Sent from my iPhone 4 On Sep 13, 2013, at 6:11 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: Hi Will - great question. As you've noted, Audit Logging is one of the new features coming out with UV 11.2, but not available in the Public Beta. As there are only a few events that are always on, I don't believe any site will run into that issue. The always on events are: 1) SYS.CONFIG.CHANGE A system-level configuration changed, such and a uvconfig, audit configuration, replication configuration change, and so forth. 2) SYS.SECURITY SQL GRANT, REVOKE, future security operations. 3) SYS.ADE Automatic Data Encryption operations: master key, key store, key creation, key deletion, file encryption, index encryption, password related operations. 4) SYS.DAEMON Starting or stopping of UniVerse background processes, such as U2Rep services. It is hard to conceive (although granted, not impossible) a site managing to run out of disk-space through the logging of those events. Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, September 13, 2013 3:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse v11.2 Public Beta - Personal Edition Reading the first part, regarding the Auditing, it appears that if a site ignores the auditing entirely and progresses along with their normal activity, *that*, ignoring that auditing, which is on and cannot be turned off, will eventually result in their system halting and being unstartable. Am I mistaken? However the introduction of local subroutines is certainly a game changer for many of us. That along might be worth the upgrade hassle. -Original Message- From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Fri, Sep 13, 2013 1:48 pm Subject: [U2] UniVerse v11.2 Public Beta - Personal Edition Hi all, I'm excited to announce that Rocket is doing its first ever public beta for UniVerse v11.2. As our first public beta, this will be a learning experience for us. We will use this experience to shape how we conduct subsequent public betas. This will be a Personal Edition, so while it won't enable you to play with all the new features currently being tested in our private beta, you will get to see some significant new additions. It has the same restrictions of our regular personal edition that can be found here: http://www.rocketsoftware.com/products/rocket-universe/try-now So, before I mention the new features, some quick housekeeping. While we learn about how much interest a public beta will generate, we want to prevent overwhelming our support team as to not affect customers. To this end, will accept bugs and regressions via our u2supp...@rs.com email channel with the following guidelines: 1) All issues submitted to u2supp...@rs.com need to have the subject UniVerse v11.2 Public Beta 2) Rocket requires any regressions not associated with new features to be confirmed not to exist in the current UniVerse v11.1 Personal Edition 3) Rocket will record issues sent in via a bug tracking system, but will not respond to the reporter unless further clarification is required. Some of the new features you can expect to see UniVerse v11.2 (that you can play with in the Personal Edition) are: 1) Local subroutines functions 2) Additions to XDOM, such as XDOMQuery 3) XML support in U2 Dynamic Objects 4) Compiler DEFINES to enable condition compile basic on database type and version $IFDEF U2_UNIVERSE $IFDEF U2_UNIVERSEv11 $IFDEF U2_UNIVERSEv11.2 5) 64-bit Windows Port 6) SHA-256 support stat = DIGEST(SHA256,data,DATA__STRING,result) 7) nbasic returns exit code 1 for success, 0 for failure 8) New compiler directive $DIM.IN.SUB to support redimensioning in subroutines 9) CLEARCOMMON /named/ now supported. Note: As mentioned before, this is only a subset of the new features that will be released for UniVerse v11.2. Keep a look out for the official release of UniVerse v11.2 later this year were you can find out everything! Downloads for Windows Personal Edition: 32bit PE: https://myshare.rocketsoftware.com/myshare/d/0FECA68828544D92B2F6322EDE56E154 64bit PE: https://myshare.rocketsoftware.com/myshare/d/ADD04F9D82F44182B6983E7DBDE4849C Part of our private beta documentation to help with local subroutines, XDOM changes and XML support in U2 Dynamic Objects: https://myshare.rocketsoftware.com/myshare/d/D71648D5C05E4BBD8A5A36C830CEF3B1 I'm looking forward
Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample
Thanks, Troy. I was going to write that after I got to 11.1. (The upgrade was scheduled for Q3, but I hear rumours it got bumped because salesmen just sold something we can't do - yet. It pays the bills.) Troy, I want to borrow your code, but I want to include proper attribution in the program header. Chuck On 8/27/2013 7:02 PM, Buss, Troy (Contractor, Logitek Systems) wrote: Regarding the recent discussion of using indexes as triggers, I use the following to update timestamps of record changes to a master item stats file that we use for controlling updates to a business warehouse (BW). Without modifying hundreds of legacy programs to support proper timestamps in the primary records, I added the following indexed Idescriptors to files I need to track. We are on universe 11.1.1 and this has been working well for over a year. DICT AR-INVOICE INDEX..MODIFIEDZ 0001 I 0002 SUBR(ZIDESC.ITEMSTATS.UPDATE, AR-INVOICE!:F0,) 0004 \ 0005 1L 0006 S 0049 used to create item created, modified, delete in zitemstats file - create index with this and no.nulls keyword EOI 216 bytes In this example, we have a AR-INVOICE header record and a related ARLI line item file. For our purposes to keep in sync with the BW, we want to timestamp the corresponding header record whenever a line item is updated so the ARLI dict item also updates AR-INVOICE header ZITEMSTATS with an I indirect update flag. DICT ARLI INDEX..MODIFIEDZ 0001 I 0002 SUBR(ZIDESC.ITEMSTATS.UPDATE, ARLI!:F0,):SUBR(ZIDESC.ITEMSTATS.UPDATE, AR-INVOICE!:F1,I) 0004 \ 0005 1L 0006 S 0049 used to create item created, modified, delete in zitemstats file - create index with this and no.nulls keyword EOI 264 bytes Alternate Key Index Summary for file ARLI File... ARLI Indices 3 (0 A-type, 0 C-type, 0 D-type, 3 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type INDEX..MODIFIEDZ INot Reqd No Yes SL NSUBR(ZIDESC.ITE MSTATS.UPDATE, ARLI!:F0,):S UBR(ZIDESC.ITEM STATS.UPDATE, AR-INVOICE!:F1, I) Subroutine ZIDESC.ITEMSTATS.UPDATE: 0001 SUB (RETURN.VALUE, ZITEMSTATS.ID, OPTIONS) 0002 * updates zitemstats with timestamps; create, modified, deleted 0003 * 0004 * Revision history: 0005 * 0006 * tdb.1190 2012-04-22_1602 new 0007 * 0008 * 0009 * input: ZITEMSTATS.ID item id to use for ZITEMSTATS file 0010 * OPTIONS 0011 *I update attb 5 with I for indirect reference 0012 * 0013 * output: RETURN.VALUE NULL 0014 * 0015 * common vars: /ZITEMSTATS/ 0016 * 0017 * called by: INDEX..MODIFIEDZ dictionary items 0018 * calls: 0019 * 0020 * notes: 0021 * 0022 * 0023 $OPTIONS TIME.MILLISECOND 0024 * 0025 * @idx.iotype = 0 - Not being used from an index; 0026 * 1 - INSERT (new) record; 0027 * 2 - DELETE record; 0028 * 3 - Derive old index value; 0029 * 4 - Derive new index value; 0030 * 0031 COMMON /ZITEMSTATS/ F.ZITEMSTATS, ZITEMSTATS.FLAG.OPEN, ZITEMSTATS.WHO 0032 * 0033 EQU NUL TO 0034 * 0035 RETURN.VALUE = NUL 0036 * 0037 * the following handles initial call and logto commands 0038 * 0039 IF NOT(ZITEMSTATS.FLAG.OPEN) OR (@WHO # ZITEMSTATS.WHO) THEN 0040 OPEN ZITEMSTATS TO F.ZITEMSTATS ELSE 0041 RETURN ;* to caller. 0042 END 0043 * 0044 ZITEMSTATS.FLAG.OPEN = 1 0045 ZITEMSTATS.WHO = @WHO 0046 END 0047 * 0048 LOG.TYPE = NUL 0049 * 0050 BEGIN CASE 0051 CASE @IDX.IOTYPE = 0 0052 * 0053 CASE @IDX.IOTYPE = 1 0054 LOG.TYPE = C ;* new - created - easier to see than 'N' new 0055 * 0056 CASE @IDX.IOTYPE = 2 0057 LOG.TYPE = D ;* delete 0058 * 0059 CASE @IDX.IOTYPE = 3 0060 * 0061 CASE @IDX.IOTYPE = 4 0062 LOG.TYPE = M ;* modified 0063 * 0064 END CASE 0065 * 0066 IF LOG.TYPE # NUL THEN 0067 * 0068 DATE.NOW = DATE() 0069 TIME.NOW = TIME() 0070 * 0071 * handle instance of midnight between date/time functions 0072 * 0073 IF DATE.NOW # DATE() AND TIME() TIME.NOW THEN DATE.NOW = DATE() 0074 * 0075 TIMESTAMP = DATE.NOW * 86400 + TIME.NOW 0076 * 0077 READU ZITEMSTATS$ FROM F.ZITEMSTATS, ZITEMSTATS.ID ELSE ZITEMSTATS$ = NUL 0078 * 0079 INDIRECT.FLAG = COUNT(OPTIONS, I) 0080 * 0081 IF INDIRECT.FLAG THEN 0082 ZITEMSTATS$1 = M ;* modified 0083 END ELSE 0084 ZITEMSTATS$1 = LOG.TYPE 0085 END 0086 * 0087 * created 0088 * 0089 IF INDIRECT.FLAG ELSE 0090 IF LOG.TYPE = C THEN 0091 ZITEMSTATS$2 = TIMESTAMP 0092 END 0093 END 0094 * 0095 * modified 0096 * 0097 ZITEMSTATS$3 = TIMESTAMP 0098 * 0099 * deleted 0100 * 0101
Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample
That is awesome information Troy! Thanks for that! (Now if I could just get my production environment upgrade to 11.1x :D ) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Contractor, Logitek Systems) Sent: Tuesday, August 27, 2013 10:03 AM To: U2 Users List Subject: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample Regarding the recent discussion of using indexes as triggers, I use the following to update timestamps of record changes to a master item stats file that we use for controlling updates to a business warehouse (BW). Without modifying hundreds of legacy programs to support proper timestamps in the primary records, I added the following indexed Idescriptors to files I need to track. We are on universe 11.1.1 and this has been working well for over a year. DICT AR-INVOICE INDEX..MODIFIEDZ 0001 I 0002 SUBR(ZIDESC.ITEMSTATS.UPDATE, AR-INVOICE!:F0,) 0004 \ 0005 1L 0006 S 0049 used to create item created, modified, delete in zitemstats file - create index with this and no.nulls keyword EOI 216 bytes In this example, we have a AR-INVOICE header record and a related ARLI line item file. For our purposes to keep in sync with the BW, we want to timestamp the corresponding header record whenever a line item is updated so the ARLI dict item also updates AR-INVOICE header ZITEMSTATS with an I indirect update flag. DICT ARLI INDEX..MODIFIEDZ 0001 I 0002 SUBR(ZIDESC.ITEMSTATS.UPDATE, ARLI!:F0,):SUBR(ZIDESC.ITEMSTATS.UPDATE, AR-INVOICE!:F1,I) 0004 \ 0005 1L 0006 S 0049 used to create item created, modified, delete in zitemstats file - create index with this and no.nulls keyword EOI 264 bytes Alternate Key Index Summary for file ARLI File... ARLI Indices 3 (0 A-type, 0 C-type, 0 D-type, 3 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type INDEX..MODIFIEDZ INot Reqd No Yes SL NSUBR(ZIDESC.ITE MSTATS.UPDATE, ARLI!:F0,):S UBR(ZIDESC.ITEM STATS.UPDATE, AR-INVOICE!:F1, I) Subroutine ZIDESC.ITEMSTATS.UPDATE: 0001 SUB (RETURN.VALUE, ZITEMSTATS.ID, OPTIONS) 0002 * updates zitemstats with timestamps; create, modified, deleted 0003 * 0004 * Revision history: 0005 * 0006 * tdb.1190 2012-04-22_1602 new 0007 * 0008 * 0009 * input: ZITEMSTATS.ID item id to use for ZITEMSTATS file 0010 * OPTIONS 0011 *I update attb 5 with I for indirect reference 0012 * 0013 * output: RETURN.VALUE NULL 0014 * 0015 * common vars: /ZITEMSTATS/ 0016 * 0017 * called by: INDEX..MODIFIEDZ dictionary items 0018 * calls: 0019 * 0020 * notes: 0021 * 0022 * 0023 $OPTIONS TIME.MILLISECOND 0024 * 0025 * @idx.iotype = 0 - Not being used from an index; 0026 * 1 - INSERT (new) record; 0027 * 2 - DELETE record; 0028 * 3 - Derive old index value; 0029 * 4 - Derive new index value; 0030 * 0031 COMMON /ZITEMSTATS/ F.ZITEMSTATS, ZITEMSTATS.FLAG.OPEN, ZITEMSTATS.WHO 0032 * 0033 EQU NUL TO 0034 * 0035 RETURN.VALUE = NUL 0036 * 0037 * the following handles initial call and logto commands 0038 * 0039 IF NOT(ZITEMSTATS.FLAG.OPEN) OR (@WHO # ZITEMSTATS.WHO) THEN 0040 OPEN ZITEMSTATS TO F.ZITEMSTATS ELSE 0041 RETURN ;* to caller. 0042 END 0043 * 0044 ZITEMSTATS.FLAG.OPEN = 1 0045 ZITEMSTATS.WHO = @WHO 0046 END 0047 * 0048 LOG.TYPE = NUL 0049 * 0050 BEGIN CASE 0051 CASE @IDX.IOTYPE = 0 0052 * 0053 CASE @IDX.IOTYPE = 1 0054 LOG.TYPE = C ;* new - created - easier to see than 'N' new 0055 * 0056 CASE @IDX.IOTYPE = 2 0057 LOG.TYPE = D ;* delete 0058 * 0059 CASE @IDX.IOTYPE = 3 0060 * 0061 CASE @IDX.IOTYPE = 4 0062 LOG.TYPE = M ;* modified 0063 * 0064 END CASE 0065 * 0066 IF LOG.TYPE # NUL THEN 0067 * 0068 DATE.NOW = DATE() 0069 TIME.NOW = TIME() 0070 * 0071 * handle instance of midnight between date/time functions 0072 * 0073 IF DATE.NOW # DATE() AND TIME() TIME.NOW THEN DATE.NOW = DATE() 0074 * 0075 TIMESTAMP = DATE.NOW * 86400 + TIME.NOW 0076 * 0077 READU ZITEMSTATS$ FROM F.ZITEMSTATS, ZITEMSTATS.ID ELSE ZITEMSTATS$ = NUL 0078 * 0079 INDIRECT.FLAG = COUNT(OPTIONS, I) 0080 * 0081 IF INDIRECT.FLAG THEN 0082 ZITEMSTATS$1 = M ;* modified 0083 END ELSE 0084 ZITEMSTATS$1 = LOG.TYPE 0085 END 0086 * 0087 * created 0088 * 0089 IF INDIRECT.FLAG ELSE 0090 IF LOG.TYPE = C THEN 0091 ZITEMSTATS$2 = TIMESTAMP 0092 END 0093 END 0094 * 0095 * modified 0096 * 0097 ZITEMSTATS$3 = TIMESTAMP
Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample
Should line 73 of your program be rather than for the time as when the date has changed, the time will be less than the time of the date - 1 which you have just set. 0068 DATE.NOW = DATE() 0069 TIME.NOW = TIME() 0073 IF DATE.NOW # DATE() AND TIME() TIME.NOW THEN DATE.NOW = DATE() Example: DATE.NOW = 16789 TIME.NOW = 83999 DATE() = 16790 TIME() = 1 Might be wrong -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Wednesday, 28 August 2013 4:26 a.m. To: U2 Users List Subject: Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample That is awesome information Troy! Thanks for that! (Now if I could just get my production environment upgrade to 11.1x :D ) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Contractor, Logitek Systems) Sent: Tuesday, August 27, 2013 10:03 AM To: U2 Users List Subject: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample Regarding the recent discussion of using indexes as triggers, I use the following to update timestamps of record changes to a master item stats file that we use for controlling updates to a business warehouse (BW). Without modifying hundreds of legacy programs to support proper timestamps in the primary records, I added the following indexed Idescriptors to files I need to track. We are on universe 11.1.1 and this has been working well for over a year. DICT AR-INVOICE INDEX..MODIFIEDZ 0001 I 0002 SUBR(ZIDESC.ITEMSTATS.UPDATE, AR-INVOICE!:F0,) 0004 \ 0005 1L 0006 S 0049 used to create item created, modified, delete in zitemstats file - create index with this and no.nulls keyword EOI 216 bytes In this example, we have a AR-INVOICE header record and a related ARLI line item file. For our purposes to keep in sync with the BW, we want to timestamp the corresponding header record whenever a line item is updated so the ARLI dict item also updates AR-INVOICE header ZITEMSTATS with an I indirect update flag. DICT ARLI INDEX..MODIFIEDZ 0001 I 0002 SUBR(ZIDESC.ITEMSTATS.UPDATE, ARLI!:F0,):SUBR(ZIDESC.ITEMSTATS.UPDATE, AR-INVOICE!:F1,I) 0004 \ 0005 1L 0006 S 0049 used to create item created, modified, delete in zitemstats file - create index with this and no.nulls keyword EOI 264 bytes Alternate Key Index Summary for file ARLI File... ARLI Indices 3 (0 A-type, 0 C-type, 0 D-type, 3 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type INDEX..MODIFIEDZ INot Reqd No Yes SL NSUBR(ZIDESC.ITE MSTATS.UPDATE, ARLI!:F0,):S UBR(ZIDESC.ITEM STATS.UPDATE, AR-INVOICE!:F1, I) Subroutine ZIDESC.ITEMSTATS.UPDATE: 0001 SUB (RETURN.VALUE, ZITEMSTATS.ID, OPTIONS) 0002 * updates zitemstats with timestamps; create, modified, deleted 0003 * 0004 * Revision history: 0005 * 0006 * tdb.1190 2012-04-22_1602 new 0007 * 0008 * 0009 * input: ZITEMSTATS.ID item id to use for ZITEMSTATS file 0010 * OPTIONS 0011 *I update attb 5 with I for indirect reference 0012 * 0013 * output: RETURN.VALUE NULL 0014 * 0015 * common vars: /ZITEMSTATS/ 0016 * 0017 * called by: INDEX..MODIFIEDZ dictionary items 0018 * calls: 0019 * 0020 * notes: 0021 * 0022 * 0023 $OPTIONS TIME.MILLISECOND 0024 * 0025 * @idx.iotype = 0 - Not being used from an index; 0026 * 1 - INSERT (new) record; 0027 * 2 - DELETE record; 0028 * 3 - Derive old index value; 0029 * 4 - Derive new index value; 0030 * 0031 COMMON /ZITEMSTATS/ F.ZITEMSTATS, ZITEMSTATS.FLAG.OPEN, ZITEMSTATS.WHO 0032 * 0033 EQU NUL TO 0034 * 0035 RETURN.VALUE = NUL 0036 * 0037 * the following handles initial call and logto commands 0038 * 0039 IF NOT(ZITEMSTATS.FLAG.OPEN) OR (@WHO # ZITEMSTATS.WHO) THEN 0040 OPEN ZITEMSTATS TO F.ZITEMSTATS ELSE 0041 RETURN ;* to caller. 0042 END 0043 * 0044 ZITEMSTATS.FLAG.OPEN = 1 0045 ZITEMSTATS.WHO = @WHO 0046 END 0047 * 0048 LOG.TYPE = NUL 0049 * 0050 BEGIN CASE 0051 CASE @IDX.IOTYPE = 0 0052 * 0053 CASE @IDX.IOTYPE = 1 0054 LOG.TYPE = C ;* new - created - easier to see than 'N' new 0055 * 0056 CASE @IDX.IOTYPE = 2 0057 LOG.TYPE = D ;* delete 0058 * 0059 CASE @IDX.IOTYPE = 3 0060 * 0061 CASE @IDX.IOTYPE = 4 0062 LOG.TYPE = M ;* modified 0063 * 0064 END CASE 0065 * 0066 IF LOG.TYPE # NUL THEN 0067 * 0068 DATE.NOW = DATE() 0069 TIME.NOW = TIME() 0070 * 0071
Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample
Phil, Ahh, good catch, I believe you are correct. Thankfully, this should be a very very rare occurrence. Thanks! Should be: 0073 IF DATE.NOW # DATE() AND TIME() TIME.NOW THEN DATE.NOW = DATE() -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Tuesday, August 27, 2013 11:51 AM To: U2 Users List Subject: Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample Should line 73 of your program be rather than for the time as when the date has changed, the time will be less than the time of the date - 1 which you have just set. 0068 DATE.NOW = DATE() 0069 TIME.NOW = TIME() 0073 IF DATE.NOW # DATE() AND TIME() TIME.NOW THEN DATE.NOW = DATE() Example: DATE.NOW = 16789 TIME.NOW = 83999 DATE() = 16790 TIME() = 1 Might be wrong _ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of the email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. _ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Configuration --
Peter, Thanks for digging for more information. It sounds to me like RLOWNER was set to the RLTABSZ, effectively saying that every read lock associated with a given semaphore group could be a READL lock. Since every READL lock would displace a possible READU lock, you could, with 300 separate processes accessing the same record in the same file, make it impossible anyone to get a READU lock in the same semaphore group. Likewise, by having a smaller number of processes perform READL's on multiple files, but coincidently use the same semaphore group, you could obtain the same blocked condition. Admittedly, both conditions seem unlikely, and if you are running a system with that many READL locks routinely active, why bother?, no one is ever going to be updating anything! I would think that a better rule would be to limit the value of RLOWNER to 50% of RLTABSZ, just to keep some room for quasi-normal function if some developer decided to create an application that used a READL on a specific file/record to communicate to other processes in ill-considered ways. Cheers, Rick On Aug 15, 2013, at 5:19 PM, Peter Cheney peter.che...@firstmac.com.au wrote: From my UV9.4 internals manual in the UV data structures chapter... Sizing lock tables... - The file lock table has FSEMNUM (default 23) rows, each with FLTABSZ (default 11) entries. - The group lock table has GSEMNUM (default 23) rows, each with GLTABSZ (default 300) entries. - The record update lock table has GSEMNUM (default 23) rows, each with RLTABSZ (default 300) entries Each row in each table has a semaphore associated with it. The whole chapter talks about semaphore collisions and retries etc when dealing with locks. Further on is another section also called Sizing lock tables that says... Increasing GSEMNUM spreads the concurrent group locks across more rows, reducing the average count of group locks per semaphore. The shorter list reduces the amount of time the semaphore needs to be held to process the tables. This reduced time not only reduces the probability of collision but also reduces the number of retries before the semaphore becomes available. Reducing the processing time also reduces the probability that the time slice will expire while the user owns the semaphore. If the time slice expires while the semaphore is held, other users may put significant load on the system trying to get the semaphore. Further on it says... Shared file locks and shared record locks are handled as linked lists From the UV9.3 system administration manual... RLOWNER - Sets the number of lock owner entries that are maintained for shared (READL) locks in a group lock semaphore set. Great care should be exercised when changing this parameter. The performance of the disk i/o subsystem may be profoundly affected. I've always been advised that the default RLOWNER value of 300 is too big and should be reduced to about 120. So does the above mean that RLOWNER controls the number of entries in a semaphore? HTH Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Friday, 16 August 2013 2:33 AM To: 'U2 Users List' Subject: Re: [U2] Universe Configuration -- More research than anything else. We are having an occasional performance problem with one file, and I was checking the lock tables and tuneables. And realized that I might be misinterpreting RLOWNER, since smat-a does not list out a separate table for it, at least that I could see. On some earlier versions of Solaris UV, it is possible to configure the lock tables to be too large for the memory segment, and uvregen will balk. I have not played with this at the current releases. I agree that the default for RLOWNER of 300 does not sound very taxing, but if it really is 300 table entries for each group semaphore x 40 bytes or so, that could add up to a chunk of wasted space. + Okay, I tested a couple of these changes: Changing RLOWNER from 300 + to 400 has no effect on the segment size output of uvregen. Changing + RLOWNER to 2000 also has no effect. Changing the RLTABSZ by 100 upped + the usage by 1.7 M ( GSEMNUM=97). Likewise, bumping GSEMNUM by 10 to + 107 bumped the segment size by 0.52 M. (No units, since it is not + reported by uvregen. It could be bytes or words.) From this, I deduce that RLOWNER, does not affect the size of any tables, rather it might be a limit on the number of users that can concurrently lock a single record using the READL statement. Not sure what else it could be. -Rick -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent
Re: [U2] Universe Configuration --
I wouldn't be concerned about the default value being too high. The main reason to modify the tunables is to increase them when you are hitting a limit. Years ago, when kernels had very little shared memory in their out-of-the-box configuration, the tunables were set quite low so that Universe would function after installation. With decent sized concurrent users (or lots of phantoms) it would frequently need to be increased. The defaults now are more reasonable. smat -a will show all the lock tables; with that you can see where you are at a given point in time. Increase it if you are reaching the limit but there is no reason to lower them if you are not. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Wed, Aug 14, 2013 at 6:23 PM, Rick Nuckolls r...@lynden.com wrote: The link to SQL makes some sense. My original thought was RLOWNER was to Shared Locks (RL) as RLTABSZ is to Exclusive (RU) locks, but the default (300) seemed a little high for tracking RL locks, especially if that is 300 x GSEMNUM. Also, the only reporting that I can find is as a RL entry in the LIST.READU output, with multiple locks on a single record appearing as a single record lock in the Active Group Locks list. Interestingly, smat -r shows the user info for the shared locks, but not the exclusive locks. This makes me wonder if the configuration value is still relevant, or if the tables have been combined. In that there seem to be very minimal uses for shared locks outside of SQL, 300 seems a bit high for the average Legacy PI/OPEN install. Thanks, Rick -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Wednesday, August 14, 2013 2:00 PM To: U2 Users List Subject: Re: [U2] Universe Configuration -- The RLOWNER parameter relates to record shared locks and were introduced to Universe when the SQL syntax was. The value determines the number of slots available to hold the user information of the processes holding the shared locks. If any shared locks are held against a record an exclusive lock, READU or FILELOCK, EXCLUSIVE will fail or take the locked clause. If you do not use SQL or specifically request a READL lock in basic then you can basically ignore it I believe from memory. Regards Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Thursday, 15 August 2013 6:06 a.m. To: 'U2 Users List' Subject: [U2] Universe Configuration -- Can anyone provide a cogent explanation of the RLOWNER configuration parameter in UV? How does it relate to the GSEMNUM and GLTABSZ/RLTABSZ? What are the contents duration of an associated entry? Is there any way to determine the number in use (as opposed to the configured number)? The manual's explanation is a bit short. Thanks, Rick Nuckolls ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Configuration --
More research than anything else. We are having an occasional performance problem with one file, and I was checking the lock tables and tuneables. And realized that I might be misinterpreting RLOWNER, since smat-a does not list out a separate table for it, at least that I could see. On some earlier versions of Solaris UV, it is possible to configure the lock tables to be too large for the memory segment, and uvregen will balk. I have not played with this at the current releases. I agree that the default for RLOWNER of 300 does not sound very taxing, but if it really is 300 table entries for each group semaphore x 40 bytes or so, that could add up to a chunk of wasted space. + Okay, I tested a couple of these changes: Changing RLOWNER from 300 to 400 has no effect on the segment size output of uvregen. Changing RLOWNER to 2000 also has no effect. Changing the RLTABSZ by 100 upped the usage by 1.7 M ( GSEMNUM=97). Likewise, bumping GSEMNUM by 10 to 107 bumped the segment size by 0.52 M. (No units, since it is not reported by uvregen. It could be bytes or words.) From this, I deduce that RLOWNER, does not affect the size of any tables, rather it might be a limit on the number of users that can concurrently lock a single record using the READL statement. Not sure what else it could be. -Rick -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: Thursday, August 15, 2013 7:20 AM To: U2 Users List Subject: Re: [U2] Universe Configuration -- I wouldn't be concerned about the default value being too high. The main reason to modify the tunables is to increase them when you are hitting a limit. Years ago, when kernels had very little shared memory in their out-of-the-box configuration, the tunables were set quite low so that Universe would function after installation. With decent sized concurrent users (or lots of phantoms) it would frequently need to be increased. The defaults now are more reasonable. smat -a will show all the lock tables; with that you can see where you are at a given point in time. Increase it if you are reaching the limit but there is no reason to lower them if you are not. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Wed, Aug 14, 2013 at 6:23 PM, Rick Nuckolls r...@lynden.com wrote: The link to SQL makes some sense. My original thought was RLOWNER was to Shared Locks (RL) as RLTABSZ is to Exclusive (RU) locks, but the default (300) seemed a little high for tracking RL locks, especially if that is 300 x GSEMNUM. Also, the only reporting that I can find is as a RL entry in the LIST.READU output, with multiple locks on a single record appearing as a single record lock in the Active Group Locks list. Interestingly, smat -r shows the user info for the shared locks, but not the exclusive locks. This makes me wonder if the configuration value is still relevant, or if the tables have been combined. In that there seem to be very minimal uses for shared locks outside of SQL, 300 seems a bit high for the average Legacy PI/OPEN install. Thanks, Rick -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Wednesday, August 14, 2013 2:00 PM To: U2 Users List Subject: Re: [U2] Universe Configuration -- The RLOWNER parameter relates to record shared locks and were introduced to Universe when the SQL syntax was. The value determines the number of slots available to hold the user information of the processes holding the shared locks. If any shared locks are held against a record an exclusive lock, READU or FILELOCK, EXCLUSIVE will fail or take the locked clause. If you do not use SQL or specifically request a READL lock in basic then you can basically ignore it I believe from memory. Regards Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Thursday, 15 August 2013 6:06 a.m. To: 'U2 Users List' Subject: [U2] Universe Configuration -- Can anyone provide a cogent explanation of the RLOWNER configuration parameter in UV? How does it relate to the GSEMNUM and GLTABSZ/RLTABSZ? What are the contents duration of an associated entry? Is there any way to determine the number in use (as opposed to the configured number)? The manual's explanation is a bit short. Thanks, Rick Nuckolls ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users
Re: [U2] Universe Configuration --
From my UV9.4 internals manual in the UV data structures chapter... Sizing lock tables... - The file lock table has FSEMNUM (default 23) rows, each with FLTABSZ (default 11) entries. - The group lock table has GSEMNUM (default 23) rows, each with GLTABSZ (default 300) entries. - The record update lock table has GSEMNUM (default 23) rows, each with RLTABSZ (default 300) entries Each row in each table has a semaphore associated with it. The whole chapter talks about semaphore collisions and retries etc when dealing with locks. Further on is another section also called Sizing lock tables that says... Increasing GSEMNUM spreads the concurrent group locks across more rows, reducing the average count of group locks per semaphore. The shorter list reduces the amount of time the semaphore needs to be held to process the tables. This reduced time not only reduces the probability of collision but also reduces the number of retries before the semaphore becomes available. Reducing the processing time also reduces the probability that the time slice will expire while the user owns the semaphore. If the time slice expires while the semaphore is held, other users may put significant load on the system trying to get the semaphore. Further on it says... Shared file locks and shared record locks are handled as linked lists From the UV9.3 system administration manual... RLOWNER - Sets the number of lock owner entries that are maintained for shared (READL) locks in a group lock semaphore set. Great care should be exercised when changing this parameter. The performance of the disk i/o subsystem may be profoundly affected. I've always been advised that the default RLOWNER value of 300 is too big and should be reduced to about 120. So does the above mean that RLOWNER controls the number of entries in a semaphore? HTH Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Friday, 16 August 2013 2:33 AM To: 'U2 Users List' Subject: Re: [U2] Universe Configuration -- More research than anything else. We are having an occasional performance problem with one file, and I was checking the lock tables and tuneables. And realized that I might be misinterpreting RLOWNER, since smat-a does not list out a separate table for it, at least that I could see. On some earlier versions of Solaris UV, it is possible to configure the lock tables to be too large for the memory segment, and uvregen will balk. I have not played with this at the current releases. I agree that the default for RLOWNER of 300 does not sound very taxing, but if it really is 300 table entries for each group semaphore x 40 bytes or so, that could add up to a chunk of wasted space. + Okay, I tested a couple of these changes: Changing RLOWNER from 300 + to 400 has no effect on the segment size output of uvregen. Changing + RLOWNER to 2000 also has no effect. Changing the RLTABSZ by 100 upped + the usage by 1.7 M ( GSEMNUM=97). Likewise, bumping GSEMNUM by 10 to + 107 bumped the segment size by 0.52 M. (No units, since it is not + reported by uvregen. It could be bytes or words.) From this, I deduce that RLOWNER, does not affect the size of any tables, rather it might be a limit on the number of users that can concurrently lock a single record using the READL statement. Not sure what else it could be. -Rick -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: Thursday, August 15, 2013 7:20 AM To: U2 Users List Subject: Re: [U2] Universe Configuration -- I wouldn't be concerned about the default value being too high. The main reason to modify the tunables is to increase them when you are hitting a limit. Years ago, when kernels had very little shared memory in their out-of-the-box configuration, the tunables were set quite low so that Universe would function after installation. With decent sized concurrent users (or lots of phantoms) it would frequently need to be increased. The defaults now are more reasonable. smat -a will show all the lock tables; with that you can see where you are at a given point in time. Increase it if you are reaching the limit but there is no reason to lower them if you are not. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.commailto:ati...@fwdco.com On Wed, Aug 14, 2013 at 6:23 PM, Rick Nuckolls r...@lynden.commailto:r...@lynden.com wrote: The link to SQL makes some sense. My original thought was RLOWNER was to Shared Locks (RL) as RLTABSZ is to Exclusive (RU) locks, but the default (300) seemed a little high for tracking RL locks, especially if that is 300 x GSEMNUM. Also, the only reporting that I can find
Re: [U2] Universe Configuration --
The RLOWNER parameter relates to record shared locks and were introduced to Universe when the SQL syntax was. The value determines the number of slots available to hold the user information of the processes holding the shared locks. If any shared locks are held against a record an exclusive lock, READU or FILELOCK, EXCLUSIVE will fail or take the locked clause. If you do not use SQL or specifically request a READL lock in basic then you can basically ignore it I believe from memory. Regards Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Thursday, 15 August 2013 6:06 a.m. To: 'U2 Users List' Subject: [U2] Universe Configuration -- Can anyone provide a cogent explanation of the RLOWNER configuration parameter in UV? How does it relate to the GSEMNUM and GLTABSZ/RLTABSZ? What are the contents duration of an associated entry? Is there any way to determine the number in use (as opposed to the configured number)? The manual's explanation is a bit short. Thanks, Rick Nuckolls ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Configuration --
The link to SQL makes some sense. My original thought was RLOWNER was to Shared Locks (RL) as RLTABSZ is to Exclusive (RU) locks, but the default (300) seemed a little high for tracking RL locks, especially if that is 300 x GSEMNUM. Also, the only reporting that I can find is as a RL entry in the LIST.READU output, with multiple locks on a single record appearing as a single record lock in the Active Group Locks list. Interestingly, smat -r shows the user info for the shared locks, but not the exclusive locks. This makes me wonder if the configuration value is still relevant, or if the tables have been combined. In that there seem to be very minimal uses for shared locks outside of SQL, 300 seems a bit high for the average Legacy PI/OPEN install. Thanks, Rick -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Wednesday, August 14, 2013 2:00 PM To: U2 Users List Subject: Re: [U2] Universe Configuration -- The RLOWNER parameter relates to record shared locks and were introduced to Universe when the SQL syntax was. The value determines the number of slots available to hold the user information of the processes holding the shared locks. If any shared locks are held against a record an exclusive lock, READU or FILELOCK, EXCLUSIVE will fail or take the locked clause. If you do not use SQL or specifically request a READL lock in basic then you can basically ignore it I believe from memory. Regards Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Thursday, 15 August 2013 6:06 a.m. To: 'U2 Users List' Subject: [U2] Universe Configuration -- Can anyone provide a cogent explanation of the RLOWNER configuration parameter in UV? How does it relate to the GSEMNUM and GLTABSZ/RLTABSZ? What are the contents duration of an associated entry? Is there any way to determine the number in use (as opposed to the configured number)? The manual's explanation is a bit short. Thanks, Rick Nuckolls ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
re. triggers Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
I won't be holding my breath Charles ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 26 July 2013 9:22 p.m. To: U2 Users List Subject: Re: [U2] Universe Triggers re. triggers Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
However, before you can add or activate any triggers, you must GRANT GRANT privileges to the user Attempting to add the triggers while you are the user uvsql if you want that user to be able To add triggers, otherwise, you will have to be user uvsql for any trigger activity. I also found you can not have any , * or - in the filename if you want to add triggers to it, If that is the case, you must create a Q pointer to the file with a name that is acceptable. You can not add a trigger to a file that is a q pointer to another directory, UNLESS, you create The Q pointer as a F type Voc entry, and use the full pathname to the files - then it's not Technically a Q pointer, but still behaves like one! These were things that I had the most trouble getting over Also, make sure any files that the trigger program will need are accessable. So if you put a trigger On a file, and the trigger program opens FILE A, and your in Account A - you must make sure that FILE A can be opened in Account A. If you move to Account B and the file that has the trigger on And you have a Q pointer to that file, make sure Account B has access to FILE A otherwise your Trigger program will bomb out. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: Thursday, July 18, 2013 8:33 AM To: U2 Users List Subject: Re: [U2] Universe Triggers Yes. Check out the SQL Reference Manual. The Trigger subroutine has a set defined number of parameters (it's in the doc). We use account type Pick (non-Schema) so a few notes: -Create a new VOC entry named ICATALOG (copy from CATALOG and change attr 6 to INFORMATION.FORMAT). Use this to catalog your Trigger Subroutine. -When we add Triggers to files, we always have all users logged off (paranoid). Here's a sample trigger subroutine (not a real program, only a demo) : SUBROUTINE TRIGGER.EXAMPLE(TRIGGER.NAME,SCHEMA,TABLE,EVENT,TIME, NEW.RECORD.ID,NEW.RECORD,OLD.RECORD.ID, OLD.RECORD,ASSOCIATION,ASSOCIATION.EVENT,COUNT,CHAIN.CASCADE,CASCADE) : OPEN 'AUDIT' TO AUDIT ELSE RETURN : * : UPDATE.TYPE = EVENT[1,1] ; * U,D,I : * : IF NEW.RECORD # OLD.RECORD THEN : READU X FROM AUDIT,NEW.RECORD.ID ELSE NULL : WRITE DATE():*:TIME() ON AUDIT,NEW.RECORD.ID : END : RETURN ; * RETURN TO CALLING PROGRAM :END Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel Jorgenson Sent: Wednesday, July 17, 2013 3:32 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Triggers Has anyone setup and used Unix/Universe triggers. Where do you start? Any manuals to get started? Regards, Dan Jorgenson Senior Systems Analyst SICK, Inc. 6900 West 110th Street Minneapolis, MN 55438 USA Phone: 952.941.6780 Fax: 952.941.9287 Direct: 952.829.4732 http://www.sickusa.com This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use or distribution is prohibited. If you have received this communication in error, please notify us by reply email and immediately and permanently delete this message and any attachments. Thank you. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
Wol: Thanks... that helps a lot. Most of our programs are UniBasic and users get to choose a destination... screen, laser, or greenBar. For some of the legacy script reports... it is a big deal to rewrite them in UniBasic... or problematic to launch these scripts from UniBasic. I do not know how to handle the problem of more than two levels of nested quotes. From the script, cranking in an LPTR1 or calling a UniBasic sub... on a script-by-script basis... is a more flexible fix than the brute force system-wide SETPTR.DEFAULT approach. --Bill Brutzman -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Monday, July 8, 2013 6:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse LPTR On 08/07/13 21:19, Bill Brutzman wrote: Thanks to Martin, Phil, and Anthony. The SETPTR and then SETPTR.DEFAULT is the way to go. I am remembering the ugh when the server is reBoots... the settings vanish. Of course, this LPTR command appears in a legacy script. Perhaps I can insert a little SETPTR 0...etc into the script so that we can bypass the server reboot problem. Comments would be appreciated. Do your users mess about at all with their printer settings? Will they get upset if this script starts messing about with their printer? If you want this printout coming out on the same printer regardless of user, I'd do a SETPTR 1... followed by a LPTR 1 Our rule was always the user's default printer is on unit 0, and it's the one closest to their desk. Any other printer or unit was fair game for the programmer as required. Not knowing your setup, my immediate reaction would be is tampering with the printer going to mess up stuff I don't know about, hence my preference for picking any unit OTHER than 0, and messing about with that. Cheers, Wol --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:57 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, It's in the UV account only. It sets the defaults by copying printer 0 settings into shared memory. To use it, do something like SETPTR 0,1,AT LASER SETPTR.DEFAULT The problem with this is that it isn't saved between UV restarts so you may need to set up a paragraph that runs as the machine is booted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:47 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
From memory it is the first printer in sp.config, which you will have to edit. I think there is also a command SETPTR.DEFAULT which may or may not be relevant. Others will confirm I am sure. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, 9 July 2013 6:36 a.m. To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
On 08/07/2013 19:36, Bill Brutzman wrote: Where can I change the default printer? We have an HP-Ux machine. The default printer is called DEFAULT. That's probably in the DEVICE file. But we never did that. I've always put a SETPTR in VOC LOGIN. But we had a lot of users and a lot of printers, so it read the user's default printer from a config. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
HELP SETPTR.DEFAULT tells you, that you need to be logged into the UV account as root I believe. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, 9 July 2013 6:47 a.m. To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
Hi Bill, It's in the UV account only. It sets the defaults by copying printer 0 settings into shared memory. To use it, do something like SETPTR 0,1,AT LASER SETPTR.DEFAULT The problem with this is that it isn't saved between UV restarts so you may need to set up a paragraph that runs as the machine is booted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:47 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
Thanks to Martin, Phil, and Anthony. The SETPTR and then SETPTR.DEFAULT is the way to go. I am remembering the ugh when the server is reBoots... the settings vanish. Of course, this LPTR command appears in a legacy script. Perhaps I can insert a little SETPTR 0...etc into the script so that we can bypass the server reboot problem. Comments would be appreciated. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:57 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, It's in the UV account only. It sets the defaults by copying printer 0 settings into shared memory. To use it, do something like SETPTR 0,1,AT LASER SETPTR.DEFAULT The problem with this is that it isn't saved between UV restarts so you may need to set up a paragraph that runs as the machine is booted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:47 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
Hi again Bill, You can execute a paragraph when UV is started by arranging to execute UV paragraph.name from the operating system level in the UV account as you bring up the system. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 21:19 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Thanks to Martin, Phil, and Anthony. The SETPTR and then SETPTR.DEFAULT is the way to go. I am remembering the ugh when the server is reBoots... the settings vanish. Of course, this LPTR command appears in a legacy script. Perhaps I can insert a little SETPTR 0...etc into the script so that we can bypass the server reboot problem. Comments would be appreciated. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:57 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, It's in the UV account only. It sets the defaults by copying printer 0 settings into shared memory. To use it, do something like SETPTR 0,1,AT LASER SETPTR.DEFAULT The problem with this is that it isn't saved between UV restarts so you may need to set up a paragraph that runs as the machine is booted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:47 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
Or place a UV.LOGIN paragraph in the UV account's VOC. Everyone logging in will take the setting by default. Regards, LeRoy Sent from my iPhone 4 On Jul 8, 2013, at 4:45 PM, Martin Phillips martinphill...@ladybridge.com wrote: Hi again Bill, You can execute a paragraph when UV is started by arranging to execute UV paragraph.name from the operating system level in the UV account as you bring up the system. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 21:19 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Thanks to Martin, Phil, and Anthony. The SETPTR and then SETPTR.DEFAULT is the way to go. I am remembering the ugh when the server is reBoots... the settings vanish. Of course, this LPTR command appears in a legacy script. Perhaps I can insert a little SETPTR 0...etc into the script so that we can bypass the server reboot problem. Comments would be appreciated. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:57 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, It's in the UV account only. It sets the defaults by copying printer 0 settings into shared memory. To use it, do something like SETPTR 0,1,AT LASER SETPTR.DEFAULT The problem with this is that it isn't saved between UV restarts so you may need to set up a paragraph that runs as the machine is booted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:47 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
On 08/07/13 21:19, Bill Brutzman wrote: Thanks to Martin, Phil, and Anthony. The SETPTR and then SETPTR.DEFAULT is the way to go. I am remembering the ugh when the server is reBoots... the settings vanish. Of course, this LPTR command appears in a legacy script. Perhaps I can insert a little SETPTR 0...etc into the script so that we can bypass the server reboot problem. Comments would be appreciated. Do your users mess about at all with their printer settings? Will they get upset if this script starts messing about with their printer? If you want this printout coming out on the same printer regardless of user, I'd do a SETPTR 1... followed by a LPTR 1 Our rule was always the user's default printer is on unit 0, and it's the one closest to their desk. Any other printer or unit was fair game for the programmer as required. Not knowing your setup, my immediate reaction would be is tampering with the printer going to mess up stuff I don't know about, hence my preference for picking any unit OTHER than 0, and messing about with that. Cheers, Wol --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:57 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, It's in the UV account only. It sets the defaults by copying printer 0 settings into shared memory. To use it, do something like SETPTR 0,1,AT LASER SETPTR.DEFAULT The problem with this is that it isn't saved between UV restarts so you may need to set up a paragraph that runs as the machine is booted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:47 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse LPTR
Of course you could also capture the existing settings with !SET.PTR(-1... And then restore them after all else has been done Just my .02 cents worth :-) Sent from my iPhone On 09/07/2013, at 8:48, Wols Lists antli...@youngman.org.uk wrote: On 08/07/13 21:19, Bill Brutzman wrote: Thanks to Martin, Phil, and Anthony. The SETPTR and then SETPTR.DEFAULT is the way to go. I am remembering the ugh when the server is reBoots... the settings vanish. Of course, this LPTR command appears in a legacy script. Perhaps I can insert a little SETPTR 0...etc into the script so that we can bypass the server reboot problem. Comments would be appreciated. Do your users mess about at all with their printer settings? Will they get upset if this script starts messing about with their printer? If you want this printout coming out on the same printer regardless of user, I'd do a SETPTR 1... followed by a LPTR 1 Our rule was always the user's default printer is on unit 0, and it's the one closest to their desk. Any other printer or unit was fair game for the programmer as required. Not knowing your setup, my immediate reaction would be is tampering with the printer going to mess up stuff I don't know about, hence my preference for picking any unit OTHER than 0, and messing about with that. Cheers, Wol --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:57 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, It's in the UV account only. It sets the defaults by copying printer 0 settings into shared memory. To use it, do something like SETPTR 0,1,AT LASER SETPTR.DEFAULT The problem with this is that it isn't saved between UV restarts so you may need to set up a paragraph that runs as the machine is booted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:47 To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR SETPTR.DEFAULT not in VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Monday, July 8, 2013 2:45 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse LPTR Hi Bill, Take a look at SETPTR.DEFAULT Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: 08 July 2013 19:36 To: 'U2 Users List' Subject: [U2] UniVerse LPTR Where can I change the default printer? We have an HP-Ux machine. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse v11.2 private beta starting next week!
Hi Dan What's new in UV11.2 beta? Or is that not yet public yet? As per the private beta test... :) Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Monday, 20 May 2013 11:40 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UniVerse v11.2 private beta starting next week! Drop a line to u2as...@rs.com or your support partner if you want in. Spots are limited. Dan McGrath Managing Director, U2 Servers Lab Rocket Software ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse v11.2 private beta starting next week!
Hi David, Correct, at this point it isn't public yet. Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Tuesday, May 21, 2013 1:40 AM To: U2 Users List Subject: Re: [U2] UniVerse v11.2 private beta starting next week! Hi Dan What's new in UV11.2 beta? Or is that not yet public yet? As per the private beta test... :) Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Monday, 20 May 2013 11:40 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UniVerse v11.2 private beta starting next week! Drop a line to u2as...@rs.com or your support partner if you want in. Spots are limited. Dan McGrath Managing Director, U2 Servers Lab Rocket Software ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe and ADO connections
[AD] Mike, in response to your question: mv.NET has an ADO.NET-compliant provider called Adapter Objects. It exposes the MV environment as tables, rows, columns, and stored procedures for all CRUD, rather than files, items, attributes, and BASIC programs, respectively. So the ADO.NET developer gets what she/he needs without being a Pick expert. The queries to U2 are pseudo-SQL, rather than being something like SQL-92 compliant. The idea here is that the MV developer(s) collaborate with the .NET developer(s) to craft queries with Where, and OrderBy clauses, where we would normally use WITH and BY. For anything more complex the best approach is to expose a BASIC subroutine as a stored proc, and accept parameters. mv.NET includes Adapter Objects to help keep non-Pick people happy, but also included is Core Objects, which is more of a Pick-like interface. This is a super-set of UO.NET. mv.NET uses UO.NET as a basic lower-level transport and wraps round it a more powerful set of functionality. If you already abstract your UI from the middle-tier and the data (Business Access Layer=BAL, Data Access Layer=DAL...) then replacing existing code should not be a challenge. mv.NET also includes Solution Objects, which generates strongly typed classes - completely abstracting you away from database queries. This will be familiar to those who know NHibernate, CSLA, the .NET Entity Framework, and other ORM tools. You generate collection classes like Customers which encapsulate instances of Customer, and those might have methods like .Save or .UpdateSalesRep. So the mechanics of data access are eliminated and the classes are usable by anyone independent of their experience with RDBMS or Pick. There are also built-in facilities for session pooling, Web Services, Silverlight, and other common requirements. Please feel free to contact me for more information, including mentoring and other services to help with the conversion. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms From: Mike Randall Anyone out there have a list of the various ADO connectors for Universe? I'm looking for pros and cons of the various offerings. We had been using the data provider from IBM and now have Rocket's version. As we have experienced some issues,I need to know what is available as options to possibly migrate our current web applications over to. New management and customer complaints about the web applications are a bad combination. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe and ADO connections
[ad] Hi Mike, FusionWare has an ADO.NET managed provider, as well as an OLE DB driver that works with legacy ADO (MDAC). You can find more information about the managed provider here: http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynxManagedProvider.aspx And there OLE DB driver here: http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynxOLEDBProvider.aspx Please don't hesitate to contact us if you have any questions. Thank you, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Randall Sent: January-23-13 12:20 PM To: 'U2 Users List' Subject: [U2] Universe and ADO connections Anyone out there have a list of the various ADO connectors for Universe? I'm looking for pros and cons of the various offerings. We had been using the data provider from IBM and now have Rocket's version. As we have experienced some issues,I need to know what is available as options to possibly migrate our current web applications over to. New management and customer complaints about the web applications are a bad combination. Thanks in advance. Mike Randall ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe and ADO connections
Tony, As we already have working models, the concern would be things like use of connection (session) pooling licenses, the ability to return datasets directly from Universe (we use SQLDirect) and overall performance. We haven't totally split the tiers but are headed down that path so we'd be close. I would be interested in discussing this further. Mike Randall IT Director Taylored Services www.tayloredservices.com 732-248-7900 x131 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, January 23, 2013 4:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe and ADO connections [AD] Mike, in response to your question: mv.NET has an ADO.NET-compliant provider called Adapter Objects. It exposes the MV environment as tables, rows, columns, and stored procedures for all CRUD, rather than files, items, attributes, and BASIC programs, respectively. So the ADO.NET developer gets what she/he needs without being a Pick expert. The queries to U2 are pseudo-SQL, rather than being something like SQL-92 compliant. The idea here is that the MV developer(s) collaborate with the .NET developer(s) to craft queries with Where, and OrderBy clauses, where we would normally use WITH and BY. For anything more complex the best approach is to expose a BASIC subroutine as a stored proc, and accept parameters. mv.NET includes Adapter Objects to help keep non-Pick people happy, but also included is Core Objects, which is more of a Pick-like interface. This is a super-set of UO.NET. mv.NET uses UO.NET as a basic lower-level transport and wraps round it a more powerful set of functionality. If you already abstract your UI from the middle-tier and the data (Business Access Layer=BAL, Data Access Layer=DAL...) then replacing existing code should not be a challenge. mv.NET also includes Solution Objects, which generates strongly typed classes - completely abstracting you away from database queries. This will be familiar to those who know NHibernate, CSLA, the .NET Entity Framework, and other ORM tools. You generate collection classes like Customers which encapsulate instances of Customer, and those might have methods like .Save or .UpdateSalesRep. So the mechanics of data access are eliminated and the classes are usable by anyone independent of their experience with RDBMS or Pick. There are also built-in facilities for session pooling, Web Services, Silverlight, and other common requirements. Please feel free to contact me for more information, including mentoring and other services to help with the conversion. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms From: Mike Randall Anyone out there have a list of the various ADO connectors for Universe? I'm looking for pros and cons of the various offerings. We had been using the data provider from IBM and now have Rocket's version. As we have experienced some issues,I need to know what is available as options to possibly migrate our current web applications over to. New management and customer complaints about the web applications are a bad combination. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 11.x
Thanks Allen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Friday, December 14, 2012 6:26 PM To: U2 Users List Subject: Re: [U2] Universe 11.x On 12/14/2012 12:16 PM, Oaks, Harold wrote: Universe folks: Who has upgraded from Universe 10.x to Universe 11.x lately? Is it painless? Like - get the users out, install Universe 11.x in 5 minutes, then get the users back in. Then, as time permits, take advantage of the new features within Universe 11.x. Or - is it a big deal to install it? My manager is interested in data encryption in the underlying data. It is my understanding the Automatic Data Encryption (ADE) only exists in Universe 11.x. Is that right? If the install is simple enough, that would seem to be the way to go to obtain this feature for all fields. If you use indexes, check the release to make sure they'll be okay. -- allen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 11.x
If you are planning to use ADE, then please *plan*. As David says, a strategy to manage encryption keys is absolutely necessary, and planning for worst-case scenarios is recommended. 1) Backups - how (and where) do you manage keys.. Do you keep the keys with the data (as an example)? 2) If you needed to retrieve data in 7 years time (e.g. a tax audit) - would you know all the keys - and the passwords - used 7 years ago? 3) Would your successors in the Company know how to obtain - and use - those same keys and passwords? 4) Is it so easy that anyone stealing a backup tape would have the keys and passwords as well? 5) What is the backup / archive strategy when individual keys and/or passwords are added or changed at a point in time? 6) Fully test any DR scenario - use observers from outside the immediate I.T. team to keep it honest: *** Freshly change encryption keys on a file that day - after the last backup - before the failure Is simulated *** Simulate loss of the current system hardware (e.g., fire or flood) *** Simulate loss of key staff - forget what you know. *** Use different hardware - with no previous user IDs created *** Ignore all previous knowledge of keys, passwords and procedures - only work from routinely secured media and stored documentation *** Fresh installation of UniVerse or UniData *** Document every step followed so the post-mortem can check this was an honest test 7) Run a post mortem - use the observers to help appraise the results. *** Did it work? *** Was it TOO easy to unlock data? *** Was it too difficult / time consuming? 8) Run the application(s) and exercise all the files after recovery 9) Re-run the scenario until it works flawlessly 10) Repeat at regular intervals - e.g. annually. Why be so careful? Unlike file corruption (for example) - restore from backup ALONE may not be a solution. It is possible to have your data and for it to still be beyond use. You don't need to feel concerned about using ADE - it has been fairly hammered in a number of scenarios as the consequences of a serious issue are well appreciated. You DO need to plan and be extra careful. Check for any specific advice, issues or notices as a matter of routine diligence. Regards JayJay ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 11.x
Your mileage will vary - the more UV specific features or APIs or the like you utilise - they more issues you're likely to have. As these tend to change at each release. If on the other hand, you have plain vanilla application then you're unlikely to have issues...then all you're doing is project managing your migration to a new host, UV release and performing testing to ensure you configuration, software and end-to-end processes are A-OK afterwards. As with any software release - carefully review the release / technical notes - especially if you have any mind any new feature you wish to use. Caution and clear objectives on how and why you're going to implement ADE is recommended. It's a greatly improved facility over previous versions - with some new features added to dramatically improve it and easy administration. However, never buy or use version 1.x of any software - extra care (and testing) is needed (especially reading the tech / release notes so you're fully aware of known issues - some which can be OS and release specific). Some good test cases for worse cases scenarios for ADE would be recommended too... also think about what would happen if you needed to retrieve encrypted files from backups. Will these same backups include the UV version/keys, etc. that you can restore the data in any unencrypted form? Is the administrative overhead of maintaining a ADE database files really worth it? Would OS-level filesystem encryption be a better choice? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Saturday, 15 December 2012 4:16 AM To: U2 Users List Subject: [U2] Universe 11.x Universe folks: Who has upgraded from Universe 10.x to Universe 11.x lately? Is it painless? Like - get the users out, install Universe 11.x in 5 minutes, then get the users back in. Then, as time permits, take advantage of the new features within Universe 11.x. Or - is it a big deal to install it? My manager is interested in data encryption in the underlying data. It is my understanding the Automatic Data Encryption (ADE) only exists in Universe 11.x. Is that right? If the install is simple enough, that would seem to be the way to go to obtain this feature for all fields. Thanks- Harold Oaks Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 11.x
Ah ha ha ha ha ha ha ha ha ha ha ha *crash* -Original Message- From: Oaks, Harold harold.o...@clark.wa.gov To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Dec 14, 2012 9:16 am Subject: [U2] Universe 11.x Universe folks: Who has upgraded from Universe 10.x to Universe 11.x lately? Is it painless? Like - get the users out, install Universe 11.x in 5 minutes, then get the users back in. Then, as time permits, take advantage of the new features within Universe 11.x. Or - is it a big deal to install it? My manager is interested in data encryption in the underlying data. It is my understanding the Automatic Data Encryption (ADE) only exists in Universe 11.x. Is that right? If the install is simple enough, that would seem to be the way to go to obtain this feature for all fields. Thanks- Harold Oaks Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 11.x
What I meant to say is, No, you can't do it in five minutes. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 14, 2012 9:29 am Subject: Re: [U2] Universe 11.x Ah ha ha ha ha ha ha ha ha ha ha ha *crash* -Original Message- From: Oaks, Harold harold.o...@clark.wa.gov To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Dec 14, 2012 9:16 am Subject: [U2] Universe 11.x Universe folks: Who has upgraded from Universe 10.x to Universe 11.x lately? Is it painless? Like - get the users out, install Universe 11.x in 5 minutes, then get the users back in. Then, as time permits, take advantage of the new features within Universe 11.x. Or - is it a big deal to install it? My manager is interested in data encryption in the underlying data. It is my understanding the Automatic Data Encryption (ADE) only exists in Universe 11.x. Is that right? If the install is simple enough, that would seem to be the way to go to obtain this feature for all fields. Thanks- Harold Oaks Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 11.x
I have done it 10 or more times on AIX, now without issue. Make sure you use the latest version of 11.x, earlier ones had some problems. To make for an easy rollback in case of problems, I always make copies of the uv and unishared directories before starting. This way if there is a problem, you can quickly go back. Also suggest you test your login and the Rocket Customer support site before starting, since you will need to authorize the new release. -- Carl Dula Voice: 973-227-8440 X111 Pulsar Systems, Inc.Fax: 973-227-8440 271 US Highway 46, STE H209 email:c...@pulsarsystems.com Fairfield, NJ 07004-2474http://www.pulsarsystems.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 11.x
On 12/14/2012 12:16 PM, Oaks, Harold wrote: Universe folks: Who has upgraded from Universe 10.x to Universe 11.x lately? Is it painless? Like - get the users out, install Universe 11.x in 5 minutes, then get the users back in. Then, as time permits, take advantage of the new features within Universe 11.x. Or - is it a big deal to install it? My manager is interested in data encryption in the underlying data. It is my understanding the Automatic Data Encryption (ADE) only exists in Universe 11.x. Is that right? If the install is simple enough, that would seem to be the way to go to obtain this feature for all fields. If you use indexes, check the release to make sure they'll be okay. -- allen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.2
Harold: Universe 10.2 EOM was September 30, 2010. U2logic is a Rocket Software VAR. We have this question all of the time when it comes time to paying maintenance. Regards, Doug www.u2logic.com Tools and applications for Unidata and Universe On Fri, Nov 30, 2012 at 12:42 PM, Oaks, Harold harold.o...@clark.wa.govwrote: We are running Universe 10.2. I know 11.x has been out quite a while. Does anyone know if there is a planned end-of-support for 10.2? Thanks- Harold Oaks County IT Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.2
Hmmm so all those who are still on 10.2 should stop paying for it :) -Original Message- From: Doug Averch dave...@u2logic.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Nov 30, 2012 12:27 pm Subject: Re: [U2] Universe 10.2 Harold: Universe 10.2 EOM was September 30, 2010. U2logic is a Rocket Software VAR. We have this question all of the time when it comes time to paying maintenance. Regards, Doug www.u2logic.com Tools and applications for Unidata and Universe On Fri, Nov 30, 2012 at 12:42 PM, Oaks, Harold harold.o...@clark.wa.govwrote: We are running Universe 10.2. I know 11.x has been out quite a while. Does anyone know if there is a planned end-of-support for 10.2? Thanks- Harold Oaks County IT Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse on a Windows Virtual Server
Hi Jerry: We have been running internally Universe on Windows 2008R2 using the 32 bit version for years. We have found that occasionally we have a run away uv process that consumes the machine. We keep either a Process Explorer window open or Window Task Manager to kill the run away processes, because you cannot get them to start on the Windows VM side. We have not used 10.3 release in so long we cannot say except it is better to be current. We have client that is using Universe 11.3 on Windows 2008R2 and is not experiencing any issues. Disk I/O is shared so their is a speed hit which we notice on large files. We have just configured a replacement machine with a SSD on it. We think the speed increase will more than offset the VM shared resource issues. Good Luck, Doug www.u2logic.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse on a Windows Virtual Server
Our customers have been running universe 10.3 on Windows 2008 R2 without any issues. On the virtualisation side we have had customers who moved to a virtual environment and experienced a drop in the performance of universe database. We ran our own test internally and could not get the same performance out of the same machine virtualized compared to bare metal. In some processes on large files the time to complete the process doubled. I would suggest that you run some performance tests on your virtual environment first to see if you are happy with the results and that your application runs at an acceptable level. Measure your processes in a virtual environment and then measure in a non virtual. It is up to you and your customers to what an acceptable level of performance is. Regards Adrian Halid -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: Thursday, 22 November 2012 3:13 AM To: U2 Users List Subject: Re: [U2] UniVerse on a Windows Virtual Server Hi Jerry: We have been running internally Universe on Windows 2008R2 using the 32 bit version for years. We have found that occasionally we have a run away uv process that consumes the machine. We keep either a Process Explorer window open or Window Task Manager to kill the run away processes, because you cannot get them to start on the Windows VM side. We have not used 10.3 release in so long we cannot say except it is better to be current. We have client that is using Universe 11.3 on Windows 2008R2 and is not experiencing any issues. Disk I/O is shared so their is a speed hit which we notice on large files. We have just configured a replacement machine with a SSD on it. We think the speed increase will more than offset the VM shared resource issues. Good Luck, Doug www.u2logic.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
