Re: [U2] Read yourself
There are @ commands that can get this stuff. Or read the cat pointer. John Israel Sent from my iPhone On May 12, 2014, at 7:39 PM, Wjhonson wjhon...@aol.com wrote: The program does not inherently know that it's in a file called BP. And it does not know it's own (value of) PROG.ID unless it can find it out somehow. -Original Message- From: Adrian Overs ove...@citysoft.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, May 12, 2014 4:33 pm Subject: Re: [U2] Read yourself What problem are you trying to solve by doing so? After all it's not rocket science (pardon the pun) to OPEN BP TO BP.FV THEN READ R.PROG FROM BP.FV, PROG.ID ELSE ... Whatever END Sent from my iPad On 13 May 2014, at 6:54 am, Wjhonson wjhon...@aol.com wrote: Does anyone have a BASIC program, that will open it's own code in a variable ? So something like this GOSUB RETURN.A.LOCAL.FILE.AND.KEY.FOR.ME READ THIS.PROGRAM FROM F.LOCALFILENAME, K.PROGRAMKEY the program reads itself. Does anyone have a program like that? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCMUSyOqejhOqemhNEV7e6XCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsSe847QhPb_nV5BZZAQsZuVtd5ZPATTD67KmKDp55mVEVvVkffGhBrwqrhdICXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3P3xI5-Aq83iS4QPiWq80n-E6y0JlKdfftdFFCW--6tgnb718Y ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr6jqb9EVd79EVp76zAsUrKrhKyC_t6WpEVdEThjvKyCyqejqdQkTXETpKrhKyCqenSm63hOr4qAUiF7vf1i6BFRxhJrUOH7BPq6BFRxhJrUOH7BPoUwgvh7cLZvAmnTSjhPRXBQQnTejvusouVqWtAklrCzB_BgY-F6lK1FJcSOrKrKr01DOFeDNc_7CQSOf00s4RtxxYGjB1SKdFBSWv6xJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dIfce6MnWhEwdbojjdbFEw1vWwq82RmUQYZQSCCrHzJY ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPoQ93hJ5AQsCzAQsIzzhOesdTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVIsg8fEzCn-LObbXX9EVWZOWqbXD9LLecfsJteOaaJPhO_OEuvkzaT0QSOrpdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CS7C73obZ8Qg6BI9FCBQQg0LZgd41qHsquuWrjjdPC62kJ0KQBUS ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] My XML is Chinese!?!
Another point to make about IE. It renders the XML in a nice and clean format but it is NOT exactly what is in the XML file. I often use IE to look at XMLs quickly but to see what is REALLY in the file, I also use NotePad++. In fact, I am doing this stuff right now for issues in Panama. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: Friday, May 09, 2014 10:15 AM To: U2 Users List Subject: Re: [U2] [OT] My XML is Chinese!?! I suspect I know what is happening, though I can't tell you WHY. The view source function is using an encoding that doesn't match your actual file. For example the view source may think its using UTF-16 for some reason, but since its really using UTF-8 the characters are all mangled. Its just a guess. I would recommend saving the file to disk and the use another editor like notepad++ which can tell you what the file encoding is. This is likely just a bug in IE 11. There are so many better editors out there for xml data, I would just use one of those instead. On Fri, May 9, 2014 at 10:05 AM, George Gallen ggal...@wyanokegroup.comwrote: OKI've got a strange thing happening on my Win 7 IE 11 If I use IE 11 to open an XML file - it renders fine - no problems. BUT...if I right click and choose View Source - all I see are Chinese characters? I know the XML is plain text and no extended codes And it only happens on my machine, if I use another PC same setup (except IE 9) It shows English when you view Source HTML renders fine, and View Source for HTML displays English. My XML declaration line looks like: ?xml version=1.0 encoding=utf-8 ? Firefox view source displays English, as does Chrome and Safari - It's just IE11 doing it. Any Ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/FZsScz8Q76QmjhOqen663hPtcTsSzt5d-WdQPhOrhKyC_t5 d4QsCQrEFLThKPsSzt5cQsLIIc6zAS8R9MBie-u2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbC Tfj-Pzb_nV5VNNfHTbFIILYOMPtPBHFShhlLt7BgY-F6lK1FJ4SCrKrKr01DOFeDNc_7CQ SOf00s4RtxxYGjB1SKdFBSWv6xJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dLKcL6MnWhE wdbojjdbFEwdboo19Ftd40Smd4033old44G6y0i9OxZfd498QgCSm3oq92Ih2HfCnF ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/1jWVIg3xASyOqejhOUMMqerFCXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsSVWvSspvW_8Lee9ZuVtdBB_Cm6rKsJteOaaJXEYG7DR8OJMddFCQPtPtPo0c-l9Q-9DUYSCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JZNBUS2_id41Fr2qpFtd41Fr309dbFEw6ONEw0or2FEwBgQg2hekfFVEx96y4SOMrci9G ___ 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]
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]
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] jobnotify: Error 913 occurred
No idea what that is. John Israel Sent from my iPhone On Mar 19, 2014, at 11:39 PM, Leverett, Brendon brendon.lever...@spotless.com.au wrote: Nearly one week and no responses... Do I assume no one encountered the 'jobnotify: Error 913 occurred' message or has any knowledge of it. Regards, Brendon Leverett From: Leverett, Brendon Sent: Friday, 14 March 2014 11:09 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: jobnotify: Error 913 occurred We have recently upgraded Universe (10.2.4 to 11.1.15) and are now finding some unusual activity around phantom jobs and the documented change to NOTIFY ON. There are a lot of details behind the scenes but in summary: - started a job via phantom command (phantom SYNC.COPY.BNET) - noticed 90 mins later that this job had crashed. This crash happens for various reasons but is more frequently crashing since the upgrade - restarted the same job with the same phantom command At this time the following 3 lines of text was returned to the user's session: jobnotify: Error 913 occurred [15466830] SYNC.COPY.BNET - terminated Phantom process started with process ID 33161456 Seems the 1ST 2 lines of text related to the previous phantom and 3rd line related to the phantom just started. My Q is: Does anyone have any ideas about the specific message jobnotify: Error 913 occurred We are running on AIX. Regards, Brendon Leverett ** This email message and any files transmitted with it may be confidential and privileged neither of which is intended to be waived. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://cp.mcafee.com/d/5fHCNASyOqenQTD1NEVvdTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVLrIKqCO_R-hsuvjjuWZOW9EV7esC---CU_ORQX8FGTd7b7axVZicHs3jq9JcTsTsS02EJmp_QFO_qSrrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jryr3NI5-Aq83iS4QPiWq816F25pOtb96y0qz6Ijh0qekmjh1mRCUNZ0SOYrTRJo Please consider our environment before printin g this email. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/avndxMsd38srhpd7bWrPwUQsLCXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTJSndjpvW_8KffFFLtuVt4QszDejvvvjsvVqWtAkRrCzBzBgY-F6lK1FJcSCrKrKr01DOFeDNc_7CQSOf00s4RtxxYGjB1SKdFBSWv6xJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dK9If6MnWhEwdbojjdbFEw4qA8lD9QIAq81GcqNd41EVhpd45rmrz7Q3rbNLzkJuGcbvvfF ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ED: The very finest of 1970s technology! was: UniVerse Dictionary question
ABSOLUTELY!!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, February 06, 2014 11:27 AM To: U2 Users List Subject: Re: [U2] ED: The very finest of 1970s technology! was: UniVerse Dictionary question But you left out THE ABSOLUTE most important feature OOPS George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Thursday, February 06, 2014 4:49 AM To: U2 Users List Subject: [U2] ED: The very finest of 1970s technology! was: UniVerse Dictionary question it's been that way for, oh I dunno, going back to PI, 30+ years? That's in input mode. Here are some related ED facts about edit-mode that I've found Pickies (vs. Primates) don't seem to know: Rspace enter replaces current line with a blank line. Ispacethis is some textenter will insert a line this is some textbut leave yoiu in edit-mode, not insert-mode. IB will put you in input mode BEFORE the line you're on. IBspacethis is a some textenter will insert a line this is some text BEFORE the current line but leave yoiu in edit-mode, not insert-mode. There is a bit of an inconsistency with IB: IBspacespaceenter Inserts a blank line BEFORE current line. I don't know why 2 spaces are needed. Oh, well. Renter repeats the previous full-line Replacement Center repeats the previous Change command. R this is some textenter replaces thw whole line. R/ABC/XYZ is really C/ABC/XYZ So if you pickies are used to saying R/ABC/XYZ/ That is really a Change command, C/ABC/XYZ. So subsequent Center will repeat your R/ABC/XYZ/ Finally, there is the actually helpful HELPenter command. (Check out HELP SEQenter.) AE aficionados may quibble over the ED motto, The very finest of 1970s technology! cds On 2/6/2014 4:24 AM, Clif Oliver wrote: 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
Re: [U2] Time for a Redback upgrade ?
I found that WWSTATE was not being cleaned up well. I wrote my own program to clean things up every night (GARBAGE.COLLECT2). It run from cron every night and cleans up everything: WWSTATE, SAVEDLISTS, and other files unique to our application. It also archives things as needed. It keeps things running fairly tightly. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ladd, Ryan Sent: Wednesday, January 22, 2014 2:22 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Time for a Redback upgrade ? My understanding (and others please correct me if I am wrong) is that the WWSTATE table is one of 3 things the Redback garbage collection cleans out (WWSESSION and some SavedLists are the other two). You can manually run a garbage collection from the RB.ADMIN menu I mentioned before. You can also inspect the logs from previous garbage collections using a different option on the menu. If the Redback garbage collection isn't running, then that is most likely the cause for your slowness. Planning some downtime and re-sizing the WWSTATE table and looking at your garbage collection parameters is probably something to consider, even after you get garbage collection running again. Ryan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, January 22, 2014 12:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Time for a Redback upgrade ? Ryan thanks for that. Our WWSTATE file is indeed poorly sized Is this something we are supposed to be periodically clearing out ? Or is some garbage collection process broken that supposed to be clearing these old entries? -Original Message- From: Ladd, Ryan ryan.l...@meritain.com To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Jan 22, 2014 9:35 am Subject: Re: [U2] Time for a Redback upgrade ? Here are some suggestions. -use showrgw and perfrgw to inspect your responders and their response time. -check your Redback Garbage Collection (RB.ADMIN, option 2) settings and logs. Additionally, check the WWSTATE table to ensure it is sized appropriately. If that table is poorly sized, your response time will suffer. -turn on more verbose logging and inspect the output of rgw.log (this requires a bounce of redback, so this may or may not be possible depending on your uptime requirements). There are more things to look at, but these should at least give you a chance at looking in the right direction. Ryan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, January 21, 2014 6:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] Time for a Redback upgrade ? We are Running Redback 4.4.0.1526 Build 1527 which is stamped 29 May 2007 This is running on Windows Server 2008 R2 Standard We've lately been experiencing odd slowness. Any tricks to where I should look first to try to narrow the possibilities of why? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/1jWVIp4xEg6jqb9EVKMyY-OYrKrhKyC_t6WpEVdEThjvKyCyqejqdQkTXETpKrhKyCqenSm63hOr4qAUiF7vf1i6BFRxhJrUOH7BPq6BFRxhJrUOH7BPuKqzvQT-LOoVxUsyeWZOWq9EV7sNtUQsLCzAtORQr8FGEEKsG7DR8OJMddECS3tPtPo0c-l9Q-9DUYSCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09IsCYyr1vF6y0QJxdcQKCy04OlYQgeRyq8dd40bZ0xJyFEwrm8NR3Ph0idTdOb-uosbyZRAw 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://cp.mcafee.com/d/5fHCN0i4zqb9EVKMyY-OYrKrhKyC_t6WpEVdEThjvKyCyqejqdQkTXETpKrhKyCqenSm63hOr4qAUiF7vf1i6BFRxhJrUOH7BPq6BFRxhJrUOH7BPuKqzvQT-LOoVxUsyeWZOWq9EV7sNtUQsLCzAtORQr8FGEEKsG7DR8OJMddFCS3tPtPo0c-l9Q-9DUYSCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09IsCYyr1vF6y0QJxdcQKCy04OlYQgeRyq8dd40bZ0xJyFEwrm8NR3Ph0idTdVhTV1mjpwIqJ ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] Time for a Redback upgrade ?
Our application, which I inherited, stores each user's login with a GUID in WWSTATE. Every time you go to a new web page, it checks the date/time stamp and as long as it is within the defined time, it updates the time stamp and lets you continue, otherwise it logs you out. Knowing this, I build SAVEDLISTS using the user's GUID as part of the key. When my GARBAGE.COLLECT2 runs in the middle of the night, it looks for WWSTATE records that have exceeded the time limit, and deleted the offenders. When I get to the SAVEDLISTS, if the GUID in the SAVEDLIST has been removed from WWSTATE, I know the SAVEDLIST is also obsolete and delete it as well. Other things follow this concept. Since we have very little activity in the middle of the night, and that is when GARBAGE.COLLECT2 runs, these files tend to get cleared out each night, and if not totally cleared, then 95% or better. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, January 22, 2014 4:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Time for a Redback upgrade ? On 22/01/14 19:27, Israel, John R. wrote: I wrote my own program to clean things up every night (GARBAGE.COLLECT2). It run from cron every night and cleans up everything: WWSTATE, SAVEDLISTS, and other files unique to our application. It also archives things as needed. It keeps things running fairly tightly. With regard to SAVEDLISTS, look at the LOGIN and ON.EXIT verbs, along with GET.STACK and SAVE.STACK. In the days of network logins, personal stacks now seem to multiply like tribbles. These will allow you to get back the way it was supposed to be, one stack per person. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCMUedEICzCX2rVEVs76XCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTXwVC_FLZvC7Am3hOY_RXBQhPaf3HFLefEYJt6OaaJQSul3PWApmU6CQjq9KVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SO-M-r1vF6y0QJxdcQKCy04OlYQgeRyq8dd40bZ0xJyFEwrm8NR3Ph0idTdDm6H ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] No mail since Friday
Got it -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, January 14, 2014 2:34 PM To: u2-users@listserver.u2ug.org Subject: [U2] No mail since Friday I have seen no traffic at all since Friday the 10th. I find it hard to believe. Is the list down? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPosrhpud78VdWX3VKVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundE9ECzBZ1d_HYVt5OXX_nKnh76zBzzhOMVtBZDBHEShjlKC_OEuvkzaT0QSyrhdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CSnSmjpFr2qpFtd41Ew1Bjh09Cy2AEmYQg2Yp8qmdTdLWCi6q3sK6sq ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Very OT] XP File Dialog Box
If you plan to go to Windows 7, you better move fast. Microsoft announced that the company discontinued the distribution of retail copies of Windows 7 at the end of October 2013. Microsoft had previously listed that date as October 31, 2014, but changed that information. http://www.foxnews.com/tech/2013/12/10/microsoft-ends-windows-7-retail-sales-directs-consumers-to-windows-8/ JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, December 12, 2013 3:09 PM To: U2 Users List Subject: Re: [U2] [Very OT] XP File Dialog Box I use Firefox, but it happens in all browsers. It also happens in programs like Adobe PDF reader, Foxit PDF reader, Open Office, Notepad, Notepad++, etc. None of these have anything to do with a browser, so I'm pretty sure it isn't browser related. I also know that XP is very outdated, but I won't be moving to Win7 until next year. Thanks, Charlie On 12-12-2013 1:57 PM, George Gallen wrote: Does it happen in all browsers? Or just IE and which version of IE are you using? If your using IE10 or IE11, have you tried to run it in compatibility mode? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, December 12, 2013 2:50 PM To: U2 Users List Subject: Re: [U2] [Very OT] XP File Dialog Box Pretty much anything I do in Win XP, in a browser and any other program which uses the file dialog box. On 12-12-2013 1:43 PM, George Gallen wrote: Do you mean when you browse for a file from HTML using Windows XP? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, December 12, 2013 2:39 PM To: U2 Users List Subject: [U2] [Very OT] XP File Dialog Box I realize this is an unusual place to post this request, but it's driving me crazy and I'm hoping someone here can help. Just about every time I use the XP file dialog box to open or save a file, it scrolls multiple times when I click in the horizontal scroll bar. Has anyone seen this behavior and know what to do about it? Thanks, Charlie Noah Tiny Bear Wild Bird Store Home of Safety Net Shipping http://cp.mcafee.com/d/avndxNJ5BVNUsYqehP9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundSt78XGr_nVMsqen4SuLsKy-OeV55BMsUZORQr8EGTssVkffGhBrwqrhdK6XCXCM0g9B0Ic_Ig5AuwcOywcjH7-ndJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JN4sUr1vF6y0QJxdcQKCy0QJxDUBzh060iqnjh00Mmd40L8_Ph07iQ-F4Qg3dgYTsTzT5gCIMtZk1 Toll Free: 1-855-TinyBear (855-846-9232) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCN0g3xEpdEILef3DzhOepdTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVKPEV7tjvW_e3zhOUCPRXBQnShT8EIK3D7KmKzp55mXzDaxVZicHs3jqpJMTsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rsh7e6MnWhEwdbojjdbFEwdbop-9oQg1w4CBQQg0c5zh0bOfYQg1QJfGhd40PkfdTd-rRa2S9S ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr3zqbbPzMVUQszCjtPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejozkD2l8XVUagQJeIadHv6loYKrgQJeIadHv6loYKrIWehTkT-LPwUQsK9IZuVt5ZAtOabbwVNXBHEShhlKUVOEuvkzaT0QSOrsdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CT4hPxI5-Aq83iS4QPiWq83iS6vymd40o19Ftd4031oQg2Yz_d40tbjWAjh0cR3PtPpeiiDnOf ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPoQcz8Qrhpusu7f6zAsOrKrhKyC_t6WpEVdEThjvKyCyqejqdQkTXETpKrhKyCqenSm63hOr4qAUiF7vf1i6BFRxhJrUOH7BPq6BFRxhJrUOH7BPtDhOeWC_R-s76zBNdDHTbELIzKhhps7efsJt6OaaJT7el3PWApmU6CS3rxKVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SUyesdwLQzh0qmMCCqnjh0qmMPYiNEw309dbFEw0ob6y0nAvVEw3Fqvkyq81CEurKrDpmyIdpy466T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/1jWVIgdEILef3DzhOepdTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVKPEV7tjvW_e3zhOUCPRXBQnShT8EIK3D7KmKzp55mXzDaxVZicHs3jrVJMTsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rsh7e6MnWhEwdbojjdbFEwdbop-9oQg1w4CBQQg0c5zh0bOfYQg1QJfGhd40PkfdTdFdTsX0cp ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/avndxMQ938srhpusu7f6zAsOrKrhKyC_t6WpEVdEThjvKyCyqejqdQkTXETpKrhKyCqenSm63hOr4qAUiF7vf1i6BFRxhJrUOH7BPq6BFRxhJrUOH7BPtDhOeWC_R-s76zBNdDHTbELIzKhhps7efsJt6OaaJT7el3PWApmU6CT3rxKVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SUyesdwLQzh0qmMCCqnjh0qmMPYiNEw309dbFEw0ob6y0nAvVEw3Fqvkyq81CEurKrFM4WP1oB
Re: [U2] Mysterious Error Message
I have rebuilt the checksums on the user and for the accounts in DMSECURITY. This has been escalated to Rocket. Thanks for all the help - I will post the solution when I get it. This has put a REAL cramp in our making changes. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, November 26, 2013 5:04 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message If I recall, the checksum itself is account specific. So if the checksum were being calculated for one account but accessing sb resources/processes from another, could that be triggering the checksum mismatch? On Tuesday, November 26, 2013, Israel, John R. wrote: Kevin, This is a temporary situation for testing an unrelated issue. When THAT issues is resolved, I will go back to a single, common DMSECURITY. This is NOT the problem - PILOT and LIVE are both using the same DMSECURITY file - PILOT has the problem, but LIVE does not. The problem is either a local file OR something in DMSECURITY that itself is account specific. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org javascript:; [mailto: u2-users-boun...@listserver.u2ug.org javascript:;] On Behalf Of Kevin King Sent: Tuesday, November 26, 2013 9:52 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Is there a particular reason you can't share that DMSECURITY file across all SB enabled accts? On Tuesday, November 26, 2013, Israel, John R. wrote: Kevin, I did an ESEARCH on the DM file, looking for E115. I did not find it in MM, but did find it in the following: _SB.GENERAL.S _SB.LOGIN _SB.SYSMENU _SB.USER.CHECK I did not find it in _MM, but this still looks like progress. I do not have access to SB source code, but at least this is something I can send back to Epicor, who can hopefully get with Rocket. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, November 26, 2013 12:36 AM To: U2 Users List Subject: [U2] Mysterious Error Message John, look for [E115]. That's how the error will appear in the SB+ routines. I'm guessing that the problem is that RB is connecting to SB through the install accounts but DMSECURITY is being referenced locally, hence the checksum mismatch. On Monday, November 25, 2013, Israel, John R. wrote: Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my t jr 3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKYuT ___ U2-Users mailing list U2-Users
Re: [U2] Mysterious Error Message
Kevin, I did an ESEARCH on the DM file, looking for E115. I did not find it in MM, but did find it in the following: _SB.GENERAL.S _SB.LOGIN _SB.SYSMENU _SB.USER.CHECK I did not find it in _MM, but this still looks like progress. I do not have access to SB source code, but at least this is something I can send back to Epicor, who can hopefully get with Rocket. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, November 26, 2013 12:36 AM To: U2 Users List Subject: [U2] Mysterious Error Message John, look for [E115]. That's how the error will appear in the SB+ routines. I'm guessing that the problem is that RB is connecting to SB through the install accounts but DMSECURITY is being referenced locally, hence the checksum mismatch. On Monday, November 25, 2013, Israel, John R. wrote: Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNEp4zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVd EThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63h OOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrhdFCXCXCM0pY GjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr 3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKnZbpJhF-VsH ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCN8i6zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVd EThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63h OOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrjdFCXCXCM0pY GjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr 3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKYuT ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCMUi3zqbbPX332b39KVJ6WarZQrFCzASzt5d-Waq9EVd
Re: [U2] Mysterious Error Message
Kevin, This is a temporary situation for testing an unrelated issue. When THAT issues is resolved, I will go back to a single, common DMSECURITY. This is NOT the problem - PILOT and LIVE are both using the same DMSECURITY file - PILOT has the problem, but LIVE does not. The problem is either a local file OR something in DMSECURITY that itself is account specific. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, November 26, 2013 9:52 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Is there a particular reason you can't share that DMSECURITY file across all SB enabled accts? On Tuesday, November 26, 2013, Israel, John R. wrote: Kevin, I did an ESEARCH on the DM file, looking for E115. I did not find it in MM, but did find it in the following: _SB.GENERAL.S _SB.LOGIN _SB.SYSMENU _SB.USER.CHECK I did not find it in _MM, but this still looks like progress. I do not have access to SB source code, but at least this is something I can send back to Epicor, who can hopefully get with Rocket. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, November 26, 2013 12:36 AM To: U2 Users List Subject: [U2] Mysterious Error Message John, look for [E115]. That's how the error will appear in the SB+ routines. I'm guessing that the problem is that RB is connecting to SB through the install accounts but DMSECURITY is being referenced locally, hence the checksum mismatch. On Monday, November 25, 2013, Israel, John R. wrote: Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list http://cp.mcafee.com/d/5fHCN8i6zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq 9EVd EThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA6 3h OOqekT
[U2] Mysterious Error Message
We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mysterious Error Message
Sorry for the typo. We thought of looking for the program giving the error. We do not have the source code for it, so even if we found it as a string, we could not read the rest of the object code. Even so, I have tried doing an ESEARCH on some of the SB files, but I have yet to find it. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, November 25, 2013 11:57 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Given that Corrupt is missing a T (itself being corrupt?) I would think it's not an OS related message. Since your HPUX, can you do a file content find in unix for RECORD CORRUP! to find out where it's coming from? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 11:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr3x0p41ASyOY-OqenD4kPtPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejozkD2l8XVUagQJeIadHv6loYKrgQJeIadHv6loYKrovhupd7ar_nVeZT3hOU_RXBQQhP79Lcnd7bXDbnhIyyHuWfaxVZicHs3jq9JcTsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rvjpd79I5-Aq83iS4QPiWq81IJivNBlKxEw6ENH4Qg3vQFF7PtPvrjguueZ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNAq3zqbbPX9EVushjdTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVJxZ5VAQsFLZvAXTsd7bz_nKnjh7csCYNsQsLKsJt6OaaJXEYG7DR8OJMddFCQPtPtPo0c-l9Q-9DUYSCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JZdAQsCMnWhEwdbojjdbFEw6OR9_6lmW6y0qz6Ijh0d_iCAvdTdTg5hgbhsZS93 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mysterious Error Message
Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNEp4zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63hOOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrhdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKnZbpJhF-VsH ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCN8i6zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63hOOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKYuT ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mysterious Error Message
Dave, Yes, I understood (or assumed) that the II was the SB+ system, just not WHY it thought something was corrupt. I found the error message just like you said in DMCONT ERROR. I have never seen this before. The record looks like a bunch of generic error messages that can be used as needed. I just tried logging in as rbadmin (the Redback UNIX id), cd'ed over to the TEST.DATA account, typed udt, then used the iConnect login/pw for SB. I got in just fine. Not sure if that was a good thing or a bad thing. Now the question is: what conditions are occurring via the web site (w/ the error) that I have not been able to replicate manually? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Monday, November 25, 2013 1:39 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message II is whatever SB+ system it is logging into. Whatever SB+ user is being used to log in doesn't have access to the account. The message is stored in the ERROR item of the DMCONT file - attribute 115 - so you won't find that using ESEARCH on a BP file. Haven't used redback so I don't know what that uses to log into SB. Have used remote processes though - and get these kinds of errors sometime if the user or group security tree doesn't allow us to get into where we are trying to go. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 1:28 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNEp4zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63hOOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrhdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKnZbpJhF
Re: [U2] Mysterious Error Message
Amy, Yes, both look good. Based on the 1st word in the message (II), this really looks like a SB error. I get NO errors if I login manually using the Redback UNIX login, cd to the TEST account, launch UniData (udt), and type in the iConnect login/pw. That is as close to simulating iConnect as I can think of. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:40 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message is WW.SB.RB cataloged in pilot and test? Is BP IILOGIN the same? If yes to both, take redback out of the picture, along with the screen changes (it's not making it to the screen yet...) Do you get the same message when you login through SB+, with the same user that the iConnect agent logs in with? (make sure that user group is allowing it to get into the pilot/test accounts) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 10:28 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNEp4zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63hOOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrhdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKnZbpJhF-VsH ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCN8i6zqbbPX5SnNO9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79IhGjxaAtYY58qmDm56RLzaIundEqmDm56RLzaIundFA63hOOqekT-LPatNPb9EVWZOW9EVhpVwsqemm3hOPORQr8FGTspVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3wVUS2_id41Fr2qpFtd40SmFfUOGTgQg3koRyq81LWkQzVKVKYuT
Re: [U2] Mysterious Error Message
Amy, Yes, I am using iConnect's SB login/pw as soon as UniData/SB launches and I get right in. I looked at the date stamp on the iConnect data and it has not been touch in a LONG time. What is different between this and running it on-line? Since I can get in that way w/o any problems, why is SB thinking there is a problem? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 2:39 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Yes, agreed. So you're using the sb+ uid/pw of the iconnect service manager? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 11:36 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Amy, Yes, both look good. Based on the 1st word in the message (II), this really looks like a SB error. I get NO errors if I login manually using the Redback UNIX login, cd to the TEST account, launch UniData (udt), and type in the iConnect login/pw. That is as close to simulating iConnect as I can think of. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:40 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message is WW.SB.RB cataloged in pilot and test? Is BP IILOGIN the same? If yes to both, take redback out of the picture, along with the screen changes (it's not making it to the screen yet...) Do you get the same message when you login through SB+, with the same user that the iConnect agent logs in with? (make sure that user group is allowing it to get into the pilot/test accounts) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 10:28 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through... RedBack is using an iConnect agent to login through SB+ and execute the screen. That message is an SB+ message. So...my first question would be - are the LOGIN paragraphs the same between accounts where it's working and where it's not? The 2nd would be - is the iconnect Agent, as defined the Site setup the same between sites? Is that agent enabled? (I'm assuming the backend iConnect accounts are shared per realm?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 8:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any
Re: [U2] Mysterious Error Message
Amy, I do have a pointer to ECL_PHPARMS. Putting a DEBUG in IILOGIN would not work for StoreFront because have no session to interact with the debugger, just a browser. However, that gives me a few idea. I build a log that tracks how far I get and when I fail to get to a certain point, narrow my search around there. Might still bang into a program that I have no source to, but it's a start. Let me do some more digging. What I really need is to know which program is read and using DMCONT ERROR F115! From that, I could back track to the problem. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 4:40 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message We The difference is, when you come in through RedBack it's using the agent itself, so it sees it as a phantom user. It may be easiest to stick a debug in IILOGIN - check around line 46 (in our version), for comment: 'Check for iConnect Phantom processing'. This would also make sense in that both test and pilot in the same realm are not working, since IILOGIN is in BP. However...if you already compared live to pilot, then I guess that goes out the window. Any chance your VOC pointer to ECL_PHPARMS is missing? I think that all those pointers are established when you 'share' the data account from either the iconnect progs account or the dfl-progs account, but I don't remember which. Assuming you retained your VOC when you created your test/pilot accounts, that should not have changed. But it's something to look at... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 11:54 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Amy, Yes, I am using iConnect's SB login/pw as soon as UniData/SB launches and I get right in. I looked at the date stamp on the iConnect data and it has not been touch in a LONG time. What is different between this and running it on-line? Since I can get in that way w/o any problems, why is SB thinking there is a problem? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 2:39 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Yes, agreed. So you're using the sb+ uid/pw of the iconnect service manager? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 11:36 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Amy, Yes, both look good. Based on the 1st word in the message (II), this really looks like a SB error. I get NO errors if I login manually using the Redback UNIX login, cd to the TEST account, launch UniData (udt), and type in the iConnect login/pw. That is as close to simulating iConnect as I can think of. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:40 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message is WW.SB.RB cataloged in pilot and test? Is BP IILOGIN the same? If yes to both, take redback out of the picture, along with the screen changes (it's not making it to the screen yet...) Do you get the same message when you login through SB+, with the same user that the iConnect agent logs in with? (make sure that user group is allowing it to get into the pilot/test accounts) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 10:28 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Yes - the LOGIN paragraphs are the same. Yes - the iConnect agents are essentially the same (paths are obviously different) and they are all enabled. The last change I made to iConnect was 3-4 weeks ago to map a new field and that worked (and is still working in LIVE). I have done an ESEARCH on all the BP files I can think of in Redback, iConnect the Avanté account itself. Even looking through source codes and object code, I cannot find RECORD CORRUPT anywhere. Maybe I missed something, maybe it is more cryptic than I would expect, maybe something else. Bottom line: I do not have a clue what program is causing this, what II record it thinks is corrupt, etc. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, November 25, 2013 1:17 PM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Hi John, ok, so let's think this through
Re: [U2] Web Services at Universe 11.n
Using Redback w/ UniData here. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, October 30, 2013 3:01 PM To: u2-users@listserver.u2ug.org Subject: [U2] Web Services at Universe 11.n I've been telling my boss that if we upgraded to Universe 11.23, we can implement web services. (We're currently on 10.2) But, finally looking in detail at the appropriate manual (Universe Web Services Developer) it seems that one can publish a web service easily enough so that Universe data can be gotten, but I don't see that the other side is implemented, where one accesses an external web service and brings back data into Universe. Am I missing the something? What are any of you using to fully implement web services with an underlying Universe environment? Thanks- Harold Oaks Sr. Analyst/Programmer 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://cp.mcafee.com/d/5fHCNEq6xApdEILcELCzBNYQsCXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsSqen1PW8Vd_HYMqemkNR-LsKCzu_3zhOyqerTVqWdAklkrKsG7DR8OJMddECQjtPtPo0c-l9Q-9DUYSCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JxNYsrdbojjdbFEw0nO1Ew6fypBrW6y3pCy09MAp-dfd42afgdTdL3ow12Qu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] SB Password Limits
Is there any way to put restrictions on SB passwords? Things like, minimum length, must have a number, must have 1 upper and 1 lower, etc. JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] SB Password
Is there a process in SB to put limits on the SB password. For example, it must be 8 or more characters, must have a digit, must have at least 1 upper and 1 lower case, etc. Thanks JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Tap-In
OK - that is just stupid simple! I have been making this MUCH too hard. Thanks! JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Monday, September 09, 2013 12:03 PM To: U2 Users List Subject: Re: [U2] SB Tap-In 1. Copy the VOC entry for SB.PROCESS to a VOC entry named STANDARD.SB.PROCESS 2. Replace the VOC entry for SB.PROCESS with your own user-defined subroutine that takes the same parameters Then call the real SB.PROCESS process from inside your user-defined subroutine using the parameters you were passed. REPLACEMENT.SB.PROCESS(L.PROCESS) .. .. Your special code .. .. CALL STANDARD.SB.PROCESS(L.PROCESS) RETURN -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, September 09, 2013 11:55 AM To: U2 Users List Subject: [U2] SB Tap-In We are looking to somehow tap into the SB security to add our own logic that would always run when a process is fired off. Any thoughts? How do you control what logic gets run when the slash is typed? Any other great ideas? We know how we want to do it, but do not know where to tap into SB to have this take effect everywhere. JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/1jWVIe6h0SyOeu7c9LLf6XCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsSgphtgjjvW_cLEKf3CeLsKCCNvDQrzHLnVqWdAklrKcYG7DR8OJMddECTPtPtPo0c-l9Q-9DUYSCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JOXapI5-Aq83iS4QPiWq81wpd409RoK6MdTdHlXK Dave Davis Team Lead, Research Development P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://cp.mcafee.com/d/k-Kr6hESyOeu7c9LLf6XCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsSgphtgjjvW_cLEKf3CeLsKCCNvDQrzHLnVqWdAklrKcYG7DR8OJMddFCTPtPtPo08DIoOEKITfUYLABt8_jai8MSrsvFwnScpk6b4WRfFMyIhdbFJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dKnpjdwLQzh0qmMCCqnjh0c39Ew1eH5MS1KVIKR [http://cp.mcafee.com/d/avndxMA86QmhPMVxdZVUTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zAS8R9MBie-u2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbCO3abG2qr_nVBZ5NUsNRXBQQSbY-zsttW_bnhIyyHtNDBgY-F6lK1FJAS-rKrKr014Zz6l5RCV_7BYAHF7Wpih66PrzZc3F6pkBm5ngLIoOFN6jFFtd7w08DIoOEKITfUYLxE-dJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JOXapI5-Aq83iS4QPiWq81wpd409RoK6MdTdNFoueV5K3Sh 6110 Enterprise Parkway Grove City, OH 43123 http://cp.mcafee.com/d/2DRPoOd39J5AsYeojvuudTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVIwOyWwCC_R-pvhsu7ctuVtddy_fET7nuLORQr8EGTspVkffGhBrwqrodLCXCXCOD4Zz6l2Zb4WRfFkZKsGMFOVEY014Zz6l2Zb4WRfFkZKsGMFOVE-dJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JOXapI5-Aq83iS4QPiWq81wpd409RoK6MdTdByZWsCSw 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://cp.mcafee.com/d/2DRPosrhp7f3C4TTDztPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejozkD2l8XVUagQJeIadHv6loYKrgQJeIadHv6loYKr8cEKE9FLZvCnQn7xP7nKnjjoLPWdNRTHYJt6OaaJT6ul3PWApmU6CTPrVKVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SVtBcS2_id41Fr2qpFtd40McCy04WIn3o6XC_aNq ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] SB Tap-In
We are looking to somehow tap into the SB security to add our own logic that would always run when a process is fired off. Any thoughts? How do you control what logic gets run when the slash is typed? Any other great ideas? We know how we want to do it, but do not know where to tap into SB to have this take effect everywhere. JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] TU.SQL.CONNECT
Does anyone have any experience using the TU.SQL.CONNECT command to connect to a Microsoft Sequel database? I am not finding any on-line docs and the OLD book I am using is not very helpful. JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stumped on a WRITE failure
Bob, Can you re-create the error on demand (from the Scheduler) or is it random? Have you tried capturing anything with a COMO? Are these on NEW records, existing records or both? Are the indexes being updated to reflect the writes even if the primary file is not? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, August 16, 2013 1:09 PM To: U2 Users List Subject: [U2] Stumped on a WRITE failure Hi folks, I have a UNIDATA program that is being run from a Windows Task Schedule entry that is failing on a WRITE statement and I'm having a heck of a time figuring out why. Here are some key observations and discoveries so far: - The WRITE statement has an ON ERROR that is not being executed. - Just before the WRITE statement, FILEINFO shows the file is OPEN and has a permissions value of 6 (R/W). - It does not always fail but when it does fail, it will continue to fail on that input file every time the program is run from the Windows Scheduler. - If I run the program directly, from my logged in session, it works perfectly every time. - Every tool I have says there is nothing wrong with the file I'm writing into. - There are 3 indexes on this file but they are all flagged to allow duplicates. - There are 2 triggers on this file that monitor and report for specific record ID's. (Very basic/simple logic.) I've pretty much exhausted ways, and things, that I know of to check for. This is a very specific problem that is somehow related to the data that is being processed. Can anyone think of something else I can check for? Thanks for your thoughts, Bob W ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/1jWVIpdEIzD71OpEVusdTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVJV2P_TjvW_8FELLcLZuVtdcsZO8VMQsFLzKmKzp5dmWbfaxVZicHs3jq9J4TsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rp7fLCPiS4QPiWq81yrqGTE6y2I3h1FEw0k5xE96zh0XIzSU-rKrg9A6 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stumped on a WRITE failure
Bob, If you are loading data from an outside source, might you be grabbing a data file that is not 100% written to disk? I have seen this a number of times. The 2 solutions to this that I recommend are either: 1) look for a 2nd file that indicates the 1st is 100% complete (be sure to delete the stub file after processing) or 2) look at the size or date/time of the data file, sleep for 10 seconds, then look again. Repeat this process until the criteria does not change Might or might not be applicable in your case. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, August 16, 2013 2:05 PM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Hi John, It is random and I've not been able to identify a common indicator between the files that work and the ones that don't. The source files are coming in from the other side of the world so it's happening in the very early hours of the morning. By the time I get in, the scheduler has tried to run the program on the bad file a couple of times. I've not tried using COMO, yet. This is exactly why I like this list so much. I'll put this in right away. I'll dig into the udterrorlog file, too, as Colin suggests. Thanks! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, August 16, 2013 10:17 AM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Bob, Can you re-create the error on demand (from the Scheduler) or is it random? Have you tried capturing anything with a COMO? Are these on NEW records, existing records or both? Are the indexes being updated to reflect the writes even if the primary file is not? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, August 16, 2013 1:09 PM To: U2 Users List Subject: [U2] Stumped on a WRITE failure Hi folks, I have a UNIDATA program that is being run from a Windows Task Schedule entry that is failing on a WRITE statement and I'm having a heck of a time figuring out why. Here are some key observations and discoveries so far: - The WRITE statement has an ON ERROR that is not being executed. - Just before the WRITE statement, FILEINFO shows the file is OPEN and has a permissions value of 6 (R/W). - It does not always fail but when it does fail, it will continue to fail on that input file every time the program is run from the Windows Scheduler. - If I run the program directly, from my logged in session, it works perfectly every time. - Every tool I have says there is nothing wrong with the file I'm writing into. - There are 3 indexes on this file but they are all flagged to allow duplicates. - There are 2 triggers on this file that monitor and report for specific record ID's. (Very basic/simple logic.) I've pretty much exhausted ways, and things, that I know of to check for. This is a very specific problem that is somehow related to the data that is being processed. Can anyone think of something else I can check for? Thanks for your thoughts, Bob W ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/1jWVIpdEIzD71OpEVusdTdEThjvKztcQsCQrEFLThjhd79J6W arZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVJV2P_TjvW_ 8FELLcLZuVtdcsZO8VMQsFLzKmKzp5dmWbfaxVZicHs3jq9J4TsTsS03fBitfyp-fdFJAu00 U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rp7fLCPiS4QPiWq81y rqGTE6y2I3h1FEw0k5xE96zh0XIzSU-rKrg9A6 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPosd2gQrhp7ee3D4THCXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsSe86zBPXFLZvATC7zhOyDRXBQkQT-ojohjd7b_bnhIyyHsQsEYG7DR8OJMddECSjtPtPo0c-l9Q-9DUYSCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JZNNMS2_id41Fr2qpFtd40NdJlrQ3h1m1EwQQg0a2MQ4zhEwtShXsvdTdDo5ApJT-v9f ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCMUg40USyOess7e9LndTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVIsgd7bDTjvW_9Lcf6zB5fHTbEFFLYMCMyCqen-mKzp55mVEVhVkffGhBrwqrjdICXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrXzzxI5-Aq83iS4QPiWq81yrqGTE6y2I3h1FEw0k5xE96zh0XIzSU-rKrdd0eOZzx ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniData to SharePoint
I have had E-mail gremlins lately, so I apologize in advance for asking this question again. We use UniData on an HPUX box. We also have SharePoint running on a Windows box. In that past, we have used Samba to push exports from UniData/HPUX to Windows servers, but SharePoint adds a wrinkle to this because what LOOKS like a folder on the SharePoint box from any other Windows box, is actually the results of SharePoint returning files based on a sequel query. Since it is not a REAL folder, I cannot use Samba to copy to that location. Has anyone figured out how to execute a UNIX command or UniData command to copy a file into a SharePoint database? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Copy File to SharePoint
We are running HPUX w/ UniData 7.2. We also have a Windows box running SharePoint. In MANY situations, we have built an export file in a UNIX directory (like a tab-delimited txt file), then used Samba to copy the file from the UNIX box to a networked drive. This does not work with a box running SharePoint because the directories shown on the SharePoint box are not real directories. They are simply renderings of a Sequel query (or something like that - not my area of expertise). Thus, Samba cannot connect to one of these fake SharePoint directories. Has anyone figured out a way to take a file from UNIX and copy it into SharePoint? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Copy File to SharePoint
We are running HPUX w/ UniData 7.2. We also have a Windows box running SharePoint. In MANY other situations, we have always built an export file in a UNIX directory (like a tab-delimited txt file), then used Samba to copy the file from the UNIX box to a networked drive. This does not work with a box running SharePoint because the directories shown on the SharePoint box are not real directories. They are simply renderings of a Sequel query (more or less). Thus, Samba cannot connect to one of these fake SharePoint directories. Has anyone figured out a way to take a file from UNIX and copy it into SharePoint? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers
We use this same concept. The triggers themselves are globally cataloged, but all they do is check a table then based on the file in question, call a 2nd locally (DIRECT) subroutine. Debugging is simple for us and never clobbers the live code when developing in a test environment on the same box. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, July 29, 2013 11:35 AM To: U2 Users List Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers I must say, I use triggers in UD with no problems. When converting from D3 to UD I had a hard time getting them to work. However, with useful suggestions from several on this list I was able to get them working properly. They turned out to be a bit more robust than the D3 triggers. I've been able to debug the trigger several times when problems appeared, but haven't for a number of years as they work as expected now. The structure took a while to get my head around, but I simply have two trigger programs (globally cataloged): U2.MASTER.TRIGGER.D U2.MASTER.TRIGGER.U ...which handle all delete and update triggers. Inside each program a file is read that actually provides the trigger subroutines to CALL (via a CALL @...). So, I can insert any subroutine as a trigger in any account. These programs are cataloged locally. I don't remember any problems debugging these subroutines. Just a thought. Bill - Original Message - *From:* perry.tay...@zirmed.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/29/2013 6:24 AM *Subject:* Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers That and the expense of their usage. Perry Taylor Zirmed, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, July 26, 2013 1:32 PM To: U2 Users List Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers How many people avoid using triggers BECAUSE of the virtual impossibility of using RAID with Triggers? On 7/26/2013 12:33 PM, Phil Walker wrote: 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
Re: [U2] [UD] BASIC Code Failing
It is worth noting that lines 107 - 110 are all doing an INSERT. The lines before and after do not. I'm not sure what that may or may not point to, but it is worth noting. Any chance that what they are inserting is the problem (i.e. POLREC and VNDKEY are null or something other than what you suspect)? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Friday, July 26, 2013 9:42 AM To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing This is all very interesting to hear. I have a customer who has occasional instances when they complain that a supply receipt has failed to update the last receipt fields. This is the code: 0092: *** 0093: 7000:* UPDATE SUPPLIES 0094: *** 0095: SUPKEY = POLREC2 0096: GOSUB 7300 * reads suprec 0097: IF SUPREC EQ THEN 0098:RETURN 0099: END 0100: SUPREC16,1 = SUPREC16,1 + OCONV(POLREC13,RCPSUB,MD4) 0101: NEWQTY = 0 0102: LOCCNT = DCOUNT(SUPREC15,@VM) 0103: FOR LOCSUB = 1 TO LOCCNT 0104:NEWQTY = NEWQTY + SUPREC16,LOCSUB 0105: NEXT LOCSUB 0106: SUPREC3 = NEWQTY 0107: SUPREC = INSERT(SUPREC,2,1,0,POLREC6) 0108: SUPREC = INSERT(SUPREC,11,1,0,POLREC11,RCPSUB) 0109: SUPREC = INSERT(SUPREC,12,1,0,FIELD(POLKEY,.,1)) 0110: SUPREC = INSERT(SUPREC,13,1,0,VNDKEY) 0111: GOSUB 7400* writes suprec 0112: RETURN : I have never been able to figure out why line 106 gets executed but 107 - 110 do not. My customer refers to it as the lawnmower man. dale ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/FZsScz8scCQmhP3P3yb3NKVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79Kl8XUz458qmDm56RLzaIundEqmDm56RLzaIundImIejthvW_8IfecnpWZOWtTCujhKUepLORQr8EGTKVOEuvkzaT0QSyrhdTdTdw0PVkDjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CS7TbCMnWhEwdbojjdbFEwdboj3ziWq81Ag60Qid40Bl3Ph0bX8-k29KVLbCN1DxO_sIf ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Type Fields in Universe
As long as you are only changing the code in the basic program, you should never need to touch the DICT. Granted, if you change the arguments in any way, that would require a recompile of the I-Desc. If you truly had to re-compile the DICT for a program change, that would strangely suggest that when you compile the I-Desc that it was somehow loading the object code of the program into the I-Desc itself. I am not doubting what you are seeing, but it sounds like there is one more piece of the puzzle that has not been identified. Are they globally or locally cataloged? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Tuesday, July 23, 2013 11:26 AM To: u2-users@listserver.u2ug.org Subject: [U2] I Type Fields in Universe It's been a while since I messed with these things so I need to ask. The I type in question is a SUBR and calls code that returns the value I want the field to have. You compile the I type and it works fine. I then need to change the code, compile the code and even re-compile the I type again, it did not work. The field acts as before the last time I compiled it. I've found the new chances will only work after I delete attributes 16 - 20 in the I type and recompile it. Is there a better/other way? - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://cp.mcafee.com/d/5fHCNAi6hESyOeovd7baby9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79Kl8XUz458qmDm56RLzaIundEqmDm56RLzaIundLfnT_hvW_cfcLnsWZOWtXCzDD7DSrLsJt6OaaJTAul3PWApmU6CQjqpKVKVI06SCnrx8PYqunrx93pXOdNP8UQsLZ1_Eqg87_O-1Fs4BBLbyYLfgEnB0K4Uic_6DBVHc8IITU76SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SOCOqejpFr2qpFtd40qq80immYQg2YLfgEq89gd40jx8PYqurKrSkVt-DKA Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNASyOeovd7baby9KVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79Kl8XUz458qmDm56RLzaIundEqmDm56RLzaIundLfnT_hvW_cfcLnsWZOWtXCzDD7DSrLsJt6OaaJTAul3PWApmU6CQPqpKVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SOCOqejpFr2qpFtd40qq80immYQg2YLfgEq89gd40jx8PYqurKrYke9 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Type Fields in Universe
It sounds to me like in the account that works, it is looking at the local copy of the program. In the account(s) that fail, it is looking at another, older piece of object code. I suggest that you go to the account(s) that are failing and type DELETE.CATALOG program. Do this several times until it says it can't find it. Then, re-catalog the program from the failed account. Be sure to catalog DIRECTly. Test this in all your accounts. The one risk to this is that if you had the program globally cataloged, then any account that was actively using THAT object code will now fail. Simply go to all your accounts and make sure you have a VOC pointer going to the desired source code. Note that you may have this condition with other programs too. This might be a good exercise to look for these when you have nothing else to do (yeah, right!) Also note that this is NOT unique to I-Desc but to any program that calls this subroutine. We use UniData so things are slightly different. However, for us, we catalog everything DIRECTly (i.e. it just builds a VOC pointer and does not put a copy of the object code in the cataloged space). This means that I technically never need to CATALOG anything so long as I manually build a VOC pointer to the desired object code. That's not really the way they want you to do it, but you get the same results. This also means that once it has been cataloged once (i.e. I have a VOC pointer pointing to the object code), I NEVER need to re-catalog. I actually find this safer. Since I never re-catalog anything (except triggers), I never make the mistake of cataloging something globally that I am expecting to be local. HTH JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Tuesday, July 23, 2013 12:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I Type Fields in Universe When I run in the same account and make changes to the code it works fine. So what step am I missing for doing it the other way. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://cp.mcafee.com/d/k-Kr6zqb8VxYQszxMVYTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zATaAtYhy2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbC_uj8vWb_nVBdOXbz_nKnjKejVxAQsLIzDemKzp5dl6WvaxVZicHs3jq9JcTsTsS03rjbJMAp-dfbJMAxIZV6UVAsqen-w_Qd843_Vv0QK2iOTBNunDEkbOwn2s96vzjOYRC4mmrHc8IIzK1NJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dIT79CMnWhEwdbojjdbFEw3jh02iOTCy0nBVW53h1a1Ew2s96vzjPtPvAB6 Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPosrhp7cfCzAse7fCXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCVkzLycgkxFqtokrm-cGNVsSxFqtokrm-cGNVsTXOp3_hvW_cFKnpsvWZOWtNOvccCzBZAsVORQr8FGETjVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrdNOpI5-Aq83iS4QPiWq80QQg0AIJVEw5VuuxgQgiwq80D2hDUQYTsTDUSF6LO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] LIST reports and Fields that Do reads
Yes, the read will be done each time the record is LISTed (SORTed, SELECTed, etc). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Friday, July 19, 2013 4:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] LIST reports and Fields that Do reads Lets say you have a field that calls a subroutine. In this routine you do a read to lookup a description which it what is passed back. When you do a LIST to create a report with this field will the read be done each time? I was just wondering how the Universe system handle's this. Dose the system store the first read in it's in memory and just uses that instead of doing a read each time? -- View this message in context: http://cp.mcafee.com/d/5fHCNApdEIzC4T666kPtPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejsGhTN68agQJeIadHv6loYKrgQJeIadHv6loYKrtsIqejhPWb_nVBUQsII9FZuVtdCVEVVZxZVVZXBHEShjlhKVOEuvkzaT0QSyrjdTdTdw0SQOXs96vzjOXs98rfuhKep76zB_EfZ3i10_-nMaxEM2iYvmH6t2-MgbyYLfgEnCjSpseGnz-EkbPmohpKNMedJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JCUVUSqmMCCqnjh05gQo19EwzWRoPEq8dwwq81unDEkd44OuPd40tkQgh_ka6XCNmg4PG4Da_d Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/avndygQ86QmhP2rz33apKVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79Kl8XUz458qmDm56RLzaIundEqmDm56RLzaIundKKmd79EVZ5_HYOYqemm4Q-LsKCPsQsY-M-YY-ZORQr8FGETsVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrdNPNIQJxdcQKCy0axEM2jh17RGNDgQgr10Qg2YLfgEq89AZCq80WFEwz-EkdTdQm8A9a7I ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Origin of the word 'COMO'
Not sure, but back in the Pr1me days, I think we had both COMOs and COMIs. That was a LNG time ago, so hopefully that will knock some dust off a smarter person's grey matter. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, July 22, 2013 3:45 PM To: u2-users@listserver.u2ug.org Subject: [U2] Origin of the word 'COMO' What is the origin of the word COMO as used for the Universe logs ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr6wUe6jqb8VxZddBBUTsSzt5d-WdQPhOrhKyC_t5d4QsCQrEFLThKPsSzt5cQsLIIc6zATaAtYhy2AdbjH2zqTNBmfbCQdbjH2zqTNBmfbCQv8f8uy_R-h7nvjuoWZOWtTHYCCed78VMQsYJt6OaqJQSel3PWApmU6CQjq9KVKVI06vaAWv4PYurjr8Y01MjlS67OFek7qUSCnrFYq6SQOXtfzgKgGT2TQ1hYGjFYjfNVJdIzM04SO-qekPpFr2qpFtd41Ew34p4pgd45njh1cDVEwclywq83he91wr31EDdTdKU76SSwP ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Redback License
We are planning to do some major disk swapping this weekend. In the past, we have found that this sort of thing can corrupt (or whatever) the Redback license. Over the weekend, when this work is done, how do I get a new license to keep Redback up and running? Thanks John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Redback License
Thanks Amy - I think that go it (or rather pointed me where I needed to go). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Wednesday, June 05, 2013 4:18 PM To: U2 Users List Subject: Re: [U2] Redback License Hey John, I *think* I remember you just go back to their auth page: (?) https://u2tcint.rocketsoftware.com/authprod.asp Amy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, June 05, 2013 10:25 AM To: U2 Users List Subject: [U2] Redback License We are planning to do some major disk swapping this weekend. In the past, we have found that this sort of thing can corrupt (or whatever) the Redback license. Over the weekend, when this work is done, how do I get a new license to keep Redback up and running? Thanks John ___ 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] Recognition for Rocket and Rocket's U2 in dual rankings today!
Reynolds Reynolds left U2 years ago. I work with some of the former folks from there. They said it was a huge mess. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Tuesday, June 04, 2013 3:30 PM To: U2 Users List Subject: Re: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today! Don't forget about Reynolds and Reynolds (UniVerse) in the automotive dealer space. I think between ADP and RR have 80% of the market collectively. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, June 04, 2013 10:20 AM To: donr_w...@yahoo.com; u2-users@listserver.u2ug.org Subject: Re: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today! The auto dealership software should be ADP Dealer Services Do they have 80% ? Or is there another automobile dealership software that runs on Multi Value ? -Original Message- From: Don Robinson donr_w...@yahoo.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Jun 4, 2013 7:16 am Subject: Re: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today! Daniel, In the View from the Top by Andy Youniss, he list the following; 40% of US institutions of higher education 80% of Mexico’s emergency response systems 70% of North America’s largest independent insurance agencies 80% of automobile dealerships in North America 55% of Fortune 100 companies 50% of the top 400 energy-products companies Except for the Fortune 100 companies, it would seem that the others might be using packaged software. A list of these packages might be interesting. I'm not disputing the numbers but some explanation of how they were calculated would be nice to know. I have a vague idea about the auto dealers and higher education but not the others. I think this illustrates the I never heard of Pick/multi-value software comments we hear a lot of because the database is hidden from the users. BTW, maybe auto parts and many other wholesalers and retailers should be added to this list. Just my 2 cents, Don Robinson From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Monday, June 3, 2013 4:59 PM Subject: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today! If you haven't seen it already, U2 got dual mentions today in top ranks. First: The UniData and UniVerse databases from Rocket Software have been listed for the first time in the database ranking site DB-Engines, making 45/169 (top 27%) on debut. http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyCxdr7ioTC83MTMnOT-vpCg_Ry85P5ehyNTEKyzRIsPA2MDYxIIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpfPyVJNzUvPTMvtRgkqp-ap1-UmJedmZfOAAEAc-4nGwZ Second: Rocket has been listed in the 'DBTA 100: The Companies That Matter Most in Data' with a big mention of the U2 databases from our CEO, Andy Youniss. http://www.dbta.com/Articles/Editorial/Trends-and-Applications/View-from-the-Top-Rocket-Software-89919.aspx http://www.dbta.com/Articles/Editorial/News-Flashes/DBTA-100-The-Companies-That-Matter-Most-in-Data-89876.aspx Regards, Dan ___ 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 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData PreStore to change the KEY of a record?
There is also the danger in a PreStore where you go to field 30 to make your change, but the record(s) in question does not have that many field. It instead goes to the last field and execute the change. This can be disastrous! Be careful! JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Tuesday, May 28, 2013 3:54 PM To: U2 Users List Subject: Re: [U2] UniData PreStore to change the KEY of a record? And if you go that route, I have used Excel a number of times for this type of thing. I use formulas to replicate what a user would type and then paste into either TCL or ED. It takes a little time to work out the details, but once you have it, you can reuse pretty easily. As someone noted earlier, the rub comes in ensuring you don't overwrite an existing record. Assuming you've done that, this might get you started. Bad Good Command A B ED FILE A SV B FD Y Where command is this Excel formula: =ED FILE A2CHAR(10)SV B2CHAR(10) FDCHAR(10)YCHAR(10) Depending on which version of Excel you have, it may include the leading when you paste. If so, paste into Notepad or Word and remove the leading HTH, Brad. From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org, Date: 05/28/2013 02:42 PM Subject:Re: [U2] UniData PreStore to change the KEY of a record? Sent by:u2-users-boun...@listserver.u2ug.org I do not think you can Prestore a replacement command to operate on the KEY (attribute zero) I would suggest giving the task to an expert user and teaching said user how to look at the Key, mentally replace bad with good and then SAVE GOOD1234, followed by FD -Original Message- From: David Wolverton dwolv...@flash.net To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, May 28, 2013 10:48 am Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ 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 U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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] UV File doesn't like being sampled?
Maybe I am missing something, but why would you want an index on @ID? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 24, 2013 10:18 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? YUP. I just isolated it to the index of @ID. I changed the original filename, recreated a new file Copied all the data Copied all the dict And finally, recreated the index (@ID) Testing the sampling on each step, all went well until I recreated the index, then it bombed again. And yes, using the NO.INDEX does fix it. Does working with an active select list de-activate the @ID Index? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Friday, May 24, 2013 10:10 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? George, I checked out system and we have experienced this issue before. Check if you have built an index on @ID. If you have, this is what is causing your issue. Using the NO.INDEX keyword will give you correct results. I don't have an explanation for the behavior. Let us know how it goes. 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 George Gallen Sent: Friday, May 24, 2013 7:52 AM To: U2 Users Subject: [U2] UV File doesn't like being sampled? OK. Any Ideas? I have a Type 30 file that if I use the SAMPLE modifier in the SELECT still returns the entire file, However, if I use the SAMPLE modifier in a LIST command on that same file, it only returns the sample amount. Now, it gets stranger, If I do a SELECT with the SAMPLE modifier, it returns the whole file as an active list, and if I Do another SELECT with the SAMPLE modifier on that active list, it only returns the the sample amount. So what, the file is just toying with me? I guess if I really want that sample, I have to ask twice? SELECT FILENAME SAMPLE 10 929347 record(s) selected to SELECT list #0. SELECT FILENAME SAMPLE 10 10 record(s) selected to SELECT list #0. This seems to be the only file that is behaving this way. There are no dictionary items in the file that would Interfere with the UV selection. My next step will be to create a new file, and copy over the contents, just in case there is something that Is corrupted in the file. This is on UV 10.0.2 / RH Linux ___ 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] UV File doesn't like being sampled?
If you are doing it because of performance, I am thinking you need to re-size the file (as you suggested). This will not just impact SELECTS, but any IO. Also keep in mind you are impacting performance just by having the index. All that being said, getting the time to resize is something that can be limited by the nature of your business. Just some points to consider. You know your business better than the rest of us. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 24, 2013 10:57 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? In thinking about itI'm not sure, but it seems to increase the selection speed (considerably). It is a type 30 file, So possibly the index makes up for a hashing algorithm where the modulo is too small? And the makeup of The @ID causing more similar hashing? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, May 24, 2013 10:52 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? Maybe I am missing something, but why would you want an index on @ID? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 24, 2013 10:18 AM To: U2 Users List Subject: Re: [U2] UV File doesn't like being sampled? YUP. I just isolated it to the index of @ID. I changed the original filename, recreated a new file Copied all the data Copied all the dict And finally, recreated the index (@ID) Testing the sampling on each step, all went well until I recreated the index, then it bombed again. And yes, using the NO.INDEX does fix it. Does working with an active select list de-activate the @ID Index? George ___ 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] SB Lookups Changes
As of this morning, all of the F3 lookups we have are behaving slightly differently. The results used to return in a nice, clean white list of data. For unknown reasons, this morning, the clean white display is now showing up with each piece of data being displayed within a box, very much the way Excel displays each cell. We are unaware of any changes we have made that would do this. Any ideas how to turn the Excel look off? Thanks John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Redback error?
I am getting the following message in the Redback logs: II RECORD CORRUPT! - CONTACT SYSTEM ADMINISTRATOR I think this is an Avanté/Epicor issue, but I usually get faster response from this group. Any thoughts? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
You should not need to do the SAVE-LIST and GET-LIST unless you wish to do a 2nd pass on the exact same results. The main purpose of a SAVEDLIST is to prevent you from having to do the same select multiple times (or to preserve the list of keys for some other purpose). Note that a SAVEDLIST is just a list of KEYs and no other data. I do not understand what is in KEYVALUE. I am assuming you are running in native UniData/UniVerse mode. If you are always wanting the same records, just build a permanent SAVEDLIST, get it and never bother with a SELECT again. A little more info about what you are ultimately trying to accomplish will help us give you a more specific solution. How many values are in KEYVALUE? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Wednesday, May 15, 2013 5:45 AM To: u2-users@listserver.u2ug.org Subject: [U2] select query.. Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH @ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 LIST.NAME = GET-LIST SOME.LIST sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of KEYVALUEs and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks Regards, Sathya V. ___ 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] Help needed..
Note that if the file was built in Windows, it may have a CR:LF combination at the end of each line. Reading it in, PICK will cleanly distinguish one as a line delimiter, but you will still have the extra (unwanted) character at the end of ROW. I forget which one is which, but any time you read in a row from a TXT file, you will want to convert the unwanted character (I believe it is a CHAR(13)). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Tuesday, May 07, 2013 7:46 AM To: U2 Users List Subject: Re: [U2] Help needed.. Hi, Personally, I would use OPENSEQ and READSEQ. Each READSEQ would read the next field in the record. The file needs to be a type 1 or type 19 for OPENSEQ. An example of this is: OPENSEQ FILE.NAME2, KEY.TXT TO SOURCE.FN ELSE STOP 'Unable to open ':KEY.TXT LOOP READSEQ ROW FROM SOURCE.FN ELSE EXIT ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If the file isn't a type 1 or 19 then use the REMOVE function on the internal array. It is very fast. An example is: READ TXT.REC FROM F., KEY.TXT TXT.REC=TXT.REC LOOP REMOVE ROW FROM TXT.REC SETTING POS UNTIL ROW='' AND POS=0 ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If you need to reprocess the array then add TXT.REC=TXT.REC and start the process again. The reason is that assigning the array to itself will reset the internal pointer REMOVE uses to keep track of where it is. One caveat, REMOVE goes to the next delimiter (field, value, subvalue or text mark) so you need to know the data you are working with. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, May 07, 2013 12:36 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help needed.. Wjhonson wjhonson at aol.com writes: That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. Hi I just used OSOPEN to open the file and the file is not getting recognized. Here is the piece of script I have used. OSOPEN FILE.NAME2 TO F.KEYFILE ELSE STOP CAN Not find file Where FILE.NAME2 is the path and the file name. Also as suggested below, how could I use get list for a file which is opened from server. Thanks in Advance, Sathya V. -Original Message- From: Israel, John R. JohnIsrael at daytonsuperior.com To: 'U2 Users List' u2-users at listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO at FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-bounces at listserver.u2ug.org [mailto:u2-users-bounces at listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users at listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at 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] Help needed..
Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO @FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ 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] Help needed..
Yes, I understand it shifts everything, but you are not traversing deeper with each loop. You are only going 1 deep every time. Old school. :-) John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 30, 2013 12:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help needed.. That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO @FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ 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] blink error?
I have not seen that in a long time. Used to occasionally get it in UniVerse on an AIX box. I think it stands for backward link (blink). Simply listing or selecting the file will fail when it hits the offending data. If you can detect the key that is failing, the simple solution used to be to try to copy the record to a temp file, delete the original record (which fixes the link), then copy it back. If that fails, you will likely need to run the fix file utility. Again, I have not seen this in 10 years or so, so my memory may be a little off. Good luck! JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Thursday, April 18, 2013 12:20 PM To: U2 Users List Subject: [U2] blink error? Never seen this error message before, no sure on the severity but I hope it's easy to fix: File 'E:\dbms\LIVE\DATAFLO/SHIPMENTS/SHIPMENTS': Computed blink of 0x765800 does not match expected blink of 0x765000! Detected within group starting at address 0x1068E000! Any input as to what I need to do to resolve it? Thanks, Jake Holt l samsill l Information Technology Director (817) 536 - 1906 x 217 l jh...@samsill.com www.samsill.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
[U2] Compressing PDFs
HPUX, UniData SB: After a bunch of work, I have a UNIX directory that has a bunch of PDFs. I wish to bundle these PDFs up into a 7zip formatted compressed file. I see that there is a ported version of the Windows version of 7zip for UNIX called p7zip. Has anyone installed p7zip and if so, what else needed to be installed with it? Is it stand-alone or is it dependent on other software packages being loaded first? OR Does anyone have a simple way for UNIX to run the Windows command line version of 7zip against my UNIX PDF directory? Thanks JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Compressing PDFs
There are several issues here that I am dealing with for this project. #1 The company that we are sending the PDFs to is Windows based, so I am limited as to the formats they can accept (zip and 7z being two of them). #2 In my testing, I have found that 7z gives significantly more compression. In my test, I took a single PDF that was 17k in size. I made 3 copies of it for a total of 17 x 4 = 68k. Using a traditional zip, I was able to compact these 4 PDFs down into a 33k file (about half). HOWEVER, after compressing it down with 7z, those same 4 PDFs went down to only 8K! That is a SIGNIFICANT difference. #3 I wrote a program we all use that archives the intended file, then transmits the archive to the 2nd party. That way, if they did not get it, I can re-send it from the archive w/o having to try to re-create the data (which may have changed). Also, if there are any issues, I can look at the archive file and determine exactly what they got and then determine if the problem was mine or theirs. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Thursday, March 28, 2013 9:13 AM To: U2 Users List Subject: Re: [U2] Compressing PDFs I have not used p7zip, but HP-UX has a native zip command on it. The thing is PDFs are pretty well compressed so you may not gain much disk space back. HTH, -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Please notify the sender immediately by e-mail if you have received this e-mail in error and delete all copies of this message. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, March 28, 2013 8:55 AM To: U2 Users List Subject: [U2] Compressing PDFs HPUX, UniData SB: After a bunch of work, I have a UNIX directory that has a bunch of PDFs. I wish to bundle these PDFs up into a 7zip formatted compressed file. I see that there is a ported version of the Windows version of 7zip for UNIX called p7zip. Has anyone installed p7zip and if so, what else needed to be installed with it? Is it stand-alone or is it dependent on other software packages being loaded first? OR Does anyone have a simple way for UNIX to run the Windows command line version of 7zip against my UNIX PDF directory? Thanks JRI ___ 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] Compressing PDFs
My push for going with 7z is that: 1) we use it as a company on all our Windows boxes and 2) the other company involved in my project also uses it The trick is to get it running on my UNIX box (or rather, getting my UNIX Admin to get it loaded and working). If the difference between a zip and a 7z file were just a few percentages, I would not be pushing so hard for 7z. But 50% compression (with zip) vs. 90% compression is worth investigating. Thanks for all replies. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, March 28, 2013 11:59 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Compressing PDFs In addition to 7-Zip (the software, not just the compression algorithm), consider WinRAR. They're both based on the same UnRAR decompression. They both support multiple platforms, multiple compression methods, multiple volumes, security, etc. I hope I don't start a war by suggesting that anyone spend money for software or anything, but WinRAR is shareware for $30 and has Windows extensions for a UI that make it worth it to some people. You don't need to pay for it, and I'd guess most people do not, but it's a good thing to do, especially for a company. There is a tiny nag on file opens which is easy to dismiss. I've been using WinRAR for almost a decade and swear by it for all compression needs. For some people the choice is just a matter of personal preference where most other comparisons are similar. You'll see arguments out there about 128bit AES vs 256, or how many CPU cores are utilized, or whether you get 80% compression vs 85%. At some point it just comes down to feel. I'd recommend that you do not provide your trading partners with software, but tell them the compression mechanism you use and why, and then point them to a couple websites from which they can make their own choices. Otherwise you could get stuck providing support because YOU told them to use brandX. As to your local storage, consider delivering files to your trading partners in a format that's easy for Them to manipulate, but re-compress/store files in a way that's easy for You to manipulate. The content is ultimately the same and file transport/unpacking issues are rare and easy to remedy. HTH T From: Israel, John R. There are several issues here that I am dealing with for this project. #1 The company that we are sending the PDFs to is Windows based, so I am limited as to the formats they can accept (zip and 7z being two of them). #2 In my testing, I have found that 7z gives significantly more compression. In my test, I took a single PDF that was 17k in size. I made 3 copies of it for a total of 17 x 4 = 68k. Using a traditional zip, I was able to compact these 4 PDFs down into a 33k file (about half). HOWEVER, after compressing it down with 7z, those same 4 PDFs went down to only 8K! That is a SIGNIFICANT difference. #3 I wrote a program we all use that archives the intended file, then transmits the archive to the 2nd party. That way, if they did not get it, I can re-send it from the archive w/o having to try to re-create the data (which may have changed). Also, if there are any issues, I can look at the archive file and determine exactly what they got and then determine if the problem was mine or theirs. From: Israel, John R. HPUX, UniData SB: After a bunch of work, I have a UNIX directory that has a bunch of PDFs. I wish to bundle these PDFs up into a 7zip formatted compressed file. I see that there is a ported version of the Windows version of 7zip for UNIX called p7zip. Has anyone installed p7zip and if so, what else needed to be installed with it? Is it stand-alone or is it dependent on other software packages being loaded first? OR Does anyone have a simple way for UNIX to run the Windows command line version of 7zip against my UNIX PDF directory? ___ 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] Date conversion..
I would suggest tab-delimited instead of csv, then give the file an xls extension. This usually pulls up the fat with much fewer mouse clicks. John Israel Sent from my iPhone On Mar 22, 2013, at 12:17 PM, Tony Gravagno 3xk547...@sneakemail.com wrote: From: Sathya Hi experts.. I have one problem in creatin a spreadsheet report with date format. One of the column in the spreadsheet is a date and it is displaying as numbers. Please help me in printing it as a date. BTW I'm using OCONV to write the value to the column. The problem isn't with MV. When you say spreadsheet people here imply Excel, and I'm guessing that's what you mean too. What most people do is they generate a CSV file with no formatting and then expect Excel to format it in specific ways. The simple answer is, if you just want text in Excel, put a single quote before the value: 123, abc, '3/22/2013 You can also force it to text like this using a formula: =3/22 The immediate response might be but I want a Date column. OK, but you're not doing anything to tell Excel that the column itself should use date formatting. [AD] This is exactly the reason why I created NebulaXLite. It gives you any kind of real Excel formatting of your choice for any cell, column, or row. With nothing but BASIC, you can: - use set fonts, colors, text rotation, and borders, - set column widths and row heights - merge cells, use hyperlinks, add comments to cells - set document properties, add multiple worksheets in a workbook - and documents open in Google Docs and OpenOffice Compare all of that (and yes, much more) to plain old delimited text. Lots of companies here use NebulaXLite. It's free for developers and only a one-time purchase price of $200 for production end-user systems. Support and enhancements are free. http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkql9QlJ9SmlxSrF-Rk1mSqpdRkssAAQDL-yocZ [/AD] HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfSyDBdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjX3T3f09HAyNzI0oIhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkqp-Uk5_OAAEAelMkgAZ Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ 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] History..
Type: .L To list the past commands. .Xn To re-execute the nth command. .? For help JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, March 19, 2013 11:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] History.. Hi all,.. I'm pretty new to Unidata. just wanted to know the command for listing the history of commands and how to select nth number of command. Also how to execute a unidata program. I know my questions will be very simple. But as I'm entirely new to this, unable to find that anywhere :-( TIA, Sathya V. ___ 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] History..
Also, Once a program is cataloged, you no longer need to type the RUN filename programname. You can just type the programname. Note that if the program is a subroutine AND it has arguments, you cannot run this from TCL. It will blow up right away. No harm, but no execution either. You also have to catalog a program in order to CALL it by another program. Be sure to understand the impact of cataloging globally (the default) vs. locally. We catalog everything locally on our box which simply builds a VOC pointer to the object code. This means that once it is cataloged once, we never need to catalog it again, but other accounts cannot see it w/o being cataloged in those other accounts too. Globally cataloged programs are available to anyone on the box (but can lead to confusion between different account w/ different versions of the same program). Both global and local have their advantages and disadvantages. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Wednesday, March 20, 2013 2:25 PM To: U2 Users List Subject: Re: [U2] History.. John answered your sentence stack commands, so I'll take a shot at how to execute a program. Typically programs are stored in type 1 files, aka directories or folders, (terminology usually depends upon base operating system, *ix or windows). There's a corresponding file containing the object code. To execute the program, you would typically enter RUN filename programname at the command prompt. Then, there's cataloged code which is a method of storing object code so that it can be referenced by multiple users, (unless it's cataloged locally). You can also execute a program directly from its native host without entering UniData if you know where the binary executable lives. The last three are included only for some semblance of completeness, I believe that the answer you're looking for right now is paragraphs two and three. On 3/19/2013 11:17 AM, Sathya wrote: Hi all,.. I'm pretty new to Unidata. just wanted to know the command for listing the history of commands and how to select nth number of command. Also how to execute a unidata program. I know my questions will be very simple. But as I'm entirely new to this, unable to find that anywhere :-( TIA, Sathya V. ___ 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] Social Networks for MV
Bob, I used to work at Ashwood! Say hi to Rod, Doug Tom for me. All good folks. John Israel Sent from my iPhone On Mar 15, 2013, at 9:34 PM, Bob Wyatt bwyatt_...@comcast.net wrote: Tony, I read the blog, but remain unmoved. I think that embracing social media weakens/dilutes/reduces the focus of the brand. If the purpose is to promote Bob Wyatt or Tony Gravagno, use social media to the fullest extent you desire. If the purpose of your web presence is to promote the brand (Nebula Research or Ashwood Computer, Inc. (my employer)), there should be as few web locations as possible. Whomever is doing the searching is interested in authoritative/reliable information - finding the information on facebook, twitter, and the like, I hope, will never ever be regarded as authoritative or reliable (in my opinion). If I want to know what Nebula Research can do for me, facebook and twitter are not on by radar as possible destinations to find out. I'm not inclined to go there even for references - I would get references from Nebula Research, not what followers of Tony (or Nebula Research) had to say on facebook or twitter. I even find the technical questions being asked (and answered) on LinkedIn as being in bad form. That isn't what LinkedIn is for. It is a narrow view, and I realize that it may not be a popular one. I'm in front of a computer more than 10 hours a day, and when I need information, I need authoritative/reliable information. And, of course, Twitter and facebook can be a huge time-vacuum - lots of time and little reward. All of the above is my personal opinion, and does not necessarily reflect the opinion of my employer... Bob Wyatt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, March 15, 2013 6:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Social Networks for MV I'm on a mini campaign to make more MV colleagues aware of the benefits of using Twitter and other social media. Everyone is welcome to visit my blog on the topic and to comment here or there. http://webdefence.global.blackspider.com/urlwrap/?q=AXicJcqxDcIwEEDRaxgHn-1QRFQIkOgoqGgdYyVGZ190diJlCMRo7MEUCPjl018d4P0AeD0BhBbT9qrIrJKL5DlXYVKeE4g9mWvRe221bTcQi7hwl93NLZVzmcYgkeV3DrWOW8Rz6CZy60s-fhU74h5r8AOmGa02DeoGC_voKM1GDTUR_PsAt9cuaAZ 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://webdefence.global.blackspider.com/urlwrap/?q=AXicY3VmeNXLwHC-n4GhKKfS0CJdr7ioTC83MTMnOT-vpCg_Ry85P5ehyMjdMKLYwMnAyMDIwoQhs7goMTWryCElsbIkP6-4tCC1KDO_CKwyo6SkwEpf3y81qTQnUTcozwUkqp-Uk5_OAAEAcRAkWwZ Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ 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] U2 Web DE Re-install
My PC dies a few weeks ago and I am trying to re-install the U2 Web DE package on my PC so that I can connect to UniData Redback on my UNIX box. Note that my web server running IIS is on yet a 3rd box. My documentation is slim to none and I am hoping to get some guidance. Everything is working fine on my UNIX box (RedBack and UniData) and all is good on my web server. I just need to get U2WebDE running from my PC. As I recall, when it asks if I want the Complete or Custom setup, I choose Custom. I am fine with the destination of C:\IBM\U2WEBDE When it asks for which features, it defaults to 1) U2 Web Designer, 2) IIS Gateway 3) International Licenses. If I click Next, I get a window showing an empty box stating: 0 IIS web sites are defined. Select one to use in this installation. Obviously, I am missing something here. If I backup to the features and also turn on the RedBack Object Server for UniData, and click next, it wants to start a Database service on my PC, but UniData is on a UNIX box. Where am I going wrong? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 Web DE Re-install
Thanks Brian! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, March 12, 2013 12:22 PM To: 'U2 Users List' Subject: Re: [U2] U2 Web DE Re-install And after all of *that*, make sure you have installed .NET framework 4 on the web server, and if you are using old ASP style pages, you need to register the COM wrappers. Only supports the connection by name (the old open2 syntax) not the older connection via ADODB. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 12 March 2013 14:55 To: U2 Users List Subject: [U2] U2 Web DE Re-install My PC dies a few weeks ago and I am trying to re-install the U2 Web DE package on my PC so that I can connect to UniData Redback on my UNIX box. Note that my web server running IIS is on yet a 3rd box. My documentation is slim to none and I am hoping to get some guidance. Everything is working fine on my UNIX box (RedBack and UniData) and all is good on my web server. I just need to get U2WebDE running from my PC. As I recall, when it asks if I want the Complete or Custom setup, I choose Custom. I am fine with the destination of C:\IBM\U2WEBDE When it asks for which features, it defaults to 1) U2 Web Designer, 2) IIS Gateway 3) International Licenses. If I click Next, I get a window showing an empty box stating: 0 IIS web sites are defined. Select one to use in this installation. Obviously, I am missing something here. If I backup to the features and also turn on the RedBack Object Server for UniData, and click next, it wants to start a Database service on my PC, but UniData is on a UNIX box. Where am I going wrong? JRI ___ 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] SB 5.5
OK gurus, here's one for you: Using SB 5.5, I make changes to my settings (like background color) and then Save Configuration As... and give it a New Session Name under the Classic tab. I can now see this as one of the available configurations the next time I log in. Where the heck is this saved? I haven't found any files in the C:\SBClient folder that have today's date. Thanks JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB 5.5
Thanks - that got me started. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Tuesday, March 12, 2013 3:16 PM To: 'U2 Users List' Subject: Re: [U2] SB 5.5 It used to be in the TUSTATE file - not sure if it's changed now or not. It should be buried somewhere in your user account - likely under application data Colin -Original Message- From: Israel, John R. Sent: Tuesday, March 12, 2013 12:53 PM To: U2 Users List Subject: [U2] SB 5.5 OK gurus, here's one for you: Using SB 5.5, I make changes to my settings (like background color) and then Save Configuration As... and give it a New Session Name under the Classic tab. I can now see this as one of the available configurations the next time I log in. Where the heck is this saved? I haven't found any files in the C:\SBClient folder that have today's date. Thanks JRI ___ 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] User cannot login
Windows or UNIX? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Monday, March 11, 2013 4:33 PM To: U2 Users List Subject: [U2] User cannot login I have a user, one of my system admins, that cannot login to Universe. Their user account is setup exactly like mine, there is no voc entry for the user and I have deleted and recreated the user a couple times just today. Is there anything else I can look at that would be preventing the him from logging in? We're running 10.0.21 on windows server 2003. Thanks, Jake Holt l samsill l Information Technology Director (817) 536 - 1906 x 217 l jh...@samsill.com www.samsill.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
[U2] VOC Pointer
I need to copy PDFs from a Windows server into a UNIX dir (where UniData lives). Can I map a VOC pointer? Other thoughts? Running HPUX, UniData 7.2.1. John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] VOC Pointer
We have used Samba other ways, but I have never actually tried to copy from Windows to Unix. What would the syntax be to copy? Thanks JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Monday, March 04, 2013 3:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] VOC Pointer On 04/03/13 20:36, Israel, John R. wrote: I need to copy PDFs from a Windows server into a UNIX dir (where UniData lives). Can I map a VOC pointer? Can the unix machine see a windows share? You MAY be able to put a network path in field 2 of a voc entry, but by default, if UD recognises a network path it'll probably refuse to access it. And is copying PDFs (binary files) using the UD command line a good idea? Other thoughts? Put samba on the HPUX box, share your HPUX directory, and copy the pdfs from Windows to nix. Or if you need to do it from the nix end, share your Windows directory and use smbmount (probably part of samba, I'm not quite sure what's happened to it) to make the windows share look like a nix directory where you can use nix commands to copy. Running HPUX, UniData 7.2.1. John Cheers, Wol ___ 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] VOC Pointer
Nightly background run every night. It has to work w/o user intervention. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rutherford, Marc Sent: Monday, March 04, 2013 3:50 PM To: U2 Users List Subject: Re: [U2] VOC Pointer John, If this is one-time manual transfer I would suggest you use ftp. Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, March 04, 2013 12:37 PM To: U2 Users List Subject: [U2] VOC Pointer I need to copy PDFs from a Windows server into a UNIX dir (where UniData lives). Can I map a VOC pointer? Other thoughts? Running HPUX, UniData 7.2.1. John ___ 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] VOC Pointer
I have done things from Window to UNIX with Samba before. As you say, we do it all the time. The issue I have is I need my Unix box to grab the data from Windows and copy it from Windows to Unix. The copy needs to be run from Unix, not Windows. THAT is the problem I am having. Mapping a network drive in Windows will be great from Windows, but will not solve the problem of issuing the command from Unix (unless I am completely missing the point). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, March 04, 2013 4:06 PM To: U2 Users List Subject: Re: [U2] VOC Pointer If copying from the windows server to the HP-UX machine... If you use the samba method... you would need: 1) Samba installed on HP-UX server running Unidata 2) Setup a share to share a directory on HP-UX 3) Map the network drive on the Windows Server 4) Just do a standard windows copy from one drive letter to the other That being said, my steps above are grossly over-simplified If you have never done a samba install on HP-UX and configuration before, this could take you several days/weeks. If its a one time deal, then the previous posters idea of ftp, is so much easier. Its been a number of years, since I put samba on HP-UX. If you can find a package that utilizes swinstall (sam) somewhere out on the web, it might make your life easier. On Mon, Mar 4, 2013 at 3:55 PM, Israel, John R. johnisr...@daytonsuperior.com wrote: We have used Samba other ways, but I have never actually tried to copy from Windows to Unix. What would the syntax be to copy? Thanks JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Monday, March 04, 2013 3:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] VOC Pointer On 04/03/13 20:36, Israel, John R. wrote: I need to copy PDFs from a Windows server into a UNIX dir (where UniData lives). Can I map a VOC pointer? Can the unix machine see a windows share? You MAY be able to put a network path in field 2 of a voc entry, but by default, if UD recognises a network path it'll probably refuse to access it. And is copying PDFs (binary files) using the UD command line a good idea? Other thoughts? Put samba on the HPUX box, share your HPUX directory, and copy the pdfs from Windows to nix. Or if you need to do it from the nix end, share your Windows directory and use smbmount (probably part of samba, I'm not quite sure what's happened to it) to make the windows share look like a nix directory where you can use nix commands to copy. Running HPUX, UniData 7.2.1. John Cheers, Wol ___ 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 -- John Thompson ___ 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] VOC Pointer
Let me give a full picture. I have a program on our Unix box running UniData. This program processes a BUNCH of nightly stuff including the launching of our PDF invoices which are built on a Windows server (I have no control of that). When the job finishes, one of the things I need to do is verify that the PDFs were in fact created and then send them out to a 3rd party source to be printed, stuffed and mailed. I thought it would be easier to copy the PDFs back to a temp folder on the Unix box, tar them and send them to the 3rd party processing company. I understand that I could have a job on the Windows box do this part, but then I would need some mechanism to fire off the script on the WIndows box. Then, when the Windows script is done, it would need some way to fire off/release the continuation of the tasks on the Unix box. Timing is important here. It may seem clumsy to pull the PDFs back on the Unix box, but I was trying to keep all the control in one place and not try to chain things between difference boxes and hope I got my timings right. Fewer points of failure and no real timing issues. STOP LAUGHING AT ME! JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rutherford, Marc Sent: Monday, March 04, 2013 4:24 PM To: U2 Users List Subject: Re: [U2] VOC Pointer So --- you want to a Unix process to drive a script (Remote Procedure Call) which would run on Windows; the RPC would gather the required files from elsewhere in the Windows world a copy them to the share folder? Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, March 04, 2013 1:12 PM To: U2 Users List Subject: Re: [U2] VOC Pointer I have done things from Window to UNIX with Samba before. As you say, we do it all the time. The issue I have is I need my Unix box to grab the data from Windows and copy it from Windows to Unix. The copy needs to be run from Unix, not Windows. THAT is the problem I am having. Mapping a network drive in Windows will be great from Windows, but will not solve the problem of issuing the command from Unix (unless I am completely missing the point). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, March 04, 2013 4:06 PM To: U2 Users List Subject: Re: [U2] VOC Pointer If copying from the windows server to the HP-UX machine... If you use the samba method... you would need: 1) Samba installed on HP-UX server running Unidata 2) Setup a share to share a directory on HP-UX 3) Map the network drive on the Windows Server 4) Just do a standard windows copy from one drive letter to the other That being said, my steps above are grossly over-simplified If you have never done a samba install on HP-UX and configuration before, this could take you several days/weeks. If its a one time deal, then the previous posters idea of ftp, is so much easier. Its been a number of years, since I put samba on HP-UX. If you can find a package that utilizes swinstall (sam) somewhere out on the web, it might make your life easier. On Mon, Mar 4, 2013 at 3:55 PM, Israel, John R. johnisr...@daytonsuperior.com wrote: We have used Samba other ways, but I have never actually tried to copy from Windows to Unix. What would the syntax be to copy? Thanks JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Monday, March 04, 2013 3:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] VOC Pointer On 04/03/13 20:36, Israel, John R. wrote: I need to copy PDFs from a Windows server into a UNIX dir (where UniData lives). Can I map a VOC pointer? Can the unix machine see a windows share? You MAY be able to put a network path in field 2 of a voc entry, but by default, if UD recognises a network path it'll probably refuse to access it. And is copying PDFs (binary files) using the UD command line a good idea? Other thoughts? Put samba on the HPUX box, share your HPUX directory, and copy the pdfs from Windows to nix. Or if you need to do it from the nix end, share your Windows directory and use smbmount (probably part of samba, I'm not quite sure what's happened to it) to make the windows share look like a nix directory where you can use nix commands to copy. Running HPUX, UniData 7.2.1. John Cheers, Wol ___ 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
Re: [U2] VOC Pointer
From a basic pgm, yes, but I can run UNIX commands as needed. I might be off course here. See E-mail from a minute ago for a full picture. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, March 04, 2013 4:32 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] VOC Pointer Hang on Kee Mo Sa Be. I thought you wanted to map a VOC pointer ? That implies you want to run this from *inside* U2... not from Unix, but rather from BASIC ? -Original Message- From: Rutherford, Marc marc.rutherf...@advancedbionics.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Mar 4, 2013 1:24 pm Subject: Re: [U2] VOC Pointer So --- you want to a Unix process to drive a script (Remote Procedure Call) which would run on Windows; the RPC would gather the required files from elsewhere in the Windows world a copy them to the share folder? Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, March 04, 2013 1:12 PM To: U2 Users List Subject: Re: [U2] VOC Pointer I have done things from Window to UNIX with Samba before. As you say, we do it all the time. The issue I have is I need my Unix box to grab the data from Windows and copy it from Windows to Unix. The copy needs to be run from Unix, not Windows. THAT is the problem I am having. Mapping a network drive in Windows will be great from Windows, but will not solve the problem of issuing the command from Unix (unless I am completely missing the point). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, March 04, 2013 4:06 PM To: U2 Users List Subject: Re: [U2] VOC Pointer If copying from the windows server to the HP-UX machine... If you use the samba method... you would need: 1) Samba installed on HP-UX server running Unidata 2) Setup a share to share a directory on HP-UX 3) Map the network drive on the Windows Server 4) Just do a standard windows copy from one drive letter to the other That being said, my steps above are grossly over-simplified If you have never done a samba install on HP-UX and configuration before, this could take you several days/weeks. If its a one time deal, then the previous posters idea of ftp, is so much easier. Its been a number of years, since I put samba on HP-UX. If you can find a package that utilizes swinstall (sam) somewhere out on the web, it might make your life easier. On Mon, Mar 4, 2013 at 3:55 PM, Israel, John R. johnisr...@daytonsuperior.com wrote: We have used Samba other ways, but I have never actually tried to copy from Windows to Unix. What would the syntax be to copy? Thanks JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Monday, March 04, 2013 3:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] VOC Pointer On 04/03/13 20:36, Israel, John R. wrote: I need to copy PDFs from a Windows server into a UNIX dir (where UniData lives). Can I map a VOC pointer? Can the unix machine see a windows share? You MAY be able to put a network path in field 2 of a voc entry, but by default, if UD recognises a network path it'll probably refuse to access it. And is copying PDFs (binary files) using the UD command line a good idea? Other thoughts? Put samba on the HPUX box, share your HPUX directory, and copy the pdfs from Windows to nix. Or if you need to do it from the nix end, share your Windows directory and use smbmount (probably part of samba, I'm not quite sure what's happened to it) to make the windows share look like a nix directory where you can use nix commands to copy. Running HPUX, UniData 7.2.1. John Cheers, Wol ___ 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 -- John Thompson ___ 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
Re: [U2] UV full screen editor
We are on a UNIX box and have SAMBA running. This lets me use any Windows text editor I want. Personally, I use SlickEdit because it has lots of features that I find very useful. It does NOT have anything built in to compile and catalog because it does not really understand that my BP source code is actually code. Just my 2 cents. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Tuesday, February 26, 2013 5:30 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV full screen editor On 26/02/13 08:38, Symeon Breen wrote: I seem to remember when we used such things that the costs in the uk where pretty similar. Wintegrate also did some emulations that accuterm did not and we needed those, but the other problem I have with Accuterm is that it is very American (not being rude here) so it has some funny (to us Europeans) way of doing things, and always looks very old fashioned. Each to their own I guess The thing with wIntegrate for us was emulation too - pretty much every emulator we tried failed somewhere. With wIntegrate it was easy to get at the definition files and re-define the client end to match the server - the VT emulation in particular bit us hard. The current official PT emulation is mostly my hard work :-) I doubt they've done anything to it since they replaced the original bare-bones version with mine back in the days of v3. Cheers, Wol ___ 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] : Evaluating DCOUNT
Or use dimensioned arrays instead of dynamic arrays. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, February 11, 2013 8:43 AM To: 'U2 Users List' Subject: Re: [U2] : Evaluating DCOUNT Jeff, My understanding is part of our problem is the fact that my multivalues are at position 200 and each time it has to count how many multivalues there are, it has to skim through the first 200 attributes, multivalues and subvalues to get to 200 before it even starts counting. So it's not so much of an issue of how many multivalues there are in 200, it's everything in 1-199 as well. Which in turn suggests that, when designing files, it may be a good idea to cluster your multivalue attributes near the beginning of your records. But that's another discussion. Sincerely, David Laansma Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, February 11, 2013 8:35 AM To: U2 Users List Cc: U2 Users List Subject: Re: [U2] : Evaluating DCOUNT David is correct (re: performance). Most of our app here have MV lists under 40-50 so it's not a huge issue. If you app has hundreds+ this could be a big challenge. Jeff Butera -- A tree falls the way it leans. Be careful which way you lean. The Lorax On Feb 11, 2013, at 8:30 AM, Dave Laansma dlaan...@hubbardsupply.com wrote: I would HOPE that it evaluates it each time since the size of array could change within the loop. Personally if the size of array is relatively small, DCOUNT is alright. However I've found REMOVE to be EXTREMELY faster and therefore use it whenever possible, even on small arrays. For example, we have two files, a 'header' and 'detail' file. The keys to the 'detail' file are stored in attribute 200 of the header file. So I'll pull the keys out of the header record, such: LINE.KEYS = HEADER.REC200 D1 = LOOP UNTIL D1 = 0 REMOVE LINE.KEY FROM LINE.KEYS SETTING D1 loop statements REPEAT As opposed to: FOR V1 = 1 TO DCOUNT(HEADER.REC200,@VM) LINE.KEY = HEADER.REC200,V1 loop statements NEXT V1 Based on historical dialogs on this subject on this forum, I have seen an improvement in overall performance. Sincerely, David Laansma Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, February 11, 2013 7:55 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] : Evaluating DCOUNT On 02/11/2013 12:14 AM, Peter Cheney wrote: Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track of what's going on? e.g. for i = 1 to dcount(array,@fm) *commands here next i versus totalattributes = dcount(array,@fm) for i = 1 to totalattributes *commands here next i Apart from readability and perhaps easier debugging is there an actual internal difference? I know it was an issue on older pick releases but I cannot remember if it ever affected UV? Not sure about universe, but unidata defintely checks the DCOUNT for each iteration. This produces 4 (not 2): CT=0 X=45:@VM:58 FOR I=1 TO DCOUNT(X,@VM) CT+=1 IF I=2 THEN X1,-1 = 99 END NEXT I CRT CT -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ 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] Record locks (Unidata 7.2)
I would also add some type of bailout logic in case the record NEVER frees up (user went home for the weekend). Obviously, you need to make the call on this on a case by case situation, but you would not want a critical process (like month end) to fail because Joe Blow left a record locked. Should you finish the other 99.% of month end or have it fail completely? Again, you need to make this call on a case by case basis for your application. MAX.TRIES = 1000 TRIES = 0 TRY.AGAIN: READU STU.REC FROM STU.FILE, STU.ID LOCKED CRT STU.ID: RECORD IS LOCKED SLEEP 2 TRIES += 1 IF (TRIES = MAX.TRIES) THEN * track this condition somehow and move on GOTO SKIP END GOTO TRY.AGAIN END THEN STU.REC48 = INST.CRED STU.REC49 = INET.CRED WRITE STU.REC ON STU.FILE, STU.ID END SKIP: John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, February 08, 2013 1:10 PM To: Jon Wells; U2 Users List Subject: Re: [U2] Record locks (Unidata 7.2) You should have written it something like this: TRY.AGAIN: READU STU.REC FROM STU.FILE, STU.ID LOCKED CRT STU.ID: RECORD IS LOCKED SLEEP 2 GOTO TRY.AGAIN END THEN STU.REC48 = INST.CRED STU.REC49 = INET.CRED WRITE STU.REC ON STU.FILE, STU.ID END You have to add the label TRY.AGAIN: so you have a jump point then add the SLEEP command for 2 seconds and lastly the GOTO command so after the SLEEP expires, execution remains at the READU command. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Friday, February 08, 2013 9:57 AM To: U2 Users List Subject: Re: [U2] Record locks (Unidata 7.2) I should add that (in our test account) I switched to the READU statement along with a LOCKED clause - READU STU.REC FROM STU.FILE, STU.ID LOCKED CRT STU.ID: RECORD IS LOCKED END THEN STU.REC48 = INST.CRED STU.REC49 = INET.CRED WRITE STU.REC ON STU.FILE, STU.ID END I locked one of the records in the list I was processing. When the program was working on that record, the CRT statement was executed, and the program moved right along processing the rest of the list; and record I had locked was not updated. Looking through the 'UniBasic Commands Reference' PDF, I found 'RECORDLOCKED (file.var, rec.id.expr)'. Perhaps this could be used within a LOOP to control things, allowing terminal input where the user can choose what to do about the record lock? I've decided to write the data to a new file, so this is no longer a big issue for me. If I had created the program using our vendor's tool kit, the generated code would have added all the appropriate gunk the system uses for record locks. The responses have been interesting as I've been looking for a chance to better understand how Unidata shops handle locks. Thank you, Jon Wells From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Sent: Friday, February 8, 2013 2:30 AM Subject: Re: [U2] Record locks (Unidata 7.2) I think people understand exactly what you're saying, but disagree. Most applications don't use the more rigorous coding for having a Locked clause that provides additional information to the user, retries, etc. That's not wrong, it's just not necessary ... depending on the site. That said, when we used to have a lot of people in an office and a dumb terminal beeping was a recognized message to everyone, it was OK (generally) to just do the READU. These days with more alternative UIs, thick-client, thin-client, web services, mobile, etc, there's no one to hear that beep. So for modern development I would agree that you really don't want an unconditional lock hanging around, you want a Locked clause with logic to rollback the transaction and exit gracefully, perhaps with a message sent to the site admin. The penalty for Not having a Locked clause with a new UI is that the port will hang, the UI will receive a timeout (which many clients aren't prepared to process), and the DBMS port could be sitting there indefinitely with no one aware of the condition. This can cascade to multiple ports until suddenly everything grinds to a halt and GUI users around the world are unable to access the app. I believe some heads will be nodding here because I hear about this happening occasionally. T From: Wjhonson Then you're misunderstanding what I'm saying. From: Kevin King +1. Well stated. Woodward, Bob wrote: In an active user session where users are obtaining a lock for a length of time, you're right. There are lots of times, though, that lock intervention is not a benefit. It all depends on the need of the application and many situations where I would highly recommend using the
Re: [U2] Searching for 'Bad' Dates
Write a new dict w/o the conversion code and select on it. John Israel Sent from my iPhone On Jan 29, 2013, at 5:38 PM, Greg Coelho coe...@american.edu wrote: All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE .. ./... (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ 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] U2 Web Designer - New Module Redback Object
I have never built a new module with web DE and I am having troubles. I went to VOC APP.IDS and added TA (Time and Attendance). When I fire up U2 Web DE, TA now appears as a module. Cool. Shooting in the dark, I build the following 3 DIR files: TACLASSES TADRIVERS TAOBJECTS and set the permissions on those DIRs as needed. This was done because the other two modules each have 3 similar DIR files. How do I build a new object in Web DE? If I right-click on the TA module, then New, then Redback Object, it gives me the following error: Server Error Status= -1, Error=Error in ReplyParser: null argument. Am I missing something simple, or not even close? John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universal COMO
Depending on the naming convention used, you might step on another COMO that you wish to preserve. Add the account name to the COMO name to avoid this (or something like that). Permissions could be an issue depending on your set up. However, with a bit of thought, this could be very useful. One-stop shopping. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, January 23, 2013 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universal COMO By default, Universe will create several files in each account you create. Like SAVEDLISTS, and ED... one of these default files is COMO which is where you can stick session logs. We use this constantly to monitor the output of phantoms, for review and debugging the next day. The logs are emailed to myself and some other programmers here. By altering the VOC entries in the accounts, we could have a central, universal COMO for all accounts, instead of one for each account. I see a *pro* in this, for the ease of cleaning up old logs from years ago, obviously no longer needed, which can be done from the O/S level. What might be a *con* ? Will Johnson ___ 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] DataStage Question
I have a simple I-Desc that is calling a subroutine. This works perfectly in UniData, but when Datastage tries to reference the I-Desc, it blows up with the following error: xSalesDelvEnhancement..sohdr.DSLink13: ds_udtGetNextPacket Error calling DSHELPER subroutine - 30107 - Subroutine failed to complete successfully I am not a Datastage guy and my Datastage guy is not a UniData guy, so we are all scratching our heads. What very little I see under Google suggests that we need to rebuild the repository index by running DS.REINDEX ALL from the Datastage shell. That seems a bit extreme and my Datastage guy does not think this is it. Any pearls of wisdom on this little gem? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataStage Question
Amy, We ARE using an older version of Datastage. Part of this project is to upgrade, but we are not there yet. If I can prove that it will work with the new version, I will try to blow this issue off for now, but I do need something to report back to the powers-that-be. Unfortunately, I do not have access to the exact version we are using at this moment. Is there a version I can report that should resolve this issue? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Tuesday, January 22, 2013 4:34 PM To: U2 Users List Cc: Jasti, Srini R.; Majors, Larry Subject: Re: [U2] DataStage Question What version DataStage are you on? (is it old enough to be the old ObjectCall interface?) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, January 22, 2013 1:16 PM To: 'U2 Users List' Cc: Jasti, Srini R.; Majors,Larry Subject: [U2] DataStage Question I have a simple I-Desc that is calling a subroutine. This works perfectly in UniData, but when Datastage tries to reference the I-Desc, it blows up with the following error: xSalesDelvEnhancement..sohdr.DSLink13: ds_udtGetNextPacket Error calling DSHELPER subroutine - 30107 - Subroutine failed to complete successfully I am not a Datastage guy and my Datastage guy is not a UniData guy, so we are all scratching our heads. What very little I see under Google suggests that we need to rebuild the repository index by running DS.REINDEX ALL from the Datastage shell. That seems a bit extreme and my Datastage guy does not think this is it. Any pearls of wisdom on this little gem? JRI ___ 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] DataStage Question
ARGH!!! That is most likely it! Thanks Dan. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, January 22, 2013 4:49 PM To: U2 Users List Subject: Re: [U2] DataStage Question Does the subroutine rely on any information set in COMMON blocks that might be available during telnet login, but not when called via DataStage? This is the biggest problem I've seen in my prior experience with DataStage -- U2 Does it work when you change the i-type to just return some dummy static information? Dan McGrath Managing Director, U2 Servers Lab Rocket Software 4600 South Ulster Street · Suite 1100 · Denver, CO 80237 · USA T: +1 720 475 8098 · E: dmcgr...@rocketsoftware.com · W: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, January 22, 2013 2:16 PM To: 'U2 Users List' Cc: Jasti, Srini R.; Majors, Larry Subject: [U2] DataStage Question I have a simple I-Desc that is calling a subroutine. This works perfectly in UniData, but when Datastage tries to reference the I-Desc, it blows up with the following error: xSalesDelvEnhancement..sohdr.DSLink13: ds_udtGetNextPacket Error calling DSHELPER subroutine - 30107 - Subroutine failed to complete successfully I am not a Datastage guy and my Datastage guy is not a UniData guy, so we are all scratching our heads. What very little I see under Google suggests that we need to rebuild the repository index by running DS.REINDEX ALL from the Datastage shell. That seems a bit extreme and my Datastage guy does not think this is it. Any pearls of wisdom on this little gem? JRI ___ 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] Redback w/o Web Page
Normally, a web page will create an object, populate some properties, then execute a method to pass the object and its properties to a U2 program (in my case UniData). No problem. I am working on a new and complicated process and I would like to cut out the web part of this for the moment and make sure that I have a solid foundation in my basic code data. I have written my main program, and I have written a very small driver program that simply loads the properties of the object, then calls the main program. The problem is, the web page usually creates the object. My driver program can set a property (simulating what the web page would do), but if I get the property in the very next line, it is empty. I assume this is because the object does not exist (though it did not give any errors). How do I build an object from within a basic program? Thanks John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Redback w/o Web Page
Thanks - I will go with that. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, January 14, 2013 12:31 PM To: 'U2 Users List' Subject: Re: [U2] Redback w/o Web Page Hi John What I've done to test RBOs is to replace the RBO.getProperty and RBO.setProperty functions with my own wrappers that just map the properties to a name-value pair held in a common block. When you don't want to run in test mode the wrappers can fall back to calling the real RBO.getProperty and RBO.setProperty functions. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 14 January 2013 17:15 To: 'U2 Users List' Subject: [U2] Redback w/o Web Page Normally, a web page will create an object, populate some properties, then execute a method to pass the object and its properties to a U2 program (in my case UniData). No problem. I am working on a new and complicated process and I would like to cut out the web part of this for the moment and make sure that I have a solid foundation in my basic code data. I have written my main program, and I have written a very small driver program that simply loads the properties of the object, then calls the main program. The problem is, the web page usually creates the object. My driver program can set a property (simulating what the web page would do), but if I get the property in the very next line, it is empty. I assume this is because the object does not exist (though it did not give any errors). How do I build an object from within a basic program? Thanks John ___ 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] [UV]Corrupted object in global catalog
Brian, I am not familiar with the Ideal flavor. However, I do know that there are several differences in how some commands work between the native UniData and Pick flavor. The LOCATE command comes to mind and has burned me a few times. Depending on the line of code, it may still compile, but will be looking at the wrong multi-value level (@FMs instead of @VMs, etc.) One of the things I have done to get around this (in UniData) is to use force the program to compile in the flavor that is not native to the account I am in. For example, if I am in a native UniData account, but I want the program to use Pick syntax, the first line of code would be: $BASICTYPE P I hope that helps of at least points you in a useful direction. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com Sent: Friday, December 28, 2012 10:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV]Corrupted object in global catalog Greetings, all! We have recently upgraded to the latest version of our vendor's software, and in the process have gone from Pick flavored accounts to Ideal flavored accounts. This has drastically changed the way programs are cataloged, as we are now using the global catalog directory (catdir, aka GLOBAL.CATDIR). We have discovered that some of the object code in the global catalog is corrupted (for lack of a better term). It looks like some of the object code files were somehow truncated. Since we don't discover this until someone notices that a program is behaving oddly, or working differently between the different servers (dev, test, production), and since the date stamp on the file in the catdir directory is the last time someone ran the program (as opposed to the time it was actually cataloged), it is impossible to tell if the object code was 'bad' from the beginning or got corrupted somewhere along the way. At this point, we can just recatalog everything. It would be a royal pain, but it is possible to do. That would ensure everything was all good right now, but doesn't do anything to make sure it stays that way. Does anyone know if there is a command we can ruin or some other way to verify object code in the global catalog? We would much rather monitor this proactively than wait until a user runs into a mysterious issue that we can't explain - or worse, runs something that ends up corrupting data because of a problem with the object code. Of course the ideal would be to figure out what's corrupting the object code to begin with - or to be able to determine if it was somehow corrupted in the initial install and we're just running into the bad pieces now. Without being able to monitor the object code and see when/if it gets corrupted again, though, that's going to be almost impossible. Any assistance would be greatly appreciated! Thanks! Brian _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata DICT size
That should not be a problem. Note that with that many elements, you would be STRONGLY advised to write your code with dimensioned arrays, not dynamic ones. Performance will be amazingly faster (assuming you have a bunch of records in the data file). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, December 10, 2012 3:30 PM To: U2 Users List Subject: [U2] Unidata DICT size So I'm curious how large a dictionary of Data elements (not I-desc) people have used on a single table in Unidata. We have a couple of tables with 200ish data elements in them and I'm facing a project that could see single tables with 400+ data elements. I assume this is no issue assuming the DICT is resized appropriately (like any other table), but curious to here people's input regarding performance and other factors. -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ 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] Advantage of indirect call in BASIC
Maybe some plan to change SOUREC at some key point w/o having to change it in multiple places? Looks like an idea that wasn't fully thought out, but that is just my 2 cents worth. Maybe someone has some pearls of wisdom on this. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, December 03, 2012 7:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Advantage of indirect call in BASIC I've not encountered this is my career previously, but now I'm seeing a system written almost entirely with the use of indirect calls in Universe BASIC. That is SOURCE = *SOME.PROGRAM ... CALL @SOURCE(INPUTS) Is there some advantage to the use of indirect calls that a system would be written entirely in this fashion? ___ 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] Advantage of indirect call in BASIC
As far as the number of arguments changing, I will often write a subroutine with a few extra variables (FUTURE1, FUTURE2, FUTURE3) so that I do not need to find all the existing programs that call it and recompile them. It makes this sort of thing a piece of cake. The existing programs will likely not need to populate the arguments other than initialized to null. John Israel Sent from my iPhone On Dec 3, 2012, at 9:28 PM, Kate Stanton k...@walstan.com wrote: I would hate to see that in our software, as it would be so hard to find where a subroutine is used. On the odd occasion we use this form (eg call depends on transaction type), we do the definition just above, so it can be found. In my experience, the number of parameters is more likely to change that the subroutine name. On 4 December 2012 13:38, Wjhonson wjhon...@aol.com wrote: I've not encountered this is my career previously, but now I'm seeing a system written almost entirely with the use of indirect calls in Universe BASIC. That is SOURCE = *SOME.PROGRAM ... CALL @SOURCE(INPUTS) Is there some advantage to the use of indirect calls that a system would be written entirely in this fashion? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.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
Re: [U2] BFORMAT
FORMAT -M0 -I2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, November 28, 2012 4:51 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] BFORMAT ED BP A 10 lines long : FOR Try HELP. -Original Message- From: Martin Braid mbr...@epicor.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Nov 28, 2012 1:48 pm Subject: Re: [U2] BFORMAT Pass on BFORMAT but ummm, doesn't ED have the FOR command? FOR -M0 -I2 (margin zero, indent 2) Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett Sent: 28 November 2012 21:43 To: U2 Users List Subject: Re: [U2] BFORMAT Hi Does anybody have a working copy of BFORMAT - I downloaded it from some useful site a long time back and modded it to work for modern UniVerse, but somewhere along the line (one late night) I have introduced some bugs I don't have time to go fix.. so before I do, maybe someone out there already has a BASIC formatting program that will allow me to only have an indent of 2 spaces instead of the usual 6? Anyone? Thanks Dennis ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== mFG8GTB3HjWZZWswXfBxQrQmlpQUG1hf7xue2rhFpgg0Q== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multiple UniData Indexes in same select
Thanks Wally. I was waiting for the official word. John Israel -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, November 07, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] Multiple UniData Indexes in same select From the Using UniData manual: Alternate Indexes in UniQuery Statement Prior to UniData 5.2, only one index was used in the selection criteria of a UniQuery statement, even if the selection criteria contained more than one indexed attribute. UniQuery now uses all available indexes when processing a statement containing selection criteria.Note: You cannot use an alternate index with a LIKE clause when the comparative attribute is numeric. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: u2.rocketsoftware.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Wednesday, November 07, 2012 7:35 AM To: U2 Users List Subject: [U2] Multiple UniData Indexes in same select Good morning, I should know this, but as the gray gets thicker, some of the old knowledge seeps away. If you have indexes on multiple attributes on a file in UniData AND you include both of those indexed attributes in the same Select statement, how does UniData know which index to use? Does it use both? Neither? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New Rocket U2 website!
NICE! Fairly intuitive, I can get the info I want quickly, it is visually pleasing w/o being overwhelming, etc. Well done. Just a thought: should there be a link at the bottom for the U2UG? It is not part of Rocket, but I think it makes sense. Maybe the U2 link at Linkedin too. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, October 25, 2012 4:59 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] New Rocket U2 website! For anyone who wants to check it out, we have launched a new website today: http://goo.gl/ON5qL Let's know what you think! Cheers, Dan ___ 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] SB+ question
Set all the fields to display only and associate the five trailing fields to the first one? Or Load into WORK variables and do the same as above? John Israel Sent from my iPhone On Oct 22, 2012, at 7:46 PM, Lunt, Bruce bl...@shaklee.com wrote: Hi All, I have a question that relates to how to display multiple pages of data on an entry screen that does not allow the lines in question to be modified. What we have is a screen that displays the current status of a customer. There are 6 different multivalued fields that are all related but they are just being displayed. There are 2 fields above the line-item section that do allow modification but the request is for me to allow the user to page up or down to review all of the line-items. On inquiry screens this is fairly simple but I don't know how to drive the pagination when the 6 fields are never even accessed by the screen. I tried to bump the @CNT field but that didn't work. Can someone suggests how I should handle this? All suggestions are greatly appreciated. Thanks in advance, Bruce Lunt ___ 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] Selection Suggestions for using UV instead of SQL
Do it in more than one command? SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID NSELECT PEOPLE Or am I missing something? John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 9:59 AM To: U2 Users Subject: [U2] Selection Suggestions for using UV instead of SQL Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. George ___ 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] Selection Suggestions for using UV instead of SQL
This gets a little trickier, but how about: 1) SELECT PEOPLE TO 1. 2) SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID. 3) SELECT PEOPLE TO 2. 4) MERGE.LIST 1 DIFF 2 TO 3. 5) SAVE.LIST XXX FROM 3. This does assume that steps 1 and 2 actually return at least 1 key. MERGE.LIST is an amazingly powerful command. It only works with the native UniData (UniVerse?) syntax as do the specific list #s, but it is easy enough to use the lower case verbs to force the individual commands to run in native mode. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 10:20 AM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL That was my first try, but the NSELECT only checks PEOPLE for those that are in the list returned by the first That are not in PEOPLE, it doesn't check for those in PEOPLE that are not in the list returned. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, October 17, 2012 10:05 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Do it in more than one command? SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID NSELECT PEOPLE Or am I missing something? John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 9:59 AM To: U2 Users Subject: [U2] Selection Suggestions for using UV instead of SQL Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. George ___ 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] Selection Suggestions for using UV instead of SQL
It looks like you have hit the point where code is needed because the SELECT just cannot handle all the conditions cleanly. My rule of thumb is: if I am going to need ANY code, do the whole thing in a program. Experience has taught me that at some point, someone will want to tweak things, and if it is already in a program, I will not migrating my Paragraphs (or whatever) into a program and them abandoning the paragraph. This may mean that I have REALLY simple program initially, but all too often, they grow over time. It also limits the number of places you need to look for that piece of code that is doing something. Just my 4 cents (2 cents w/ inflation) John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 12:02 PM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Meant to have left outer join, not inner join. BUT.I hit a snag. If someone has entries in REGISTRATION with EID = '1' and an EID = '2' - they still get selected, since the it passes The '1' test, but the outer join also pulls in the EID = '2'. So I'm going to have To do a loop through, or maybe the index method may work as well. Damn -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 10:28 AM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL I'm OK with using SQL - just wondering how you could use UV native. select distinct PEOPLE.PID from PEOPLE inner join REGISTRATION on (PEOPLE.PID = REGISTRATION.PID) where EID '1'; I will admit, UV could use a join clause. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 10:20 AM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL That was my first try, but the NSELECT only checks PEOPLE for those that are in the list returned by the first That are not in PEOPLE, it doesn't check for those in PEOPLE that are not in the list returned. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, October 17, 2012 10:05 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Do it in more than one command? SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID NSELECT PEOPLE Or am I missing something? John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 9:59 AM To: U2 Users Subject: [U2] Selection Suggestions for using UV instead of SQL Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. George ___ 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] Selection Suggestions for using UV instead of SQL
I like it! Once improvement: if the 2nd select fails, you should clear select list #1. Something like this: CMD = CMD-1 = PA CMD-1 = SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID TO 1 CMD-1 = IF @SYSTEM.RETURN.CODE 1 THEN GO THE.END CMD-1 = SELECT PEOPLE TO 2 CMD-1 = IF @SYSTEM.RETURN.CODE 1 THEN GO JUMP1 CMD-1 = MERGE.LIST 2 DIFF 1 CMD-1 = GO THE.END CMD-1 = JUMP1: CMD-1 = CLEARSELECT 1 CMD-1 = THE.END: EXECUTE CMD Even so, very cool! Thanks for sharing. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Wednesday, October 17, 2012 3:02 PM To: U2 Users List Subject: Re: [U2] Selection Suggestions for using UV instead of SQL That's a neat trick, I always assumed that you would have to write the paragraph out to the VOC and then execute it. I like this! Thanks. -Dianne On 10/17/2012 2:45 PM, David A. Green wrote: And to do this from UniBasic: CMD = CMD-1 = PA CMD-1 = SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID TO 1 CMD-1 = IF @SYSTEM.RETURN.CODE 1 THEN GO THE.END CMD-1 = SELECT PEOPLE TO 2 CMD-1 = IF @SYSTEM.RETURN.CODE 1 THEN GO THE.END CMD-1 = MERGE.LIST 2 DIFF 1 CMD-1 = THE.END: EXECUTE CMD David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Wednesday, October 17, 2012 10:54 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL select registration with EID = '1' saving unique PID to 1 select people to 2 merge.list 2 diff 1 Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 17, 2012 6:59 AM To: U2 Users Subject: [U2] Selection Suggestions for using UV instead of SQL Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could join the two, then do the select or use a subquery (I'm on UV 10.0.2 - not sure if sub querys work) Just curious how this could be done with UV Native, and without involving a program. I first tried SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID - NSELECT PEOPLE But that returned 0 - since the NSELECT only works off the current select list, not the whole file Yes, I could create a temporary file, then select off that Yes, I could read each people record, then loop through registration to see if it doesn't exist. Both of the above require programming I guess I could create a subroutine that does the looping through registration, and put that into an I descriptor - looking for another option. George ___ 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] Q-Pointers
Follow up from last week: I contacted a former co-worker who has contacts with some of the folks that worked with Dick Pick back in the original days. This guy said that when they were brain storming about how to develop the original Pick database, they talked about a way to point to things quickly, thus the Q in a Q-pointer stands for Quick. I would not stake my life on this answer, but this looks like the most accurate answer so far. John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Q-Pointers
My contact is Doug Owens with Ashwood Computer, Blue Ash (CIncinanti), OH Doug's contact is Henry (Hank) R Janicki, CEO and Founder of VirtualPlex, LLC John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 10:20 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Q-Pointers Cite this guy so we can record it in our history logs. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 6:50 am Subject: [U2] Q-Pointers Follow up from last week: I contacted a former co-worker who has contacts with some of the folks that worked with Dick Pick back in the original days. This guy said that when they were brain storming about how to develop the original Pick database, they talked about a way to point to things quickly, thus the Q in a Q-pointer stands for Quick. I would not stake my life on this answer, but this looks like the most accurate answer so far. John ___ 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] Friday type of question
But if there is a field or value mark, the record is not empty. John Israel Sent from my iPhone On Sep 1, 2012, at 12:35 AM, Wjhonson wjhon...@aol.com wrote: If there is an attribute mark or value mark, they count as part of the Length of the @Record. So a record with only a single value mark, still has a length of 1. -Original Message- From: Allen Elwood RR aelw...@socal.rr.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Aug 31, 2012 8:29 pm Subject: Re: [U2] Friday type of question does that still work if there are attr/value marks but everything else is null ? not sure, never tried, but i know i've seen recs with nothing but these before ellusian, lol, sounds like the aliens with the big brains that could make you see things that weren't there in star trek (had to look it up, it's talosians) On 8/31/2012 4:56 PM, Rutherford, Marc wrote: David, Create an 'I' type dictionary which with this function: 1 Top of REC_LEN 001: I 002: LEN( @RECORD ) 003: 004: LEN 005: 10R 006: S Select the file with your new dict = 0 SELECT PARTS WITH REC_LEN = 0 Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Morelli, David W. Sent: Friday, August 31, 2012 4:43 PM To: U2 Users List Subject: [U2] Friday type of question Is there an easy way to determine if a record is empty? I have a saved list of a thousand or more records that have record ID's that interfere with our Ellusian database. If they are truly empty, I can do house cleaning on them. If they contain any data, I have to do a different process. When I AE into a record I get :AE PERSON 2362 Top of 2362 in PERSON, 0 lines. So, it is really empty. I believe there must be a better way than handling every one of them, but I have been away from Unidata and forgotten everything. David Morelli Pacific University Oregon ___ 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] U2UG
What is the E-mail address for contacting support at U2UG? I clicked on the only link I could find (bo...@u2ug.org), but that got rejected (which suggests that needs to be reviewed). Thanks John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Web Error
Yesterday, we had a DR test where we used all of our DR hardware to test our DR plan. Everything in Avanté went fine as did most of our ePortal testing. However, when it came to the web pages connecting to the Avanté account (as opposed to connecting to the ePortal account), I am getting the nebulous 500 error message in my browser. To eliminate any misleading messages, I have bounced Redback (thus clearing out the logs and starting fresh), stopped IIS, cleared all logs in IIS, changed Windows\rgw.ini to use the DR box name (wdhp7640), then restarted IIS. When I attempt to go to the web page in question, I get: 2012-08-16 16:38:28 172.16.1.22 POST /eportal/std/storefront/shipping.asp guid=43442041196|162|80004005|Can't_connect_to_account_'LIVE.DATA'_(wdhp7640:8509)_rc=-1_ 443 - 192.168.9.232 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.1;+WOW64;+Trident/5.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+InfoPath.2;+.NET4.0C;+.NET4.0E) 500 0 0 15537 The key point being: Can't_connect_to_account_'LIVE.DATA'_(wdhp7640:8509) Here is the updated Windows\rgw.ini rbexamples wdhp7640:8501 rbodemo wdhp7640:8502 EPORTAL wdhp7640:8503 LIVE.DATA wdhp7640:8509 == EPORTAL_PILOT wdhp7640:8505 PILOT.DATA wdhp7640:8506 EPORTAL_DEV wdhp7640:8507 TEST.DATA wdhp7640:8508 [LogLevel] panic=1 err=1 wrn=0 inf=0 init=0 trace=0 verb=0 big=0 What am I missing? It connects to the EPORTAL account just fine. I have convinced management to leave things in a DR mode until the end of the day to try to figure this out. John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Array Types
SPEED! Other than the extra time spent to build it, it is MUCH faster to access VAR(1000) than to access VAR1000. If I know my variables are going to be small or I am doing reads, yeah, I use dynamic arrays. If I am building some big arrays in a program, I usually use dim arrays. One thing you CAN'T do is insert a value. If I have a real ugly array in a pgm that needs 1 more level of delimiting beyond @SVM, I will use a DIM array as my first level. Yeah, I know @TMs exist, but the functions do not know how to use them. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, July 27, 2012 11:16 AM To: U2 Users List Subject: [U2] Array Types I am surprised that anyone uses dimensioned arrays. I use dynamic arrays for everything. If there are any advantages that dimension arrays have over dynamic... please let me know... without getting sentimental. --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] Array Types
Yes! Thanks for that clarification. I did mean ATTRIBUTE. Thanks Charlie. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Friday, July 27, 2012 12:42 PM To: U2 Users List Subject: Re: [U2] Array Types Hi John, I had to jump in here, if for no other reason than to let people know I'm still alive and kicking. :-) When you said One thing you CAN'T do is insert a value. I hope you meant attribute. You can insert (and delete) values and subvalues all day long. If you are working with an item where a specific attribute position has meaning, and hopefully a dictionary item that defines it, you would not want to insert attributes anyway. That would lead to hair-pulling, gnashing of teeth and other bad things. If you're working on a variable length item such as a list of IDs, report, etc., a dynamic array is definitely the way to go. Just use whichever best fits the needs of the situation. Neither is inherently good or bad - it's all context driven. Regards, Charlie Noah Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) On 07-27-2012 11:27 AM, Israel, John R. wrote: SPEED! Other than the extra time spent to build it, it is MUCH faster to access VAR(1000) than to access VAR1000. If I know my variables are going to be small or I am doing reads, yeah, I use dynamic arrays. If I am building some big arrays in a program, I usually use dim arrays. One thing you CAN'T do is insert a value. If I have a real ugly array in a pgm that needs 1 more level of delimiting beyond @SVM, I will use a DIM array as my first level. Yeah, I know @TMs exist, but the functions do not know how to use them. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, July 27, 2012 11:16 AM To: U2 Users List Subject: [U2] Array Types I am surprised that anyone uses dimensioned arrays. I use dynamic arrays for everything. If there are any advantages that dimension arrays have over dynamic... please let me know... without getting sentimental. --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 ___ 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] Select Statement Invalid
I believe that using a lower case select forces the syntax to the native UniData mode, not flipping it to the other mode. Thus using SELECT or select in native UniData mode is the same, but in P mode, select will expect native UniData syntax. As stated earlier, paragraphs ONLY use the native syntax. Just change the syntax to: SELECT WIPMTLRQ WITH @ID LIKE 299486...302667...318583...337991...374396...376742...382767...385661... I hope this helps. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BobW Sent: Wednesday, July 11, 2012 11:08 PM To: 'U2 Users List' Subject: Re: [U2] Select Statement Invalid If he changed SELECT to select, would that get him the results he wants? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, July 11, 2012 5:10 PM To: U2 Users List Subject: Re: [U2] Select Statement Invalid Paragraphs run in U mode. Change it to a proc or change the syntax Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Wednesday, July 11, 2012 5:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] Select Statement Invalid Unidata 7.1.20, pick flavor I have this quick paragraph to select records based on partial keys: 001: PA 002: SELECT WIPMTLRQ WITH @ID = 299486]302667]318583]337991]374396]376742]382767]385661] 398932]415256]445409]453821] 454353]478175]478845]502457] Bottom. However, this is what I get when I run it: No data retrieved from current (S)SELECT statement. Yet if I run SELECT WIPMTLRQ WITH @ID = 299486] I get records returned. What am I missing? Thanks. Albert DeWitt, CPIM ___ 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 - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1392 / Virus Database: 1520/3887 - Release Date: 09/09/11 Internal Virus Database is out of date. ___ 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
