[U2] UniData Hash File Viewer
Before I go and reinvent the wheel, I was wondering if anyone has already created a program that will display the technical data within an UniData hash file? I'm talking Header information, being able to jump to any group, look at the keys in the group, look at the data in the group, see the overflow pointers, etc. I checked the Wiki but didn't see anything like this. I have written a cool program like this that just allows one to traverse an OS file, but isn't hash file smart. Before I go and modify it I thought I'd ask the list first. David A. Green (480) 201-7953 DAG Consulting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Read yourself
We always have a variable PGID defined at the top of the program. This at least HELPS identify the source code. Most of our programs have the ability to edit the code while you are in the program via some common hot-keys built into our core system. (controlled by security) There is also a hot-key to view source in a custom program, outside the editor. We use 'PGID' to identify the name of the current program. In universe, you may also look at the results of SYSTEM(9001) to get the current execution stack. If your object file is type-19, and long-names are ON - it's easy to parse. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, May 12, 2014 6:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Read yourself I understand how one could potentially do it. I was more interested to see if anyone had already done it. Cat pointers only work for catalogued entries by the way -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, May 12, 2014 4:41 pm Subject: 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/5fHCMUSyOqejhOqemhNEV7e6XCQrEFLThKCqejqdQkTXEFE CzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsSe 847QhPb_nV5BZZAQsZuVtd5ZPATTD67KmKDp55mVEVvVkffGhBrwqrhdICXCXCM0pYGjFY jfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3P3x I5-Aq83iS4QPiWq80n-E6y0JlKdfftdFFCW--6tgnb718Y ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr6jqb9EVd79EVp76zAsUrKrhKyC_t6WpEVdEThjvKyCy qejqdQkTXETpKrhKyCqenSm63hOr4qAUiF7vf1i6BFRxhJrUOH7BPq6BFRxhJrUOH7BPoU wgvh7cLZvAmnTSjhPRXBQQnTejvusouVqWtAklrCzB_BgY-F6lK1FJcSOrKrKr01DOFeDN c_7CQSOf00s4RtxxYGjB1SKdFBSWv6xJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dIfce6 MnWhEwdbojjdbFEw1vWwq82RmUQYZQSCCrHzJY ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPoQ93hJ5AQsCzAQsIzzhOesdTdEThjvKztcQsCQrEFLT hjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzO VIsg8fEzCn-LObbXX9EVWZOWqbXD9LLecfsJteOaaJPhO_OEuvkzaT0QSOrpdTdTdw0PVk DjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CS7 C73obZ8Qg6BI9FCBQQg0LZgd41qHsquuWrjjdPC62kJ0KQBUS ___ 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] Read yourself
OR you can use SYSTEM(9001) on universe OR you can use SYSTEM(9001) on universe OR you can use SYSTEM(9001) on universe OR you can use SYSTEM(9001) on universe OR you can use SYSTEM(9001) on universe Hmmm, thought someone said that already :-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, May 12, 2014 7:19 PM To: U2 Users List Subject: Re: [U2] Read yourself You can also use the program stack (UD - SYSTEM(49), UV - SYSTEM(9001), D3 - SYSTEM(33)). This gives not only the program running but the path. That ought to give needed information to both open the file and read the program source code. HTH, Bill - Original Message - *From:* d...@pickpro.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/12/2014 4:55 PM *Subject:* Re: [U2] Read yourself We always have a variable PGID defined at the top of the program. This at least HELPS identify the source code. Most of our programs have the ability to edit the code while you are in the program via some common hot-keys built into our core system. (controlled by security) There is also a hot-key to view source in a custom program, outside the editor. We use 'PGID' to identify the name of the current program. In universe, you may also look at the results of SYSTEM(9001) to get the current execution stack. If your object file is type-19, and long-names are ON - it's easy to parse. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, May 12, 2014 6:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Read yourself I understand how one could potentially do it. I was more interested to see if anyone had already done it. Cat pointers only work for catalogued entries by the way -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, May 12, 2014 4:41 pm Subject: 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/5fHCMUSyOqejhOqemhNEV7e6XCQrEFLThKCqejqdQkTXEF E CzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsS e 847QhPb_nV5BZZAQsZuVtd5ZPATTD67KmKDp55mVEVvVkffGhBrwqrhdICXCXCM0pYGjF Y jfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jr3P3 x I5-Aq83iS4QPiWq80n-E6y0JlKdfftdFFCW--6tgnb718Y ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr6jqb9EVd79EVp76zAsUrKrhKyC_t6WpEVdEThjvKyC y qejqdQkTXETpKrhKyCqenSm63hOr4qAUiF7vf1i6BFRxhJrUOH7BPq6BFRxhJrUOH7BPo U wgvh7cLZvAmnTSjhPRXBQQnTejvusouVqWtAklrCzB_BgY-F6lK1FJcSOrKrKr01DOFeD N c_7CQSOf00s4RtxxYGjB1SKdFBSWv6xJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dIfce 6 MnWhEwdbojjdbFEw1vWwq82RmUQYZQSCCrHzJY ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPoQ93hJ5AQsCzAQsIzzhOesdTdEThjvKztcQsCQrEFL T hjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplz O VIsg8fEzCn-LObbXX9EVWZOWqbXD9LLecfsJteOaaJPhO_OEuvkzaT0QSOrpdTdTdw0PV k DjUCvzPqrp7w0e2qKMM-l9OwXn6QOXtfzgSSCnrFYq5O5mUm-wafBitfyp-fdFJAu00CS 7 C73obZ8Qg6BI9FCBQQg0LZgd41qHsquuWrjjdPC62kJ0KQBUS ___ 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] Read yourself
Wont work --- if you use any external subroutines. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs Sent: Monday, May 12, 2014 7:18 PM To: U2 Users List Subject: Re: [U2] Read yourself You can get the Program name by parsing @SENTANCE You can then read the Verb from the VOC and act on that or if the item is globally catalogued then read the last line from your catdir item From unix level use strings $catpath/$item | tail -1 and then process that. HTH Sent from my iPad On 13 May 2014, at 9:33 am, Adrian Overs ove...@citysoft.com.au wrote: 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://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] Read yourself
IT'S JUST NOT TRUE EVER. @sentence cannot work. The stub program that launched an initial program will be in the @sentence... You could be 3 calls deep into external subroutines - there is nothing in @sentence re: the call-stack. Our shop writes *very* few stub programs - most are subroutines called by other subroutines. Instead: Add PGID=programName Or even PGID=filename ProgramName To the top of the program - quick and easy. Use of system routines such as SYSTEM(9001) is usually overkill. Your program should be aware of it's name - if no other reasons than: * display on the screen to help users identify where their problem came from * print on reports * add to log-file entries + and of course, to answer the original question: how can I read the current program source A well-designed system/program should hard-code as little as possible as well. What better key to use for a configuration record than the program name itself. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs Sent: Monday, May 12, 2014 7:39 PM To: U2 Users List Subject: Re: [U2] Read yourself That's true - if the subroutines are catalogued with a noxref clause you're screwed. Sent from my iPad On 13 May 2014, at 10:19 am, David Wasylenko d...@pickpro.com wrote: Wont work --- if you use any external subroutines. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs Sent: Monday, May 12, 2014 7:18 PM To: U2 Users List Subject: Re: [U2] Read yourself You can get the Program name by parsing @SENTANCE You can then read the Verb from the VOC and act on that or if the item is globally catalogued then read the last line from your catdir item From unix level use strings $catpath/$item | tail -1 and then process that. HTH Sent from my iPad On 13 May 2014, at 9:33 am, Adrian Overs ove...@citysoft.com.au wrote: 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://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] Read yourself
I think the point has been lost. The person is requesting the name of the CURRENT ROUTINE If that is A SUBROUTINE - there is no @ that I know of that returns the name of the currently executing routine. The fact the CALLING routine knows the name is #1, is of no value to this request and #2, lends nothing to any routine being self-aware. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs Sent: Monday, May 12, 2014 7:58 PM To: U2 Users List Subject: Re: [U2] Read yourself I totally agree with and endorse your programming standards David. However if the program is calling another subroutine it should know the name of that subroutine or be able to derive it if it is called with an @. Sent from my iPad On 13 May 2014, at 10:45 am, David Wasylenko d...@pickpro.com wrote: IT'S JUST NOT TRUE EVER. @sentence cannot work. The stub program that launched an initial program will be in the @sentence... You could be 3 calls deep into external subroutines - there is nothing in @sentence re: the call-stack. Our shop writes *very* few stub programs - most are subroutines called by other subroutines. Instead: Add PGID=programName Or even PGID=filename ProgramName To the top of the program - quick and easy. Use of system routines such as SYSTEM(9001) is usually overkill. Your program should be aware of it's name - if no other reasons than: * display on the screen to help users identify where their problem came from * print on reports * add to log-file entries + and of course, to answer the original question: how can I read the current program source A well-designed system/program should hard-code as little as possible as well. What better key to use for a configuration record than the program name itself. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs Sent: Monday, May 12, 2014 7:39 PM To: U2 Users List Subject: Re: [U2] Read yourself That's true - if the subroutines are catalogued with a noxref clause you're screwed. Sent from my iPad On 13 May 2014, at 10:19 am, David Wasylenko d...@pickpro.com wrote: Wont work --- if you use any external subroutines. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs Sent: Monday, May 12, 2014 7:18 PM To: U2 Users List Subject: Re: [U2] Read yourself You can get the Program name by parsing @SENTANCE You can then read the Verb from the VOC and act on that or if the item is globally catalogued then read the last line from your catdir item From unix level use strings $catpath/$item | tail -1 and then process that. HTH Sent from my iPad On 13 May 2014, at 9:33 am, Adrian Overs ove...@citysoft.com.au wrote: 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://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Webinars: Evoke - Cross platform, multi-device app development from BlueFinity
Last week at the International Spectrum show in Phoenix, Arizona, BlueFinity International announced a revolutionary new product for line of business applications development. 'Evoke' allows developers to create an application once and automatically generate code needed to deploy it to Desktop devices, mobile devices - iPhone/iPad, Android phone/tablet and Windows Phone/tablet plus Windows native desktop and Windows Modern UI. There is absolutely nothing like it in the MultiValue world and it will be highly competitive in the general systems marketplace. Yes, there is finally a product first introduced to the MultiValue community that will be used for SQL, Oracle, and etc. development! Even if you have developed a mobile app or are currently creating rich, web and/or mobile applications - this is a game changer. If you want to leverage industry standard technologies like ASP.NET, HTML5/CSS/JavaScript, XAML, C# and PhoneGap without being an expert, this product is for you! These sessions are guaranteed to transform your perspective on developing state-of-the-art business software! Introduction to Evoke Wed, Apr 16, 2014 11:30 AM - 12:30 PM EDT (New York)https://www2.gotomeeting.com/register/589659906 Wed, Apr 30, 2014 3:30 PM - 4:30 PM AEST (Sydney)https://www2.gotomeeting.com/register/733768874 Wed, Apr 30, 2014 11:30 AM - 12:30 PM EDT (New York)https://www2.gotomeeting.com/register/481272074 Technical deep dive into Evoke Tues, Apr 22, 2014 11:30 AM - 12:30 PM EDT (New York)https://www2.gotomeeting.com/register/141521946 Thurs, May 1, 2014 11:30 AM - 12:30 PM EDT (New York)https://www2.gotomeeting.com/register/539338922 For more information, please visit http://www.bluefinity.com/evoke ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] jobnotify: Error 913 occurred
Sorry, I forgot to reply... I vaguely recall having a jobnotify errors when we migrated to AIX6.1 and UV11.1.9 during the testing phases...but do not recall if it was the 913 version you got...I cannot find my notes on this and didn't raise it as a problem case with Rocket... You could be occasionally running out of user processes - but only when the system is busy... or perhaps some settings are not optimised for your server / license, etc. A quick check is to verify 'ulimit' sessions for your UV session (do a ulimit -a at the shell prompt). Check the current values of the ULIMIT and SHMMNI kernel parameters. SHMMNI should be set to Number of Users + 2. (This is from a Rocket UV11 tech note) Finally, I think we also ran into issues with running out of LCTs...not necessarily relayed to the jobnotify error... This was another configuration issue not documented in the install guide at the time. That required of the tweaking of the UVCONFIG NUSERS parameters to ensure that everything was 'optimised', etc. and documented in the tech guidese UniVerse 11.1 - Before You Upgrade.pdf (previously What You Need To Know for Eleven One.pdf). Hope this helps... Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon Sent: Thursday, 20 March 2014 2:40 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: Re: [U2] jobnotify: Error 913 occurred 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 ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 ODBC error
Do you have a context? New UV version? Old process just stopped working? New version of software X or Y? New server? New everything and old query A or updated query B? Those error message aren't helpful without some context... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Judy M Sent: Wednesday, 19 March 2014 3:38 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2 ODBC error U2 UviVerse verions is The version of UniVerse TIO run is 11.1.9. ODBC U2 version is 32 bit 6.140.01.7533 I am call the ODBC DSN from Cognos Data Manager V10.2.1. This is the last entry in the ODBC log anyone give me any pointer. databuild.exe cfc-c40 ENTER SQLGetDiagRecW SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x0018CCC8 SQLSMALLINT 1 SQLWCHAR * 0x0032C4A8 SQLINTEGER *0x0032C610 SQLWCHAR * 0x0018D9D0 SQLSMALLINT512 SQLSMALLINT * 0x0032C61C databuild.exe cfc-c40 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x0018CCC8 SQLSMALLINT 1 SQLWCHAR * 0x0032C4A8 [ 5] S1003 SQLINTEGER *0x0032C610 (0) SQLWCHAR *0x0018D9D0 [ 55] [Rocket U2][U2ODBC][0400864]SQL data type out of range.SQLSMALLINT512 SQLSMALLINT * 0x0032C61C (55) databuild.exe cfc-c40 ENTER SQLGetDiagRecW SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x0018CCC8 SQLSMALLINT 2 SQLWCHAR * 0x0032C4A8 SQLINTEGER *0x0032C610 SQLWCHAR * 0x0018D9D0 SQLSMALLINT512 SQLSMALLINT * 0x0032C61C databuild.exe cfc-c40 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 2 SQL_HANDLE_DBC SQLHANDLE 0x0018CCC8 SQLSMALLINT 2 SQLWCHAR * 0x0032C4A8 SQLINTEGER *0x0032C610 SQLWCHAR * 0x0018D9D0 SQLSMALLINT512 -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/U2-ODBC-error-tp42865.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Embedded help as hypertext
Wrapping in HTML is easy. Like anything ...doing it properly is hard...doing it right costs time and money...is it really worth it?? Unlikely - unless Rocket did it for us! :) Why don't just used BDT it has online context sensitive help and like the original poster said he uses the PDF. Key flaw in any plans is the large amount of missing commands and functions in all versions of the documentation (PDF, BDT, online in U2, etc.). In the past Rocket Software predecessor companies did produce Windows help file versionsas they do now for the fix/bug/release list download'ble from their website. Ideally, you should be just google it...and it would refer to a page on their site...just like you can do already for a numerous vendors... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Thursday, 13 March 2014 1:05 AM To: U2 Users List Subject: Re: [U2] Embedded help as hypertext The Universe 'HELP' (and HELP BASIC and HELP SQL) listings are all contained as records in the file 'HELP.FILE'. Creating a program to make an index page and html-ized versions of the individual items would be an easy project: LIST HELP.FILE PICK*SAVE.LIST TEXT 07:59:54am 12 Mar 2014 PAGE1 HELP.FILE. PICK*SAVE.LIST Text.. SAVE.LIST . . Use SAVE.LIST to save an active select list. You can use GET.LIST . to recall this list for subsequent processing and avoid having to . repeat the selection process each time you want to use the same selec . list. . . . Syntax . . SAVE.LIST [ [ filename ] listname ] [ FROM n ] . . . Parameters . . . The following table describes each parameter of the syntax. . On Tue, Mar 11, 2014 at 11:49 PM, Hona, David david.h...@cba.com.au wrote: I assume you're talking about UV? Define 'improved'? It could be improved by actually having all the commands, options and functions in it first. Even the PDF versions are missing information :) However, if you want another/better built-in HELP facility for your own purposes...PIHELP may help you (it offers paging back, sub-topics, indexing, etc.)... If so, take a look at PIHELP (TCL verb) and SHOW.HELP (subroutine -SHOW) which is a port of the Prime INFORMATION help which has 'hypertext' (sub-topics) and paging (back/forwards). In PI, there was also a subroutine you could call (rather than EXECUTE PIHELP subject. It has own format where you can specify the help file source and sub-topics indexed based on keywords in the topic/help message, like this in field/line one: 0001: .*X PIHELP ONLINE COMMAND VERB TOPIC SUBJECT AID ASSISTANCE An index on the help file would on the above field allow PHELP ABOUT keyword. The FROM key word lets you specify you own help file. It is better than the native UV HELP in some respects and utilises the default SYS.HELP file or your own (if required). I did note that there is no indices for the SYS.HELP file, so the PIHELP ABOUT topic function doesn't work...the required I-type dictionary item to parse the help records appears to be missing from the dictionary of SYS.HELP (Rocket Support should be able to assist there). The source is in APP.PROGS (PIHELP.B and SHOW.HELP.B) - good luck! I guess it has been ported over for PI/open users that used this facility for their own applications... The U2 Tools have built online help too - which are handy. If you use them - I'd encourage all newcomers to use these tools and similar commercial products to supplement the built-in native command-line tools (aka terminal shell session)... Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, 12 March 2014 3:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Embedded help as hypertext Does anyone have an improved version of the TCL command HELP ? Are there any wiki's or anything that comprise all of the HELP text and perhaps more ? I sometimes use it, sometimes use the PDFs and sometimes just google. I think it would be a great resource were there a better solution. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender
Re: [U2] Embedded help as hypertext
I assume you're talking about UV? Define 'improved'? It could be improved by actually having all the commands, options and functions in it first. Even the PDF versions are missing information :) However, if you want another/better built-in HELP facility for your own purposes...PIHELP may help you (it offers paging back, sub-topics, indexing, etc.)... If so, take a look at PIHELP (TCL verb) and SHOW.HELP (subroutine -SHOW) which is a port of the Prime INFORMATION help which has 'hypertext' (sub-topics) and paging (back/forwards). In PI, there was also a subroutine you could call (rather than EXECUTE PIHELP subject. It has own format where you can specify the help file source and sub-topics indexed based on keywords in the topic/help message, like this in field/line one: 0001: .*X PIHELP ONLINE COMMAND VERB TOPIC SUBJECT AID ASSISTANCE An index on the help file would on the above field allow PHELP ABOUT keyword. The FROM key word lets you specify you own help file. It is better than the native UV HELP in some respects and utilises the default SYS.HELP file or your own (if required). I did note that there is no indices for the SYS.HELP file, so the PIHELP ABOUT topic function doesn't work...the required I-type dictionary item to parse the help records appears to be missing from the dictionary of SYS.HELP (Rocket Support should be able to assist there). The source is in APP.PROGS (PIHELP.B and SHOW.HELP.B) - good luck! I guess it has been ported over for PI/open users that used this facility for their own applications... The U2 Tools have built online help too - which are handy. If you use them - I'd encourage all newcomers to use these tools and similar commercial products to supplement the built-in native command-line tools (aka terminal shell session)... Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, 12 March 2014 3:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Embedded help as hypertext Does anyone have an improved version of the TCL command HELP ? Are there any wiki's or anything that comprise all of the HELP text and perhaps more ? I sometimes use it, sometimes use the PDFs and sometimes just google. I think it would be a great resource were there a better solution. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-threaded phantom processing
Hi Peter Clearly, you have no other option than to go the direction you have. Sounds like you're using the correct API and approach for the task at hand and with the constraints you have. Sounds like you have considered various implications and you're constrain by UV versions and UniRPC being blocked (a good thing if you're connectivity to third-parties and over unsecure/public networks :))... BTW: UV File triggers are light-weight triggers available in UV11.x - without the overhead and complexity of UV SQL Triggers. The MQSeries interface is good, but it's learning curve can be steep and is only feasible if both sites are licensed users. I've used it a lot, but the underlying complexity of the MQ setup and API can be up there with TCP/IP sockets :(... if you're new to it all! SQL BCI requires UniRPC access so that would be ruled out for your use as well. All of the higher-level APIs just save you the hassle of writing a complex low-level interface which could be hard to develop, debug and maintain in the future... In my experience, it is difficult to optimise any interface unless you have some minimum, average and maximum loads or throughput requirements to be met. It'll be difficult to optimise the interface other than setting minimum and maximum phantom processes - as you're and other have already mentioned. I guess time will tell how it works and what tweaking (aka optimisation) will be required...nothing like real-world usage to sort things out... Another potential consideration you need to consider or at least have test cases is loss of connectivity due to abnormal termination by the client, network (local/carrier/remote) or remote server. All these events may cause various issues that can impact UV locally, remotely and your TCP connectivity. Troubleshooting network and application connectivity is never easy - hence working through worse case scenarios in advance is a worthwhile - and somewhat very tedious exercise. Such issues have are applicable to all applications - of course. Such network issues impact the native UV APIs as well...but I am sure you'll get to know and loathe errors such as FIN_WAIT, etc., etc. as you get more usage and issues, etc. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Friday, 7 March 2014 6:00 PM To: 'U2 Users List' Subject: Re: [U2] Multi-threaded phantom processing Initially data volume will be small - probably about 20 customers per day and about 6 records per customer but it is likely to grow very quickly up to some unknown amount. We'll have to see I guess. The records per customer are likely to be the high volume stuff. There is transaction logging on the remote system that I can use and am relying on for data integrity but I did not know about the SQL stuff until this week. Not sure if it would work until I can find time to play with it and see how it might suit us. Some of the other constraints were: no access allowed to the remote unirpc port, the remote UV is below 10.3 and different from ours, neither site has a UV/Net licence in prod. So I think I'm pretty much stuck with file queuing and multiple phantoms for now at least. I also was able to get a successful remote file process going on our test system while waiting for confirmation of UV/Net accessibility. It is very nice and might have been a nice solution too. Then I did some experimenting with the performance requirements on the file triggers and found there to be too much of a lag for the triggers to fire directly to the other end. This would've caused unacceptable problems in testing not to mention going live so a file queuing process had to be devised. In all the file queuing works quite well and can be coded for rock solid reliability so it has a lot of pluses. I can also fine tune the phantom loop times and socket timeouts on the fly at both ends once the data starts flowing and we get some idea of what needs changing. Fingers, toes, arms, legs (and eyes!) all currently crossed. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Friday, 7 March 2014 13:41 To: U2 Users List Subject: Re: [U2] Multi-threaded phantom processing Hi Peter Sounds like an interested piece of work, just a couple of questions for you: - what sort of data volumes and update frequencies are involved? - do you need to know if the data has been successfully committed to the remote UV database? - did you consider SQL BCI or even UV/Net (read the different UV versions is an issue and so this may be a constraint) Gregor mentioned SQL BCI as an alternative interface - I've used that before to exchange data between systems
Re: [U2] Multi-threaded phantom processing
Yes of course there are many solutions: rcp, ftp, nfa, http, mapped drives, etc. But the one that has the most security is the socket to socket communications with your own protocol. You get to control who has access and what commands they have access to. And of course you get to add logging as you need. Plus it runs native from U2 so that you can do command like compile, or move just a single attribute or sub-value. My customer needed a tool to keep the developers out of the live data server. By disabling the normal data transfer methods and installing a socket-to-socket approach we made the auditors very happy. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Wednesday, March 05, 2014 5:57 PM To: U2 Users List Cc: U2 Users List Subject: Re: [U2] Multi-threaded phantom processing As elegant as some of these ideas are, it might be possible, depending on the number and nature of the transactions, to batch them up every n seconds and use rcp to copy them to an in box on the remote machine. -Rick On Mar 5, 2014, at 4:19 PM, Horacio Pellegrino pellegrin...@gmail.com wrote: Why don't you have one port listening for requests, and as soon as they come in, you create a new phantom to answer that request ( liberating the listener immediately for the next request ), then when the phantom finishes it could log off. Might be you want to keep a pool of phantoms alive for a while, on the assumption they might be reused. That way you are sill using one license per request, but you have the benefit of pooling... You can always set min-max limit for those phantom-workers. Horacio Pellegrino On Tue, Mar 4, 2014 at 11:30 PM, Peter Cheney peter.che...@firstmac.com.auwrote: Thanks David. As they say Bigger than Ben-Hur! That's a great idea. The server I have is listening on a predetermined port. I trolled through /etc/services and a netstat on the remote host to select something that looked unused. So then if it the main phantom spawns 1-n children (presumably more phantoms?), it would also need to select 1-n ports which I suppose must also be predetermined? Or is there a call to the OS that can return an unused port? We're on AIX but the remote host is HPUX. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Wednesday, 5 March 2014 13:01 To: 'U2 Users List' Subject: Re: [U2] Multi-threaded phantom processing Peter, first of all let me congratulate you on this achievement. Having just finished a similar feat using UniData I understand the complexities that went into it. The system I'm current working with will be relatively low traffic. But I was pondering on the method of having a server socket that would just spawn a transfer server socket and send the socket address to the calling client. Then the client disconnects from the main server and just uses the transfer server to complete the task. Having 10 open phantoms with sockets will use up 10 licenses. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, March 04, 2014 6:18 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Multi-threaded phantom processing Hi Everyone, A project that I'm currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I'll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I've seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent - child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms
Re: [U2] Multi-threaded phantom processing
Will you kinda lost me on this approach. Since the Server socket is on a different machine than the client they don't see each other's locks. Different clients might be on different servers too. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, March 05, 2014 5:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Multi-threaded phantom processing Peter is the only point of the parent child communications to address points like 1 I'm busy go away; OR 2 I'm available to work If so, you could simply use a lock-semaphore to address both of those issues.\ -Original Message- From: Horacio Pellegrino pellegrin...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Mar 5, 2014 4:19 pm Subject: Re: [U2] Multi-threaded phantom processing Why don't you have one port listening for requests, and as soon as they come in, you create a new phantom to answer that request ( liberating the listener immediately for the next request ), then when the phantom finishes it could log off. Might be you want to keep a pool of phantoms alive for a while, on the assumption they might be reused. That way you are sill using one license per request, but you have the benefit of pooling... You can always set min-max limit for those phantom-workers. Horacio Pellegrino On Tue, Mar 4, 2014 at 11:30 PM, Peter Cheney peter.che...@firstmac.com.auwrote: Thanks David. As they say Bigger than Ben-Hur! That's a great idea. The server I have is listening on a predetermined port. I trolled through /etc/services and a netstat on the remote host to select something that looked unused. So then if it the main phantom spawns 1-n children (presumably more phantoms?), it would also need to select 1-n ports which I suppose must also be predetermined? Or is there a call to the OS that can return an unused port? We're on AIX but the remote host is HPUX. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Wednesday, 5 March 2014 13:01 To: 'U2 Users List' Subject: Re: [U2] Multi-threaded phantom processing Peter, first of all let me congratulate you on this achievement. Having just finished a similar feat using UniData I understand the complexities that went into it. The system I'm current working with will be relatively low traffic. But I was pondering on the method of having a server socket that would just spawn a transfer server socket and send the socket address to the calling client. Then the client disconnects from the main server and just uses the transfer server to complete the task. Having 10 open phantoms with sockets will use up 10 licenses. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, March 04, 2014 6:18 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Multi-threaded phantom processing Hi Everyone, A project that I'm currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I'll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I've seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent - child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms, 1 for the transactions and one for the ancillary data. Although we run UV on AIX the only other requirement is that I must be able to do it within UV Basic. Does anyone out there on the list know of a better way or any alternatives/advice so I can get a better appreciation of what else might be possible please? Many thanks in advance, Peter
Re: [U2] Multi-threaded phantom processing
Hi Peter Sounds like an interested piece of work, just a couple of questions for you: - what sort of data volumes and update frequencies are involved? - do you need to know if the data has been successfully committed to the remote UV database? - did you consider SQL BCI or even UV/Net (read the different UV versions is an issue and so this may be a constraint) Gregor mentioned SQL BCI as an alternative interface - I've used that before to exchange data between systems and it works well. If you had the same UV version on both hosts - then UV/Net is simple effect way of transmitting data between UV systems with only licenses required on the remote system. With BCI you could utilise the Stored Procedure facility via an ExecDirect() call to push the data to the remote system in your UV file trigger. With UV/Net you could push the items to be copied the by your UV file trigger - thus the updates being written directly onto the remote host. BCI is free/included in UV and of course will utilise a license on the remote host. You need to write your own custom code. Probably a bit easier to maintain than any TCP/IP sockets based interface. Definitely a lot easier to troubleshoot ;-) ! YMMV. UV/Net is licensed on the number user connections on the remote host. Hence the above alternative as designed to eliminate the file-based queue - which in some instances by be desirable to maintain - depending on business, technical or operational needs/objections. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Wednesday, 5 March 2014 12:18 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Multi-threaded phantom processing Hi Everyone, A project that I’m currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I’ll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I’ve seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent - child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms, 1 for the transactions and one for the ancillary data. Although we run UV on AIX the only other requirement is that I must be able to do it within UV Basic. Does anyone out there on the list know of a better way or any alternatives/advice so I can get a better appreciation of what else might be possible please? Many thanks in advance, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains
Re: [U2] Multi-threaded phantom processing
I don't know how you would query the OS on the fly, but you can do a manual search for a bank of 10 or 20 unused ports and claim them. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, March 04, 2014 9:30 PM To: 'U2 Users List' Subject: Re: [U2] Multi-threaded phantom processing Thanks David. As they say Bigger than Ben-Hur! That's a great idea. The server I have is listening on a predetermined port. I trolled through /etc/services and a netstat on the remote host to select something that looked unused. So then if it the main phantom spawns 1-n children (presumably more phantoms?), it would also need to select 1-n ports which I suppose must also be predetermined? Or is there a call to the OS that can return an unused port? We're on AIX but the remote host is HPUX. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-threaded phantom processing
Peter, first of all let me congratulate you on this achievement. Having just finished a similar feat using UniData I understand the complexities that went into it. The system I'm current working with will be relatively low traffic. But I was pondering on the method of having a server socket that would just spawn a transfer server socket and send the socket address to the calling client. Then the client disconnects from the main server and just uses the transfer server to complete the task. Having 10 open phantoms with sockets will use up 10 licenses. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, March 04, 2014 6:18 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Multi-threaded phantom processing Hi Everyone, A project that I’m currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I’ll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I’ve seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent - child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms, 1 for the transactions and one for the ancillary data. Although we run UV on AIX the only other requirement is that I must be able to do it within UV Basic. Does anyone out there on the list know of a better way or any alternatives/advice so I can get a better appreciation of what else might be possible please? Many thanks in advance, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
As a work around, would this work: * produce file1 with record key and then 100+ data fields * produce file2 with remaining data fields * execute Linux command: paste file1 file2 myrealdata.csv David Rotman, Ph.D. Associate Vice President for Technology Chief Information Officer Cedarville University 251 N. Main Street Cedarville, OH 45314 rotm...@cedarville.edu voice 937-766-7905 fax 937-766-8819 On Mon, Mar 3, 2014 at 3:34 PM, jeffrey Butera jbut...@hampshire.eduwrote: On 3/3/14, 3:21 PM, Jeff Schasny wrote: Jeff, What I think many of us are suggesting is essentially if it hurts when you do that, don't do that i.e. if the query language won't accomplish what you want to do, use something else. Jeff Believe me - I hear you (and others). But my administration isn't listening because they all think this is a reasonable request (excel can handle 200+ columns). So if I can't make this work in Unidata I'll have to move to MSSQL which I really, really, really don't want to do. At this point I'm just trying to understand the limit on the number of fields in a LIST statement. I know in my case that it's not a sentence length issue as I might've thought earlier so I'd like to know what is causing this (with the understanding that I very well may not be able to solve this). Jeff jeffrey Butera wrote: On 3/3/14, 2:58 PM, Brian Leach wrote: Jeff Try mvQuery, that should not have any problems with those volumes. Hi Brian We've isolated the problem to Unidata itself, not the reporting tool. In short, when we do a LIST with about 150 fields, it throws: too many items in LIST As soon as we erase a field (any field), the LIST statement runs properly. Unfortunately, I cannot locate any parameter that might control this. I thought we were hitting U_SENTLEN - but we're nowhere near that value. -- 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
Re: [U2] Left Outer Join Question
Remove the TO 3 on the MERGE command. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Monday, March 03, 2014 3:37 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Left Outer Join Question I must be doing something wrong. When I try this I get; SELECT FILE1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 TO 3 SELECT list 1 is not active. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp 42740p42762.html Sent from the U2 - Users mailing list archive at Nabble.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] [UD] Who's locking a record
Can you get what you need using GETREADU? David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, January 28, 2014 1:18 PM To: U2 Mail List Subject: [U2] [UD] Who's locking a record In UniData, if you do a READU you can find out the User ID who has the record locked by using the STATUS() function; this returns the 'UID' value. Here's a list of users: 3 Dev (0)- lu Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total ( 24 + 1 ) / 25 1 0 0 0 1 UDTNO USRNBR UID USRNAME USRTYPE TTYIP-ADDRESS TIME DATE 1 2488 197612 AsiAdmin phantom pts/1 Console 10:42:32 Jan 15 2014 2 3920 197610 JohnSmith udt pts/2 192.168.1.52 08:15:33 Jan 28 2014 3180 197608 udcsuser udcspts/3 udcs 09:22:57 Jan 28 2014 4 3840 197608 udcsuser udcspts/4 udcs 09:23:08 Jan 28 2014 Now, if John Smith goes to read and lock a record that is locked by port#3, how can I figure out which port# actually has the record locked, since the UniData GETUSER() function only returns the UID, and that user, because it is a UniObjects user, is connected on more than one port#? I have a file managed at login that keeps track of the PORT#s and the associated users assigned by our application. I want our logging to report that a record lock by user so-and-so on port {n} is already in place. Thanks. 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] [UV] Programmatic Verification of Globally Cataloged Subroutine
There is the !EXIST subroutine. It's a legacy Prime INFO subroutine - created for legacy code that need it. The source code is in UV APP.PROGS and just reads GLOBAL.CATDIR and also sets STATUS() with a return code too. CATALOGED.NAME = '*MYGLOBALSUB' call !EXIST(CATALOGED.NAME, RC) crt CATALOGED.NAME: = :(if RC then exists else NOT found) crt CATALOGED.NAME: STATUS() = :STATUS(): = :(if STATUS() then exists else NOT found) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Tuesday, 28 January 2014 4:06 AM To: U2-Users List Subject: [U2] [UV] Programmatic Verification of Globally Cataloged Subroutine Does anyone know of a good method in UniVerse BASIC to be able to verify if a subroutine is globally cataloged? Thanks. Perry Taylor Senior MV Architect Office (877) 494-7633 ext. 4392 Direct (502) 779-4392 ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sales EDI Question...
Hi Robert, Although I'm still just exploring, I added the Sales tag to the Subject to be politically correct. We offer a map-based EDI translator for installation and integration with your backend software. EDI Purchase Orders (850, 875) convert to Sales Orders using the same business rules used to create Sales Orders in your backend software. ASN's convert to EDI ASN's (856). Invoices convert to EDI Invoices (810, 880). EDI Cash Receipts (820) convert to Cash Receipts and post against Invoices. etc. Maps can be cloned in a matter of seconds and then modified to meet specific Trading Partner requirements. This product was originally developed on Advanced Pick and has been running for about 15 years on mvBase. It is also installed inhouse on Universe and can be ported to Unidata using the PICK flavor for the EDI accounts. It interfaces with serial, ftp and AS2 van services and did interface with the Softshare van some years ago when it was running on Advanced Pick. If you'd like to explore this option further, please let me know and I'll contact you directly, or you may contact me if you prefer. Best wishes, Dave Taylor, CEO Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) www.sysmarkinfo.com We are using Dataflo from epicor, Unidata, Kore Kourier electronic forms rand Redback for our storfront application - Original Message - From: da...@sysmarkinfo.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, January 02, 2014 6:50 PM Subject: Re: [U2] EDI Question... Robert, What database are you running your backend software on? What's more affordable as an inhouse product or cloud-based service? Happy New Year, Dave On 2013-12-31 08:46, Robert Frailey wrote: EDI brings up a whole can of worms for me in the new year. We currently use softshare as our van, I would really like to do EDI in house or find something more affordable. Does anyone have any suggestions. Thank You Robert Frailey Manager Information Systems Utah Medical Products Inc. Utah Medical Products Ltd. Femcare-Nikomed Ltd. Femcare Australia rfrai...@utahmed.com 801-569-4016 - Original Message - From: Peter S. Goldberger pet...@eoftech.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, December 31, 2013 8:55 AM Subject: Re: [U2] EDI Question... ISA (IEA) and GS (GE) control numbers should be consecutive per trading partner. The Receiver COMM ID and the control number together are what the VAN looks at. George Gallen wrote: The control numbers for the ISA/GS/ST segments, do they need to be unique only on a trading partner scale, or on a VAN scale? So if two trading partners are going through the same VAN, can they both have say a ISA control # of 1? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.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 ___ 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] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux
Did you use format.conv (UNIX / DOS/Windows command) or FORMAT.CONV (TCL command) on the HPUX sourced files that restored - post-restore? This will convert them into the format required for the target system... There are many options to choose from...see Admin.pdf (In the UV11.1 edition, see section 15-21 - PDF page 362 or do a TCL HELP FORMAT.CONV) A quick google would've revealed to you the following thread... which could be useful as well... http://u2-universe-unidata.1073795.n5.nabble.com/UniVerse-On-RedHat-td7144.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mburgun Sent: Wednesday, 8 January 2014 4:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] Migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux Hi, The general consensus seems to be that when migrating UniVerse across platforms the best approach is to use UVBACKUP on the old platform and then UVRESTORE on the target platform and all platform issues are taken care of. We, however have just attempted this process in migrating UniVerse 10.1.20 on HP-UX to UV 11.x on Redhat Linux and have come across the following problem ... UVBACKUP seemed to worked OK (we were able to restore on old platform UVRESTORE seemed to work OK on target platform http://u2-universe-unidata.1073795.n5.nabble.com/file/n42468/uvscreen.png In the above screenshot the directory contains UniVerse files but UniVerse doesn’t recognise them. UniVerse can’t run in this directory without its essential database files. Answering “Y” to the question also won’t work as UniVerse is unable to initialise the directory while it contains rubbish files having the same names as the required UniVerse files. Does anyone have any ideas? Thanks! Michael -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Migrating-UniVerse-10-1-20-on-HP-UX-to-UV-11-x-on-Redhat-Linux-tp42468.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [SPAM] - Re: Interfacing Touchscreens directly to UniVerse - Email contains a url listed on multi.uribl.com
The ipad-browser-webserver- universe seems like the most logical way to approach this task as it doesn't lock you into apple, the web site can be made agnostic enough so you can utilize apple/android/windows/whatever comes out next, it also gives you a far greater control over security and access to your database and allows you to encrypt the data easily between server and client preventing man in the middle attacks and Trojan worms from picking up your data on your lan, it also allows you to easily extend the capability of your software into the internet for portability without the need for VPN's and other mess, this would be the method that I would use. What are you using between your webserver and the universe server? Are they on the same box? Other solutions would be to write a client App for whatever platform you choose which makes calls directly to a server application sitting on your server which would then use universe as a database, you could probably get an app to log directly into the universe database, I've seen it done, but it's not great. For apple you require apple desktops to develop the software and special software to distribute software outside of the app store, it's a bit of a nightmare really. Android is easier and you can just develop on whatever you have using Java and push the compiled APK to the devices via side loading or write it to update itself quite easily. I'd not recommend moving away from your current setup except maybe to a more robust version of the same general concept. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, 3 January 2014 8:28 AM To: U2 Users List Subject: [SPAM] - Re: [U2] Interfacing Touchscreens directly to UniVerse - Email contains a url listed on multi.uribl.com I may be confused here but the device's (tablet, phone, what have you) operating system is what drives/runs/interprets the touch screen. To Universe it's just another input stream. Russ wrote: We've already done the iPad/browser/web server/universe solution. But are wondering if anyone has successfully approached this in another way. Thanks Happy New Year to all. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Interfacing-Touchscre ens-directly-to-UniVerse-tp42426.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Please consider the environment before printing this email Important Security Information: Maitland Mutual Building Society Limited will never ask for your PIN, password or account details to be disclosed via a link within an email message. If you receive an email of this nature, please delete the email and notify us immediately on 1300 688 825. Please check this email and any attachments for the presence of viruses. Disclaimer: This email and any files transmitted with it are confidential and intended solely for the addressee. If you have received this email in error please notify the sender immediately. Views or opinions in this email do not necessarily represent those of Maitland Mutual Building Society Limited ABN 94 087 651 983 (The Mutual), Australian Credit Licence 238139 and AFSL 238139. The Mutual accepts no liability for any damage caused by any virus transmitted by this email. Any advice contained in this email doesn't take into account your objectives, financial situation or needs. Before acting on the information, consider whether it is right for you. You should read all relevant disclosure documents before making a decision. All interest rates are quoted on a per annum basis. All interest rates quoted are current at the time of the email, however they are subject to change without notice. For up-to-date interest rates please refer to our website at www.themutual.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regarding: LISTING SUB-VALUES
Shan is CUSTOMER.PHONE.NUMBER an associated MV? If you have an association with a field like CUSTOMER.PHONE.TYPE and you want just the FAX numbers then you can use the WITH keyword in your query like: :LIST CUSTOMER CUSTOMER.NAME WHEN CUSTOMER.PHONE.TYPE EQ FAX CUSTOMER.PHONE.NUMBER David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shanmukh Nandha Sent: Thursday, December 26, 2013 11:26 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Regarding: LISTING SUB-VALUES Hi Everyone, Always a pleasure to read the useful advice and varying personalities on this list. Generally we are using SB+ account. There will be many multi-value field available in files, How to list specific Multi values of a field in specific file . For example:- CUSTOMER FILE contains fields like 1. CUSTOMER.NAME http://customer.name/ (single value) 2. CUSTOMER.SALARY (single value) 3.CUSTOMER.PHONE.NUMBER (multi value) 1. JOHN (Cust name with single value) 2. 70$/hr (Cust salary with single value) 3. 123454ý 655656ý 767787ý 87887 (Cust Ph No with Multi value) General to list specific field we use LIST CUSTOMER F3. How to list 3rd position of 3rd field of CUSTOMER file. Could any one of you can please let me know Thank you, Shan ___ 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] BASIC code - upper, lower, CamelCase, what say you?
For me I work a lot with javascript, html, and css. So having my UniBasic in all caps is something I'm use to and it sticks out from the other programming languages that I must use to create. I've had a UniBasic line of code that generated a javascript line that did a writeln of an HTML line that contained CSS code in. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, December 20, 2013 12:02 PM To: U2 Users List Subject: [U2] BASIC code - upper, lower, CamelCase, what say you? First off - Merry Christmas and Happy New Year to all. I'm starting to write a lot of new BASIC (Universe 11.1) subroutines for our DesignBais application, and since I'll be starting with a blank code template instead of modifying existing code, and I thought 'hey why not join the 21st century' and make the code look more mainstream, and readable. (falling back on our last TEXMUG presentation by Clif Oliver on refactoring). And considering Universe 11.2 now supports local subroutines and functions, I should make the code look and behave more object-like. Does anyone know of a set of rules or guidelines on how to do this?Just experimenting briefly, Universe BASIC compiler will allow any mix of cases for keywords, but variables are case sensitive. Example: ED BP TEST ABC=1 Abc=2 abc=3 PRINT ABC Print Abc pRiNt abc stop end RUN TEST 1 2 3 So, how are developers mixed case in their code these day? Do keywords, local variables, common variable, equates follow a standard method? thanks in advance, ___ 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] [OT] Interview Questions
Here is something I have used: What single project or task would you consider the most significant accomplishment in your career so far? · Can you give me a detailed overview of the accomplishment? · Tell me about the company, your title, your position, your role, and the team involved. · What were the actual results achieved? · When did it take place and how long did the project take. · Why you were chosen? · What were the 3-4 biggest challenges you faced and how did you deal with them? · Where did you go the extra mile or take the initiative? · Walk me through the plan, how you managed to it, and if it was successful. · Describe the environment and resources. · Describe your manager’s style and whether you liked it or not. · Describe the technical skills needed to accomplish the objective and how they were used. · Some of the biggest mistakes you made. · Aspects of the project you truly enjoyed. · Aspects you didn’t especially care about and how you handled them. · How you managed and influenced other, with lots of examples. · How you changed and grew as a person. · What you would do differently if you could do it again. · What type of formal recognition did your receive? Regards, David Sharp Date: Fri, 13 Dec 2013 12:27:18 -0800 From: i...@keyway.net To: u2-users@listserver.u2ug.org Subject: Re: [U2] [OT] Interview Questions Please email me in regards to your ads. I am currently in between contracts/assignments/projects and looking for my next assignment. Multivalue languages I have been programming in: * CACHE (language: MV BASIC) * INFORMATION (language: INFO/BASIC) * jBASE (language: jBC, jBASE BASIC, jBASIC) * MENTOR System (language: DATA/BASIC, DATABASIC, DATA BASIC) * MVENTERPRISE (language: MVENTERPRISE BASIC) * MVON/ONWARE (language: ONWARE BASIC) * OPENINSIGHT (language: BASIC+) * OPENQM, QM (language: QMBASIC) * PICK, Advanced PICK, D3 (language: PICK BASIC) * Power95 (language: DATA/BASIC, DATABASIC, DATA BASIC) * REALITY System (language: DATA/BASIC, DATABASIC, DATA BASIC) * REVELATION, Advanced REVELATION (language: R/BASIC, REVELATION BASIC) * UNIDATA (language: UNIBASIC) * UNIVERSE (language: UNIVERSE BASIC) * UNIVISION (language: UVBASIC) * WebSphere DataStage (language: DSBASIC, DataStage BASIC) Robert Norman, Multivalue Programmer/Analyst (951) 541-1668 On 10/7/2013 7:35 PM, Kevin King wrote: This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group: Technical questions aside, what are the best interview questions you've asked, been asked, or otherwise heard about that help differentiate between the candidates worthy of additional consideration vs. those that are not? Each company is different of course, but that aside I'm hoping to get some ideas to cut to the heart of the matter as quickly and efficiently as possible, both for the sake of the interviewer and the interviewee. (My technical interview is bordering on 200 questions and growing at an alarming pace.) If there were a half dozen questions to open with that could help set the stage for what may be to come, that could be very beneficial for everyone in this mix. Also, in an effort to keep the OT to a minimum, please don't ask me questions about the positions here. If you have questions, email me directly or through LinkedIn. I'd prefer to keep this topic on point of your recommended interview questions. ___ 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] [SPAM] - Re: [Very OT] XP File Dialog Box - Email contains a url listed on multi.uribl.com
I find the file copy dialogue quite nice in Windows 8... (shoot first, calculate later, show a pretty graph) and it's nice to do away with wasteful aero transparency crap... It appears to perform quicker than Windows 7 on the same hardware (probably because of the more simplified visuals) and I am enjoying its better understanding of soft and hard links on the file system. I dislike the new start menu, charms menu and extra fluff in the way of network settings, control panel items and shutdown functions, I've taken to making desktop shortcuts to get to what I actually want. I'm forcing myself to use it so I'm comfortable supporting it, right now I'm at the meh, it works stage... Kind Regards, David W. Campbell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Friday, 13 December 2013 7:28 AM To: U2 Users List Subject: [SPAM] - Re: [U2] [Very OT] XP File Dialog Box - Email contains a url listed on multi.uribl.com +1 On 12-12-2013 2:17 PM, George Gallen wrote: Windows 8 suks Anyone give any good points that makes Windows 8 worthwhile? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, December 12, 2013 3:13 PM To: U2 Users List Subject: 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-s ales-directs-consumers-to-windows-8/ 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 Please consider the environment before printing this email Important Security Information: Maitland Mutual Building Society Limited will never ask for your PIN, password or account details to be disclosed via a link within an email message. If you receive an email of this nature, please delete the email and notify us immediately on 1300 688 825. Please check this email and any attachments for the presence of viruses. Disclaimer: This email and any files transmitted with it are confidential and intended solely for the addressee. If you have received this email in error please notify the sender immediately. Views or opinions in this email do not necessarily represent those of Maitland Mutual Building Society Limited ABN 94 087 651 983 (The Mutual), Australian Credit Licence 238139 and AFSL 238139. The Mutual accepts no liability for any damage caused by any virus transmitted by this email. Any advice contained in this email doesn't take into account your objectives, financial situation or needs. Before acting on the information, consider whether it is right for you. You should read all relevant disclosure documents before making a decision. All interest rates are quoted on a per annum basis. All interest rates quoted are current at the time of the email, however they are subject to change without notice. For up-to-date interest rates please refer to our website at www.themutual.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Exporting to File regularly
Wow, overwhelming response to this question, thank you VERY MUCH for all of your idea's, I have a lot to process and decide what I can achieve... as a bit of background that I probably should have included, I am running UniVerse 11.1.9 on an IBM AIX 7.1.1.15 box. So far Bruce Decker seems to have the most appealing option if I can get it going, I'm sure I be full of more questions than answers in a few days, I just hope making this script doesn't make me the go to guy at work when someone needs weird universe stuff done... *gulp* Oh and its a database that is populated by a contact form from a secure website which then alerts the old terminal sessions that this business used in the past, but since they switched to a web interface for the software and hardly anyone uses the terminal full time any more the items sit there sometimes for hours before a response, so yes I want to be spammed by this all day long, and once it works I can point that spam at a receptionist or two :) The problem with notifying just on changes, is the file changes every time an individual reads a record and marks a particular record as READ for that user by removing their name from the users who have not read this yet column, the file size never changes unless it needs to grow and when records are deleted it simply fills with junk, which I take it is a standard universe thing it does, at this point the numbers appear sequential but that is best guess sigh. The vendor is incredibly secretive, they wont tell me how it works and their NDA says I am not allowed to memorize how their interface works... WTF so YAY obscure software that we cant leave because we are backed into a corner! /end rant Anyway thanks for all the help guys, so glad I found this place! -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regularly-tp42264p42277.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV/Net usage and licensing
Hi Peter, It's been a while since I've used/played around with UV/Net, but this may help... 1. Setup You only need a ensure UniRPC is active and you license for UV/Net on the server you wish to access. I don't recall you need to anything other than the UniRPC Daemon listening for requests and it will invoke uvnet for your client request. 2. Security I can't recall if you're using UNIX or not...(it is supposed to OS independent) Although, UV/Net is supposed to set the effective user (UID numer) and group (GID numer) for the remote users connecting to the remote UV server...if required. Plus if specified - as you're doing so. My experience with similar DB product tools is it is far better to have the UID and GIDs directly aligned. Specifically: make sure the UID and GID for the same named accounts are exactly the same on both servers. Or if you use SET.REMOTE.ID that the account locally has sufficient rights or in fact it exists. I have issues with the same accounts and groups on different users have different UIDs and GIDs on the different client and servers - causing grief/ havoc on similar products to UV/Net, etc. Also - check if you have UniVerse Dynamic Type30 files, that your UNIX file ownerships, group ownership and Other are set exactly the same. This includes the hidden file.Type30. Having different settings are recipe for lots of grief! Finally, be forewarned that allowing testers/developers access to your production server via UV/Net is an EXTREMELY bad idea! (Career terminating if things go pear shaped when they have write/delete rights!). It is far too easy for these types of users to be unaware their test account is in fact pointing to your production service and there access is write/delete. Did you try the UVNETRID environment variable in place of SET.REMOTE.ID? If you are still having issues, you may have to enabled UniRPC debugging which is very extensive and generate logs of data - but is useful for seeing exactly where things are going wrong. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 12 December 2013 2:23 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UV/Net usage and licensing Hi Everyone, We’re looking at doing some remote file mangling and was wondering if there are any gotchas when using UV/Net to do this? In my scenario if I am on host A and want to read/write files on host B. Host B only needs to read/write files on host B but not on host A. Do I need UV/Net on host A as well as host B or just on host A? Host A is running UV 10.3.4 and host B is running UV 10.2.6. Local testing on host A to host A/DR shows record locking is working OK but if the remote file does not have read/write on ‘other’ (e.g. 660) then all writes fail regardless of how I spec the credentials via SET.REMOTE.ID. Setting the permissions to 666 is the only way I can get this to work even when using the same login and group membership at each end. Also does anyone know if firewall ports other than standard unirpc port 31438 need to be opened either end for bi-directional file access too please? Regards, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Exporting to File regularly
Hi David If you upgrade to the latest UV version you have access to the built-in UV DB audit logging facility. Then you can setup a logging event to log changes to the file(s) in question. Hence, not violating the NDAs nor application flow (which you would have too if modifying the file with adding indices / triggers or the like). A simple file-based trigger (not the UV/SQL triggers - which a different more powerful beasts) that copies could make a copy to your own file or invokes a BASIC program/script to send notifications should do the trick too. A working example someone has posted on U2-Users List: http://u2-universe-unidata.1073795.n5.nabble.com/universe-11-1-triggers-via-indexing-and-IDX-IOTYPE-sample-tc41706.html#a41718 Audit logging is not for you unless you upgrade UVbut perhaps in the future...I guess you need a job to check the audit log for these events...too https://docs.rocketsoftware.com/nxt/gateway.dll/RKB14/universe/11.2/security1.pdf See page 372 Section 7 for Audit logging BTW: Look at from the vendors' perspective they have a lot of intellectual property tied up in their product. They sell it with consultancy, etc. It's how they make their living - pay their bills and eat... ;) Plus a lot of clients go out of their way not to pay for anything... it's a two-way rocky road sometimes! Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Campbell Sent: Thursday, 12 December 2013 9:05 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Exporting to File regularly Wow, overwhelming response to this question, thank you VERY MUCH for all of your idea's, I have a lot to process and decide what I can achieve... as a bit of background that I probably should have included, I am running UniVerse 11.1.9 on an IBM AIX 7.1.1.15 box. So far Bruce Decker seems to have the most appealing option if I can get it going, I'm sure I be full of more questions than answers in a few days, I just hope making this script doesn't make me the go to guy at work when someone needs weird universe stuff done... *gulp* Oh and its a database that is populated by a contact form from a secure website which then alerts the old terminal sessions that this business used in the past, but since they switched to a web interface for the software and hardly anyone uses the terminal full time any more the items sit there sometimes for hours before a response, so yes I want to be spammed by this all day long, and once it works I can point that spam at a receptionist or two :) The problem with notifying just on changes, is the file changes every time an individual reads a record and marks a particular record as READ for that user by removing their name from the users who have not read this yet column, the file size never changes unless it needs to grow and when records are deleted it simply fills with junk, which I take it is a standard universe thing it does, at this point the numbers appear sequential but that is best guess sigh. The vendor is incredibly secretive, they wont tell me how it works and their NDA says I am not allowed to memorize how their interface works... WTF so YAY obscure software that we cant leave because we are backed into a corner! /end rant Anyway thanks for all the help guys, so glad I found this place! -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regularly-tp42264p42277.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Exporting to File regularly
Hi Everyone, I'm new to universe (a complete noob) and I couldn't quite find what I was looking for on google and I've been smashing my face against this for a while until I stumbled upon this mailing list so I was wondering if anyone could help me out here. I'm writing a script that will hopefully alert me via email whenever a new record is added to a particular universe file, if there is a better way to do this I would be all ears. I'm working around another proprietary system which operates on universe and I dont know enough about universe to really say for sure what is proprietary and what is universe standard code and the proprietary stuff is covered in NDA's and no touchy hand slappy orders so I cannot really modify the way it works, I just need to know when a new entry appears, preferably via an smtp email. My Current plan works like this I'm looking to regularly (every 5 minutes) output data into a text or csv file, doesn't matter really, so long as it is not full of characters that batch scripts hate and it can happen in an automated fashion. The closest thing I can get to what I want right now is SP.ASSIGN HS LIST FILE.NAME LPTR this lists all the records and dumps them in a spool file under /var/spool/uv/ and then a script I have written in the past retrieves that spool file for me, I have trained that spool file to look for specific markers in the first line of the file and apply a particular script to it This spooled print job gives me a list of the records that I can then sort numerically, pick the highest number, check that number against what the number was last time and alert me via email if its different. Ultimately I would love for a regularly running script to just output the highest record (maybe sort numerically and give me the highest number and dump just that number into a file on the unix box for me to retrieve and the work with. Any help would be greatly appreciated! -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regularly-tp42264.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata index/query ?
Jeffrey, And index is a B(Binary)+ tree, the plus means that it auto adjusts and balances itself as it builds or shrinks. After UniData 5.2 UniQuery will use as many indices as it can. In your case it is the equivalent of doing two UniQuery selects to two different lists and then doing a MERGE.LIST. If you are always wanting a combined index lookup on those two values you can create an I-Descriptor that combines them and index the I-Descriptor. Then use the I-Descriptor in your select statements. Remember using an Index doesn't always mean faster selects. If your index brings back a lot of records then you are processing them by index pointer and the disk reads will be all over the file. Whereas without the index you are reading the file going through it by groups and it will minimize the disk reads. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: Friday, December 06, 2013 8:09 AM To: U2 Users List Subject: [U2] Unidata index/query ? Unidata 7.3.3 on RedHat: I have a table with numerous indicies built: File.. H08.CR.COURSE.EVALS Alternate key length.. 20 Node/Block size... 4K OV blocks. 1 (0 in use, 0 overflowed) Indices... 6 (6 D-type) Index updates. Enabled, No updates pending Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr XCCE.STUDENT.ID D NumYes Yes Yes Yes S 8 XCCE.STATUS D TxtYes No Yes Yes S 17 XCCE.COURSE.NAME D TxtYes No Yes Yes S 14 XCCE.TERM D TxtYes No Yes Yes S 12 XCCE.TYPE D TxtYes No Yes Yes S 22 XCCE.SUBJECT D TxtYes No Yes Yes S 23 Since these are data fields (nothing computed on-the-fly) and indexed, queries should be fast.The table has approximately 737,000 records. This query runs in under 1 second: SELECT H08.CR.COURSE.EVALS WITH XCCE.TERM EQ '2013F' However this query takes 10+ seconds (or longer) - even with two indexed fields: SELECT H08.CR.COURSE.EVALS WITH XCCE.TERM EQ '2013F' AND XCCE.TYPE EQ 'FINCRSE' I'm at a loss to explain the second, any insight appreciated. -- 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
Re: [U2] Unidata index/query ?
Yes, Doug if an index is properly done it will make a huge difference. But there are times when using an index can be slower. And this is the point I'm making. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: Friday, December 06, 2013 9:13 AM To: U2 Users List Subject: Re: [U2] Unidata index/query ? Hi David: In Unidata indexes DO mean faster selects. I have file with millions of records with about 14 indexes and most every select on the index comes back in under a second. Our disks are 90,000 IO's per second with a 16GB main memory, without indexes to select and read through that data takes 5 to 10 minutes minimum. I have an open ticket with Rocket Software about indexes failing after 7.3.2. I had a similar problem and reduced my version from 7.3.4 to 7.3.2. Regards, Doug www.u2logic.com XLr8Tools for Universe and Unidata programmers On Fri, Dec 6, 2013 at 9:00 AM, David A. Green dgr...@dagconsulting.com wrote: Jeffrey, And index is a B(Binary)+ tree, the plus means that it auto adjusts and balances itself as it builds or shrinks. After UniData 5.2 UniQuery will use as many indices as it can. In your case it is the equivalent of doing two UniQuery selects to two different lists and then doing a MERGE.LIST. If you are always wanting a combined index lookup on those two values you can create an I-Descriptor that combines them and index the I-Descriptor. Then use the I-Descriptor in your select statements. Remember using an Index doesn't always mean faster selects. If your index brings back a lot of records then you are processing them by index pointer and the disk reads will be all over the file. Whereas without the index you are reading the file going through it by groups and it will minimize the disk reads. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: Friday, December 06, 2013 8:09 AM To: U2 Users List Subject: [U2] Unidata index/query ? Unidata 7.3.3 on RedHat: I have a table with numerous indicies built: File.. H08.CR.COURSE.EVALS Alternate key length.. 20 Node/Block size... 4K OV blocks. 1 (0 in use, 0 overflowed) Indices... 6 (6 D-type) Index updates. Enabled, No updates pending Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr XCCE.STUDENT.ID D NumYes Yes Yes Yes S 8 XCCE.STATUS D TxtYes No Yes Yes S 17 XCCE.COURSE.NAME D TxtYes No Yes Yes S 14 XCCE.TERM D TxtYes No Yes Yes S 12 XCCE.TYPE D TxtYes No Yes Yes S 22 XCCE.SUBJECT D TxtYes No Yes Yes S 23 Since these are data fields (nothing computed on-the-fly) and indexed, queries should be fast.The table has approximately 737,000 records. This query runs in under 1 second: SELECT H08.CR.COURSE.EVALS WITH XCCE.TERM EQ '2013F' However this query takes 10+ seconds (or longer) - even with two indexed fields: SELECT H08.CR.COURSE.EVALS WITH XCCE.TERM EQ '2013F' AND XCCE.TYPE EQ 'FINCRSE' I'm at a loss to explain the second, any insight appreciated. -- 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
Re: [U2] Working with accented characters
Bob, I have never been satisfied with MCT so I wrote my own, feel free to use what you will and add your accented characters logic to it. SUBROUTINE DAG.MCT(OUT.DATA, IN.DATA) * MCT - Masked Character Title * A better option than using UniBasic's MCT Conversion Code * by David A. Green -- 5/20/02 -- www.dagconsulting.com * GOSUB INIT BEGIN CASE CASE IN.DATA = UPCASE(IN.DATA) ; GOSUB DO.MCT CASE IN.DATA = DOWNCASE(IN.DATA) ; GOSUB DO.MCT CASE 1 ; OUT.DATA = IN.DATA END CASE * RETURN ! INIT: WORD.EXCEPTIONS= WORD.EXCEPTIONS1, -1 = BY WORD.EXCEPTIONS1, -1 = IN WORD.EXCEPTIONS1, -1 = OF WORD.EXCEPTIONS1, -1 = AND WORD.EXCEPTIONS1, -1 = ON WORD.EXCEPTIONS1, -1 = THE * WORD.BOUNDRYS = WORD.BOUNDRYS := WORD.BOUNDRYS := - WORD.BOUNDRYS := . WORD.BOUNDRYS := _ WORD.BOUNDRYS := WORD.BOUNDRYS := / WORD.BOUNDRYS := ( WORD.BOUNDRYS := ) WORD.BOUNDRYS := @AM WORD.BOUNDRYS := @VM WORD.BOUNDRYS := @SM WORD.BOUNDRYS := @TM * OUT.DATA = RETURN ! DO.MCT: DATA.LEN = LEN(IN.DATA) THIS.WORD = FOR DATA.PTR = 1 TO DATA.LEN DATA.CHAR = IN.DATA[DATA.PTR, 1] BEGIN CASE CASE INDEX(WORD.BOUNDRYS, DATA.CHAR, 1) ; GOSUB DO.THIS.WORD CASE 1 ; THIS.WORD := DATA.CHAR END CASE NEXT DATA.PTR DATA.CHAR = GOSUB DO.THIS.WORD RETURN ! DO.THIS.WORD: IF THIS.WORD THEN BEGIN CASE CASE THIS.WORD[1, 3] = MCC ; THIS.WORD = OCONV(THIS.WORD[1,2], MCT):OCONV(THIS.WORD[3,], MCT) CASE OUT.DATA = ; THIS.WORD = OCONV(THIS.WORD, MCT) CASE THIS.WORD MATCHES WORD.EXCEPTIONS ; THIS.WORD = OCONV(THIS.WORD, MCL) ;* Lower Case CASE 1 ; THIS.WORD = OCONV(THIS.WORD, MCT) ;* Title Case END CASE OUT.DATA := THIS.WORD:DATA.CHAR THIS.WORD = END ELSE OUT.DATA := DATA.CHAR END RETURN ! END David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Little Sent: Monday, November 25, 2013 1:10 PM To: U2 Users List [u2-users@listserver.u2ug.org] Subject: [U2] Working with accented characters To convert the first character of a regular ASCII string to uppercase, I'd use OCONV(STRING,'MCT') so that STRING is output as String. However, this doesn't seem to work for Spanish accented characters. The machine is UV 11.1.11 with NLS enabled. What is the most elegant way to convert a name, such as JOSÉ to José ? I'm not a sys admin, so if it requires setting up an NLS map or something along those lines, I'm probably out of luck. bob little applications architect independent contractor market america, inc. 1302 pleasant ridge rd. greensboro, nc 27409 Phone: 336-698-4367 Cell: 248-675-5515 Skype: boblittle904 ___ 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] moving UV from one server to another (windows)
No one has pointed out the elephant in the room yet, so I will. Windows 7 is not intended for this use; while this configuration may work for some values of work, stability issues can and should be expected. In particular, I would expect the network stack to be, unh, flaky might be the best word. More importantly, Windows 7 is not LICENSED for this use. I am not affiliated with Rocket, nor can I speak for them, but I would be very surprised if Rocket supports this configuration. This is NOT a good idea; it has false economy written all over it. I would discourage your client, friend or whatever from going down this path. David Scoggins On Mon, Nov 18, 2013 at 2:03 PM, George Gallen ggal...@wyanokegroup.comwrote: Had someone ask me this question. They are downsizing their PC's They have UV currently installed on a Windows Server PC - and each of the PC's using wintergate to access it. This server is having some issues, so they want to move UV off of it, and have it run on one of their client PC Running windows 7. My thought was that you would install UV on that PC, Then (with the services off), copy the file structure from The Server to the PC. Assuming the all the folders are named the same on both systems for the install. And of Course remove UV from the Server once all it good. Should this be all that would be needed? Will UV function on a Windows 7 PC? Can it be used as working PC - as well as be a UV server? Everything I've heard says it should run by itself - but - can it run on a PC as background service? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- David Scoggins dscogg...@gmail.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Rocket releases UniVerse version 11.2.0
This has to be one of the most feature rich releases of UV for a long time. There are many new features and enhancements that we've been holding out for a long time... Well done Dan Rocket U2 team for the big effort for this huge release and the keeping U2/UV alive a kicking... Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Friday, 15 November 2013 4:39 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Rocket releases UniVerse version 11.2.0 If you haven't received an email already, I just wanted to let you all know we have released the next major version of the UniVerse Database today! You can find out more from our website, or from my blog post here: http://blog.rocketsoftware.com/2013/11/the-universe-database-version-11-2-released Cheers, Dan McGrath Managing Director, U2 Servers Lab Rocket Software ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
Why not let HR handle the personality questions and background checks, that's what they do. That leaves you to concentrate on their technical abilities. 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 Susan Joslyn Sent: Tuesday, October 08, 2013 12:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [OT] Interview Questions Kevin, Not that I have any real experience - at least not for what seems like a lifetime - with hiring. But my instinct might be to let the applicant tell me whatever they want. You know, just an open ended Tell me what you would like me to know about your skills, your ambitions and your work ethic. Probably that's an approach you've already tried. Susan -Original Message- From: mailto:u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon Sent: Tuesday, 8 October 2013 1:40 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions Interviewer: What is one of your weak points? Applicant: My honesty. Interviewer: I would have thought that was a strong point. Applicant: I don't give a %^* what you think you stupid ^^%$ ___ 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 from one file with save-list from another file
Hi Brandon, If you want to send one of your columns/fields in your UV/SQL SELECT result to an active select list or saved list - within the same SQL query - you need to use 'TO SLIST' keyword option... See the HELP SQL SELECT online for the limitations though. For example: To save the column/field Y.INFO.packet.id to select list 0: select Y.INFO.packet.id TO SLIST 0 from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; - OR- To save the column/field Y.INFO.packet.id to a saved list named MYSQLJOIN in SAVEDLISTS: select Y.INFO.packet.id TO SLIST MYSQLJOIN from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon Sent: Wednesday, 28 August 2013 6:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] Select from one file with save-list from another file Hello! UniVerse 10.1, HP/UX, Pick. Is there a way I can build a save-list from a selection from one file X.INFO (where the record ID is an 8 digit number) and use that list to select from file Y.INFO (where that 8 digit number is not the record ID but does exist as a foreign key elsewhere in the file). In SQL this would be considered a join and would look something like this: select * from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; I can run this in TCL and have it return the results I want but can't build a save-list from it because I don't know the UniVerse/SQL syntax to do so. So to summarize, is there a way to use a save-list built from X.INFO to make another save-list comprised of the record ID's from Y.INFO? Thanks for any advice you can give. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers
Yes, Chuck a typo in the release number and much less capable than SQL style triggers...so a backwards step too. But far less overhead and drama to setup/maintain... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Wednesday, 7 August 2013 7:58 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 @IDX.IOTYPE Thanks to a fellow u2-list member who mailed me privately. I think David Hona was maybe thinking of that, but it's available at 11.1, not 10.1. Chuck On 8/5/2013 6:23 PM, Perry Taylor wrote: Rocket added an @variable (don't recall the name of it) that tells which call is being made. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, August 03, 2013 9:40 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 David, I didn't understand your 1st clause, Now that (from UV10.1) Index-based triggers are officially supported, By index-based triggers, I assume you mean the trick of indexing an I-descriptor that calls a subroutine that updates some other file, which is generally not the sort of thing you expect such a subroutine to do. What is this official support? Did I miss an announcement, a change in the documentation, or a whitepaper? And by support - just to get my hopes up beyond all reason - does that mean they've introduced some mechanism (@variable?) to help distinguish among calls of the subroutine for insert (where indexing calls the subroutine once, to find the new value to index) delete (where indexing calls the subroutine 1x, to find the value to delete), and change (where indexing calls the subroutine 2x, once with the old version of the record, once with the new, to see whether the indexed value has changed and, if so, what to delete, what to add. Distinguishing these has always been tricky for the general case. Hope springs eternal, Chuck On 8/1/2013 12:32 PM, Hona, David wrote: Now that (from UV10.1) Index-based triggers are officially supported, can these replace your SQL-based triggers? These have less functionality and less overhead, but that's the price you have to pay Can't say I had a chance to try it for myself...yet...! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, 27 July 2013 5:32 AM 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
Re: [U2] What is the equivalent to UNNEST in Universe
Does UniVerse have ASD( ... ) keyword? That's what you would use in UniData. 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 Adrian Halid Sent: Tuesday, August 20, 2013 4:39 PM To: U2-Users@listserver.u2ug.org Subject: [U2] What is the equivalent to UNNEST in Universe Hi All, How do you perform a LIST or SELECT in Universe which will unnest or explode its Associated Multi Value Data before the query. For example. If I have a file called CUSTOMERS which has an association ORDERS. The DICT on CUSTOMERS have the following. A single value attribute called CUSTOMER.NAME. And then a set of a multi value attributes below. ORDER.DATE PRODUCT.KEY AMOUNT How to I perform a query to get all the records that have an ORDER.DATE 20/08/2013 and PRODUCT.KEY = ABC and AMOUNT = 100 when comparing against the same multi value position. I know I can use a Universe SQL query below with the UNNEST keyword to get the data. SELECT CUSTOMER.NAME, ORDER.DATE, PRODUCT.KEY, AMOUNT FROM UNNEST ON ORDERS WHERE ORDER.DATE '20/08/2013' AND PRODUCT.KEY = 'ABC' AND AMOUNT = '100'; How would you achieve the same result using a standard Universe LIST or SELECT command. Not a Universe SQL command. Regards Adrian Halid ___ 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] KeyPressed
Try a HUSH ON/OFF around your input. 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 Bill Brutzman Sent: Friday, August 09, 2013 1:04 PM To: 'U2 Users List' Subject: [U2] KeyPressed With Dynamic Connect... and UniBasic... I need a screen that continuously displays time... as we have an inspection screen where press operators enter fresh data each hour. Something like... loop call *timeOfDay call *displayOtherStuff input thisKey, -1 until (thisKey = '1') sleep repeat gosub secondScreen The trouble with this thing is... when a key is pressed... it wants to display the key on asubsequent screen. I tried...inputclear... but it is not doing what I want. Suggestions would be appreciated. --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] [UD] BASIC Code Failing
Hi Brian That's a good idea to do what you have done and do in mvStamp... I guess what I'm also look at is that the use of MD5 checksums (for example) is a 'well known/accepted and platform independent' mechanism to verify files are 'as they should be'. Hence, in theory you quickly detect changes that have occurred to the object, source and catalog version in simple independent way without even referencing back a source control system. Plus in UV BASIC you now have the ENCODE and ENCRYPT functions to help you check/secure your code - if you so desire - post-implementation. Here's simple compilation comparison before and after...obviously you can extend it to the source changes in catdir, etc. $ openssl md5 /my/PROGRAMS/BP.O/test123 MD5(/my/PROGRAMS/BP.O/test123)= 7e3743a1ac709cca2f9e1dd034e19048 $ nbasic BP test123 Compiling: Source = '/my/PROGRAMS/BP/test123, Object = '/my/PROGRAMS/BP.O/test123 *** Compilation Complete. $ openssl md5 /my/PROGRAMS/BP.O/test123 MD5(/my/PROGRAMS/BP.O/test123)= 080524f5d4da1c363298e2e538d3cf49 $ openssl md5 `cat /.uvhome`/catdir/'*test123 MD5(/usr/ibm/uv/catdir/*test123)= 05b3b02a4369915e448af6837160ac8f $ Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, 1 August 2013 11:13 PM To: 'U2 Users List' Subject: Re: [U2] [UD] BASIC Code Failing Dale The stamp I use assigns a dummy variable using strings that contain searchable keys. That means when the code is compiled these strings end up unaltered in the object code string table, so that they can be easily found and extracted. For example: VERDATA='' VERDATA := 'Version=001000136;' VERDATA := 'VerBeta=;' VERDATA := 'VerDate=16637;' VERDATA := 'VerProd=mvPDF;' VERDATA := 'VerTM=mvPDF;' VERDATA := 'VerCopy=2013 Brian Leach Consulting Limited;' VERDATA := 'VerCo=Brian Leach Consulting Limited;' VERDATA := 'VerDesc=Produce a PDF Document by merging data;' VERDATA := 'CatName=PDF.MERGE;' VERDATA := 'VerModule=GENERAL;' VERDATA := 'VerModVer=002003022;' VERDATA := 'VerHist=19 JUL 13 1.0.136 Release 2.3.22;' A useful addition is that I have a I Descriptor that returns this, so I can list the source or object file and rip out these details: LIST pdf.bp.O PDF.MERGE 01:02:24pm 01 Aug 2013 PAGE1 pdf.bp.O.. Version.. Version Description... Module Version PDF.MERGE 1.0.136 Produce a PDF Document by merging data 2.3.22 I did put some free code on my website to do this - look for mvStamp. As for cutting or build scripts, these refer to anything that builds your software.. every site should have something to do this, to ensure a smooth and automated transition from test to live or for deployment. In my case, the build process usually consists of a script written in vbscript (WSH) that runs the various client side builds (for Delphi, C# etc.) then uses UniObjects to execute a server side cutting paragraph passing the new version number. This typically updates the version stamps, recompiles everything, handles any platform builds (most of my stuff runs on UniVerse, UniData, QM and D3), updates a README document from my task system, adds them all into revision control, then calls mvInstaller to build the release package. Then control passes back to the vbscript to assemble the setup (InstallShield or visual studio) and zip the resulting setup ready for upload. I did think about kicking off all the unit tests as well but I prefer to do that after a test installation. All of which took some setting up to begin with but has saved enormous amounts of time and agony since. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: 01 August 2013 12:27 To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing Brian, Is the stamp just VERSION = 123 ,? Could you explain what you mean by cutting routines, I've either never heard that term or my old timers is kicking in. dale On 08/01/2013 06:09 AM, Brian Leach wrote: David I add version stamps to my code that compile into the object code, so at least I can easily check that the source and object (including that in catdir) matches what I expect. That's at least a small and easy step in the right direction, though that doesn't rule out changes that don't update the stamp of course. The stamps are always updated by my cutting routines and then the items are then added to source control as part of the cut... If you did something similar you can always diff what you've got against your source code control system rather than reinventing
Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers
Now that (from UV10.1) Index-based triggers are officially supported, can these replace your SQL-based triggers? These have less functionality and less overhead, but that's the price you have to pay Can't say I had a chance to try it for myself...yet...! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, 27 July 2013 5:32 AM 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 subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] BASIC Code Failing
In UV we're had similar strange problems with seemingly unchanged source/object code - not work as per normal and things going amiss for no good reason...once we found the object code in BP and the catalog space were mismatched and simply re-catalog'd it. Another time we re-compiled a program - as it was always invoked via RUN BP PROGNAME... in both instances the problem seem to go away. This was in a controlled product environment so it's in highly unlikely someone could of or would've changed the code... In UV you can do a VCATALOG to verify the BASIC object to what is actually catalogued... All of these issues made me wonder if our implementation routines need to have a more robust. More robust in terms of storing some control information for both pre/post verification - hence being able to detect 'unauthorised changes' through the various stages. This could include calculating and storing (say) MD5 (etc) hashes on the source and object to cross verify changes. Hence, make it more easy to detect object or source changes outside the authorised/control deployment process... without having to go through every single file and comparing to tape or disk backups, etc., etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, 31 July 2013 6:06 AM To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing John: That's an interesting thought. We do backups of the application account every night, so I do have the last 10 days object code in a backup (plus the last four months weekly backups). I'll look at this the next time it happens. Thanks, Bill Untitled Page - Original Message - *From:* jhes...@momtex.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/30/2013 11:01 AM *Subject:* Re: [U2] [UD] BASIC Code Failing I would also consider the possibility of data corruption at the hardware level. Granted, I would expect that you'd also occasionally find anomalies within your source code and data files if this were the case, but I don't know how your filesystems are set up. If the object code has become corrupt, that would explain why recompiling fixes the problem. The newly created object code will be stored on a new location in the filesystem. Fortunately this possibility is very easy to test for. Just make a copy of your application account on alternate storage and wait for the problem to recur. When it does, open the live object file and your backup copy in an editor with diff capability (Notepad++ is a good one) and see if they still match. -John ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] BASIC Code Failing
Intermittent data issues can be one of the hardest to debug. One way that has helped me out is to create a log file to log the transaction information, then verify the data and when it is incorrect, send off an email with the log file key to investigate. 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 dale kelley Sent: Friday, July 26, 2013 9:32 AM To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing Thanks Bob, I'll try that validation, maybe even write SUPREC and read it back for another validation. (It's a low intensity system.) At least that way I could be telling them rather than them telling me! dale ___ 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] LIST reports and Fields that Do reads
In UniData we also make sure the file is opened to a COMMON variable. Makes a huge performance difference vs doing the OPEN on every call to the subroutine. YMMV Sent from my iPhone. Please forgive brevity as well as any auto-corrected or fat finger spelling errors! On Jul 19, 2013, at 1:29 PM, randyleesmith randyleesm...@roadrunner.com wrote: In this case it is a SUBR call. Ok, thanks I'm a little older school and speed was always an issue I had to be aware of. Thanks for all the quick feedback. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/LIST-reports-and-Fields-that-Do-reads-tp41304p41308.html Sent from the U2 - Users mailing list archive at Nabble.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] Benton Scheduler
To Riverman, I have not heard of the Benton scheduler and I'm not sure what sort of scheduler you're looking for, but we have a Finite Scheduling scheduler associated with the Shop Floor Control module of our discrete Manufacturing software suite. I'll be glad to send you some information on it if you're interested. Best wishes in finding your new scheduler, Dave Taylor Sysmark Information Systems, Inc. 1-800-SYSMARK (1-800-797-6275) I am looking for source code for Infocus's Benton scheduler. As far as i can tell Infocus has disappeared from this planet. Our organisation is having some challenges with reinstalling Benton. I am also looking for other scheduler options. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Benton-Scheduler-tp41282.html Sent from the U2 - Users mailing list archive at Nabble.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] UML mapping tool for MV (UniVerse)
Regardless of the toolset, the first hurdle would be to normalise your database to look like a relational one. Which is likely to be the greatest hurdle. Data dictionaries in U2/PICK are optional are a purely for reporting purposes - they can have duplicates and these can be conflicting. Even worse (as if you thought it could be) - data dictionaries can be incomplete or wrong. This added to the lack of enforcement of data integrity and constraints usually causes these toolsets to fail (indeed, even the UV/ODBC driver fails too!)... so good luck! Rocket released U2 Metadata Manager to assist in this respect and is designed to allow forward and backwards capability. Although, support for this in UV is limited to the latest official release... so your alternative is UV/ODBC... For UV/ODBC users - I have always recommended a separate UV account and data dictionary that is spotless. For some this is the best option - why go against the flow - when you create your own stream... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lynette LeDoux Sent: Tuesday, 16 July 2013 5:45 AM To: u2-users@listserver.u2ug.org Subject: [U2] UML mapping tool for MV (UniVerse) Hello all. The call has come to locate possible data modelling tools (UML) that could potentially would connect to our UniVerse system. Ideas? L2 (Lynette LeDoux) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2-users-requ...@listserver.u2ug.org Sent: Monday, July 15, 2013 2:00 PM To: u2-users@listserver.u2ug.org Subject: U2-Users Digest, Vol 51, Issue 13 Send U2-Users mailing list submissions to u2-users@listserver.u2ug.org To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to u2-users-requ...@listserver.u2ug.org You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org When replying, please edit your Subject line so it is more specific than Re: Contents of U2-Users digest... Today's Topics: 1. Re: Mobile phones (Symeon Breen) 2. Re: [ANN] FOSS4MV - Free Open Source Software for the MVDB world (Daniel McGrath) 3. SORT reports line length, change right margin? (randyleesmith) 4. Re: SORT reports line length, change right margin? (Anthonys Lists) 5. Re: SORT reports line length, change right margin? (Don Robinson) 6. Re: Mobile phones (Bill Haskett) 7. Re: SORT reports line length, change right margin? (randyleesmith) 8. Re: SORT reports line length, change right margin? (Bill Haskett) 9. Re: SORT reports line length, change right margin? (Wols Lists) 10. Re: SORT reports line length, change right margin? (randyleesmith) 11. Re: SORT reports line length, change right margin? (Wols Lists) 12. Re: SORT reports line length, change right margin? (randyleesmith) 13. Re: SORT reports line length, change right margin? (Wols Lists) -- Message: 1 Date: Mon, 15 Jul 2013 13:20:14 +0100 From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] Mobile phones Message-ID: 004d01ce8155$a9f67e30$fde37a90$@gmail.com Content-Type: text/plain; charset=us-ascii Thanks everyone for your information. -- Message: 2 Date: Mon, 15 Jul 2013 14:25:42 + From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] [ANN] FOSS4MV - Free Open Source Software for the MVDB world Message-ID: 61ef3a8534e14d709dffdc5bd2f27...@den-vm-mbx3.rocketsoftware.com Content-Type: text/plain; charset=iso-8859-1 Thanks Tony Kevin! Unhappy to see we both ended up on different platforms (GitHub BitBucket) which means people would need to learn 2 different sites, but ecstatic to see we both ended up using Git which means people really only need to learn 1 tool chain to be able to work with both. Cheers, 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 Tony Gravagno Sent: Saturday, July 13, 2013 5:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] [ANN] FOSS4MV - Free Open Source Software for the MVDB world Posted for Kevin Powick === Fellow developers, I'm happy to announce a new resource for MVDB developers. FOSS4MV! FOSS4MV is a community for people that use or develop Free and Open Source Software for MVDB platforms, such as D3, OpenQM,
Re: [U2] Writing to a Windoz box from Universe
Ah, yes - we used in AIX6.1 :) It was the older AIX5.x environments it wasn't there... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 11 July 2013 3:54 PM To: U2 Users List Subject: Re: [U2] Writing to a Windoz box from Universe AIX 6.1 does have it built in. I think 5.2 ML12 might also include the ability to mount CIFS shares -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Thursday, 11 July 2013 10:39 AM To: U2 Users List Subject: Re: [U2] Writing to a Windoz box from Universe Last time I checked, AIX has no native built-in capabilities to mount CIFS/Windows shares. 1. Samba/AIX port - open source If you wish to load the Samba port to AIX, you can use smbclient to perform an sftp/ftp like connection that'll mount the share temporarily - then you can get/put the file(s), etc. 2. FastConnect - IBM supported If you use IBM's FastConnect for AIX - you have to mount the share as a filesystem first - as smbclient is not supported unfortunately. Both solutions - of course - require a Windows account to connect to the Windows server and it must have sufficient rights on that share/filesystem to write/read/delete files, etc. Having a Windows share mounted all the time can be a security risk - especially if using generic Windows accounts with too much rights. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Parks, Boyd Sent: Thursday, 11 July 2013 5:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Writing to a Windoz box from Universe I simply want to write a filename to a Windoz server from an IBM box running AIX. What is the simplest method? I would like to avoid ftp. Been there, done that! Thanks! Boyd Boyd Parks MDIV ERA Programmer/Analyst 770.237.7541 770.975.3303 (cell) 770.237.6541 (fax) McKesson Business Performance Services www.mckesson.comhttp://www.mckesson.com ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1HxsMXL8TR/2RPtkBcfWCsuqIZuZ7iELX/0.2 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Auto Starting Applications
Yes, this was a problem - but I haven't recently tried to execute UV11 and cron. UV11 has a different shared memory model - inherited from UD - in comparison to older releases. A quick test shows that phantom processes are getting their own shared memory segment under UV11. So - at first glance - it appears no longer to be an issue from UV11 onwards. Dave Church's uvcron.c program was the solution in the past/now to help for those still waiting to user cron or similar scheduling tool...with uv. http://www.pickwiki.com/cgi-bin/wiki.pl?Uvcron -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Thursday, 11 July 2013 9:23 AM To: U2 Users List Subject: Re: [U2] [UV] Auto Starting Applications You should use uvsh rather than uv and you also need to consider multiple cron jobs running as the same user at the same time as Universe does not like this or never used to at least. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 11 July 2013 10:51 a.m. To: U2 Users List Subject: Re: [U2] [UV] Auto Starting Applications You can certainly launch a UV process from a unix script. e.g. #!/usr/bin/bash cd /$path_to_uv_account/$ACCOUNTNAME $UVHOME/bin/uv phantom PROGRAMNAME /somedir/log1.txt $UVHOME/bin/uv LIST SOMEFILE DICTITEM1 DICTITEM2 /somedir/log2.txt You can call this from cron too if required. Cheers Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Kevin King [ke...@precisonline.com] Sent: Thursday, 11 July 2013 8:34 AM To: U2 Users List Subject: Re: [U2] [UV] Auto Starting Applications Wouldn't a simple startup script suffice - like in /etc/init.d/rc*x*.d (depending on Linux)? On Wed, Jul 10, 2013 at 12:42 PM, Perry Taylor perry.tay...@zirmed.comwrote: What techniques are you folks using to start up apps when UniVerse on Linux is started? Obviously hooking into uv.rc is an option. Are there others? Thanks. Perry ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Writing to a Windoz box from Universe
Last time I checked, AIX has no native built-in capabilities to mount CIFS/Windows shares. 1. Samba/AIX port - open source If you wish to load the Samba port to AIX, you can use smbclient to perform an sftp/ftp like connection that'll mount the share temporarily - then you can get/put the file(s), etc. 2. FastConnect - IBM supported If you use IBM's FastConnect for AIX - you have to mount the share as a filesystem first - as smbclient is not supported unfortunately. Both solutions - of course - require a Windows account to connect to the Windows server and it must have sufficient rights on that share/filesystem to write/read/delete files, etc. Having a Windows share mounted all the time can be a security risk - especially if using generic Windows accounts with too much rights. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Parks, Boyd Sent: Thursday, 11 July 2013 5:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Writing to a Windoz box from Universe I simply want to write a filename to a Windoz server from an IBM box running AIX. What is the simplest method? I would like to avoid ftp. Been there, done that! Thanks! Boyd Boyd Parks MDIV ERA Programmer/Analyst 770.237.7541 770.975.3303 (cell) 770.237.6541 (fax) McKesson Business Performance Services www.mckesson.comhttp://www.mckesson.com ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Flip Case command?
TCL: PTERM -CASE INVERT BASIC: TTYSET -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Saturday, 6 July 2013 7:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] Flip Case command? Does anyone know of an internal command of any sort that will allow one to flip the case of some input stream ? That is, not just make it all lower case or all upper case, but actually make all lower case input upper, AND at the same time all upper case input lower. That is truly flip the case of each input character ? I'm going to write my own, unless someone has one. Thanks ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Running total
You can also see what the I-type does by DLIST yourfile yourdictitem It's the equivalent of VLIST for I-Types... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 4 July 2013 9:48 AM To: U2 Users List Subject: Re: [U2] Running total I believe the expression in the second example is referred to as a compound expression? Can't put my finger on the exact documentation but I seem to recall that compound expressions are broken up into parts (for want of a better term) delimited by a ';' and each part can be referenced throughout the entire expression by an @ number e..g. @1 refers to the first part and the nth part is @n etc. So for: LIST VOC SIZE EVAL SIZE + @2;@ My take on how this works is the the first part of the expression (SIZE + @2) can be referenced later on as @1, The second part is referenced as @ (instead of @2) and I believe is used to refer to the result of the entire expression (sum of all the parts). Can @ in this case also be referenced as @2? It probably could but would break the expression. Therefore the reference to @2 is causing the expression to grab the entire result using contents of @ (via @2 thus keeping it separate to @) and add it to SIZE which then becomes the new result (@) of the expressions and the whole thing is repeated. Does that sound about tight? Or have I got it way wrong? Cheers Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Wjhonson [wjhon...@aol.com] Sent: Thursday, 4 July 2013 7:31 AM To: u2-users@listserver.u2ug.org; donr_w...@yahoo.com Subject: Re: [U2] Running total Can anyone explain this situation better. I've only ever used the @ to simplify a few I-descriptors. I have a dict item SIZE that is just the LEN(@RECORD) So in this thread we've seen two EVAL solutions to a running total LIST VOC SIZE EVAL @1+SIZE LIST VOC SIZE EVAL SIZE + @2;@ In the first example is the @1 just saving the previous result of THIS eval ? And then in the second example does the fact that SIZE is first in the Eval, effectively *push* the accumulator into position two or something? So that's why you need @2 ? And then what would be the meaning of ;@ at the end of that? Pretty confusing stuff! ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Running total
Here is what I use: SUBROUTINE RUNNING_TOTAL(CUR.TOT, AM.PTR, AMT, RESET.DATA) * RUNNING_TOTAL Keeps a Running Total for Reports * by David A. Green -- 9/12/01 * COMMON /RUNTOT/ RUNTOT.REC(10) * EQUATE RUNTOT.FLAG TO RUNTOT.REC(1) EQUATE RUNTOT.TOTS TO RUNTOT.REC(2) EQUATE RUNTOT.LAST TO RUNTOT.REC(3) * TEST.FLAG = @DATE:@TIME * IF TEST.FLAG # RUNTOT.FLAG THEN RUNTOT.FLAG = TEST.FLAG RUNTOT.TOTS = RUNTOT.LAST = END * IF RESET.DATA # RUNTOT.LASTAM.PTR THEN RUNTOT.LASTAM.PTR = RESET.DATA RUNTOT.TOTSAM.PTR = 0 END * RUNTOT.TOTSAM.PTR += AMT CUR.TOT = RUNTOT.TOTSAM.PTR * RETURN Your formula for the I-Descriptor is: SUBR(RUNNING_TOTAL, n, Dict_Name, Reset_Dict_Name) Where n is a unique number for the Query statement, so you can have more than one running total per query. Dict_Name is the Dictionary Name to use for Totalling. Reset_Dict_Name is the Dictionary Name for 'Zeroing out' the Totals when it changes values. If you don't wish to 'Zero out' the totals then use . Note: The reset option only works on presorted data! Technical: Running Total supports Multi-Values. For optimal performance use smaller unique numbers like 1, 2, etc. 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 Wjhonson Sent: Monday, July 01, 2013 5:36 PM To: u2-users@listserver.u2ug.org Subject: [U2] Running total Teach me again how to do a running total in a Access/Recall/English report. I haven't done one in years, but I seem to recall that it's possible. ___ 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] [AD] Your Webinar Invitation: Join us for Mainstream Developer Usage of MultiValue Databases
Reserve your Webinar seat now at: https://www2.gotomeeting.com/register/327855570 Another opportunity for .NET developers wishing to access MultiValue databases so see mv.NET in action. mv.NET has built a reputation for being the product of choice. Any MultiValue application can be enhanced and new applications can be built using mv.NET without needing to move away from tried, tested and trusted MultiValue database technology or existing business logic. mv.NET Solution Objects takes MultiValue application development to dazzling new heights and, with one simple implementation, provides developers with limitless ways to create amazing application interfaces using the very latest industry standard technologies -- HTML5, ASP.NET MVC, WPF and any other .NET enabled Microsoft environment. Solution Objects allows you to create a unified, single point of access layer around your database platform. This layer can then be leveraged by any kind of application in order provide access to your database content. Using the Solution Objects layer from within the .NET environment is simple and easy and requires no knowledge of MultiValue database technology. Whether you are building a browser hosted application, a mobile app, a desktop rich client or any other kind of service or application, Solution Objects can meet all of your data connectivity requirements - allowing you to utilize your MultiValue resources in a focused and efficient manner and also allowing you to continue leveraging your MultiValue database investment. Additionally, organizations can utilize the massive resource pool of .NET developers to boost application development bandwidth and reduce development timescales. Let our experts show you how easy it can be to unleash your creativity and create state-of-the-art, industry standard applications which can be deployed across any of the wide range of today's interface devices - workstations, browsers, handhelds, phones and other mobile devices. With mv.NET Solution Objects, your MultiValue application can now rival the 'mainstream' competition in terms of features, functions, performance, stability and efficiency! Title: Mainstream Developer Usage of MultiValue Databases Date: Tuesday, June 25, 2013 Time: 11.30 AM - 12:30 PM EDT Time: 4:30 PM - 5:30 PM BST After registering you will receive a confirmation email containing information about joining the Webinar. System Requirements PC-based attendees Required: Windows(r) 7, Vista, XP or 2003 Server Mac(r)-based attendees Required: Mac OS(r) X 10.6 or newer Mobile attendees Required: iPhone(r), iPad(r), Android(tm) phone or Android tablet ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] DEBUG in a Phantom issue
Has anyone seen a phantom process get stuck in a loop because of an embedded DEBUG statement? I would think the input at the ! prompt would have aborted the phantom, but it just kept going saying invalid input over and over and over. just about filled the disk. UniData 6.1 David A. Green (480) 813-1725 DAG Consulting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] History of Prime Information
Hi As long as you don't tell anyone else, as it might show my age, I can add a bit of background. I worked for Prime and was seconded to represent sales to the project in Milton Keynes that delivered PI/open. In fact I was part of the group that decided on the name and still have some of the original marketing collateral in a box somewhere. As far as I can remember due to the implementation Martin outlined the run time code could be moved between Unix systems without recompiling.But I am sure Martin will be able to remember and correct me if I am wrong. Assuming we are talking about a UK VAR in South London for the EXL 7330's etc I was probably involved as well. Small world. And yes I then moved to VMark as they acquired Prime Information. It took them years to assimilate PI in to Universe, but that's another story!! Regards David Peters Sales Manager BlueFinity International - an Mpower1 Group Company -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 12 June 2013 22:14 To: u2-users@listserver.u2ug.org Subject: Re: [U2] History of Prime Information On 12/06/13 13:36, Martin Phillips wrote: It is interesting to note that just a few weeks before first release the marketing guys decided to change the platform on which it would be launched. If we had gone the assembler route, this would have imposed a huge delay. With C, it took just a few changes to recompile everything. When we got rid of our Prime (2750, iirc), we migrated to PI/Open. We migrated our main system to three EXL7330s, which used a MIPS R3000 processor - the same as in the Sony Playstation 1 I understand! But we also had an EXL300 (if I've got the designation right) which was an Intel box (286 processor?) and also ran PI/Open. So that's two unique architectures right there ... :-) 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
[U2] [AD] Webinar: Mainstream Developer Usage of MultiValue Databases
As a nice follow up to the - UniObjects.Net vs Third-party Products - thread Please join our Webinar: Mainstream Developer Usage of MultiValue Databases June 12, 2013 - 11:30am - 12:30pm EDT (New York) For .NET developers wishing to access MultiValue databases, mv.NET has built a reputation for being the product of choice. Any MultiValue application can be enhanced and new applications can be built using mv.NET without needing to move away from tried, tested and trusted MultiValue database technology or existing business logic. mv.NET Solution Objects takes MultiValue application development to dazzling new heights and, with one simple implementation, provides developers with limitless ways to create amazing application interfaces using the very latest industry standard technologies -- HTML5, ASP.NET MVC, WPF and any other .NET enabled Microsoft environment. Solution Objects allows you to create a unified, single point of access layer around your database platform. This layer can then be leveraged by any kind of application in order provide access to your database content. Using the Solution Objects layer from within the .NET environment is simple and easy and requires no knowledge of MultiValue database technology. Whether you are building a browser hosted application, a mobile app, a desktop rich client or any other kind of service or application, Solution Objects can meet all of your data connectivity requirements - allowing you to utilize your MultiValue resources in a focused and efficient manner and also allowing you to continue leveraging your MultiValue database investment. Additionally, organizations can utilize the massive resource pool of .NET developers to boost application development bandwidth and reduce development timescales. Let BlueFinity's experts show you how easy it can be to unleash your creativity and create state-of-the-art, industry standard applications which can be deployed across any of the wide range of today's interface devices - workstations, browsers, handhelds, phones and other mobile devices. With mv.NET Solution Objects, your MultiValue application can now rival the 'mainstream' competition in terms of presentation, features, functions, performance, stability and efficiency! Register: https://www2.gotomeeting.com/register/327855570 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] UniObjects.Net vs Thrid-party Products
And from Bluefinity we certainly welcome Dan's endorsement to technology that enhances the use of U2 and makes for happy, long term users as this is great for everyone. There are certainly a lot of happy mv.NET customers in that category. Regards David Peters, Sales Manager at Bluefinity -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 29 May 2013 15:27 To: U2 Users List Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products Thanks for the reply Tony, I can't speak for anyone but Rocket, but we definitely don't feel threatened and encourage everyone to write great applications and share the story, regardless of what technology you use to connect U2 to your front-end. Did I mention share the story? :) Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, May 28, 2013 1:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products From: Daniel McGrath Tony, out of curiosity, have you looked at UO.NET's replacement: U2 Toolkit for .NET? Not recently bud. Once I settle on a toolkit that works well, my research in that specific area slows down. How much research do we continue to do on cars after we've made a purchase? Do we keep house hunting after we move into a new home? It's appropriate to be informed about what's happening in our industry, but I have dozens of platforms, frameworks, toolkits, and related versions that I need to keep up with - that still means time needs to be allocated for hundreds of permutations of all of these blasted software packages that are all supposed to save us time. Like everyone else here, I need to use whatever free time I have to hone my skills with the latest versions of the tools I already use, rather than continue to look into replacements. Despite professional curiosity, at some point we need to stop playing with tools and just hunker down to write real code. I'd like to say that at some point I'll cycle back around for another look at the U2 toolkit, but remember that for my purposes of writing applications that are the same across all MV platforms, a platform-specific tool is generally off of my radar. Sure, it would be nice to save my clients money using free tools, but I have U2 clients that have been running a single license of mv.NET for years. The tiny cost of the tool is trivial in the big picture. People need to think hard about exactly how much free costs them, or how adverse they are to buying a low-cost license for something that will last years. And that's just the cost of the tool. When a U2 site posts a job ad for someone to do UI work or web services, they might say must know U2 Toolkit for .NET. If they have a tool that anyone in the MV industry can use, the scope of candidates broadens to include U2 developers And everyone else. .NET developers have already broadened their scope to the outside world. Once they/we have made that jump, there's no reason anymore to limit one's self to a single MV platform and related tools. A company that is going in this direction should think hard about branching out and then snapping right back again to platform-specific tools. Sure, you're going to find someone who does U2-only work with .NET, but why limit your scope to U2-only people? The non-end-user developers that I know who use mv.NET aren't interested in limiting themselves to one platform anymore. It doesn't make sense to not have access to that pool of talent just because you want to use a free tool. And no, the DBMS vendors shouldn't feel threatened by this - we're enhancing applications for everyone, not the competition. It's the end-users that win here as well as their up-line channel. So Rocket Software and Tiger Logic and Ladybridge and everyone else should be encouraging their developer channel to use mv.NET rather than somehow feeling threatened by it. (More than I expected to write on that one, sorry.) T Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services http://Nebula-RnD.com/blog http://Twitter.com/TonyGravagno ___ 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] UniData PreStore to change the KEY of a record?
OK - a program was always a choice -- just wanted to ensure I had not missed a 'simple feature' of AE along the way -- again - 90 records -- I have to alter a single attribute and change the key ... was hoping I could do one 'compound' prestore! No such luck! Thanks all... at least I know I have 'maxed out' the usage of PreStores!! DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, May 29, 2013 2:25 AM To: U2 Users List Subject: Re: [U2] UniData PreStore to change the KEY of a record? To stay with the picture of not using a hammer to drive in a screw, I would just write a Basic program to do this. Use the right tool for the job! Open the file Execute GET-LIST Then a loop that generates the new Ids including checking that it doesn't already exist, READU record from old Id, WRITE record to new ID, DELETE old record. A few lines of code written in less than a minute. Compile, generate list, run program, job done! On 28/05/2013 21:59, Charlie Noah wrote: Dang, David, you beat me to it. ;^) I was just going to suggest the same thing. Just because the OP wanted to use ED (a hammer) to drive in a screw doesn't mean that it is the best tool ( a screwdriver). Good answer. Charlie Noah On 05-28-2013 3:42 PM, David A. Green wrote: I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. 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 David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' 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 ___ 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] 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
Re: [U2] UniData PreStore to change the KEY of a record?
But how would I 'swap out' the bad piece? For example - -the key is currently bad.1234 and I want it to be good.1234 How would I perform that 'replace' on the ID for the record? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Tuesday, May 28, 2013 1:04 PM To: 'U2 Users List' Subject: Re: [U2] UniData PreStore to change the KEY of a record? Sure, you should be able to write the record with the new key and then delete the existing record. The trouble comes in making sure another record doesn't already exist with the new key. Hth Colin -Original Message- From: David Wolverton Sent: Tuesday, May 28, 2013 11:48 AM To: 'U2 Users List' 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
Re: [U2] UniData PreStore to change the KEY of a record?
I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. 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 David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' 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
Re: [U2] UniVerse v11.2 private beta starting next week!
Hi Dan What's new in UV11.2 beta? Or is that not yet public yet? As per the private beta test... :) Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Monday, 20 May 2013 11:40 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UniVerse v11.2 private beta starting next week! Drop a line to u2as...@rs.com or your support partner if you want in. Spots are limited. Dan McGrath Managing Director, U2 Servers Lab Rocket Software ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selecting a special character in a SELECT (UV)
Try: ALT-160 Example: SELECT MY.FILE WITH @ID LIKE ...á... (By holding down the alt key and pressing 160 on the numeric keypad. 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 George Gallen Sent: Thursday, May 16, 2013 6:41 AM To: U2 Users Subject: [U2] Selecting a special character in a SELECT (UV) Ok. I'm trying to find all the ID's in a file that contain the character ^160 I tried : SELECT filename WITH @ID LIKE ...^160... But that didn't work. Aside from writing a program to scan the file, is there a way from TCL? 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] canon ir4025 printer on redhat
UniVerse admin guide details printing options. Using the admin tools won't setup remote network interfaces by default. Hence, in unix you need to write/use the a UV spooler driver Unix script interface. From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Dale Kelley [dalekel...@dalewkelleyinc.com] Sent: Friday, 3 May 2013 8:00 AM To: u2-users@listserver.u2ug.org Subject: [U2] canon ir4025 printer on redhat I have a customer who just got a Canon ir-4025 copier/printer/everythingelse. Unable to find a linux driver I downloaded a product called BrightQPro which allowed me to install the printer on the redhat system. I can print using lp or lpr, I can print web pages and from Office, but UniVerse cannot see the printer: Requested printer does not exist. Has anybody used these products, I have done everything I could think of about 7 times. Thanks -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/canon-ir4025-printer-on-redhat-tp40657.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] History of Prime Information
Ah, I recall Prime small mini-tower (under the desk) ATT System V boxes too -the EXL 300 series which ran a re-branded version of UniVerse (PI/EXL I think). This was rolled out before the EXL 7000 series which were MIPS RISC/os based servers. I vaguely recall Prime was looking at Silicon Graphics and Sequent (the latter was bought by IBM) When PI/Open finally arrived it was great, but the loss of the Primos Batch subsystem and spooler was a bit of a culture shock and required some rewrites...Prime tried to port their Batch and Spooler products to UNIX (not that successfully as I recall!). UV at the time was a giant step backwards for Prime INFORMATION users in many respects but the catch the fact it got you off very old, slow expensive hardware. :) But even then they weren't cheap (by today's standards)... http://www.cbronline.com/news/prime_adds_to_exl_line_pick_netware_on_all_its_unix_kit For those interested the demise of Prime/CV is documented in these links partially documented here: http://www.fundinguniverse.com/company-histories/computervision-corporation-history/ I recall a story from some ex-Prime employees that ponder where Prime would be today...if only they purchased another company instead of Computervision...that company was Sun Microsystems... probably still in the same place! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, 29 April 2013 6:59 PM To: 'U2 Users List' Subject: Re: [U2] History of Prime Information I think prime and vmark had done business together hence why the purchase - I remember back in 92/93 when we had a pair of prime 1920's (I think) running prime information, we then got a new prime unix box, that was actually a rebadged MIPS running Riscos, they said at the time that PI+ the new version of Information for unix was not quite ready but they would supply universe version 1 for free while they finished it off. Going from prime information to uv v1 was like taking a backward step, and we found a load of bugs in uv, esp with the locking tables, and deadlocks etc. Anyway we eventually got PI+ but I think it was just after that that Prime went out of business, we also used the CAD software, so we took the computervision CAD and ended up with PI+ but supplied by universe. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 27 April 2013 14:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] History of Prime Information On 27/04/13 05:26, Wjhonson wrote: Okay but let's just talk about 1990-1993 How did Computer Vision exactly get its hands on Prime Information ? This happened *before* the final bankruptcy of Prime? Or did somehow Prime sell or spin off Computer Vision with Prime Information as well? iirc they didn't. Computer Vision did a sort of reverse buyout, taking Prime's CAD business with it. INFORMATION was sold to Vmark, and the hardware business was sold to ?Pericom? That might be why Pr1mos has ended up in copyright limbo. There was a White Knight involved in this, so I'm guessing that the breakup and sale was along the lines of PI to Vmark, software to Computer Vision, and hardware and support to this other company. With the result that it wasn't clearly specified who got the copyrights to Pr1mos and now nobody can do much with it because they don't know who actually owns it... Enquiring minds want to know Well, I might not be much good at enlightening, but I was around as a customer when it all happened ... Cheers, Wol ___ 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: 2012.0.2241 / Virus Database: 3162/5776 - Release Date: 04/26/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. **
Re: [U2] History of Prime Information
If I'm not mistaken, there was another company in between Vmark and IBM. I believe (and there may have been some smoke and mirrors in all this) that Informatics acquired Ardent and then assigned the CEO of Ardent as the President of Informatics, or something like that, to run both Ardent and Informatics. And then later, IBM acquired Informatics for their database and just inherited Vardent almost by accident. Then, I believe that IBM acquired Unidata and formed the U2 product group. Certainly someone (Suzie) at Rocket could clarify this and perhaps publish an document for historical purposes to document this history completely and accurately. Dave Taylor Sysmark Information Systems, Inc. Prime Computer out of Natick Massachusetts went out of business. One of their products was PR1ME INFORMATION. They were acquired by another computer, Computervision (Thank you Mark, I'd forgotten the name). The product PRIME INFORMATION was acquired by VMark. Vmark was later acquired by Ardent Software. I don't remember if there were any companies in between Ardent and IBM, and while this was going on, there was a separate history happening for Unidata. Net upshot was that IBM acquired both Universe and Unidata, and branded them as U2. Source - my memory, (such as it is). I started playing with PR1ME INFORMATION on a PR1ME 450-II back in 1978. I bought disk drives, controllers, and tape units off and on throughout the years from Computronix, specifically from Randy Styka, which is where I came into this conversation. On 4/26/2013 4:18 PM, Wjhonson wrote: so explain that better and whats the source? -Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 12:58 pm Subject: Re: [U2] TCL input and response logging (AD) I didn't say vmark acquired prime. I said they acquired prime information. (Allen - Sent from my paperweight) On Apr 26, 2013, at 3:07 PM, Wjhonson wjhon...@aol.com wrote: That idea doesn't seem right Allen. I can't find any reference to Vmark acquiring Prime, after Prime's bankruptcy. One reference says that the Prime assets all went to ComputerVision, but it's just a blog Anyone have a newspaper article link ? -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 11:58 am Subject: Re: [U2] TCL input and response logging (AD) I'll have to update the wiki poo pea a pages Who is the woman in this picture? http://en.wikipedia.org/wiki/File:Prime9950_kean.jpg -Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 11:31 am Subject: Re: [U2] TCL input and response logging (AD) Prime Information was a product running as an application on PRIMOS. It was acquired by Vmark and subsequently by Advent if memory serves me correctly. IBM acquired Universe and Unidata and subsequently sold them to Rocket. (Allen - Sent from my paperweight) On Apr 26, 2013, at 1:40 PM, Wjhonson wjhon...@aol.com wrote: I don't think Universe was ever Prime. -Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 25, 2013 5:06 pm Subject: Re: [U2] TCL input and response logging (AD) On 4/25/2013 5:36 PM, Randy Styka wrote: Hi! It's been a long time since I posted here but our company, Computronics, has sold a product called PEEK for Unix systems since 1993. It is most often used for remote support, to see what is on someone's screen. And, if needed to send keystrokes as if they were typing them, to help them out or close out programs. But one of the other uses is for logging. PEEK can be set up to fire off a background process when a user logs in. That process is independent of the user, and can run under another id. It can then write a log of either all keystrokes of the user (input only mode) or of input and the resulting output. Since it runs under a different id, the logs can be placed where you want and they can't be modified or accessed by the user being peeked on. If this is of interest, visit http://www.computronics.com and look for information on PEEK. The manuals are there and a free trial is available. Note we are UNIX only (we don't do Windows ;-) If you have questions, email me at ra...@computronics.com. Thanks! Randy ++ | Computronics Randy Styka, ra...@computronics.com | | 4N165 Wood Dale Road Phone: 630/941-7767 | | Addison, Illinois 60101 USA Fax:630/941-7714 | |www:http://www.computronics.com | | for product information: i...@computronics.com | | for product support:
Re: [U2] History of Prime Information
Informix? Yes! Informatics? HaHaHa! LOL Bingo. From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Kevin King [ke...@precisonline.com] Sent: Friday, 26 April 2013 7:22 PM To: U2 Users List Subject: Re: [U2] History of Prime Information Vmark + Unidata = Ardent - Informix - IBM - Rocket, right? On Fri, Apr 26, 2013 at 7:12 PM, David Taylor da...@sysmarkinfo.com wrote: If I'm not mistaken, there was another company in between Vmark and IBM. I believe (and there may have been some smoke and mirrors in all this) that Informatics acquired Ardent and then assigned the CEO of Ardent as the President of Informatics, or something like that, to run both Ardent and Informatics. And then later, IBM acquired Informatics for their database and just inherited Vardent almost by accident. Then, I believe that IBM acquired Unidata and formed the U2 product group. Certainly someone (Suzie) at Rocket could clarify this and perhaps publish an document for historical purposes to document this history completely and accurately. Dave Taylor Sysmark Information Systems, Inc. Prime Computer out of Natick Massachusetts went out of business. One of their products was PR1ME INFORMATION. They were acquired by another computer, Computervision (Thank you Mark, I'd forgotten the name). The product PRIME INFORMATION was acquired by VMark. Vmark was later acquired by Ardent Software. I don't remember if there were any companies in between Ardent and IBM, and while this was going on, there was a separate history happening for Unidata. Net upshot was that IBM acquired both Universe and Unidata, and branded them as U2. Source - my memory, (such as it is). I started playing with PR1ME INFORMATION on a PR1ME 450-II back in 1978. I bought disk drives, controllers, and tape units off and on throughout the years from Computronix, specifically from Randy Styka, which is where I came into this conversation. On 4/26/2013 4:18 PM, Wjhonson wrote: so explain that better and whats the source? -Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 12:58 pm Subject: Re: [U2] TCL input and response logging (AD) I didn't say vmark acquired prime. I said they acquired prime information. (Allen - Sent from my paperweight) On Apr 26, 2013, at 3:07 PM, Wjhonson wjhon...@aol.com wrote: That idea doesn't seem right Allen. I can't find any reference to Vmark acquiring Prime, after Prime's bankruptcy. One reference says that the Prime assets all went to ComputerVision, but it's just a blog Anyone have a newspaper article link ? -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 11:58 am Subject: Re: [U2] TCL input and response logging (AD) I'll have to update the wiki poo pea a pages Who is the woman in this picture? http://en.wikipedia.org/wiki/File:Prime9950_kean.jpg -Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Apr 26, 2013 11:31 am Subject: Re: [U2] TCL input and response logging (AD) Prime Information was a product running as an application on PRIMOS. It was acquired by Vmark and subsequently by Advent if memory serves me correctly. IBM acquired Universe and Unidata and subsequently sold them to Rocket. (Allen - Sent from my paperweight) On Apr 26, 2013, at 1:40 PM, Wjhonson wjhon...@aol.com wrote: I don't think Universe was ever Prime. -Original Message- From: Allen Egerton aeger...@pobox.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 25, 2013 5:06 pm Subject: Re: [U2] TCL input and response logging (AD) On 4/25/2013 5:36 PM, Randy Styka wrote: Hi! It's been a long time since I posted here but our company, Computronics, has sold a product called PEEK for Unix systems since 1993. It is most often used for remote support, to see what is on someone's screen. And, if needed to send keystrokes as if they were typing them, to help them out or close out programs. But one of the other uses is for logging. PEEK can be set up to fire off a background process when a user logs in. That process is independent of the user, and can run under another id. It can then write a log of either all keystrokes of the user (input only mode) or of input and the resulting output. Since it runs under a different id, the logs can be placed where you want and they can't be modified or accessed by the user being peeked on. If this is of interest, visit http://www.computronics.com and look
Re: [U2] UV Creating a Soap Request
Hi Peter Is your SOAPAction correct?? The tempURI.org is a Microsoft standard placeholder - usually replaced by a proper URI or hostname name, etc. SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, 16 April 2013 4:14 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UV Creating a Soap Request Hi Everyone, Recently I had some success getting a secure version of this to work etc. but now they want to change it to non-SSL so am trying to get plain old http to work. Using this example as a starting point: https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api I've managed to (I think) translate the example above with our URL and soap action etc. but I have a question regarding the UV SOAPCreateRequest and hope someone may be able to assist. The URL I specify in SOAPCreateRequest is http://our-dev.domain.com/apps/jobs/Services/Job.svc However in the log file I get: 04/16/2013 15:05:16 [ 446706 925928 ] Assembled Request: POST /apps/jobs/Services/Job.svc HTTP/1.1 Date: Tue, 16 Apr 2013 05:05:16 GMT Host: our-dev.domain.com SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole User-Agent: IBM UniVerse 11.x Content-Type: text/xml; charset=utf-8 Content-Length: 1670 The POST seems to be missing the first part of the URL and with the response being a 400 bad request I'm wondering if there's anything I can do to force the complete URL? In particular is there a SOAP command that I'm missing? Briefly I do the following in this order: Ret = setHTTPDefault( VERSION , 1.1 ) Ret = SOAPSetDefault( VERSION , 1.2 ) Ret = SOAPCreateRequest( URL , SoapAction , SoapReq ) Ret = SOAPSetRequestContent( SoapReq , PAYLOAD , 1 ) Ret = SOAPSubmitRequest( SoapReq, Timeout, RespHeaders, RespData, SoapStatus ) The return codes from above are: setHTTPDefault result = 0 SOAPSetDefault result = 0 SOAPCreateRequest result = 0 SOAPSetRequestContent result = 0 SOAPSubmitRequest result = 0 The SoapStatus from SOAPSubmitRequest above is: Response status : 400▒Bad Request The RespHeaders returned from SOAPSubmitRequest above is: Response headers : Cache-Control▒private▒Server▒Microsoft-IIS/7.5▒X-Powered-By▒4.0.30319▒X-Powered-By▒ASP.NET▒Date▒Tue, 16 Apr 2013 05:46:06 GMT▒Content-Length▒0 To me the soap action seems good and the xml in the payload looks ok too so it has to be something in the delivery. We're running UV 10.3.4 on AIX 5.3. Reckon I must be missing something above so looking at the basic ref manual but it does not indicate if any of the soap commands therein and the above have other dependencies/pre-requisites and in what order they should occur. I guess a prior soap knowledge is expected but I'm just starting to get into this so if anyone can assist that'd be really helpful thanks. Cheers Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial
Re: [U2] is this an INDEX ISSUE?
Hello David 1) Is your file you're indexing corrupt or does it have any errors or warnings as reported by 'fixtool'? If corrupt, can you repair it (after backing it up:)) ? 2) What queries using the indices are slow? All or one? 3) What UV release? 4) How and when do you re-index the file? 5) Has the file been recently been resized/restored or otherwise changed? Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of david yu Sent: Saturday, 13 April 2013 9:47 AM To: u2-users@listserver.u2ug.org Subject: [U2] is this an INDEX ISSUE? hello, We have a file that is updated almost every minute for transportation appointment, we index a field in a file to make the reporting much faster but recently we noticed when we ran the report not all the transportation appt shows up on the report, so customer doesnt get their transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Creating a Soap Request
Oops, yes - sorry for my misleading reply regarding the URIs. Tempui.org is a valid placeholder and you don't need to replace it. Have you tried now SOAPAction and what error do you get then? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Wednesday, 17 April 2013 9:24 AM To: U2 Users List Subject: Re: [U2] UV Creating a Soap Request Thanks again David and Symeon for your replies I thought the SOAPAction was correct but now am not sure. If I browse to the WSDL schema I see the following spec though. Would this mean the 'tempuri.org' should be replaced with 'our-dev.domain.com' in the WSDL too? wsdl:operation name=CreateJob1UserPartyRole soap:operation soapAction=http://tempuri.org/IJobService/CreateJob1UserPartyRole; style=document/ wsdl:input soap:body use=literal/ /wsdl:input wsdl:output soap:body use=literal/ /wsdl:output /wsdl:operation I went and checked out the www.webservicex.net site (from the e.g. below) and looking in there and comparing to what I had and they seem to be pretty much a match except for the domain part of the SOAPAction. So perhaps I need to look elsewhere? There seems to me to be only 3 variables at play here: The URL, the SOAPAction, and the XML request. Given that I've just finished fiddling with the URL and SOAPAction with no apparent change in the log output I'll turn my attention to the XML ... One other question is it possible to query the WSDL from UV? Cheers Peter ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] is this an INDEX ISSUE
We did not have any OS or Universe upgrade. here is the list.index LIST.INDEX CALL.FILE ALL Alternate Key Index Summary for file CALL.FILE File... CALL.FILE Indices 4 (2 A-type, 1 C-type, 1 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type Build Nulls In DICT S/M Just Unique Field num/I-type CALL.STATUS D Not Reqd Yes Yes S L N 13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] is this an INDEX ISSUE
hello Tom, I wish I could just ignore it but as I previously mentioned, our patient are not getting their transportation appt which is not good service. I asked assistance to our software vendor and supposedly they open a case with Rocket but still no reply, I am hoping someone from this forum have a solution. like you mentioned, it works in all the files that we have index except for 1 and giving me a big headache since without index the report take more than 2 hours and by the time the report output is done it is not a valid report. -- Message: 1 Date: Sun, 14 Apr 2013 08:41:38 -0400 From: Tom Whitmore tewhitm...@ratex.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] is this an INDEX ISSUE? Message-ID: BA2E471C9317804EB8470750F458BD9801EC779E3DC4@public Content-Type: text/plain; charset=us-ascii Hi David, To your real problem and question. We are on UniVerse, using Linux and we have had problems like what was initially reported. I have not had time to play and figure out what is going on. We have moved from 10.x to 11.1.11 and I have not tried recently. Also, it seems to work fine on some files but other files have problems and we aren't doing anything special with the indexes that have problems (they are simple D or A type dictionaries) Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Jenkins Sent: Saturday, April 13, 2013 3:30 AM To: david yu; U2 Users List Cc: u2-users@listserver.u2ug.org Subject: Re: [U2] is this an INDEX ISSUE? Was the file open to a UniVerse session! Or we're you EXECUTING the RESIZE from a process that had the file open? The latter can cause issues -close the file first. If it's AIX and you are running multiple UniVerse shells from crown tab as foreground tasks (I.e. not as phantoms or by using executive) at the same time it could be relevant too. Regards JayJay On 13 Apr 2013, at 00:46, david yu d...@yahoo.com wrote: hello, We have a file that is updated almost every minute for transportation appointment, we index a field in a file to make the reporting much faster but recently we noticed when we ran the report not all the transportation appt shows up on the report, so customer doesnt get their transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ 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] is this an INDEX ISSUE?
hello, We have a file that is updated almost every minute for transportation appointment, we index a field in a file to make the reporting much faster but recently we noticed when we ran the report not all the transportation appt shows up on the report, so customer doesnt get their transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you print a .pdf from inside a Unix Box
First up - Adobe PDF is a subset of the Adobe Postscript page description language (PDL). Some printer vendors have Postscript emulations. Most business class laser/LED printers or multi-function devices (MFDs) today have intelligent page description language detection built in and typically analyse the datastream before attempting to do anything with it...mean that they can switch between plain text from UniVerse or UNIX or PDF/Postscript or HP PCL / PXL formats and others on-the-fly... Some modern printers have Adobe PDF and Adobe Postscript (or an emulation) built-in. Meaning they can be sent files in either format. . (Side note - Google: PDF Direct Print support). If you have printers are capable of accepting Adobe PDF files - then just simply submit an those files direct to the printer from your host. If your printer has Adobe Postscript or a Postscript emulation - you translate the PDF data file into 'native' Postscript via Ghostscript or similar toolset prior to sending it to the printer. If you don't have any Postscript capable printers - you can - using Ghostscript translate the file from PDF into HP PCL or similar PDL (many are supported). Then send the generated output to your printer queue. You can write custom version of the Ghostscript supplied 'ps2pdf' script to generate to PCL file from an Postscript file (and call the script, say ps2pcl). It's not difficult to customise this scripts for your own output device (printer, image file, etc)... have done this before... As implied by others - you won't have the same capabilities nor any options to dynamically or selectively control over the output (orientation, N-up printing, duplex, tray selection, page-fit, paper type, copies, page range, etc)... that you can perform from Windows Acrobat PDF viewer. An alternative to this is to perhaps utilise one or more host-based printer print queue defined for (some of these may be feasible) such printing preferences, etc. HPJetDirect for HPUX and other UNIX platforms is pretty feature rich especially when talking with HPDirectJet printers... See what Adobe has on this issue here: http://www.adobe.com/products/postscript/pdf.html Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Conway - Bamac LTD Sent: Friday, 5 April 2013 2:54 AM To: 'U2 Users List' Subject: [U2] How do you print a .pdf from inside a Unix Box I may have missed this discussion but if someone can help me that would be great. We have been executing a SB command to windows to open Adobe and print the PDF document. We would like to either not have to open Adobe and print the document or print the document from within our Unix box. We have a hp7640 11iv3 running on an Itanium processor. Here is the Unidata information: Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 721 Oh, love this list, I have been using Pick since 1985 and still going strong. Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [uv] Message[010252]
Hi Adrian The SYS.MESSAGE file has all the system messages... DAVID: CT SYS.MESSAGE 010252 010252 0001 Message %i is either invalid or not found in the SYS.MESSAGE file. 0002 I have no idea what it really means. I'd check if that particular has an existing UV process and has a pre-existing shared memory segment for a start... (likely to be unrelated)... this is not a UV process executing via crontab is it?? Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs Sent: Thursday, 4 April 2013 12:04 PM To: U2 Users List Subject: [U2] [uv] Message[010252] I am getting the above obscure error message when a particular user tries to invoke the uniVerse environment /usr/lpp/uv/bin/uv AIX v5 and uniVerse 10.1.22 can anyone please help me by telling me what this means? Or better yet how I can find out for myself? Sent from my iPhone ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [uv] Phantom question
Robert you can free yourself of these iphantoms for sendmail. I've written a program that talks to SMTP directly from UniBasic. You can do HTML, plain text, or both and you can do any kind of attachements. If you are a programmer you can do it yourself, here is what you'll need: * Knowledge of sockets * Knowledge of SMTP protocol * A subroutine to encode BASE64 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 Robert Frailey Sent: Wednesday, March 27, 2013 2:01 PM To: U2 Users List Subject: Re: [U2] [uv] Phantom question sendmail uses a phantom In each of my plant accounts we send sales-orders,invoices and statements via e-mail. the first person to loginto the account becomes the phantom user for sendmail. I have 4 active unidata accounts, so 4 phantoms. Dead uses can become phantoms if their session gets terminated unexpectantly. LP printers use phantoms to print to print servers - Original Message - From: Mark Eastwood ma...@afsi.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wednesday, March 27, 2013 11:59 AM Subject: [U2] [uv] Phantom question I see several phantoms running with I do a PORT.STATUS Question is - is it possible to determine which Account they are running in? I have several accounts and not sure where they are actually running. They launch with the BRIEF option, so no output in PH TIA, Mark Uv 10.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
Re: [U2] REDBACK Fatal UniBasic errors
Bill, thanks for the post, I will check this location for debugging purposes. But it doesn't help my issue of having Redback send back an error message that makes more sense when the UniBasic program aborts. 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 Bill Haskett Sent: Friday, March 22, 2013 3:56 PM To: U2 Users List Subject: Re: [U2] REDBACK Fatal UniBasic errors David: Have you turned on UniObjects error logging? If not, create the following item in the UDTHOME directory: serverdebug 001 udcs 10 E:\U2\ud\log\udcs\udcs.log My UDTHOME is located at E:\U2\ud so your path should replace mine from above. Also, I've created a udcs subdirectory under the UDTHOME log subdirectory. You can actually just name (and place) this log file whatever and wherever you like. After each UO connection there's a bunch of stuff in it that most often helps me. HTH, Bill Untitled Page - - - */Fav Icon Advantos Systems, Inc./* ☎ Tel: 760-944-5570 x7002 | ☏ Fax: 760-655-1583 The Property Management Advantage. - Original Message - *From:* dgr...@dagconsulting.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 3/22/2013 1:43 PM *Subject:* [U2] REDBACK Fatal UniBasic errors I'm accessing UniData via .NET and Redback. But if there is a fatal UniBasic error, like trying to access an unopened file, I get the following: dagLink.DOAdoExecute - ADO Record Set Execute - Connection to Application Server lost Responder Error: (errno=32 The process cannot access the file because it is being used by another process.) Responder Error: (errno=32 The process cannot access the file because it is being used by another process.) Responder Error: Server Err: SpGetLen error, rc=-109 Output Log: none. Error Log: none. * It then goes on to tell me that we have a Responder Error. The rgw.log has this: 102340,RESP,spdr.c,1219,SpGetLen error, rc=-109 (ErrorCode=109 The pipe has been ended.) 102340,RESP,ntbackend.c,720,Resp1 killing pid=122680 102340,RESP,ntbackend.c,701,WriteFile (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,769,Sent 0 stop failed. (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,626,try SafeTerminateProcess (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,630,Did not respond to SafeTerminateProcess: try TerminateProcess (gag) (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,633,TerminateProcess (ErrorCode=5 Access is denied.) 102340,RESP,ntbackend.c,790,Resp1 kill of pid=0 complete, rc=1. 102340,SCHD,ntresp.c,368,2.child slot=6 thandle=-1 102340,SCHD,ntresp.c,370,child died aidx=3 102340,RESP,respcmn.c,428,Responder terminating now. Is there a way to capture a better error message? David A. Green (480) 813-1725 DAG Consulting ___ 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 Fatal UniBasic errors
I'm accessing UniData via .NET and Redback. But if there is a fatal UniBasic error, like trying to access an unopened file, I get the following: dagLink.DOAdoExecute - ADO Record Set Execute - Connection to Application Server lost Responder Error: (errno=32 The process cannot access the file because it is being used by another process.) Responder Error: (errno=32 The process cannot access the file because it is being used by another process.) Responder Error: Server Err: SpGetLen error, rc=-109 Output Log: none. Error Log: none. * It then goes on to tell me that we have a Responder Error. The rgw.log has this: 102340,RESP,spdr.c,1219,SpGetLen error, rc=-109 (ErrorCode=109 The pipe has been ended.) 102340,RESP,ntbackend.c,720,Resp1 killing pid=122680 102340,RESP,ntbackend.c,701,WriteFile (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,769,Sent 0 stop failed. (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,626,try SafeTerminateProcess (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,630,Did not respond to SafeTerminateProcess: try TerminateProcess (gag) (ErrorCode=232 The pipe is being closed.) 102340,RESP,ntbackend.c,633,TerminateProcess (ErrorCode=5 Access is denied.) 102340,RESP,ntbackend.c,790,Resp1 kill of pid=0 complete, rc=1. 102340,SCHD,ntresp.c,368,2.child slot=6 thandle=-1 102340,SCHD,ntresp.c,370,child died aidx=3 102340,RESP,respcmn.c,428,Responder terminating now. Is there a way to capture a better error message? David A. Green (480) 813-1725 DAG Consulting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ISO Date Format
In UniData you can just use D-YMD. 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 Jeff Schasny Sent: Monday, March 11, 2013 6:57 AM To: U2-Users@listserver.u2ug.org Subject: [U2] ISO Date Format Has anyone come up with an OCONV string that will product an ISO standard date (-MM-DD)? After a vendor insisted on this last week I ended up creating a subroutine called by an I descriptor but it seems like there should be an easier way. A quick trip through the Universe Basic manual, my old Prime Info-Basic manual, and Pick Basic: A programmer's guide didn't shed any light. -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot 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] Unidata WHEN/ASSOCIATED
Jeff, This could be a good enhancement. How do you want it to work? 1. SELECT just the IDs or whatever the SAVING clause points to. Or 2. SELECT the IDs,MV pointers that match But until it goes through I'm sure someone has already written the code to do it in a UniBasic program. 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 Jeffrey Butera Sent: Friday, March 08, 2013 1:23 PM To: U2 Users List Subject: [U2] Unidata WHEN/ASSOCIATED Stupid question: is there a good reason why WHEN/ASSOCIATED can only be used with LIST and not SELECT? -- 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] UV: Consuming https service from within UVBasic using SOAP
You're welcome Peter. Sounds like you're past first base (communications OK) and now the challenge is handing the XML data exchanges. That will be fun! Will you use be the UV BASIC XML DOM routines? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Wednesday, 6 March 2013 11:37 AM To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Hi again, Finally had a chance to get back to this and have had success using a slightly modified version of the code here: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html After reviewing David's suggestions below and confirming the certificate requirements, the only areas requiring change were the URL (to the https url we had set up), and the path to where our client certificate accessible by UV (e.g. /opt/uv/certificates/Client-Root.cer) This brought some success as I was at least getting a response from the webserver but it was an error code 415 indicating incorrect mime type. e.g. 415 Cannot process the message because the content type 'application/x-www-form-urle. (the output is truncated but is just enough to get an idea of what is wrong) Then I discovered that the http_method parameter for 'POST' in the createSecureRequest function has a default mime type of application/x-www-form-urlencoded so I changed the HTTP.POST variable from POST to POST:application/soap+xml. Hey presto! Now I get this reply from the webserver: e.g. ResponseHeaders : Content-Length▒518▒Content-Type▒application/soap+xml; charset=utf-8▒Server▒Microsoft-IIS/7.0▒X-Powered-By▒ASP.NET▒Date▒Tue, 05 Mar 2013 23:41:35 GMT ResponseData: s:Envelope xmlns:s=http://www.w3.org/2003/05/soap-envelope; xmlns:a=http://www.w3.org/2005/08/addressing;s:Headera:Action s:mustUnderstand=1http://tempuri.org/IJobService/CreateJob1UserPartyRoleResponse/a:Actiona:RelatesTourn:uuid:5af711cc-4ed3-4208-baa1-48aa9f74af60/a:RelatesTo/s:Headers:BodyCreateJob1UserPartyRoleResponse xmlns=http://tempuri.org/;CreateJob1UserPartyRoleResult513682af531c9e1090b67f20/CreateJob1UserPartyRoleResult/CreateJob1UserPartyRoleResponse/s:Body/s:Envelope HttpStatus : 200 OK Many thanks again to David and Symeon for their assistance in this. Cheers Peter PS My code at this stage is only a prototype and is functionally the same as the example in the URL above but if anyone would like a copy then please let me know. ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor no longer working in UniSQL after UD upgrade
Have your compiled your i-descriptor? Is it marked as MV? 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 Mecki Foerthmann Sent: Tuesday, March 05, 2013 5:42 AM To: U2 Users List Subject: [U2] I Descriptor no longer working in UniSQL after UD upgrade Hi we upgraded from UD 5.2/Solaris to UD 7.2/RH about a month ago and so it looked fine so far. Now I had a call that there are purchase orders missing on a Cognos report. When I investigated I noticed that from the day of the upgrade I have rows in the table used for that report with missing dates. The report is based on a SQL Server 2000 table that gets updated every night with Purchasing information from UD using DTS. We want to track supplier performance so I take a snapshot of the outstanding Purchase order deliveries every night and add them to this table. Each row also contains the date the snapshot was done. Some order line have multiple deliveries so I created a I-type dictionary item using REUSE(@DATE). This is mapped in the schema and was working just fine under 5.2 but now there is only a date for the first multivalue. I created a new subtable using the 7.2 VSG and the result is the same. The dictionary works just fine from ECL but in SQL only the first row has a date and all others are null. Any idea why this doesn't work anymore under UD 7.2? ___ 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 full screen editor
Is there a way to have BDT use a TCL command besides BASIC/CATALOG to do my compile and cataloging? 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 Symeon Breen Sent: Monday, February 25, 2013 10:03 AM To: 'U2 Users List' Subject: Re: [U2] UV full screen editor On the UV clients CD in the eclipse based tools there is the Basic Development toolkit (BDT) this will probably give you most of what you want. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nirvan Wijesekera Sent: 25 February 2013 14:04 To: u2-users@listserver.u2ug.org Subject: [U2] UV full screen editor Hello all, I'm new to this forum, so apologies if this topic has been brought up before. Can anyone recommend a decent full-screen editor for Universe? I require it for editing source code as well as modifying data files. Seems like most of them can do one or the other, but not both. We do not run System Builder, so is there anything else available? We are trying to move away from the native UV line editor. Many thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Clearing Input Buffer
CLEARINPUT 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 Al DeWitt Sent: Friday, February 22, 2013 12:52 PM To: 'U2 Users List' Subject: Re: [U2] FW: Clearing Input Buffer How do I flush the buffer? What is the name or function I need? I can't put my finger on the right page in the Unidata manuals. Thanks. Al DeWitt -Original Message- From: Kevin King [mailto:ke...@precisonline.com] Sent: Friday, February 22, 2013 1:25 PM To: U2 Users List Subject: Re: [U2] FW: Clearing Input Buffer I would think flushing the input buffer in either location would be sufficient, assuming the problem is as you described. I've seen situations where there's something in the second field, for example, that is data stacking something new and the data stacking from the gun is conflicting with that. If you're confident that's not the case, flushing the input before that third field should suffice. On Fri, Feb 22, 2013 at 12:20 PM, Al DeWitt adew...@stylmark.com wrote: I have an input screen (built with System Builder) where data can either be entered manually or via a barcode scanner. The screen has 3 text boxes for input. The barcode option fills two of the text boxes and is supposed to land on the third box to await input. However, the scanner must be adding an extra return or something because when I scan it the third field's Process After executes. What can I do to flush the input buffer at the end of my validation routine on my second field...or is it better to do this on the Process Before on my third field. It's more of a nuisance but it would look more professional if I could make it clean. 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 ___ 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: Consuming https service from within UVBasic using SOAP
Hi Peter, You easily change that sample source code try amending these lines to access any SSL webserver/appserver. For example the Firstmac.com.au website using SSL by default I see - so that'll be a good site to use as an worked example - that uses a CA Root certificate. Basically, all you'll need a copy of you GeoTrust's root certificate accessible by your (UV SOAP/HTTP) client application. You must upload this (or any other SSL certificate) to your UV host and tell you UV application where it can be found... * Assumes client host can resolve and access this URL * For HTTPS SSL www.firstmac.com.au is using GeoTrust CA certificates, hence upload a DER copy of it first. URL = https://www.firstmac.com.au/home; * Define the full path to the GeoTrust CA Root certificate, uploaded to the host (exported in DER format) X.CERT.PATH=@PATH:/geotrust.cer ;* Full path to a DER copy of GeoTrust CA Root Certificate X.USED.AS=2 ; * 1=Self-signed, 2=CA Issued certificate X.FORMAT=2 ; * DER format X.ALGORITHM=1; * RSA key Hope this helps. The CA Root SSL certificate business is complex and is part of that steep learning curve! Good luck! Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 21 February 2013 11:44 AM To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Hi David, Thanks for the url - am going through this now and the accompanying log. It seems the host not found in hostlist error is not an issues so will continue investigating other causes. I do believe the answer will lie somewhere in my own malformed request so just need to work it out I guess. Will post updates as this progresses. Many thanks, Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 20 February 2013 20:17 To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Peter, As Symeon mentioned, protocol logging is required to help troubleshoot issues. If you like to use Firefox, the 'Firebug' plug-in is helpful to see what goes on behind the scenes - but only once you have familiarised yourself with the basic concepts of the HTTP protocol. Otherwise, not much will make much sense... The variable unassigned and UV version, shouldn't be an issue... we got UV SOAP going on UV10.1 ...years ago... using the IBM UV sample code mentioned in this URL: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html We cloned this code for a proof of concept and our version worked for us (if I recall correctly)... Obviously (maybe not), this is sample code in the URL will not actually work anymore - if actually did all those years ago (I can't recall) but it should give you a heads-up so to speak and point you in the right direction (more or less - hopefully more!)... Regards, David ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV: Consuming https service from within UVBasic using SOAP
Peter, As Symeon mentioned, protocol logging is required to help troubleshoot issues. If you like to use Firefox, the 'Firebug' plug-in is helpful to see what goes on behind the scenes - but only once you have familiarised yourself with the basic concepts of the HTTP protocol. Otherwise, not much will make much sense... The variable unassigned and UV version, shouldn't be an issue... we got UV SOAP going on UV10.1 ...years ago... using the IBM UV sample code mentioned in this URL: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html We cloned this code for a proof of concept and our version worked for us (if I recall correctly)... Obviously (maybe not), this is sample code in the URL will not actually work anymore - if actually did all those years ago (I can't recall) but it should give you a heads-up so to speak and point you in the right direction (more or less - hopefully more!)... Regards, David ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Quick Question on u2 toolkit for .net
Just to confirm Symeon that mv.NET has that functionality. Regards David Peters Bluefinity -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 14 February 2013 15:27 To: U2 Users List Subject: Re: [U2] Quick Question on u2 toolkit for .net No, it doesn't. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, February 14, 2013 3:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] Quick Question on u2 toolkit for .net I am currently not really interested in most of this - we just simply connect to u2 using uo.net to do subroutine calls and produce webservices from this. However my question is, does this toolkit allow you to edit and compile U2 basic programs within visual studio ? Now that would be handy. Rgds Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [AD] Free Webinar: Empower MultiValue and Integrate with the World!
There are a few seats remaining in next week's webinar - don't miss out...register at https://www2.gotomeeting.com/register/931463594 For .NET developers wishing to access MultiValue databases, mv.NET has built a reputation for being the product of choice. Any MultiValue application can be enhanced and new applications can be built using mv.NET without needing to move away from tried, tested and trusted MultiValue database technology or existing business logic. mv.NET Solution Objects takes MultiValue application development to dazzling new heights and, with one simple implementation, provides developers with limitless ways to create amazing application interfaces using the very latest industry standard RIA technology -- HTML5, Silverlight, ASP.NEThttp://ASP.NET, WPF and any other .NET enabled Microsoft environments, servers and applications. Native applications can be produced for iPhone/iPad/iPod or Android using a common C# based development environment. Browser based applications can be created using ASP.NEThttp://ASP.NET and HTML5 that adapt themselves to the appearance of native platforms. mv.NET provides the route to fulfil both of these requirements without learning multiple mobile platform skill sets. In fact, .NET developers don't even need MultiValue knowledge to produce applications! Organizations can utilize the massive resource pool of .NET developers to boost application development bandwidth and reduce development timescales. Let our experts show you how easy it can be to unleash your creativity and create state-of-the-art, industry standard applications which can be deployed across any of the wide range of today's interface devices - workstations, browsers, handhelds, phones and other mobile devices. With mv.NET Solution Objects, your MultiValue application can now rival the 'mainstream' competition in terms of features, functions, performance, stability and efficiency! Join us for a free online overview and demonstration February 19, 2013 http://www.bluefinity.com/site/Empower_MultiValue_Webinar.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Turn pagination back on
BPIOCP 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 Wjhonson Sent: Thursday, February 07, 2013 1:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] Turn pagination back on Someone remind me, how to do this. If pagination has been turned off, and for my embedded routine, I want to turn it back on again. How do I do this? I've tried HEADING, and PAGE, and CRT @(0,0) I know there's a trick but I can't quite recall what it is ___ 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] U2 Test Tools for system/unit regression testing w/integration with HP QualityCenter
Thanks Brian - that sounds great! I would be keen to get a trial version, once you have a SSH capable version. How is the product licensed? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, 5 February 2013 10:14 PM To: 'U2 Users List' Subject: Re: [U2] U2 Test Tools for system/unit regression testing w/integration with HP QualityCenter Hi David I've recently released a testing product called (predictably!) mvTest. This supports automated testing of U2 applications using a dedicated scripting language modelled after UniBasic for familiarity but with a number of key extensions to handle data validation, test data handling, UI scripting and assertions. You can use this to create unit tests, UI tests (currently TELNET and U2-compatible secure TELNET/SSL but with SSH to follow shortly), regression and volume tests. Here's a quick overview of how it works - - You create unit or UI tests using the scripting language. These can be run through either of a Windows client or through a server-side script runner e.g. if you want to perform CI testing through a phantom. There's a nice Windows based editor to create, organize and test these. - The tests return pass or fail information based on assertions, so you can see at a glance if anything has broken. You can save the information and run various reports against it. - The tests can run direct against the database through a UO.NET connection (e.g. for testing subroutine calls and parameters) or through a terminal-style UI. It embeds a complete terminal emulator with all the necessary functions, and this allows you to drive screens, perform spot checks, branch on different results (e.g. handling error messages raised from your screens), handle send/expect style scripting and more complex conditions (such as wait until the cursor is at this location and this message has appeared here). - It keeps a separate shared server connection open while the UI tests run so you can, for example, script an entry screen via the terminal UI that ends up saving some data like a sales order, and then immediately check what has been written to the database through the underlying connection as part of the same script. - Unit tests can be organized into batches in which the tests run in order, so you can set up sequences that match business operations. - Batches can be organized into runs, so you can test whole suites of your application. Each run can be customized, so you can feed in per-site or per-system information. Runs can optionally randomize the order in which batches are executed, and you can set up different run scenarios and iteration patterns. - You can feed in and randomize test data and from the client side runner, access local features as well as the database operations. - Volume testing can take place using the Windows client. This is a multithreaded client supporting multiple concurrent UI sessions - I've tested up to 250 concurrent connections from a single PC running against an SB+ system for one customer last year who needed to stress test their SB+ system performance coming up to the New Year sales. This first release is targeting U2 with other MVDBMS to follow. I'm also adding support for GUI testing using the Microsoft Automation APIs and WebUI testing going forward. Anyone interested can contact me for an evaluation version, or download the user guide from www.brianleach.co.uk. Regards Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
Jon, Everything is strait forward except the wait until logic. That can get very complex if you want to. RECORDLOCKED(file.var, rec.id.expr) - Returns record lock status, 0 if not locked. MATREADU or READU or RECORDLOCKU - Will lock a record.* MATWRITE or WRITE or RELEASE - Will unlock a record. *Note you can use GETUSERNAME(STATUS()) to see who has it locked. 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 Jon Wells Sent: Wednesday, February 06, 2013 2:53 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Record locks (Unidata 7.2) Hi all, I have not looked at the world of record locks since my R83 Pick days. I'm hoping to add the ability for the program I'm working on to: * Check if a record is locked * Wait until the lock is removed * Once the lock is removed, or if the record is not locked: * Lock the record * Perform the WRITE statement I'm hoping someone can share an example of how to accomplish this in UniBasic. Thank you, Jon Wells Campbell University ___ 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] Large File Operations Kill Linux
Yes, sounds like it's been identified and fixed a while ago... like Dan says...kernel update will the simple way to address it... (time outage permitting) https://bugzilla.redhat.com/show_bug.cgi?id=735946 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Tuesday, 5 February 2013 9:32 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Large File Operations Kill Linux Other users could have been hanging at malloc. With a swappiness of 100 (on some kernels) or 100 (on others) or not 0 or 100(not sure which behavior you get on 2.6.18), pages wouldn't be getting freed up quickly enough duing the creation/copying of a large file. Another thing to look at (although I prefer the support route, since you have it), is /sys/kernel/mm/transparent_hugepage/defrag. Other people who have had this problem alleviated it by setting this to never. Of course, others fixed it by updating the kernel. My aged eyes read what you have as 2.6.8.1... ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 Test Tools for system/unit regression testing w/integration with HP QualityCenter
Hello All, I am just wondering what U2 or UniVerse specific integrated testing suites people are using out there and ideally in use today. We have the need for a UV11.x specific or capable tool for automating our existing system/unit and regression test packages. We have a our existing test suites/scripts in HP QualityCenter (HPQC) and we currently manually capture and store the results (plus track 'defects') there as well. Ideally, this tool should be able to integrate with HPQC. At minimum some means to capture results - test case number plus success/failure to a file. Our primary application interface is via a terminal interface via SSH emulating VT220 terminals. But we also use various interfaces UV Clients APIs or third-party utilities (accessed via UNIX shell scripts or the like). Ideally, testing package should be able to drive (simulate keystrokes via keyboard entry) or invoke all of these in some fashion. Hence some sort of scripting of terminal emulator or UNIX shell and/or client APIs would be ideal. Another requirement is a tool that has the ability to perform simulated end-user terminal session load testing (ie., connect X number of users via terminal emulation over SSH and perhaps client APIs too) - we would could simulate actual users interactive access and run X, Y or Z test scripts. The primarily purpose of this is to simulate database record locking contention, etc. under load, etc. Plus other stress testing under load. Your solution could be a commerical product or a perhaps some in-house tool or opensource or combination thereof...whatever it is - I'd be interested to hear about this tool or your experience of attempting to do this. Thanks in advance for any feedback. Cheers, David ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] SETPTR
Bill, sounds like a domain name network issue. How does a ping to UDGENERIC respond? Maybe you can add the IP address to your host file? 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 Bill Haskett Sent: Friday, February 01, 2013 6:14 PM To: U2 Mail List Subject: [U2] [UD] SETPTR Does anyone know why UniData (v7.2.12) responds differently to the SETPTR command between two different machines? I created a local printer, which I share as UDGENERIC, that is a generic/text printer to a file. I did this on both machines. Machine 1 - Windows 2008 R2 fully updated - UniData 77 user Standard Edition. :version Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 7212 :SETPTR 0,146,61,0,0,1,BRIEF,NOEJECT,NOHEAD,DEST UDGENERIC This command takes exactly 60 seconds to return to ECL. Machine 2 - Windows 2008 R2 fully updated - UniData 24 user Workgroup Edition. :version Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 Yes Device License... 7.2 Yes NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 7212 :SETPTR 0,146,61,0,0,1,BRIEF,NOEJECT,NOHEAD,DEST UDGENERIC This command returns to ECL immediately. Both machines are Dell R210 rack-mount servers. I'm having the udt.errlog fill up with messages: Fri Feb 01 18:19:34 pid=2828 In E:\DataTrust\DTA\BP\BP\_RESET.STANDARDS at line 33 Fri Feb 01 18:19:34 pid=2828 errno=1801: The printer name is invalid. Fri Feb 01 18:19:56 pid=3696 pid=3696,uid=197875,udtno=2: ...which is caused by one of our subroutines, used everywhere in our application. This error occurs nowhere else where our application is installed, because I execute the above SETPTR command within the LOGIN process at login. I can't execute it on our 77 user machine because logging on will take over a minute! Any ideas? Thanks, Bill Haskett ___ 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] [UD] Disabling/blocking ODBC
Brian, *UOLOGIN works for me in UV11.1.9 AIX. What arguments are you specifying? I haven't got been able to get *ODBCLOGIN to work. I'm speculating if the arguments the same though - such is the nature of undocumented features? Perhaps they should have *APILOGIN to for all API clients? Plus a new @-variable that can identify what server-side interface is handling the call - thus eliminating the need for UOLOGIN and ODBCLOGIN... ? Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, 29 January 2013 8:05 PM To: 'U2 Users List' Subject: Re: [U2] [UD] Disabling/blocking ODBC Sadly these appear to be UniData only. Or at least, in the past I've tried with local catalog, global catalog as *UOLOGIN and global catalog as the (illegal) UOLOGIN. None of these got fired. Would be really useful as a central consolidation point for things like setting DATE.FORMAT. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: 28 January 2013 21:23 To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Is this only Unidata or Universe? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, 29 January 2013 9:15 a.m. To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC Glad to hear that! Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, January 28, 2013 12:25 PM To: U2 Users List Subject: Re: [U2] [UD] Disabling/blocking ODBC There is an undocumented feature: ' ODBCLOGIN'. This is a subroutine that is called for every ODBC call. You can use this to either blank prevent ODBC, or setting up restricted login access login. Dan, I got the info from our VAR and it works great. Thanks! Brad. 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 ___ 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 ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sleeping in Basic
In my latest phantom program I used the PAUSE/WAKE commands as one poster suggested. It was a little bit tricky but this is what I came up with: The driver program has this logic: ... UTP.ID = GETENV(UD_TELNET_PID) CMD = PHANTOM UPDATE.RECORD.PH :REC.KEY: :UTP.ID PRINT START: :TIMEDATE() PRINT CMD PERFORM CMD * PAUSE 60 PRINT FINISH: :TIMEDATE() ... While the Phantomed program has the following: PARAMS = FIELD(TRIM(@SENTENCE), , 2, ) REC.KEY = FIELD(PARAMS, , 1) UTP.ID = FIELD(PARAMS, , 2) PRINT Start UPDATE.REC.PH for :REC.KEY GOSUB UPDATE.REC PRINT Wake up process :UTP.ID WAKE UTP.ID 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 Gregor Scott Sent: Wednesday, January 16, 2013 9:41 PM To: U2 Users List Subject: Re: [U2] Sleeping in Basic This might be a bit late, but just be careful about using openSocket() in a phantom. On UV (and I suspect on UD) this will change the phantom to an iPHANTOM because it will consume a license. If you have multiple phantoms running this concurrently you will start to see a licensing impact you were not expecting. Regards, Gregor -Original Message- ... Doug this works for me in UniData: SLEEP.TIME = 500 ;* .5 Second ERR = openSocket(loopback, 25, 1, SLEEP.TIME, hBUFF) David A. Green (480) 813-1725 DAG Consulting ... This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ 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] Universal COMO
So you do what you want to do, but not hard code it and hence require manual updating of all those VOCs. When you want to move for some reason...like lack of disk space or a new disk letter... UD also supports multiple version to operate on the same host/server...done mainly through the use of shell variables to point to proper version. Much like you can do with Oracle too. Now that would be handy if UV could do that too...especially when upgrading/test new releases, etc. Back to your query... In the past we use to have multiple UV accounts from the old legacy systems. But then we bit the bullet and simply created a single account. Not all sites can do this if you have duplicate filenames. We had few files like this and just renamed them and end up prefixing the duplicates with the (original) account name to ease the transition. Then we just change any applications/dictionaries that use to refer to. We didn't have any issues with duplicate HOLD, SAVEDLISTS nor COMO filenames. But you do have to aware of potential gotchas like this when applications start overwriting each other's' output. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, 24 January 2013 7:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universal COMO What's the reason for using a variable, @MY_COMO, instead of the actual path ? -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Jan 23, 2013 7:22 pm Subject: Re: [U2] Universal COMO In UniData (on Windows) this is pretty simple. First you create an environment variable for the como file (e.g. MY_COMO) that points to the directory under which you've created a _PH_ directory and a D__PH_ dictionary file. Then you create a VOC item as follows: _PH_ 001 DIR 002 @MY_COMO\_PH_ 003 @MY_COMP\D__PH_ ...to include in every account's VOC file. This will now act as a centralized como repository. I do this with the _HOLD_ directory, as everyone on our machines share the same spooler file, and each spooler file name is a unique .txt file. I'm sure it would be even easier on a nix machine. :-) Bill ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users