Re: [U2] Web services at 11.x
Harold: Maybe you'd be interested in: https://u2devzone.rocketsoftware.com/accelerate/resources/videos/rest HTH, Bill Untitled Page - Original Message - *From:* harold.o...@clark.wa.gov *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 5/13/2014 11:20 AM *Subject:* Re: [U2] Web services at 11.x Right, Enterprise Service Bus. Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 13, 2014 10:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Web services at 11.x https://en.wikipedia.org/wiki/Enterprise_service_bus -Original Message- From: Oaks, Harold harold.o...@clark.wa.gov To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Tue, May 13, 2014 10:11 am Subject: [U2] Web services at 11.x I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Read yourself
Richard: This is exactly what appears in UniData's SYSTEM(49) function call, although in reverse order. 5 Dev (0)- BPTEST CRT SYSTEM(49) ; END Compiling Unibasic: SAVEDLISTS\BpTest_332397981 in mode 'p'. compilation finished 1²E:\AboEnterprise\Abo\BP\BP\_START.STACK²32■2²E:\AboEnterprise\Abo\BP\BP\_TCL.SHELL²1161■3²E:\AboEnterprise\Abo\BP\BP\_BPTEST²104■4²SAVEDLISTS\_BpTest_332397981²1■ Bill Untitled Page - Original Message - *From:* rbl...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/13/2014 1:46 PM *Subject:* Re: [U2] Read yourself George, It's better illustrated by multiple call levels. A colleague here wrote these specifically to test this: STACK.1 SUBROUTINE STACK.1 CRT || CRT CHANGE(SYSTEM(9001), @AM, CHAR(13):CHAR(10)) CRT || RETURN STACK.2 SUBROUTINE STACK.2 CALL STACK.1 RETURN STACK.WRAP CRT @(-1) CALL STACK.2 And here's the results: || 3ý/(absolute path)/BP.O/STACK.1ý0x6 2ý/(absolute path)/BP.O/STACK.2ý0x0 1ý/(absolute path)/BP.O/STACK.WRAPý0xe || Best Regards, Richard Lewis On Tue, May 13, 2014 at 11:59 AM, George Gallen ggal...@wyanokegroup.comwrote: Unless I'm doing it wrongdidn't look it up. For me - on UV 10.0.2 PRINT SYSTEM(9001) STOP END Outputs RUN LIB TEST 0 George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 13, 2014 1:55 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Read yourself I had posted an update, that I had tried it (it returns the program stack) Its System(9001), and it will return the subroutine names in the stack as well as the main program (on Universe 11 anyway) Someone has to try this on Unidata, and on D3 to make sure it also returns the subroutine name. What it returns is the absolute path, so you would still need a program to translate this into a LOCAL file name and program id, which is, to what, I'm trying to get. Like I mentioned, I'm sure there is a way to do it, it's just a question of whether someone has a routine which *does* this already, and the answer is apparently not, so if I have to roll my own. -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 13, 2014 10:40 am Subject: Re: [U2] Read yourself Does the 9001 call work for subroutines, or just the main program? Also, it's platform specific It all depends on what your trying to do, if the 9001 call works, great, if not figure something else out. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 13, 2014 1:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Read yourself Well do you see any problem in just using the SYSTEM(9001) and ignoring embedding this information ? -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 13, 2014 10:27 am Subject: Re: [U2] Read yourself Then you would need to write another program that scans the programs and checks if the VERDATA element For the program name matches the @ID in the program file - if not email someone to fix it. Then have it run nightly - so if it did get cloned without changing, it wouldn't be that way For long. George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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/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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
Can you open the .csv file (the Windows File item within the Windows Directory) with a text editor? Does it look like text? Is there a sub-directory within this directory? Are the permissions of this .csv file the same as the rest of the items within the directory? You're not getting that stupid desktop.ini item within the directory, are you? Just a few thoughts. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 5/6/2014 10:04 AM *Subject:* [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Rgarding ED editor
Shanmukh: Although the following link is designed for D3... http://www.d3ref.com/?category=2 ...it's pretty good documentation on the line EDitor. HTH, Bill - Original Message - *From:* shanmukhnan...@gmail.com *To:* u2-users@listserver.u2ug.org *Date:* 4/17/2014 2:47 AM *Subject:* [U2] Rgarding ED editor Hello Friends, Can any one help with ED editor docs in Unibasic Programming language Thank you, Shanmukh ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Business ?
If I'm not mistaken, they're a very large DesignBais user. Bill Untitled Page - Original Message - *From:* jbut...@hampshire.edu *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/28/2014 12:55 PM *Subject:* [U2] Business ? Does anyone know much about FW Davidson http://www.fwdco.com? They came across my radar and I see references to Unidata along with SQL and Oracle. Just curious if anyone know precisely what solution(s) they run on Unidata... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SpreadsheetML and Excel2013
I'm not using 2013. A friend was showing me that the new word and excel files were nothing but XML inside a zip file. So, open a .xlsx or .docx file with a zip client and you can actually see its contents. Kind of amazing. Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users u2-users@listserver.u2ug.org *Date:* 3/24/2014 11:00 AM *Subject:* [U2] SpreadsheetML and Excel2013 Is anyone else having issues with Excel2013 giving errors to previously working XML files from Excel2003 It keeps telling me there is an error in the table, and says there is log file, which is blank - not helpful. George 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
Re: [U2] Unidata 7.2.6 Secure submitRequest Question
Do sockets update the serverdebug defined file, like UniObjects does? Bill - Original Message - *From:* ke...@precisonline.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/24/2014 2:36 PM *Subject:* [U2] Unidata 7.2.6 Secure submitRequest Question Anybody ever seen anything like this before: 1523926:error:0D0890A1:asn1 encoding routines:ASN1_verify:unknown message digest algorithm:a_verify.c:141: 1523926:error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed:s3_clnt.c:844: This is displaying on a routine when it hits a submitRequest after the following routines have been successfully called: * createSecurityContext * setAuthenticationDepth * addCertificate * createSecureRequest * addRequestParameters Where should I start digging? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] jobnotify: Error 913 occurred
This reminds me... Does UV have the same kind of logging as UD? Whenever UD crashes with things like LCT errors there's a log file created in the dbms account directory outlining the kinds of problems that occurred. These were very helpful when I sent them to Wally. :-) Bill - Original Message - *From:* david.h...@cba.com.au *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/20/2014 11:21 PM *Subject:* 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] MongoDB
This is a very interesting analysis of MongoDB vs Oracle... http://www.fstsummitus.com/media/whitepapers/2013/a_total_-10gen.pdf Perhaps U2 ought to seriously review this to expand their market via pricing. Remember, most big companies started out small. To price small companies out of the U2 market is to send big companies elsewhere. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] jobnotify: Error 913 occurred
I have no idea what it is either. When phantoms crash I figure it has to do the the credentials running the phantom. In windows I find all my scheduled tasks run under a specific set of credentials. If something runs that I don't have permissions for it just crashes. So the user has to have access to all the files and functions the program accesses. Since you changed servers, I'm guessing this is a good place to start. Bill - Original Message - *From:* johnisr...@daytonsuperior.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/20/2014 3:58 AM *Subject:* Re: [U2] jobnotify: Error 913 occurred No idea what that is. John Israel Sent from my iPhone On Mar 19, 2014, at 11:39 PM, Leverett, Brendon brendon.lever...@spotless.com.au wrote: Nearly one week and no responses... Do I assume no one encountered the 'jobnotify: Error 913 occurred' message or has any knowledge of it. Regards, Brendon Leverett From: Leverett, Brendon Sent: Friday, 14 March 2014 11:09 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: jobnotify: Error 913 occurred We have recently upgraded Universe (10.2.4 to 11.1.15) and are now finding some unusual activity around phantom jobs and the documented change to NOTIFY ON. There are a lot of details behind the scenes but in summary: - started a job via phantom command (phantom SYNC.COPY.BNET) - noticed 90 mins later that this job had crashed. This crash happens for various reasons but is more frequently crashing since the upgrade - restarted the same job with the same phantom command At this time the following 3 lines of text was returned to the user's session: jobnotify: Error 913 occurred [15466830] SYNC.COPY.BNET - terminated Phantom process started with process ID 33161456 Seems the 1ST 2 lines of text related to the previous phantom and 3rd line related to the phantom just started. My Q is: Does anyone have any ideas about the specific message jobnotify: Error 913 occurred We are running on AIX. Regards, Brendon Leverett ** This email message and any files transmitted with it may be confidential and privileged neither of which is intended to be waived. If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://cp.mcafee.com/d/5fHCNASyOqenQTD1NEVvdTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVLrIKqCO_R-hsuvjjuWZOW9EV7esC---CU_ORQX8FGTd7b7axVZicHs3jq9JcTsTsS02EJmp_QFO_qSrrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jryr3NI5-Aq83iS4QPiWq816F25pOtb96y0qz6Ijh0qekmjh1mRCUNZ0SOYrTRJo Please consider our environment before printing this email. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/avndxMsd38srhpd7bWrPwUQsLCXCQrEFLThKCqejqdQkTXEFECzASzt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsTJSndjpvW_8KffFFLtuVt4QszDejvvvjsvVqWtAkRrCzBzBgY-F6lK1FJcSCrKrKr01DOFeDNc_7CQSOf00s4RtxxYGjB1SKdFBSWv6xJJcKTjUQbAaJMJZ0kvaAWv4PYurjr8Y01dK9If6MnWhEwdbojjdbFEw4qA8lD9QIAq81GcqNd41EVhpd45rmrz7Q3rbNLzkJuGcbvvfF ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Embedded help as hypertext
Then, someone did the following for D3. http://www.d3ref.com/ It's really too bad this isn't how U2 provides documentation, as it'd get indexed all over the internet, which would be good marketing, maybe. :-) Bill - Original Message - *From:* david.h...@cba.com.au *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/11/2014 10:49 PM *Subject:* 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
Re: [U2] Left Outer Join Question
Randy: NSELECT is a not select. It doesn't use, as far as I know, any filters with it. Use the filters with the SELECT then use the NSELECT (then use more SELECTs with filters if you want). Bill - Original Message - *From:* randyleesm...@roadrunner.com *To:* u2-users@listserver.u2ug.org *Date:* 3/4/2014 10:43 AM *Subject:* Re: [U2] Left Outer Join Question Using NSELECT works as long as I don't do a complicated statement with it. NSELECT OLDMAS WITH CO = SF AND WITH TRWSTATUS AND WITH ACTIONCODE NE 99 ... Unknown word WITH on command line. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
NSELECT gets the items in the list, created by SELECT X, that do not exist in Y. Consequently, you can do things like: SELECT VENDORS WITH LAST USED 01/01/13 INVOICEKEY xxx records selected to list 0 NSELECT INVOICES ...where INVOICEKEY is the field that produces the record keys into the INVOICES file. Duplicate keys are a different story. If you want the list to be duplicate free then you need to use the SAVING UNIQUE (that's UniData but I think it's also UniVerse) keyword at the end of the SELECT statement. e.g. SELECT VENDORS WITH LAST USED 01/01/13 INVOICEKEY xxx records selected to list 0 SELECT INVOICES SAVING UNIQUE @ID HTH, Bill - Original Message - *From:* randyleesm...@roadrunner.com *To:* u2-users@listserver.u2ug.org *Date:* 3/4/2014 11:07 AM *Subject:* Re: [U2] Left Outer Join Question If I do; SELECT X NSELECT Y Won't that take all my duplicate keys out from Y when I only want selected ones taken out from Y? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
Then, there's always:
:SELECT FILE1
xxx items selected.
NSELECT FILE 2
yyy items selected.
You can also do the same as noted below with an EVAL command. e.g.
:select FILE1 WITH EVAL TRANS('FILE2', @ID, 0, 0) =
xxx items selected.
Bill
- Original Message -
*From:* james.mcgo...@bankofthewest.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/3/2014 9:56 AM
*Subject:* Re: [U2] Left Outer Join Question
The usual pick way to do this is to create an attribute:
AE DICT FILE1 BLACKLIST
001: I
002: TRANS(FILE2, @ID, 0, 0) ; or really old-school OCONV(@ID,TFILE2;X;0;0)
003:
004:
005: 20L
006: S
:GET.LIST L1
1000 Items Selected
:SELECT FILE1 WITH BLACKLIST =
600 Items Selected
-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 9:44 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Left Outer Join Question
I have 2 files.
File 2 is a black list of records (keys) I want to exclude in and active select
list of File 1.
I've been looking into this for a little while and am not sure what I'm doing
wrong.
Docs are not very helpful with any examples on the how to do with this.
I know of ways to deal with this in code, but was hoping for an SQL way to deal
with it.
-
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-tp42740.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 NOTICE: This message is intended only for the addressee
and may contain confidential, privileged information. If you are
not the intended recipient, you may not use, copy or disclose any
information contained in the message. If you have received this
message in error, please notify the sender by reply e-mail and
delete the message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
Jeff:
I've written a little BASIC utility that takes a file, selects what I
want, then outputs via the ITYPE function as a CSV file to the spooler.
I wonder if that gets around the 150 field limit, since it's in BASIC?
I know UniData is weird regarding this kind of thing. For instance,
they also have something like a 256 item limit in a query statement...
:SELECT MYFILE WITH CUST# = 123...256257
...will abort. This too is hardwired. However, a neat little utility
provided by U2 called LSELECT selects items whose field definition
value is in a list, so if you're on the web you'd first allow the user
to select stuff, put it into a list, then use LSELECT to select the
items from the file...kind of like:
:SELECT CUSTOMERS WITH LAST_ACTIVE 01/01/13
500 records selected to list 0.
SAVE.LIST MY.LIST
Overwriting existing saved list.
500 key(s) saved to 1 record(s).
LSELECT SALESORDERS WITH CUSTNO IN MY.LIST VERBOSE
(Parsed Command)
LSELECT SALESORDERS WITH CUSTNO IN MY.LIST TO 0
(Selected List)
List Source MY.LIST found 500 items.
(Create Temp File)
LSELECT0031 file created with MOD = 3
(Loaded List to Temp File) - 500 items.
1436 key(s) saved to 1 record(s).
(Selected Result List)
UDT.COMMAND = select SALESORDERS WITH EVAL
TRANS('LSELECT0031',CUSTNO,'@ID','X') GT TO 0
UDT.RESPONSE = ■1436 records selected to list 0.■■
Destination 0
Named List 0
(Delete Temp File)
LSELECT0031 file deleted...
Makes one wonder...h.
Bill
Untitled Page
- Original Message -
*From:* rotm...@cedarville.edu
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 3/3/2014 12:57 PM
*Subject:* 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.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Left Outer Join Question
If you on UniData and you're in PICK mode then you have to lower case this kind of thing, since such PRIME style stuff only works in the UniData parser mode. So, try this: 3 Dev (0)- SELECT ADDRBOOK WITH MAILLIST NE AND WITH MAILLIST_OWNERS = [BOD] 309 records selected to list 0. SAVE-LIST BILL1 Overwriting existing saved list. 309 key(s) saved to 1 record(s). SELECT ADDRBOOK WITH CUSTOMERS NE 114 records selected to list 0. SAVE-LIST BILL2 114 key(s) saved to 1 record(s). get.list BILL1 TO 1 309 records retrieved to list 1. get.list BILL2 TO 2 114 records retrieved to list 2. merge.list 1 UNION 2 TO 0 423 record(s) selected. 3 Dev (0) ...and here we are with 423 items selected as the active select list. HTH, Bill //- Original Message - *From:* randyleesm...@roadrunner.com *To:* u2-users@listserver.u2ug.org *Date:* 3/3/2014 2:36 PM *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-tp42740p42762.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] Unidata Index Failure
Doug: I've had problems in the past when updating indexes while people were using the file. I began using the ONLINE keyword to the CREATE.INDEX command and it took several sub-releases before the problems have gone away (knock, knock!). My problem was the indexes I build for everyone's name and address come from a central address book file, while this information is used by multiple files (e.g. vendors, employees, customers, etc). Even though the address book file is indexed, so are all the other files (I don't want to look at employees when I'm looking for vendors). So, the solution was to set a flag when a change was made, then delete rebuild the indexes for the file when the next person logged in. Now, using UO and the web, it is checked much more frequently than when on telnet. Anyway, this process was obviously rebuilding when others were in the file. We occasionally had missing items that required the index be rebuilt by hand (at TCL/ECL). The ONLINE keyword seems to have resolved this over the course of several sub-releases. HTH, Bill Untitled Page - Original Message - *From:* dave...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/26/2014 7:20 AM *Subject:* [U2] Unidata Index Failure We have be experiencing a Unidata index failure above 7.3.2 on Windows 2008/2012. When we go back to 7.3.2 the problem goes away. The problem is sometimes the index does not get built for certain items. If we save the records or rebuild the index it goes away for a few days to a weeks until one or two items show up not in the index. Our customers report a software failure which takes us hours determine that no application software is the cause and we rebuild the indexes on the file in question. We have been working with Rocket Software for about 6 months on this problem. Rocket is reporting to me that no one has reported this issue to them. We thought we ask anyone on the list if they have seen any problem that is similar where they have solved the problem by rebuilding the indexes. Regards, Doug www.u2logic.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] wasted time on rs.com
Baker: Can't agree more. You'd think it would be easy to simply index your help site, place a search box on each page, then let people search for anything...but alas. [sigh] This is so difficult that we all ignore it and open our sites up to search engines. I did it on Microsoft one time and what a nightmare that was. :-) Bill Untitled Page - Original Message - *From:* baker_hug...@neimanmarcus.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/21/2014 6:45 AM *Subject:* Re: [U2] wasted time on rs.com Charles, your point is well taken. I am on the site alot, and have the same struggles finding what I need. The other day I was searching for a specific Tech bulletin the exact number, and it wouldn't find it. Regards, R. Baker Hughes Senior UV DBA, Wipro/NMG From: Charles Stevenson stevenson.c...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 02/21/2014 08:37 AM Subject:Re: [U2] wasted time on rs.com Sent by:u2-users-boun...@listserver.u2ug.org The question was Why can't it be easy to find? not Where is it? Searching Rocket website is difficult. The other day someone on this list was searching for Tech support Survivor's guide. Did he find it? We were told he needed a 2UBC login to get to it. Not for the riffraff. Try finding Mark Baldridge's Hitchhiker's Guide To UniVerse, which should be required reading. Go to www.rocketsoftware.com homepage enter some variants of Hitchhiker's guide to the universe at the search prompt of rocket software homepage. Your search yielded no results Keep going. You can limit the product families to U2. (Although I don't think that really does anything.) Nada. Tell me how long it takes to find it. Try to find out what particular error codes mean. Known issues and the release where they are fixed are buried in some help file you can get to only by looking up particular releases in a product matrix and downloading the entire help file. At least, that's the only way I've found. Do you have to do that for Lnux? MS? HP? any other software product you use? I used a new MS backup tool to backup a Win8 server its virtual servers. I got an error code. I am decidedly not a windows administrator. But on 1st attempt I found a useable MS answer. I rely on this u2-list. It's quicker to post a question here than wade through RS looking for anything. A couple weeks ago I couldn't remember syntax for the old, arcane Revise. Posted the q here got 2 answers. On 2/20/2014 8:05 PM, baker_hug...@neimanmarcus.com wrote: It is on the Tech Connect website. You might need a u2tc login to get to the product matrix. https://u2tc.rocketsoftware.com/matrix.asp Then enter Product desired, and OS: https://u2tc.rocketsoftware.com/buildmatrix.asp Regards, R. Baker Hughes Senior UV DBA, Wipro/NMG From: Marc Harbeson marc.harbe...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 02/20/2014 11:00 AM Subject:[U2] wasted time on rs.com Sent by:u2-users-boun...@listserver.u2ug.org why can the download for the U2 clients not be easy to find on the web site?!?!? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary queston
Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer.
You know, I was able to integrate all printers into U2 by writing a few simple programs and using Print Wizard to convert our PCL5 output into a .pdf file. This way, I never work with printers at the UD level any more. And PW is an awesome product with awesome support. Bill Untitled Page - Original Message - *From:* antli...@youngman.org.uk *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 1/28/2014 12:54 PM *Subject:* Re: [U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer. On 28/01/14 20:31, Jeff Schasny wrote: I've been using Universe since it was in beta and I had no idea you could use a URI in SETPTR. Its a good day, I've learned something new. Thanks! Just watch out. In today's modern world of GDI printers, sending a raw text dump from UV is often not a good idea. In the old days of dot-matrix, or even PCL that just expected a text stream, it worked fine. It's nowhere near that simple any more :-( Cheers, Wol Wols Lists wrote: So if I am working on \\ASHDOWN (the name of my computer) I can use SETPTR to point at \\TIGGER\HP - a printer logically connected to a different computer that I've never told UV anything about. Setptr is quite happy to be given a windows remote computer reference and it works fine. That was how all our printers worked - they usually had network cards in them, so when a new printer turned up, I would assign it a name in DNS, and for anybody who was supposed to use it I would just edit their login script to add eg SETPTR ...,AT \\ACCOUNTS-HP\RAW And it just worked. No UV printer setting up whatsoever. Okay, my setup was a little bit cleverer than that, but everything, and I mean EVERYTHING, was done in my programs. Nothing at the UV level whatsoever. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Who's locking a record
Oops, I forgot to mention I'm using Windows.
Bill
Untitled Page
- Original Message -
*From:* bl...@shaklee.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 1/28/2014 1:12 PM
*Subject:* Re: [U2] [UD] Who's locking a record
Here's how we do it:
READU MASTER.REC FROM F.CNTRL, 'COM.MASTER' LOCKED
UID = STATUS()
CMD = '!grep :':UID:': /etc/passwd | cut -d -f5'
EXECUTE CMD CAPTURING USER.NAME
MSG = 'DIST record - ':DIST.NBR:' is locked by: ':USER.NAME1
CALL SB.DISP(9,MSG)
SLEEP 5
CALL SB.DISP(9.'')
RETURN
END ELSE
RELEASE F.CNTRL, 'COM.MASTER'
STOP
END
-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 12: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
___
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
Thanks Colin David. That's what I did; what a dance though!
I wonder why anyone would want STATUS() to return a value that doesn't
give us the means to resolve the problem (as in what terminal, or what
UO program was locking the record)? PORT.STATUS is of no value in a web
environment because it's too slow and doesn't return a call stack on a
UO process.
It's be really nice if we could get any information about a port/process
simply by querying some object, instead of having to remember some
esoteric function whose data we need to parse through. Kind of like UD
not telling us which darned dbms account a user is logged into!
Thanks again.
Bill
Untitled Page
- Original Message -
*From:* alfke...@hotmail.com
*To:* 'U2 Users List' u2-users@listserver.u2ug.org
*Date:* 1/28/2014 3:49 PM
*Subject:* Re: [U2] [UD] Who's locking a record
That's what we used to use. It's a little more of a pain as you have to
parse through the output to find the correct record - but it should give you
need. It's simply list.readu output in an array.
Hth
Colin
-Original Message-
From: David A. Green
Sent: Tuesday, January 28, 2014 2:19 PM
To: 'U2 Users List'
Subject: 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: 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-ADDRESSTIME 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] Accuterm the Web version
Were you talking about the version of AccuTerm that runs through a web browser? If so it's a nice product but the user still has to download and install AccuTerm, which works fine over the internet. I can certainly echo the sentiments regarding the quality of AccuTerm products and their wonderful support. If you'd like more information, can you be more specific about what you're looking for. I think your request was a little too general. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 12/23/2013 11:07 AM *Subject:* Re: [U2] Accuterm the Web version No the original post was to see 1) if anyone is using this web version and 2) to get a testimonial FROM them. Period. That's all. Anything else you read into it, was not present. The purpose of customer testimonials is to get their own personal experience. That's for what I was looking. Solely. -Original Message- From: Bruce Decker bdec...@bluepinc.com To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Dec 23, 2013 10:36 am Subject: Re: [U2] Accuterm the Web version Okay: Let me try it this way. I've known and worked with Pete for over 25 years. In ALL of that time, I've found that the quality of his products are first rate, he does not exaggerate claims (which is what I thought the original post was suggesting) and if there was an issue (rare) he is very responsive and quick to resolve the issue. I believe if Pete tells you something, you can take it to the bank. I think this is helpful information especially for those who may not know Pete and wonder if they can rely on information he is providing. I should have spelled it out instead of being snarky. My apologies. -BD On 12/23/2013 11:22 AM, Wjhonson wrote: Bruce if you don't like this thread, you don't have to respond. Please let those of us who want to know these answers discuss it. -Original Message- From: Bruce Decker bdec...@bluepinc.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Dec 23, 2013 10:19 am Subject: Re: [U2] Accuterm the Web version Exactly what he means. -BD On 12/23/2013 11:13 AM, Dave Laansma wrote: Please elaborate. What exactly does Pete say. Sincerely, David Laansma Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Decker Sent: Monday, December 23, 2013 12:58 PM To: U2 Users List Subject: Re: [U2] Accuterm the Web version If Pete says it, I believe it. -BD On 12/23/2013 10:52 AM, Wjhonson wrote: We are using the Accuterm application to telnet into Universe 11 I've toyed with the idea of using the Accuterm browser version, does anyone here use that ? I just wonder what are the advantages or disadvantages of that. I know what Pete says, I want to hear from a customer though. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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
Re: [U2] Accuterm the Web version
Well, I use it every day. All of our clients on our old server use it. We have a simple connection script set up on our corporate web server (an AccuTerm connection script). We also have some code to download and install the latest AccuTerm version to the client should they need it. Once we got all of this working it has worked flawlessly since. HTH, Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 12/23/2013 11:51 AM *Subject:* Re: [U2] Accuterm the Web version My specific request is that I wish to hear from a person who is actually using, as their main way of connecting to the database, the WEB based version of Accuterm. Not just someone who tried it for a day or something. But rather a person who is using it day to day for their normal work. -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Dec 23, 2013 11:28 am Subject: Re: [U2] Accuterm the Web version Were you talking about the version of AccuTerm that runs through a web browser? If so it's a nice product but the user still has to download and install AccuTerm, which works fine over the internet. I can certainly echo the sentiments regarding the quality of AccuTerm products and their wonderful support. If you'd like more information, can you be more specific about what you're looking for. I think your request was a little too general. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 12/23/2013 11:07 AM *Subject:* Re: [U2] Accuterm the Web version No the original post was to see 1) if anyone is using this web version and 2) to get a testimonial FROM them. Period. That's all. Anything else you read into it, was not present. The purpose of customer testimonials is to get their own personal experience. That's for what I was looking. Solely. -Original Message- From: Bruce Decker bdec...@bluepinc.com To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Dec 23, 2013 10:36 am Subject: Re: [U2] Accuterm the Web version Okay: Let me try it this way. I've known and worked with Pete for over 25 years. In ALL of that time, I've found that the quality of his products are first rate, he does not exaggerate claims (which is what I thought the original post was suggesting) and if there was an issue (rare) he is very responsive and quick to resolve the issue. I believe if Pete tells you something, you can take it to the bank. I think this is helpful information especially for those who may not know Pete and wonder if they can rely on information he is providing. I should have spelled it out instead of being snarky. My apologies. -BD On 12/23/2013 11:22 AM, Wjhonson wrote: Bruce if you don't like this thread, you don't have to respond. Please let those of us who want to know these answers discuss it. -Original Message- From: Bruce Decker bdec...@bluepinc.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Dec 23, 2013 10:19 am Subject: Re: [U2] Accuterm the Web version Exactly what he means. -BD On 12/23/2013 11:13 AM, Dave Laansma wrote: Please elaborate. What exactly does Pete say. Sincerely, David Laansma Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce Decker Sent: Monday, December 23, 2013 12:58 PM To: U2 Users List Subject: Re: [U2] Accuterm the Web version If Pete says it, I believe it. -BD On 12/23/2013 10:52 AM, Wjhonson wrote: We are using the Accuterm application to telnet into Universe 11 I've toyed with the idea of using the Accuterm browser version, does anyone here use that ? I just wonder what are the advantages or disadvantages of that. I know what Pete says, I want to hear from a customer though. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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
Re: [U2] [UV] INPUTTRAP Statement
You can't trap the 'break' key, but you can prevent its usage. In UniData it is: ON.ABORT ...which is a very finicky task to accomplish in that the command doesn't permanently turn on or off anything, it simply executes a command on a program abort. For us, the command executes the ON.ABORT command again (for the next abort) the routes the user back to the main menu; a very abstract way to get the job done. HTH, Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 12/23/2013 11:56 AM *Subject:* Re: [U2] [UV] INPUTTRAP Statement I don't think you can use *any* of the chars that are pre-trapped like ctrl-c (Break) That is, chars that actually make the op-sys wake up and act in immediate mode If you are trying to *trap* the break so you can see when someone is trying to use it, there is another way, although the other way of which I'm thinking doesn't *prevent* its use, it just *records* its use. Maybe you could go into more detail about why you're trying to trap ctrl-c -Original Message- From: Perry Taylor perry.tay...@zirmed.com To: U2-Users List u2-users@listserver.u2ug.org Sent: Mon, Dec 23, 2013 11:41 am Subject: [U2] [UV] INPUTTRAP Statement Has anyone ever used the INPUTTRAP statement in UniVerse BASIC? I want to be able to trap a break (Ctrl-c) but I can't seem to get it to work with CHAR(3), or any other character for that matter. The UniVerse BASIC Commands documentation provides no examples on its use. Anybody done anything like this? Any sample code you're willing to share? Thanks. Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] INPUTTRAP Statement
Yea. It took me awhile to figure this out. ON.ABORT sets up a (VOC) entry to be run on a program abort; but only once! If you want it to happen again, which I wanted in our menu system (i.e. I didn't want people to press [Ctrl]+C to get to TCL out of our menu system), then my (VOC) item SORRY looks like: 001 PA 002 ON.ABORT SORRY 003 MENU ...where ON.ABORT SORRY is activated to occur upon the next program abort (which a break key is an abort) and MENU sends the user back to the main menu. When a user logs on I execute this command (and a UTD.OPTION 105 OFF to make sure ON.ABORT can't be executed from within BASIC) then route users to the main menu. Now, if anyone tries to break out of our menu system the abort management is activated again (awaiting an abort) and the user is routed to the main menu. This is convoluted, but it works. :-) Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 12/23/2013 1:13 PM *Subject:* Re: [U2] [UV] INPUTTRAP Statement Could you explain more why your On.Abort executes another On.Abort ? I didn't understand that part. -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Dec 23, 2013 1:06 pm Subject: Re: [U2] [UV] INPUTTRAP Statement You can't trap the 'break' key, but you can prevent its usage. In UniData it is: ON.ABORT ...which is a very finicky task to accomplish in that the command doesn't permanently turn on or off anything, it simply executes a command on a program abort. For us, the command executes the ON.ABORT command again (for the next abort) the routes the user back to the main menu; a very abstract way to get the job done. HTH, Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 12/23/2013 11:56 AM *Subject:* Re: [U2] [UV] INPUTTRAP Statement I don't think you can use *any* of the chars that are pre-trapped like ctrl-c (Break) That is, chars that actually make the op-sys wake up and act in immediate mode If you are trying to *trap* the break so you can see when someone is trying to use it, there is another way, although the other way of which I'm thinking doesn't *prevent* its use, it just *records* its use. Maybe you could go into more detail about why you're trying to trap ctrl-c -Original Message- From: Perry Taylor perry.tay...@zirmed.com To: U2-Users List u2-users@listserver.u2ug.org Sent: Mon, Dec 23, 2013 11:41 am Subject: [U2] [UV] INPUTTRAP Statement Has anyone ever used the INPUTTRAP statement in UniVerse BASIC? I want to be able to trap a break (Ctrl-c) but I can't seem to get it to work with CHAR(3), or any other character for that matter. The UniVerse BASIC Commands documentation provides no examples on its use. Anybody done anything like this? Any sample code you're willing to share? Thanks. Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] BASIC code - upper, lower, CamelCase, what say you?
Charles: I've always used the following: http://www.pickwiki.com/cgi-bin/wiki.pl?BFind ...to search everything on U2, including Windows directories. Considering Windows search capabilities really suck, this is very handy for our web stuff, programs, accounts, dictionaries, etc. I did this so many years ago the newer version may or may not have some enhancements or fixes. This way I couldn't care less about case. Now-a-days all of my UniData STATEMENTS are upper case while everything else is designed to be readable by anyone who speaks and writes human languages (in my case English). Bill - Original Message - *From:* stevenson.c...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 12/20/2013 1:07 PM *Subject:* Re: [U2] BASIC code - upper, lower, CamelCase, what say you? If you use mixed case, what search tools comparitors do you use when researching your program libraries? Particularly if you have programs written in different styles over the years. What formatting tools do you use? On 12/20/2013 10:01 PM, Bobby Worley wrote: 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
Another option, which I always have done, is to iconv dates in 15 Jan 2013 format. This always works regardless of which date method is selected. Don't know why yanks do things that irritate you. But then, most people do things that irritate someone. As Mark Brown always points out; the trouble with standards is everybody has one. This seems more of an issue than what yanks do. :-) Bill Untitled Page - Original Message - *From:* antli...@youngman.org.uk *To:* u2-users@listserver.u2ug.org *Date:* 12/16/2013 6:00 PM *Subject:* Re: [U2] [OT] Interview Questions On 17/12/2013 00:17, Wjhonson wrote: What is the last Thursday of the current month. Current Date minus Current Day of Month number plus 1 puts you on the first of the current month Or you could just Oconv d2/ and replace the middle number with 01 with Iconv that. Actually, I think that'll screw up pretty spectacularly! OCONV(@TODAY, D2) gives me 17/12/13. If I replace the middle number (or if Kevin replaced the middle number) we'd both end up somewhere in January! Why do you Yanks put the least significant number in the middle? That's crazy! If you want the first of the month, the easiest way to do it is FIRST = 01/:OCONV(@TODAY,D2[M,Y]) (if I've remembered my syntax correctly). Then to get that into internal format I_FIRST = ICONV(FIRST, D2DMY) You should NEVER assume that dates are in the format you expect, unless you are in control (which you aren't, here, seeing as you've messed up pretty spectacularly :-) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
Of course, one normally puts dates together like that because left justification works, and we all know how we're always limited by someone elses standards. :-) Bill - Original Message - *From:* james.mcgo...@bankofthewest.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 12/16/2013 6:22 PM *Subject:* Re: [U2] [OT] Interview Questions There's an xkcd for everthing: http://xkcd.com/1179/ -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, December 16, 2013 6:13 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions Another option, which I always have done, is to iconv dates in 15 Jan 2013 format. This always works regardless of which date method is selected. Don't know why yanks do things that irritate you. But then, most people do things that irritate someone. As Mark Brown always points out; the trouble with standards is everybody has one. This seems more of an issue than what yanks do. :-) Bill Untitled Page - Original Message - *From:* antli...@youngman.org.uk *To:* u2-users@listserver.u2ug.org *Date:* 12/16/2013 6:00 PM *Subject:* Re: [U2] [OT] Interview Questions On 17/12/2013 00:17, Wjhonson wrote: What is the last Thursday of the current month. Current Date minus Current Day of Month number plus 1 puts you on the first of the current month Or you could just Oconv d2/ and replace the middle number with 01 with Iconv that. Actually, I think that'll screw up pretty spectacularly! OCONV(@TODAY, D2) gives me 17/12/13. If I replace the middle number (or if Kevin replaced the middle number) we'd both end up somewhere in January! Why do you Yanks put the least significant number in the middle? That's crazy! If you want the first of the month, the easiest way to do it is FIRST = 01/:OCONV(@TODAY,D2[M,Y]) (if I've remembered my syntax correctly). Then to get that into internal format I_FIRST = ICONV(FIRST, D2DMY) You should NEVER assume that dates are in the format you expect, unless you are in control (which you aren't, here, seeing as you've messed up pretty spectacularly :-) 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 - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata error for the ages, so to speak.
Doug: This is a UniData anomaly. You can't reference fields like @RECORD3, you have to refer to them like EXTRACT(@RECORD,3,0,0). HTH, Bill Untitled Page - Original Message - *From:* dave...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 12/5/2013 1:44 PM *Subject:* [U2] Unidata error for the ages, so to speak. I was playing with EVAL trying to see why it would work in Universe and not in Unidata. I typed in this sentence in Unidata 7.3.6: list CRM.CUSTOMERS WITH EVAL UPCASE(@RECORD15) LIKE BILL... UPCASE(@RECORD15) -^ Virtual Attribute Error: qz1zq syntax error So what is qz1zq syntax error? Who would of thought this would help a seasoned professional like myself figure our my syntax error. I guess I really don't understand this database after many many years... The correct syntax was : list CRM.CUSTOMERS WITH EVAL UPCASE(CONTACT.NAME) LIKE 'BILL...' Regards, Doug www.u2logic.com Web applications with real error messages ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Running Account wide I-DESC
Doesn't UV have a DICT.DICT ? In UD you can create truly global dictionaries by placing them in DICT.DICT. Bill - Original Message - *From:* dia...@aptron.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 12/6/2013 6:13 AM *Subject:* Re: [U2] Running Account wide I-DESC Depending on the complexity of the I-type, you can sometimes accomplish the same thing with an S-type, which is not compiled. So we use that sometimes for global type dictionary items like that. So for example we put an item COUNTER in the VOC which we can use on any file: COUNTER 0001 S 0002 0 0003 0004 0005 0006 0007 0008 A;1 0009 R 0010 5 -Dianne On 12/5/2013 3:44 PM, George Gallen wrote: Not sure if this helps anyone... There is an I DESC that we usually put in the DICT of most files. Usually, when you go to use it, it hadn't been entered, while not difficult to enter - just a pain. I tried to put the IDESC in VOC, but I wasn't able to compile it I was able to put it in the VOC of VOC - which compiled - but wasn't usable globally. SoIn order to get an IDESC to be used globally (at least globally within that account). You must... 1. Enter the IDESC into the VOC of VOC 2. Compile the IDESC 3. COPY from the VOC VOC to VOC Now it's usable on any file without having to add it Funny, if you want to add a D type DICT , you only need to put it in VOC, But , with I DESC, the problem is compiling it - you can only compile in the VOC of VOC Then you have to copy it into VOC for it to be usable. Like I said...If it helps...great, If not - move on. George 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
Re: [U2] List of display control @ variables for UVBasic
In the UD BASIC manual, this information is under the @ item in the table of contents. Bill - Original Message - *From:* jscha...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 11/20/2013 9:20 AM *Subject:* Re: [U2] List of display control @ variables for UVBasic Not really. It has the named @ variables like @userno, @ selected, @vm, etc but the terminal control codes @(-1), @(-2), @(-3), etc are not there. At least not in my (admittedly old, 10.2) version. HELP BASIC @ worked for me. Thanks all. Gregor Scott wrote: The UniVerse BASIC Commands Reference documents it (look for @ function in the TOC) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, 20 November 2013 8:54 AM To: U2-Users@listserver.u2ug.org Subject: [U2] List of display control @ variables for UVBasic Anyone know where the list of @ variables for display control ( @(-1) = clear screen) is in the Universe documentation? I can't seem to find it. Thanks -- 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 -- 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/1IpKwm7RGU/5YCbcDsMLoLdzSG18nYGvY/0.204 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 PE 7.1.0 - Use of EXECUTE with the RTNLIST option
Bruce: Thanks. This always gets me so I never use the RTNLIST. :-) Bill Untitled Page - Original Message - *From:* bdec...@bluepinc.com *To:* u2-users@listserver.u2ug.org *Date:* 11/20/2013 3:56 PM *Subject:* Re: [U2] UD PE 7.1.0 - Use of EXECUTE with the RTNLIST option This is a reply to a old post but since this is the top search result for RTNLIST, I'll post a reply with useful info. Unidata's BASIC compiler seems to be quite particular about the ORDER of the clauses on an Execute. Put RTNLIST, RETURNING AND CAPTURING in the wrong order and you'll see a error like this: Compiling Unibasic: mysource\test4 in mode 'p'. main program: syntax error at or before line 7 EXECUTE \SELECT VOC\ RETURNING junk RTNLIST l.voc CAPTURING screen; --^ Misuse of reserved word 'RTNLIST' Expecting: end-of-file,END compilation failed Here is the code with examples of proper order of the clauses on an execute and the final example of EXECUTE producing the failure message above... done = @FALSE l.voc = \\ i = 0 * EXECUTE \SELECT VOC\ RTNLIST l.voc ; *compiles ok EXECUTE \SELECT VOC\ RTNLIST l.voc RETURNING junk ; *compiles ok EXECUTE \SELECT VOC\ RTNLIST l.voc RETURNING junk CAPTURING screen ; *compiles ok EXECUTE \SELECT VOC\ RETURNING junk RTNLIST l.voc CAPTURING screen ; *fails compile * LOOP READNEXT id FROM l.voc ELSE done = @TRUE UNTIL done DO i=+ 1 REPEAT CRT i:\ records counted\ STOP ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple question - selecting and listing records
Brandon: Is this UV or UD? There's a bit of a difference setting up the query language to use the WHEN clause within these two different U2 dbms products. The task of setting up the query is to set up fields as multi-value first, then associating multi-valued field definitions into a group. Bill Untitled Page - Original Message - *From:* brandon.h...@iqor.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 11/19/2013 10:31 AM *Subject:* Re: [U2] Simple question - selecting and listing records You may be right :) I do no programming with this system, I'm just an end user that's trying to understand better. Field. Type Field Conversion.. Column. Output Depth Name.. Field. Definition... Code Heading Format Assoc.. Number @IDD0CREDITCARD.FILE 10L S PACKET D2PACKET 8R M STATUS D 10STATUS 15L M TRACKING.IDD9TRACKING ID 20L M PMT.DATE D7 D4/ PMT DATE10R M As far as WHEN clause, I tried: list creditcard.file packet status tracking.id pmt.date when pmt.date eq 11/19/2013 and it sorts those dates to be the first results, but it still lists all the other card entries on that packet before moving to the next record. Is this just a consequence of how the creditcard.file is set up? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, November 19, 2013 12:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Simple question - selecting and listing records Could you post the exact statement you're using with the WHEN clause, a and also the contents of the DICT items? I suspect one or more of them is not actually setup as a multivalued field -Original Message- From: Hilk, Brandon brandon.h...@iqor.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Nov 19, 2013 8:29 am Subject: [U2] Simple question - selecting and listing records Hello, I have a quick question regarding listing multivalued fields. I hope the formatting is retained on this email so my example doesn't get confusing. This file is structured for multiple credit card entries under one @id. How can I alter my LIST command to only show the entries for the date specified? I tried using when in both the LIST and SELECT statements but didn't get the results I was looking for. I feel like I'm missing something really basic. Thanks in advance. }SELECT CREDITCARD.FILE WITH PMT.DATE EQ 11/19/2013 303 record(s) selected to SELECT list #0. }}LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE CREDITCARD.FILE PACKET.. STATUS. TRACKING ID. PMT DATE.. 5215216252152162 APPROVED25D6TGCD 11/19/2013 52152162 12/31/2013 52152162 01/31/2014 52152162 02/28/2014 52152162 03/31/2014 52152162 04/30/2014 52152162 05/30/2014 52152162 06/30/2014 52152162 07/31/2014 52152162 08/29/2014 52152162 09/30/2014 52152162 10/31/2014 5643649556436495 APPROVED259l17j2 02/18/2013 56436495 APPROVED25a0hfg7 03/18/2013 56436495 APPROVED25adf4bt 04/18/2013 56436495 APPROVED25ar1ofv 05/20/2013 56436495 APPROVED25b7a92o 06/18/2013 56436495 APPROVED25bk0tpv 07/18/2013 56436495 APPROVED25c11rl1 08/19/2013 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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
Re: [U2] moving UV from one server to another (windows)
George: David is correct that you should use Windows server to run U2 products for a business environment. However, there is a role for running everything on a single Windows 7 machine for demos, proof-of-concepts, development, etc. There is no need to worry about Windows reboots for a non-24/7 environment, and what you've discussed so far would not lead anyone to think you need 24/7 uptime. So, Windows is perfectly acceptable and, IMHO of course, even more acceptable than a 'nix' environment for this kind of low-use configuration. Just a thought... Bill Untitled Page - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 11/19/2013 6:22 AM *Subject:* Re: [U2] moving UV from one server to another (windows) Yes, but they will be running windows - which NEVER needs to be reboot unless it's Something really serious! George -Original Message- From:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Monday, November 18, 2013 7:19 PM To: U2 Users List Subject: Re: [U2] moving UV from one server to another (windows) Hi Bob, Post migration, one thing for consideration might be user education regarding the new use of their workstation/PC? No more will the user just be able to re-boot it when it freezes etc or shut it down each night at home-o'clock. Cheers Peter On 19/11/13 05:55, Woodward, Bob wrote: Oh, I'd always say go for more memory. Especially if there are other Windows apps that are going to be used on that computer. As to the locking, the normal record locks inside of UV once it's moved. Just do a simple edit of a record on the workstation, then from another workstation, edit the same record. If there is a problem, the workstation hosting UV is probably not locking the records. When I saw the problem, it was because the workstation was accessing UV through the C: drive, which was local, of course. To fix it, you have to map a network drive and ONLY use the network drive on that workstation. The idea was that local drives didn't NEED to be locked since it's a single user OS. At least that's the way it was explained to me. Come to think of it, Win7 may not even maintain a network locking table. Remember, I said I did this on a PE version where I was pretty much the only user. BobW -Original Message- From:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, November 18, 2013 11:38 AM To: U2 Users List Subject: Re: [U2] moving UV from one server to another (windows) Locking issues once UV is running on the Windows 7 machine, or locking issues caused by Copying over the data and overwriting the fresh install? This won't be a heavily used system (3 or 4 users maximum and even then should be too taxing). Should they max out the memory on the PC it's going to be installed on? Or is 4gb fine? George -Original Message- From:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, November 18, 2013 2:28 PM To: U2 Users List Subject: Re: [U2] moving UV from one server to another (windows) One of the things you may need to watch real careful would be locking. Especially on the workstation that is hosting UV. Then, as long as all the drive letters are the same as on the server, everything should be okay. Of course, YMMV but I've done this type of swapping on my home network with the personal edition a number of years ago. -Original Message- From:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, November 18, 2013 11:04 AM To: U2 Users Subject: [U2] moving UV from one server to another (windows) 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 administratorggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/
Re: [U2] UV Basic parsing xml with XDOM commands
Now that is quite a dance! [whew...] Bill Untitled Page - Original Message - *From:* peter.che...@firstmac.com.au *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 11/5/2013 6:00 PM *Subject:* [U2] UV Basic parsing xml with XDOM commands Hi Everyone, Thought I'd post a solution to a task I've been working on in the hope it will assist someone else with similar requirements. Thanks also to those who've previously posted on this as I found the following to be most helpful as well: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg18895.html https://gdoesu2.wordpress.com/tag/xdomlocate/ http://listserver.u2ug.org/pipermail/u2-users/2010-September/004713.html http://www.mvdeveloper.com/kb/docs/kb10.pdf I had to parse some xml returned via a soap request to an IIS server: ?xml version=1.0? s:Envelope xmlns:s=http://schemas.xmlsoap.org/soap/envelope/; s:Body SuggestResponse xmlns=http://tempuri.org/; SuggestResult xmlns:a=http://schemas.datacontract.org/2004/07/FirstMac.Services.Category.Contracts; xmlns:i=http://www.w3.org/2001/XMLSchema-instance; a:CategoryGroupSome group data/a:CategoryGroup a:CategoryNameSome name data/a:CategoryName /SuggestResult /SuggestResponse /s:Body /s:Envelope There are only ever 2 value nodes returned if the soap query is successful with the SuggestResult node containing 'i:nil=true' if the query is not successful. e.g. SuggestResult i:nil=true ... / The xml contains a default namespace and after much searching and trial and error I discovered I needed to use the following xpathString and nsMAP parameters in the XDOMLocate function: Notes re the XDOMLocate function. I found the UV11.1 Basic Commands Reference and Basic Extensions documents for XDOMLocate to be scarce on detail for the following: * Each additional namespace in the string must also be space delimited. * The double quotes enclosing the http url must be removed for each namespace defined in the nsMAP parameter. The description given has double quotes in the wrong places. e.g. if you have s:Envelope xmlns:s=http://schemas.xmlsoap.org/soap/envelope/; then the namespace you need to specify is nsMAP = 'xmlns:s=http://schemas.xmlsoap.org/soap/envelope/' code xpathStr = '/s:Envelope/s:Body' nsMAP = 'xmlns:s=http://schemas.xmlsoap.org/soap/envelope/ ' nsMAP := 'xmlns:a=http://schemas.datacontract.org/2004/07/FirstMac.Services.Category.Contracts ' nsMAP := 'xmlns=http://tempuri.org/ ' nsMAP := 'xmlns:i=http://www.w3.org/2001/XMLSchema-instance' OK = XDOMOpen( RespData, XML.FROM.STRING, hDOM ) if OK = XML.SUCCESS then crt 'XML document opened' OK = XDOMLocate( hDOM, xpathStr, nsMAP, hRoot ) if OK = XML.SUCCESS then crt 'Found ':xpathStr OK = XDOMGetNodeName( hRoot, NodeName ) crt 'Root node=':NodeName OK = XDOMLocateNode( hRoot, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.ELEMENT.NODE, hParent ) if OK = XML.SUCCESS then OK = XDOMGetNodeName( hParent, NodeName ) crt 'Parent node = ':NodeName ;* 'SuggestResponse' OK = XDOMLocateNode( hParent, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.ELEMENT.NODE, hChild ) if OK = XML.SUCCESS then OK = XDOMGetNodeName( hChild, NodeName ) crt 'Child node = ':NodeName ;* 'SuggestResult' OK = XDOMLocateNode( hChild, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.ELEMENT.NODE, hValueNode ) if OK = XML.SUCCESS then OK = XDOMGetNodeName( hValueNode, NodeName ) crt 'Value node1 = ':NodeName ;* 'a:CategoryGroup' OK = XDOMLocateNode(hValueNode, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.TEXT.NODE, hTextNode ) if OK = XML.SUCCESS then OK = XDOMGetNodeValue(hTextNode, Value ) crt 'Payload1 = ':Value ;* 'Some group data' end else gosub ShowError end end OK = XDOMLocateNode( hChild, XDOM.CHILD, 2, XDOM.ELEMENT.NODE, hValueNode ) if OK = XML.SUCCESS then OK = XDOMGetNodeName( hValueNode, NodeName ) crt 'Value node2 = ':NodeName ;* 'a:CategoryName' OK = XDOMLocateNode(hValueNode, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.TEXT.NODE, hTextNode ) if OK = XML.SUCCESS then OK = XDOMGetNodeValue(hTextNode, Value ) crt 'Payload2 = ':Value ;* 'Some name data' end else gosub ShowError end end else gosub ShowError end end else gosub ShowError end end else gosub ShowError end
Re: [U2] [OT] Support Ticket Software
Charlie: Welcome to the new world of technology. sigh... Bill - Original Message - *From:* cwn...@comcast.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/24/2013 6:49 AM *Subject:* Re: [U2] [OT] Support Ticket Software Thanks for the link, Larry. It appears that's the right company. Their sales people couldn't answer my question and referred me to tech support. After going through their telephone hell I sat on hold about 45 minutes and gave up. From their forums it appears that the originator of a ticket can be given permissions to view or edit tickets, but doesn't have to be. I don't know if I can persuade BC to do it, though. Charlie On 10-23-2013 12:19 PM, Larry Hiscock wrote: http://www.salesforce.com/remedyforce/features/ Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Wednesday, October 23, 2013 8:47 AM To: U2 Users List Subject: Re: [U2] [OT] Support Ticket Software Hi Symeon, I had looked at salesforce and it wasn't really intuitive that they had a support ticket system. I think they are the one, though. The reason I was curious is that BigCommerce said that under the new system they sprung on us unannounced over the weekend, we could enter support tickets, but not look up or view tickets we'd submitted. I thought that was rather strange. I've never used a system before where I couldn't view my tickets. The old system they used allowed viewing of tickets, and responding either via email or online. It's just one more capability BC has taken away - and to think I moved away from Intuit for doing that very same thing... Thanks, Charlie On 10-23-2013 2:14 AM, Symeon Breen wrote: The secure server at force.com , e.g. secure.force.com ? which would be salesforce - and they do have ticketing software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: 23 October 2013 03:55 To: U2 Users List Subject: [U2] [OT] Support Ticket Software My online store platform has switched to a new support ticket system called secure.force, but I can't find any info on the company that markets it, and of course, my provider won't tell me anything about it. Has anyone seen or know anything about it? Thanks, Charlie Tiny Bear Wild Bird Store Home of Safety Net Shipping http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] [OT] Interview Questions
Kevin: After actually hiring a lot of people, and firing those that needed it, I've come to the conclusion that all employers need a person with the following three attributes: 1) An ability, and willingness, to be on-time, 2) An ability, and willingness, to be presentable in all business situations, and 3) An ability, and willingness, to learn what they don't know (which is always a lot!). The people coming out of college these days are mostly unemployable. Today's bachelors degree is like a 1930 8th grade education, or a 1970 high school education. So, no matter what any Human Services dweeb says, getting someone to show up looking presentable and willing to work whatever it takes to learn what they don't know is gold! These kinds of people are quite trainable and, considering all software frameworks have a short shelf life anyway, offer a lot of flexibility for your purposes. Just a thought. :-) Bill - Original Message - *From:* ke...@precisonline.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/11/2013 9:56 AM *Subject:* Re: [U2] [OT] Interview Questions Unfortunately, in one case I hired a friend. Needless to say, it was one of the worst decisions I've made. Not only lost a friend, but lost a lot of customer confidence by her attitude, poor workmanship, and unwillingness to adapt. On Thu, Oct 10, 2013 at 7:01 AM, Robert Frailey rfrai...@utahmed.comwrote: Wow, seen a lot of that and managers trying to get friends hired to create a perfect office society. quit hiring backstabbing chaff with their own agendas. Robert - Original Message - From: Kevin King ke...@precisonline.com To: Susan Joslyn sjos...@sjplus.com; U2 Users List u2-users@listserver.u2ug.org Sent: Wednesday, October 09, 2013 8:07 PM Subject: Re: [U2] [OT] Interview Questions Susan, yes. I've been very open in my interviews, and it's netted significantly regrettable results. So this time I'm going for people who can get behind and contribute to the common cause as soon after hire as possible. I don't have any aspirations of hiring for life, though I certainly do endeavor to have that kind of an environment for a person who wants that sort of thing. I just need to quit hiring backstabbing chaff with their own agendas. On Tue, Oct 8, 2013 at 1:54 PM, Susan Joslyn sjos...@sjplus.com wrote: 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-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org[ mailto:u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org mailto:u2-users-bounces@**listserver.u2ug.orgu2-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-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://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] [OT] Interview Questions
Kevin: And that's the crux of the interview process. If you hire people with all the skills you want, and they don't go somewhere else, why would you think people you train will go somewhere else? Or think of this conversely. My thought is people go somewhere else for a reason. Nip that reason in the bud, so to speak, and you won't have that problem, or at least you can focus your attention on other problems. :-) Bill Untitled Page - Original Message - *From:* ke...@precisonline.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/11/2013 1:15 PM *Subject:* Re: [U2] [OT] Interview Questions I also agree. I'm willing to train, but what I've found is that someone that is willing to learn doesn't necessarily mean they're able to learn or willing to do what they've learned. What happened here was that a group of folks with little experience got a lot of good training and then took the training elsewhere, so I'd rather not start from scratch if at all possible. We need folks to be able to contribute quickly, so I don't have the time nor desire to give someone their first programming job knowing that I'm only giving them wings to fly. And yeah, I'm still a little bitter. I'll get over it. :-) On Fri, Oct 11, 2013 at 1:33 PM, Robert Frailey rfrai...@utahmed.comwrote: I totally agree with Brenda and Bill. Work sent Brooke and I to Epicor's Unidata and Pick classes in California, I only had Novell and Microsoft when I was hired. I picked up Unix, Unidata, redback and DBMS from classes provided by work. 19 years later, Brooke and I are self sufficient. We show up on time and put in whatever necessary to complete our tasks. We learn everything in sight. We would be hard pressed if one or both of us got hit by a bus. I'm expected to be 24 hours a day / seven days a week and Brooke fills in when I can't. I run into very few people with our work ethic anymore. Robert - Original Message - From: Brenda Ives bren...@marketamerica.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Friday, October 11, 2013 1:18 PM Subject: Re: [U2] [OT] Interview Questions How about the other end here? By other end, I mean this. What about someone in college or out of college with a degree other than an IT subject or if with an IT degree or working on one, who has been taught by someone with over 20 years of experience outside of college but the student/graduate has no employment history of what has been taught them outside of college. Plus they meet all 3 of your requirements listed below? UniVerse/UniData/D3/JBASE/**CACHE is not taught in colleges and if we don't teach them what happens when all of us oldies are gone? Brenda -Original Message- From: u2-users-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org[mailto: u2-users-bounces@**listserver.u2ug.orgu2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Friday, October 11, 2013 2:41 PM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions Kevin: After actually hiring a lot of people, and firing those that needed it, I've come to the conclusion that all employers need a person with the following three attributes: 1) An ability, and willingness, to be on-time, 2) An ability, and willingness, to be presentable in all business situations, and 3) An ability, and willingness, to learn what they don't know (which is always a lot!). The people coming out of college these days are mostly unemployable. Today's bachelors degree is like a 1930 8th grade education, or a 1970 high school education. So, no matter what any Human Services dweeb says, getting someone to show up looking presentable and willing to work whatever it takes to learn what they don't know is gold! These kinds of people are quite trainable and, considering all software frameworks have a short shelf life anyway, offer a lot of flexibility for your purposes. Just a thought. :-) Bill --**--** - Original Message - *From:* ke...@precisonline.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/11/2013 9:56 AM *Subject:* Re: [U2] [OT] Interview Questions [...snipped...] On Thu, Oct 10, 2013 at 7:01 AM, Robert Frailey rfrai...@utahmed.com [...snipped...] Robert - Original Message - From: Kevin King ke...@precisonline.com To: Susan Joslyn sjos...@sjplus.com; U2 Users List u2-users@listserver.u2ug.org Sent: Wednesday, October 09, 2013 8:07 PM Subject: Re: [U2] [OT] Interview Questions Susan, yes. I've been very open in my interviews, and it's netted significantly regrettable results. So this time I'm going for people who can get behind and contribute to the common cause as soon after hire as possible. I don't have any aspirations of hiring for life, though I certainly do endeavor to have that kind of an environment
[U2] Fwd: Re: Select from one file with save-list from another file
Tony:
I use a simple program, inspired by a U2 tech note at
https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select,
that does the following:
LSELECT ARTVIOLATION WITH UNITID IN DEFAULT.LIST.NAME
The list is simply generated then used in the statement. So, I can
create a select list of unit#s from anywhere and name it
DEFAULT.LIST.NAME. Then can search the ARTVIOLATION file items whose
unit ID is anywhere in the select list.
[...added comments...]
This becomes required when one does something like:
SELECT SOMEFILE 'a''b''c'...'{n}'
...and the number of items to select exceed 256 (UD barfs on this).
Now, I just change the code to do a select first, like:
SELECT SOMEFILE 'a''b''c'...'{n}'
SAVE.LIST MY.LIST
LSELECT ANOTHERFILE WITH KEY IN MY.LIST
This turned out to be a simple solution when web'izing our application,
knowing users will be selecting keys (not values) to submit to a select
statement that does something (lots of things, actually). :-)
Bill
Untitled Page
- Original Message -
*From:* 3xk547...@sneakemail.com
*To:* u2-users@listserver.u2ug.org
*Date:* 8/28/2013 5:18 AM
*Subject:* Re: [U2] Select from one file with save-list from another file
Not sure where to toss this into this thread so I'll start at the
beginning. I wanted to see the solutions that would be offered. I
blogged on exactly this topic back in 2008. The solution I published
for D3 uses @environment variables to allow us to do inner queries
with a tiny bit of simple and reusable code, no dict items, no work
files, and no save-lists. Perhaps someone can describe the
UD/UV-specific equivalents so that we can accomplish this here using
similar methods? I'll be happy to add the U2 solution to the blog for
future reference.
http://Nebula-RnD.com/blog/tech/mv/2008/03/d3shell1.html
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
http://Nebula-RnD.com/blog
http://LinkedIn.com/in/TonyGravagno
http://Twitter.com/TonyGravagno
http://PickWiki.com
http://groups.google.com/group/MVDBMS
http://www.LinkedIn.com/groups/Pick-Users-Group-64935
http://BitBucket.org/FOSS4MV/
From: Hilk, Brandon
UniVerse 10.1, HP/UX, Pick.
Is there a way I can build a save-list from a selection from onefile
X.INFO (where the record ID is an 8 digit number) and use that listto
select from file Y.INFO (where that 8 digit number is not the recordID
but does exist as a foreign key elsewhere in the file). In SQLthis
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 butcan't build
a save-list from it because I don't know the UniVerse/SQL syntax todoso.
So to summarize, is there a way to use a save-list built from X.INFOto
make another save-list comprised of the record ID's from Y.INFO?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] ED PERMISSIONS subroutine
Diane: I use UniData and always put my accounts underneath a level separate from @UDTHOME (in E:\UDAccounts). I've never had this kind of problem, but have had DNS issues. I wouldn't even contemplate putting anything under C: so have no idea what can happen there. :-( Bill - Original Message - *From:* dia...@aptron.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 8/20/2013 1:29 PM *Subject:* Re: [U2] [UV] ED PERMISSIONS subroutine c:\level contains about 10 universe accounts. All are local directories, none are remote. -Dianne On 8/20/2013 4:24 PM, Aaron Titus wrote: Hi Diane, a couple of questions. How many other directories exist within c:\level ? Is C:\ACCOUNT a local directory and c:\level remote? *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, Aug 20, 2013 at 2:00 PM, Dianne Ackerman dia...@aptron.com wrote: OK, I've found the PERMISSIONS subroutine (APP.PROGS PERMS.B) and have narrowed this issue down more. It's actually a slowness in the basic command STATUS. It's instantaneous in an upper level account (eg C:\ACCOUNT) but takes 4-5 seconds in a lower level account (eg C:\level\ACCOUNT). Any thoughts? Thanks -Dianne On 8/15/2013 9:50 AM, Dianne Ackerman wrote: Does anyone know anything about the -PERMISSIONS subroutine used by the ED verb in Universe? Running 11.1.12 on Windows, the ED verb has a huge delay and we've tracked it down to that subroutine call in the basic ED program. If I could look at that subroutine to see what it's doing, maybe I can figure out what's causing that delay. Thanks! -Dianne ED BP ED.B The file BP is read-only and cannot be updated. 3988 lines long. : L PERMISSIONS 0153: PERMISSIONS = '-PERMISSIONS' : L 0308: CALL @PERMISSIONS(EDIT.FILE,EDIT.**PERM.MODE,EDIT.PERM.IN,EDIT .PERM.OUT) : EX __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] @RECORD VARIABLES
Isn't this pretty much the same thing as ITYPE(), except the conversions
are processed?
In the CALCULATE() form, the dictionary.item can be a quoted string
or a UniBasic variable. The expression uses the data from the current
@RECORD during the evaluation process.
In the {} form, the dictionary.item must be the literal dictionary
name with no quotation marks.
You must open a dictionary to @DICT and read the data record into
@RECORD for the function to work properly.
If these functions are successful, they update the values in @CONV,
@FORMAT, and @HEADER. You can then use these @ variables in other
UniBasic functions, such as ICONV, OCONV, and FMT. For more information
about @ variables, see Appendix B, UniBasic@variables.
-
The UniBasic ITYPE function enables a UniBasic program to execute
a UniData virtual attribute from the dictionary of a UniData file.
The value of the function is the same as if it were run using UniQuery
or UniData SQL.
Note: ITYPE generally requires you to open both the dictionary and
data portions of the file. Before you use this function, you must
compile the dictionary of the file by using the ECL COMPILE.DICT
or CD command.
In most cases, you also must assign the @ID and @RECORD variables.
These variables resolve the value of the ITYPE function. However,
if neither the ID of the file nor the data from the record is used
in the ITYPE, you do not need to assign these variables.
Note: Conversion or formatting codes in the dictionary record of
the virtual attribute does not affect the value ITYPE returns.
Bill
Untitled Page
- Original Message -
*From:* p...@gnosys.co.nz
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/15/2013 2:10 PM
*Subject:* Re: [U2] @RECORD VARIABLES
Is that only a Unidata thing? Sounds like a nice feature to have in
Universe.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Friday, 16 August 2013 9:06 a.m.
To: U2 Users List
Cc: u2-users-boun...@listserver.u2ug.org
Subject: Re: [U2] @RECORD VARIABLES
Of course. Worked like a charm.
Thank you Dave.
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
From: Dave Davis dda...@harriscomputer.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date: 08/15/2013 03:41 PM
Subject:Re: [U2] @RECORD VARIABLES
Sent by:u2-users-boun...@listserver.u2ug.org
HELP CALCULATE
You have to have your dictionary open to @DICT as well.
I think you want to say
RESULT = CALCULATE(ATTRIBUTE)
Since {} is for a literal attribute name only.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Thursday, August 15, 2013 4:35 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] @RECORD VARIABLES
I am attempting to pass a variable into a SUBROUTINE and use it to access the
data through the dictionary name.
SUBROUTINE fieldLookup(., ATTRIBUTE, ) .
.
.
READ @RECORD FROM F.FILE, @ID THEN
RESULT = {ATTRIBUTE}
END ELSE
RESULT =
END
The part that isn't working is the RESULT = {ATTRIBUTE}
As written here it is looking for a dictionary attribute named ATTRIBUTE.
I tried forcing it to evaluate the variable ATTRIBUTE to the value in ATTRIBUTE
by putting it in parenthesis, but it complained that it was expecting a
variable when it was compiling.
Is there a way to use a variable in the curly braces so that I can make this a
generic subroutine?
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Dave Davis
Team Lead, Research Development
P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg
]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]
http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com
This message is intended exclusively for the individual or entity to which it
is addressed. This communication may contain information that is proprietary,
privileged or confidential or otherwise legally exempt from disclosure. If you
are not the named addressee, you are not authorized to read, print, retain,
copy or disseminate this message or any part of it.
If you have received this message in error, please notify the sender
immediately by e-mail and delete all copies of the message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
This email was Virus
Re: [U2] OPENSEQ
Al:
UniData help shows...
Help Information For: UNIBASIC OPENSEQ
Page: 1/5
OPENSEQ
Syntax
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[ON ERROR statements] [LOCKED statements] {THEN statements [END]
| ELSE statements [END]}
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[LOCKED statements] [ON ERROR statements] {THEN statements [END]
| ELSE statements [END]}
Description
The UniBasic OPENSEQ command opens a sequential file for access,
starting at the specified record. UniData limits to 150 the number
of sequential files you can open in a UniBasic program.
It would seem your path uses the seq.filename, record.id format
instead of the absolute path format. e.g.
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances\:FNAME TO
OUT.FILE ELSE
HTH (and fixes it).
Bill
Untitled Page
- Original Message -
*From:* adew...@stylmark.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/5/2013 7:17 AM
*Subject:* Re: [U2] OPENSEQ
I'm a Domain Admin so permissions is not an issue. I'm going back to the
beginning and start over. Maybe I have an issue I'm not seeing.
Thanks for all your help.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com
Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook
-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, August 05, 2013 9:10 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ
Does the code still fail with the dummy file out there? If not, I'd guess
permissions.
From: Al DeWitt adew...@stylmark.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date: 08/05/2013 09:04 AM
Subject:Re: [U2] OPENSEQ
Sent by:u2-users-boun...@listserver.u2ug.org
Thanks for your reply Kevin.
I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it.
FNAME does not exist. In the code I stole this from the name is created
anew each time. It always open the file empty, allows me to populate
and close it. However, in this code it's not working.
Since we're running SB+/SBClient I thought the '.XLS' extension was
causing issues (grasping at straws) but I'm getting the same errors.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com
Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook
-Original Message-
From: Kevin King [mailto:ke...@precisonline.com]
Sent: Monday, August 05, 2013 8:31 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ
I've never used OPENSEQ on a remote drive like that. I presume you can
LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the
OPENSEQ should work with that just fine. May I also presume that you
looed at FNAME and a file with that name really does exist in that
directory file?
On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote:
Please educate me on OPENSEQ. I have some code that is giving me an
error. The funny thing is that I stole the code from a working program:
The code:
064: FNAME = 'LLV':FNAME:'.XLS'
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO
OUT.FILE ELSE
066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE
067: ERRCD = STATUS()
068: GOSUB 900
069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.')
070: GO
071: END
If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66
ERRCD = 0. According to manual 2 means: The file does not exist. A 0
means The record does not exist.
In my voc file I have an entry for LRGLBRVARS. It looks like this:
Top of LRGLBRVARS in VOC, 3 lines, 48 characters.
001: DIR
002: \\led\fs-styl\Public\LrgLbrVariances
003: D_HOLD_
Bottom.
What is OPENSEQ looking for and where does it expect it to find it?
Thanks.
Albert DeWitt, CPIM
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
Remember, if you're using Windows 2008 (Vista Server) or later (I use
2008 R2 - Windows 7 Server) then you have to be careful about how you
share the network directory you want to share.
For testing purposes, if you're using Windows, it may be a good idea to
share the directory to everyone, with full permissions.
Bill
Untitled Page
- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 8/5/2013 10:16 AM
*Subject:* Re: [U2] OPENSEQ
*Falls out of my chair*
What ? What ?
I never knew you could DO this!
After some fiddling about I finally was able to make OPENSEQ open an UNC path.
Of course the one I tried, actually points to the exact same server and account
the code is already running in, but I didn't even know you could OPEN an UNC
path at all before! I've been translating the UNC paths into DOS paths.
Now to try to open remote UNC path
-Original Message-
From: Bill Haskett wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Aug 5, 2013 10:05 am
Subject: Re: [U2] OPENSEQ
Al:
UniData help shows...
Help Information For: UNIBASIC OPENSEQ
Page: 1/5
OPENSEQ
Syntax
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[ON ERROR statements] [LOCKED statements] {THEN statements [END]
| ELSE statements [END]}
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[LOCKED statements] [ON ERROR statements] {THEN statements [END]
| ELSE statements [END]}
Description
The UniBasic OPENSEQ command opens a sequential file for access,
starting at the specified record. UniData limits to 150 the number
of sequential files you can open in a UniBasic program.
It would seem your path uses the seq.filename, record.id format
instead of the absolute path format. e.g.
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances\:FNAME TO
OUT.FILE ELSE
HTH (and fixes it).
Bill
Untitled Page
- Original Message -
*From:* adew...@stylmark.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/5/2013 7:17 AM
*Subject:* Re: [U2] OPENSEQ
I'm a Domain Admin so permissions is not an issue. I'm going back to the
beginning and start over. Maybe I have an issue I'm not seeing.
Thanks for all your help.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com
Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook
-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, August 05, 2013 9:10 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ
Does the code still fail with the dummy file out there? If not, I'd guess
permissions.
From: Al DeWitt adew...@stylmark.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date: 08/05/2013 09:04 AM
Subject:Re: [U2] OPENSEQ
Sent by:u2-users-boun...@listserver.u2ug.org
Thanks for your reply Kevin.
I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it.
FNAME does not exist. In the code I stole this from the name is created
anew each time. It always open the file empty, allows me to populate
and close it. However, in this code it's not working.
Since we're running SB+/SBClient I thought the '.XLS' extension was
causing issues (grasping at straws) but I'm getting the same errors.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com
Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook
-Original Message-
From: Kevin King [mailto:ke...@precisonline.com]
Sent: Monday, August 05, 2013 8:31 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ
I've never used OPENSEQ on a remote drive like that. I presume you can
LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the
OPENSEQ should work with that just fine. May I also presume that you
looed at FNAME and a file with that name really does exist in that
directory file?
On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote:
Please educate me on OPENSEQ. I have some code that is giving me an
error. The funny thing is that I stole the code from a working program:
The code:
064: FNAME = 'LLV':FNAME:'.XLS'
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME
Re: [U2] Pick flavor in U2 personal edition
Eric: Yes. Bill - Original Message - *From:* earmstr...@lobelfinancial.com *To:* u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org *Date:* 8/5/2013 1:24 PM *Subject:* Re: [U2] Pick flavor in U2 personal edition Dan, Thanks. I downloaded and installed the Extensible Administration Tool it. Do I have to create a new U2 Server in order to use it? Eric Armstrong IT Dept -- Message: 6 Date: Fri, 2 Aug 2013 21:31:58 + From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] Pick flavor in U2 personal edition Message-ID: 8e17b0ffe20e47db8ffcae5d1b91e...@wal-vm-mbx1.rocketsoftware.com Content-Type: text/plain; charset=us-ascii XAdmin, part of our U2 DBTools package: http://www.rocketsoftware.com/products/rocket-u2-clients-and-dbtools/try-now Regards, Dan McGrath Managing Director, U2 Servers Lab Rocket Software LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] XAdmin wiki?
You know, I'd have no problem updating documentation to a wiki site, where I know all documentation would go and I could continue to reference the documentation in the future. The Pickwiki is a little disorganized, but since I do most of my database work with U2 I'd be happy to update anything to a wiki they provide. The biggest problem I see is the changing technology. Everything changes, including wikis! Simple is always better, and since we're all developers to one degree or another, we don't need a completely idiot-proof environment; just someone at U2's end who can keep us idiots in line and keep the site organized. Just my $.02. :-) Bill - Original Message - *From:* dave...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 8/5/2013 4:57 PM *Subject:* Re: [U2] XAdmin wiki? Hi: The problem is not whether you need a wiki or not. The problem is the documentation is terrible and in most cases non-existent. A year ago at U2 University a majority of us discussed this with the board of Rocket U2. The agreed with us they would fix this and show some examples as well. Well, here we are a year and many months later with the same problem. New users and non-eclipse users cannot figure out how this tool works. Since U2logic is a U2 VAR, U2logic does get paid to tell our clients how to use this tool and the others. However, since the tools are given away by Rocket there is little money in the pot for any meaningful help. Regards, Doug www.u2logic.com Better documentation for our XLr8 Tools ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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
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 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, July 25, 2013 12:25 PM To: U2 Mail List Subject: [U2] [UD] BASIC Code Failing We've been having an anomaly that has occurred over the past 7 years we've been using UniData on Windows. Yesterday one of the accounts on our ASP server, that contains about 30 accounts, had a billing issue. This issue was created because a single BASIC program didn't run a couple of lines of code, thus a particular type of charge wasn't created for anyone on this account. The BASIC code is compiled in an application account then cataloged locally in each account (a pointer to the program file exists on every account). When I make a copy of this particular account, then run the offending program in it, I see the same problem. When I put a DEBUG statement (in the offending program) just above where I suspect the problem occurs, recompile then rerun it, there is no problem. After futzing around with placing the DEBUG statement in several different locations, with no further issue, I remove the DEBUG statement and finally re-compile the offending program. I've changed nothing in the program, but it now works. This particular program runs maybe 250,000 billings every month with nothing wrong happening. In fact, I haven't seen this problem in this billing program for the past seven years, which means that maybe over 20 million transactions have been created with no issues. This happens about once every six months or so on one BASIC program or another, where I look at an offending program, see something like five lines of code writing to five different files, and the issue is the last two lines didn't execute. When I put a DEBUG into the program everything works fine. When I remove the DEBUG statement and recompile everything works fine from then on. Has anyone else seen this? Maybe there's something I should do to prevent this. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers
I must say, I use triggers in UD with no problems. When converting from D3 to UD I had a hard time getting them to work. However, with useful suggestions from several on this list I was able to get them working properly. They turned out to be a bit more robust than the D3 triggers. I've been able to debug the trigger several times when problems appeared, but haven't for a number of years as they work as expected now. The structure took a while to get my head around, but I simply have two trigger programs (globally cataloged): U2.MASTER.TRIGGER.D U2.MASTER.TRIGGER.U ...which handle all delete and update triggers. Inside each program a file is read that actually provides the trigger subroutines to CALL (via a CALL @...). So, I can insert any subroutine as a trigger in any account. These programs are cataloged locally. I don't remember any problems debugging these subroutines. Just a thought. Bill - Original Message - *From:* perry.tay...@zirmed.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/29/2013 6:24 AM *Subject:* Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers That and the expense of their usage. Perry Taylor Zirmed, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, July 26, 2013 1:32 PM To: U2 Users List Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers How many people avoid using triggers BECAUSE of the virtual impossibility of using RAID with Triggers? On 7/26/2013 12:33 PM, Phil Walker wrote: I won't be holding my breath Charles ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 26 July 2013 9:22 p.m. To: U2 Users List Subject: Re: [U2] Universe Triggers re. triggers Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the 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 CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and
[U2] [UD] BASIC Code Failing
We've been having an anomaly that has occurred over the past 7 years we've been using UniData on Windows. Yesterday one of the accounts on our ASP server, that contains about 30 accounts, had a billing issue. This issue was created because a single BASIC program didn't run a couple of lines of code, thus a particular type of charge wasn't created for anyone on this account. The BASIC code is compiled in an application account then cataloged locally in each account (a pointer to the program file exists on every account). When I make a copy of this particular account, then run the offending program in it, I see the same problem. When I put a DEBUG statement (in the offending program) just above where I suspect the problem occurs, recompile then rerun it, there is no problem. After futzing around with placing the DEBUG statement in several different locations, with no further issue, I remove the DEBUG statement and finally re-compile the offending program. I've changed nothing in the program, but it now works. This particular program runs maybe 250,000 billings every month with nothing wrong happening. In fact, I haven't seen this problem in this billing program for the past seven years, which means that maybe over 20 million transactions have been created with no issues. This happens about once every six months or so on one BASIC program or another, where I look at an offending program, see something like five lines of code writing to five different files, and the issue is the last two lines didn't execute. When I put a DEBUG into the program everything works fine. When I remove the DEBUG statement and recompile everything works fine from then on. Has anyone else seen this? Maybe there's something I should do to prevent this. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] BASIC Code Failing
Robert: ...the object code became corrupt due to a system crash. That sounds plausible. Our systems rarely go down, but they do get rebooted with Windows Updates. UO connections often fail, then get picked up. Telnet often freezes or aborts (mostly client issues) then they log in again. Then there's ... It's always something...and these moron kids think everything works just fine (because they haven't lived long enough to see it not work). :-) Bill Untitled Page - Original Message - *From:* i...@keyway.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/25/2013 1:57 PM *Subject:* Re: [U2] [UD] BASIC Code Failing I just remembered another situation I saw once where a program behaved strangely. When we used the command to verify the object code (BVERIFY?) it didn't verify. A recompile fixed it because the object code became corrupt due to a system crash. Sometimes you can have the same thing happen, but in the catalog space. Robert Norman ROBERT NORMAN AND ASSOCIATES 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 (951) 541-1668 i...@keyway.net mailto:i...@keyway.net http://users.keyway.net/~ice/ http://users.keyway.net/%7Eice/ Affordable UNIVERSE programming services for PICK/BASIC, DATA/BASIC, UniVerse Basic, UniBasic, R/BASIC, jBC. On 7/25/2013 1:36 PM, Woodward, Bob wrote: I agree with Tony. I once had a program that my fix was just adding a JUNK = 0 line near the top of the program. With that do-nothing line the program worked. Comment the line out or remove it completely and the program seemed to skip lines of code. This was a LONG time ago, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, July 25, 2013 1:05 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] BASIC Code Failing Bill, at Pick Systems we occasionally saw issues like this, where the object code would behave differently if specific statements (their opcodes/tokens) were broken across frame boundaries. Until DBMS patches become available, the problem could be avoided with some carefully-placed NULL statements. I've seen this with RPL too, for exactly the same reasons. I know nothing of U2 internals but the internals are of course similar. Unfortunately without a confirmed cause/effect scenario defined by engineers, it's a crap shoot as to whether inserting NULLs will help, or where they can be inserted to ensure they work. I suggest you contact Rocket and ask them to pursue this as a byte-level issue in your object code. Sending them the code might not help if they test in an environment that's different from your own. They need to see it on your system. I'm just trying to save you some wasted diagnostic time... Best, T From: Bill Haskett ... a single BASIC program didn't run a couple of lines of code... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] [UD] BASIC Code Failing
As always, thanks G-Man! I can't replicate it. It just comes up every six months (or so) with something totally different happening within our application, not to everybody, but to someone. The testing is always the same; test to confirm, put in the DEBUG, recompile, test, confirm fix, take out DEBUG, recompile, test to confirm fix, then move on. In the meantime, hundreds of thousands of transactions have taken place with no problems. All I can say is; it could be worse! :-) Bill - Original Message - *From:* 3xk547...@sneakemail.com *To:* u2-users@listserver.u2ug.org *Date:* 7/25/2013 1:04 PM *Subject:* Re: [U2] [UD] BASIC Code Failing Bill, at Pick Systems we occasionally saw issues like this, where the object code would behave differently if specific statements (their opcodes/tokens) were broken across frame boundaries. Until DBMS patches become available, the problem could be avoided with some carefully-placed NULL statements. I've seen this with RPL too, for exactly the same reasons. I know nothing of U2 internals but the internals are of course similar. Unfortunately without a confirmed cause/effect scenario defined by engineers, it's a crap shoot as to whether inserting NULLs will help, or where they can be inserted to ensure they work. I suggest you contact Rocket and ask them to pursue this as a byte-level issue in your object code. Sending them the code might not help if they test in an environment that's different from your own. They need to see it on your system. I'm just trying to save you some wasted diagnostic time... Best, T From: Bill Haskett ... a single BASIC program didn't run a couple of lines of code... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] CentOS with Universe?
Are you saying your client wouldn't pay $750 for Windows Server 2008 R2? ...and you actually get paid? :-) Bill - Original Message - *From:* dw...@tincat-group.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/17/2013 6:41 AM *Subject:* [U2] CentOS with Universe? We have a VAR who would prefer to load Universe and their application on a supported platform, but we would prefer not to pay for RHEL 6. I searched the list and found a few tidbits, but does anyone have a good list of what changes might be required to successfully run Universe 11.1 on CentOS? How much pain would we be introducing for ourselves and our VAR, if they were willing to play along? Thanks. --dawn ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CentOS with Universe?
Dawn: I kind of figured. :-) Whatever you decide, I'm sure would be fine. I would just not look for anything free, because nothing is free. I run everything on Windows because everything in the O/S is updated and I know every machine I run is running the same version of Windows. It seems when Windows updates I have very few problems with the software I'm running on the machine. Surprisingly, this makes my life a lot easier. IIS is easy to install, and 3rd party SFTP is too, with virtual accounts as act like real Windows accounts. Although I run UniData, I think UniVerse is just as stable on Windows as it is on ..nix. Although you may have specific reasons to run on ..nix I would think free shouldn't be one of them. Just a thought. Bill - Original Message - *From:* dw...@tincat-group.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/17/2013 10:48 AM *Subject:* Re: [U2] CentOS with Universe? Hi Bill -- Ah, this time I'm in the client seat, desiring a hosted solution for Universe. We will choose the same box for starters for the web server as well. The VAR runs IIS on Windows, but Apache on linux. Given that info, which OS would you select for Universe 11.1? --dawn On Wed, Jul 17, 2013 at 12:28 PM, Bill Haskett wphask...@advantos.netwrote: Are you saying your client wouldn't pay $750 for Windows Server 2008 R2? ...and you actually get paid? :-) Bill --**--** - Original Message - *From:* dw...@tincat-group.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/17/2013 6:41 AM *Subject:* [U2] CentOS with Universe? We have a VAR who would prefer to load Universe and their application on a supported platform, but we would prefer not to pay for RHEL 6. I searched the list and found a few tidbits, but does anyone have a good list of what changes might be required to successfully run Universe 11.1 on CentOS? How much pain would we be introducing for ourselves and our VAR, if they were willing to play along? Thanks. --dawn __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://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] CentOS with Universe?
I'm not sure why you'd say that. I wouldn't create a caveat that my time is worth nothing; thus, as Tony says, Linux ain't free. I have very little trouble with Windows, so, again, I'm not sure what you refer to about not putting IIS and the dbms server on the same box and face it towards the internet...Windows is much better than it used to be. The minimal amount of configuration, along with a firewall device and/or router seems to work just fine, especially in our development environment. Now, if you want to work with the Active Directory on Windows Server 2012, or configure a VPN on your firewall/VPN device, then you might as well just shoot yourself instead! :-) I use Windows because, in the aggregate, using it has saved me a lot of time with our customers. YMMV... Bill - Original Message - *From:* antli...@youngman.org.uk *To:* u2-users@listserver.u2ug.org *Date:* 7/17/2013 12:25 PM *Subject:* Re: [U2] CentOS with Universe? On 17/07/2013 19:09, Bill Haskett wrote: Dawn: I kind of figured. :-) Whatever you decide, I'm sure would be fine. I would just not look for anything free, because nothing is free. It's only free if your time is worth nothing - I think that's one of Tony's quotes. Just don't forget, linux is Free, which is completely different. I run everything on Windows because everything in the O/S is updated and I know every machine I run is running the same version of Windows. It seems when Windows updates I have very few problems with the software I'm running on the machine. Surprisingly, this makes my life a lot easier. IIS is easy to install, and 3rd party SFTP is too, with virtual accounts as act like real Windows accounts. And yet we hear loads of stories about how updates regularly break Windows ... although they tend to be client stuff that suffers most of that. The counter-advantage of linux is it's easy to run a stripped-down box with only the services you want. Especially with a net-facing system, how easy is it to run Windows with everything except IIS locked-down/disabled/deleted? And on linux you have total control over updates too. I don't think you want to run gentoo like me, but if you've got someone who can administer the system you could run Apache on one system facing the net, on a totally locked-down system (maybe even with a DVD as your system drive) with a firewall between that and your UV system. I'd be a little bit worried about having just one Windows system, net-facing, running both the web server and the database. Although I run UniData, I think UniVerse is just as stable on Windows as it is on ..nix. Although you may have specific reasons to run on ..nix I would think free shouldn't be one of them. Just a thought. A sensible thought :-) but you can see which way I'd go :-) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Fwd: UML mapping tool for MV (UniVerse)
You can place all of your dictionaries into a separate account, in a separate directory. Create valid update permissions for an administrator to this database directory and read permissions for users, and anyone else Bill Untitled Page - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 7/16/2013 9:44 AM *Subject:* [U2] Fwd: UML mapping tool for MV (UniVerse) -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Jul 16, 2013 9:42 am Subject: Re: [U2] UML mapping tool for MV (UniVerse) But with programmers able to create new DICT entries as they will, how do you *keep* it spotless? -Original Message- From: Hona, David david.h...@cba.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jul 15, 2013 5:40 pm Subject: 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... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Fwd: UML mapping tool for MV (UniVerse)
George: You could create another dictionary account, next to the first one, and reference it for those accounts that utilize the same file names with different data structures. Would that work? Bill Untitled Page - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/16/2013 11:16 AM *Subject:* Re: [U2] Fwd: UML mapping tool for MV (UniVerse) The only downside to that would be that you can't have filenames of the same name in different accounts, unless you factor the accountname into the dict name. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, July 16, 2013 2:11 PM To: U2 Users List Subject: Re: [U2] Fwd: UML mapping tool for MV (UniVerse) You can place all of your dictionaries into a separate account, in a separate directory. Create valid update permissions for an administrator to this database directory and read permissions for users, and anyone else Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Fwd: UML mapping tool for MV (UniVerse)
Yea, but who's going to read, and understand, the XML? :-) Bill Untitled Page - Original Message - *From:* dave...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/16/2013 2:05 PM *Subject:* Re: [U2] Fwd: UML mapping tool for MV (UniVerse) You silly boys and girls, you don't need dictionaries to do a UML class diagram. You just need UniBasic code, Eclipse to index your code, and XLr8 to create the XML. Regards, Doug www.u2logic.com Spelling is optional for U2 programmers ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mobile phones
Did it help, and what did you decide to do? :-) Bill - Original Message - *From:* syme...@gmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 7/15/2013 5:20 AM *Subject:* Re: [U2] Mobile phones Thanks everyone for your information. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SORT reports line length, change right margin?
The simplest solution is to change the print width in UV then alter the CPI in PCL. You may not have to alter the print width in UV if the original developer was prescient enough to plan for expansion. e.g. ^027E^027l1e64F^027a0l85M^027(s0p16.67h0s3b##DEFFONTNO##T ...where ##DEFFONTNO### is just a tag that is substituted by the actual font ID# at runtime. HTH, Bill - Original Message - *From:* randyleesm...@roadrunner.com *To:* u2-users@listserver.u2ug.org *Date:* 7/15/2013 7:32 AM *Subject:* [U2] SORT reports line length, change right margin? It's been a while, nice to be back and working again. :) I'm on a Universe Database; I have a proc full of SORT reports. I needed to add new fields, but the size of the line is too small. I'm already using landscape mode and don't have enough space. I have been testing with PCL, but I was wondering if I could just make the line longer. Seems to be enough room if I could adjust the right margin. MARGIN /n/ only changes the left margin. I never had to deal much with SORT reports in the past, so I though you Guru's could help. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-length-change-right-margin-tp41205.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] [UV] Record Sampling for File Sizing Diagnostics
Harold: UniData does have the SAMPLED verb. It works the same way as described. Bill - Original Message - *From:* harold.o...@clark.wa.gov *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/12/2013 2:17 PM *Subject:* Re: [U2] [UV] Record Sampling for File Sizing Diagnostics Perry: In Universe the modifier SAMPLED nn selects every nn'th record. For example, SELECT MYFILE SAMPLED 50 selects every 50th record. That way you plow thru the entire file but come back with only 1/50 of the records. I don't know if this keyword exists in Unidata Harold Oaks Clark County, WA -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Tuesday, June 11, 2013 9:01 AM To: U2-Users List Subject: [U2] [UV] Record Sampling for File Sizing Diagnostics I have several *very* large files on which I need to perform some file sizing diagnostics. Rather than repeatedly running HASH.AID against these files is there a good way to sample say 2-3 million records to copy into a test file? SAMPLE will only grab the first n records in hash order and I'm thinking that would not necessarily be a good representative sample of the file's contents. Am I up in the night thinking this is the case? Is there a better way to get a good sample of records for this purpose? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] MsgLvlConfig
Does anyone have documentation on msglevelconfig? I've set it as: unidata = 16/PID/DT ...and get all kinds of junk like: Sat May 25 20:27:45 pid=3808 No active select list, creating empty saved list. Sat May 25 21:17:59 pid=172 No active select list, creating empty saved list. Sat May 25 22:00:17 pid=1160 DELETE.LIST MVNET_10166_SEL failed. Sat May 25 22:00:17 pid=1160 DELETE.LIST MVNET_10179_SEL failed. ...which just floods the udt.errlog. Also, is there a way to log the account path? I use multiple accounts with shared code so which account is having problems with a program would be quite helpful? Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] MsgLvlConfig
Robert: Thanks! The links were very informative. :-) Bill Untitled Page - Original Message - *From:* rfrai...@utahmed.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/11/2013 12:10 PM *Subject:* Re: [U2] MsgLvlConfig http://u2-universe-unidata.1073795.n5.nabble.com/Re-Logging-td28343.html http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg32670.html http://comments.gmane.org/gmane.comp.db.u2.general/57763 Robert - Original Message - From: Bill Haskett wphask...@advantos.net To: U2 Mail List U2-users@listserver.u2ug.org Sent: Tuesday, June 11, 2013 1:06 PM Subject: [U2] MsgLvlConfig Does anyone have documentation on msglevelconfig? I've set it as: unidata = 16/PID/DT ...and get all kinds of junk like: Sat May 25 20:27:45 pid=3808 No active select list, creating empty saved list. Sat May 25 21:17:59 pid=172 No active select list, creating empty saved list. Sat May 25 22:00:17 pid=1160 DELETE.LIST MVNET_10166_SEL failed. Sat May 25 22:00:17 pid=1160 DELETE.LIST MVNET_10179_SEL failed. ...which just floods the udt.errlog. Also, is there a way to log the account path? I use multiple accounts with shared code so which account is having problems with a program would be quite helpful? 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 ___ 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?
Or, you could download the BPTEST or TRY program from: http://www.pickwiki.com/cgi-bin/wiki.pl?BasicSource ...then write the simple code from the command line. Not only are these programs good to test syntax, but they're great for performing simple tasks that don't work from the command line. Bill - Original Message - *From:* mec...@gmx.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/29/2013 12:25 AM *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
Re: [U2] select query..
George: In UniData, all SAVEDLISTS items have 000 (or 001, etc) appended to the end of it. Although one can normally do a SAVE.LIST MY.LIST and expect that the actual item ID in the SAVEDLISTS file to be MY.LIST000 this isn't always the case if the list is large. This makes managing a list directly in UD problematic. :-( HTH, Bill - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/15/2013 6:43 AM *Subject:* Re: [U2] select query.. I'm confused.. If your doing a select with @ID = you will only get 1 response each time, @ID is a primary key field. So as suggested just open the file, then do a read from That file with the given @ID. An alternative to a SAVE.LIST and GET.LIST could be to open SAVEDLISTS as file Then READ and WRITE your dynamic list to that file, and just use a FOR/NEXT loop to Traverse it. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Wednesday, May 15, 2013 5:45 AM To: u2-users@listserver.u2ug.org Subject: [U2] select query.. Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH @ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 LIST.NAME = GET-LIST SOME.LIST sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of KEYVALUEs and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Manage $ values
Dale: Be careful with this if running UniData. Here are some UDT.OPTIONS documentation: UDT.OPTIONS 56 - U_CONV_BADRETURN Normally, if an OCONV or ICONV conversion fails due to invalid data or an invalid conversion code, UniData returns the input string. In BASICTYPE P, if you turn on UDT.OPTIONS 56, UniData returns an empty string. ON If this option is on, UniData returns an empty string when an OCONV or ICONV conversion fails. Note: For compatibility with most Pick® systems, turn this option on. OFF If this option is off, UniData returns the original string when an OCONV or ICONV conversion fails. I've been bitten by this in the past. :-( Bill - Original Message - *From:* dalekel...@dalewkelleyinc.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/7/2013 3:06 PM *Subject:* Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Would anyone else like a change to *HS.UPDFINFO?
It has always been my opinion that any TCL verb, function, or whatever should be able to process a select list if one is present. All of the utilities I write have this capability, along with help. :-) Bill - Original Message - *From:* gregor.sc...@pentanasolutions.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/1/2013 5:34 PM *Subject:* Re: [U2] Would anyone else like a change to *HS.UPDFINFO? That has not been our experience. The actual workings of the program are not well explained in the UV doco. I did find in the UV11 UniOLEDB PDF an explanation of sorts: * Scans the dictionaries of all nonsystem files named in the VOC, finding all associations and unassociated multivalued columns. * Rewrites the file information cache (.hs_fileinfo) under the account's directory, based on the above dictionary information and on the contents of the HS_FILE_ACCESS file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Thursday, 2 May 2013 1:57 AM To: U2 Users List Subject: Re: [U2] Would anyone else like a change to *HS.UPDFINFO? That would be a nice feature. I do believe that it only processes files with a * or *SELECT dictionary item however. 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] UD - Display Current Terminal Type
Thanks, Martin. This does the same thing !echo %TERM% does, where I noted that my SYSTEM(7) variable was Actwy60 while the results of this Windows environment variable was wyse60. When I noticed this my thoughts went to why? :-) Thanks again, Bill Untitled Page - Original Message - *From:* mbr...@epicor.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/24/2013 5:57 AM *Subject:* Re: [U2] UD - Display Current Terminal Type Not ECL, but UniBasic and should work in UD on either Unix or NT X=GETENV(TERM) PRINT X vt220 - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: 24 April 2013 13:23 To: U2 Users List Subject: Re: [U2] UD - Display Current Terminal Type Sorry, I thought it was available on both UV and UD. It is a valid verb on UV: GET.TERM.TYPE Wyse Technology 50/60 (W) Width : 127 Depth : 40 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 9:09 PM To: U2 Users List Subject: Re: [U2] UD - Display Current Terminal Type :GET.TERM.TYPE Not a verb GET.TERM.TYPE :version Module Name Version Licensed UniData RDBMS 7.3 Yes Connection Pooling... 7.3 Yes Device License... 7.3 Yes NFA.. 7.3 No RFS.. 7.3 No EDA.. 7.3 No 733 Bill Untitled Page - Original Message - *From:* tewhitm...@ratex.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/23/2013 5:11 PM *Subject:* Re: [U2] UD - Display Current Terminal Type GET.TERM.TYPE will display the terminal type, width and depth. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 5:12 PM To: U2 Mail List Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== to report this email as spam. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UD - Display Current Terminal Type
I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Display Current Terminal Type
Ahh! 4 Dev (0)- !echo %TERM% wyse60 4 Dev (0)- BPTEST CRT SYSTEM(7) ; END Compiling Unibasic: SAVEDLISTS\BpTest_516680981 in mode 'p'. compilation finished ACTWY60 I ran the command TERM ACTWY60 when I logged in. I wonder why the difference? Thanks, Bill - Original Message - *From:* dda...@harriscomputer.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/23/2013 2:19 PM *Subject:* Re: [U2] UD - Display Current Terminal Type !echo $TERM perhaps. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 5:12 PM To: U2 Mail List Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Display Current Terminal Type
Well, that doesn't work, which I tried originally as this is what other mvDbms products use (at least what I'm used to). UniData doesn't respond with the terminal type. 4 Dev (0)- TERM TERM parameters are all numeric: TERM A,B,C,D For the terminal A=number of characters in a line(132). B=number of lines per page(42). For the line printer C=number of characters in a line(146). D=number of lines per page(61). 4 Dev (0)- Bill Untitled Page - Original Message - *From:* bob_woodw...@k2sports.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/23/2013 2:48 PM *Subject:* Re: [U2] UD - Display Current Terminal Type In Unidata 6.1, TERM with no arguments gives me a brief syntax help message. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 23, 2013 2:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD - Display Current Terminal Type TERM with no arguments will *display* your current settings, at the bottom of the display it will say 'wyse50' -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Mail List U2-users@listserver.u2ug.org Sent: Tue, Apr 23, 2013 2:11 pm Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 RESIZE CONCURRENT
Jeff: Since the documentation says: RESTORE - If the system crashes or RESIZE CONCURRENT encounters an error, delete the temporary copy of the resized file and restore the original file before any resize operation took place. I'd guess the RESTORE keyword is putting something somewhere where you don't have permissions. Further documentation says: - - - - - - - - - - Recovering from a Concurrent Resize Error If the concurrent resizing process encounters an error, or the system crashes during the resize operation, complete the following steps to restore the file:- Resizes the file according to its actual size, thus correcting overflows. 1. Check and repair the physical integrity of the file, if necessary. For nonrecoverable files, use the guide utility to check if the file needs to be repaired. If so, use the fixfile command to repair the file. If the file is a recoverable file, restarting UniData after the system crash should automatically fix both the original file and the temporary copy of the file as it was being resized. 2. Execute the RESIZE CONCURRENT CONTINUE command against the file if you want the resize operation to continue to completion. Execute the RESIZE CONCURRENT RESTORE command against the file if you want to delete the temporary copy of the file and restore the original file before any resize operation took place. If you do not execute either of these options, the RESIZE CONCURRENT operation will fail and display an error message describing the reason for the failure. At this release, the guide utility has been enhanced to display a message indicating that the file is currently being resized. The message includes the number of groups that have been resized: - - - - - - - - - - I wonder what, and where, that is? Bill Untitled Page - Original Message - *From:* jbut...@hampshire.edu *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/23/2013 3:35 PM *Subject:* Re: [U2] Unidata RESIZE CONCURRENT On 04/22/2013 09:49 PM, Jeffrey Butera wrote: I'm attempting some experiments with RESIZE CONCURRENT on Unidata 7.3.3 (RedHat) but failing miserably. I didn't think there was any configuration I needed to enable before using CONCURRENT, perhaps I'm misunderstanding the error message: :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT RESTORE H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. Resize Concurrent Continue/Restore failed because the RESIZE_CONCURRENT bit was not set on the file. I determined that the problem is RESTORE. If we eliminate that keyword, RESIZE CONCURRENT works. :RESIZE H08.FACULTY.WL.SNAP 3593,8 CONCURRENT H08.FACULTY.WL.SNAP is a synonym, real name is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP. The temporary file for RESIZE is H08.DATA/DATA_F/H08.FACULTY.WL.SNAP.resize. H08.FACULTY.WL.SNAP RESIZED from 3359 to 3593 I'm not yet sure of implications of not using RESTORE or CONTINUE, but I'm ok for now. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Display Current Terminal Type
Thanks, but that's not it for UniData. Bill Untitled Page - Original Message - *From:* antli...@youngman.org.uk *To:* u2-users@listserver.u2ug.org *Date:* 4/23/2013 3:48 PM *Subject:* Re: [U2] UD - Display Current Terminal Type On 23/04/13 22:12, Bill Haskett wrote: I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Dunno whether it works for UD, but the UV command is GET.TERM.TYPE. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Display Current Terminal Type
:GET.TERM.TYPE Not a verb GET.TERM.TYPE :version Module Name Version Licensed UniData RDBMS 7.3 Yes Connection Pooling... 7.3 Yes Device License... 7.3 Yes NFA.. 7.3 No RFS.. 7.3 No EDA.. 7.3 No 733 Bill Untitled Page - Original Message - *From:* tewhitm...@ratex.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/23/2013 5:11 PM *Subject:* Re: [U2] UD - Display Current Terminal Type GET.TERM.TYPE will display the terminal type, width and depth. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, April 23, 2013 5:12 PM To: U2 Mail List Subject: [U2] UD - Display Current Terminal Type I've had a brain-freeze and can't remember how to display the current terminal type at ECL. I know it's SYSTEM(7) but what ECL command do I need to display it? TERM doesn't work (although I can set it by entering TERM WYSE60). PTERM doesn't work (it gives me all kinds of other things). Any help would be appreciated. Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Refactoring Tools
Brian: Prayer may come in handy. :-) Bill Untitled Page - Original Message - *From:* br...@brianleach.co.uk *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 4/22/2013 12:12 PM *Subject:* Re: [U2] Refactoring Tools Jeff - Exactly :) I mean refactoring as in restructuring old code to make it more testable and consistent. You find these tools for .NET, java and other languages though there the model is different because of the OO nature. Universe code doesn't decompose down the same way but I was just wondering whether anyone had built some assisting tools before I have to start designing and building some. Example, an slice through a program that mixes UI and business logic to rip out the useful guts into external subroutines for unit testing whilst preserving the overall logic safely. Which means the tool needs at least a rudimentary understanding of code syntax and scope rather than just stripping lines out. (e.g. this block sets a local variable as a by-product, that also just happens to be used 5,000 lines later on in a GoSub so it needs to be surfaced if the block is externalized - that kind of stuff that could easily get lost). I've written plenty of code analysis software but not specifically for this. Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: 22 April 2013 19:49 To: U2 Users List Subject: Re: [U2] Refactoring Tools *https://en.wikipedia.org/wiki/Code_refactoring Code refactoring is a disciplined technique for restructuring an existing body of code, altering its internal structure without changing its external behavior,[1] undertaken in order to improve some of the nonfunctional attributes of the software. Advantages include improved code readability and reduced complexity to improve the maintainability of the source code, as well as a more expressive internal architecture or object model to improve extensibility. My translation: Remove the spaghetti without changing functionality. *Wjhonson wrote: Perhaps by refactoring you mean just to make the code more consistent. Yes and no. Decompiling the object code, will enforce consistency, however at the expense of readability. -Original Message- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Sun, Apr 21, 2013 5:26 am Subject: [U2] Refactoring Tools Hi All I'm doing some intensive work with a large UniVerse site to assist them in migrating their 20 year old code base and working practices to full Agile, XP and TDD. They are really enthusiastic in embracing the modern world and making good progress, but there is a huge amount of legacy code to be cleaned up and test harnessed. So before I spend time possibly reinventing the wheel, does anyone know of any good refactoring tools for UniVerse Basic? Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] WRITESEQ Error
Beware of Windows Updates! They've cause me all kinds of trouble. So much so that I now have to review the updates by hand to see what they're trying to slip in! :-o Bill - Original Message - *From:* adew...@stylmark.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 4/12/2013 7:59 AM *Subject:* Re: [U2] WRITESEQ Error We found the cause to this problem and I thought I'd share it with you. The file we append sits on a virtual PC. The VOC pointer is \\file-server\share-name\folder-name This PC is configured for automatic windows updates and automatically restarts. We had Patch Tuesday. The PC restarted fine and automatically started the application, however, the share-name stopped working. When the IT person tried to restart it he didn't do it correctly. Now that we have correctly recreated share-name all is well. Thanks for all your help. Al DeWitt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Thursday, April 11, 2013 6:34 PM To: U2 Users List Subject: Re: [U2] WRITESEQ Error I quite often found that the file had either not been sequentially opened, or it had been closed before the writeseq command. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Thursday, April 11, 2013 3:56 PM To: 'U2 Users List' Subject: Re: [U2] WRITESEQ Error I initially thought it was a permissions issue as well, however, I am a domain admin and I get the same error. If it is a permissions error than something has changed that I am not aware of. Al DeWitt -Original Message- From: Wjhonson [mailto:wjhon...@aol.com] Sent: Thursday, April 11, 2013 5:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] WRITESEQ Error Here 9 points to a permissions issue http://u2-universe-unidata.1073795.n5.nabble.com/Unidata-6-1-AIX-quot- write- error-errno-9-quot-on-WRITESEQ-td6781.html -Original Message- From: Kevin King ke...@precisonline.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Apr 11, 2013 3:44 pm Subject: Re: [U2] WRITESEQ Error Al brings up a good point though... Where would one find what error 9 means exactly? I scanned the documentation and didn't see any mention of an error 9 for WRITESEQ or even described in STATUS() which is where a lot of the IO errors show up. On Thu, Apr 11, 2013 at 3:45 PM, Wjhonson wjhon...@aol.com wrote: You're first test is always permissions. Permissions, permissions, I hate them. -Original Message- From: Al DeWitt adew...@stylmark.com To: (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Thu, Apr 11, 2013 2:10 pm Subject: [U2] WRITESEQ Error I have a program that has been working fine until today. The users are now experiencing an error at the following statement #: 508: WRITESEQ RECRD APPEND ON FILEIN ELSE ... at line 508 write error, errno = 9 Can someone tell me what errno 9 is and what my cause it?The file resides on a virtual XP machine that runs a third-party app that reads this file. 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Social Networks for MV
Symeon: That isn't mostly true if you're a small business. Many times a small business's marketing focus has been on stationary, business cards, membership with the local chamber of commerce or rotary club, church membership, and sometimes a targeted trade show or advertisement in a particular trade publication. This is far different than what you observe for much larger businesses looking at much broader-based markets. I can't tell you how many of my small business friends have overpaid and been unhappy with SEO firms, marketing lists, marketing firms, and the plethora of business pustules who promise much and produce little. I'm sure we've all been there, and done that! In a small business, there isn't such a redundancy of resources that these decisions don't matter. Just a thought, or two. :-) Bill Untitled Page - - - */Fav Icon Advantos Systems, Inc./* ☎ Tel: 760-944-5570 x7002 | ☏ Fax: 760-655-1583 The Property Management Advantage. - Original Message - *From:* syme...@gmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 4/2/2013 1:30 AM *Subject:* Re: [U2] Social Networks for MV Marketing has always been about multiple ways to do predominantly the same thing you have a newspaper campaign, poster campaign, radio, tv, cpc ads, web banners, cold calling etc, these are just some more. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 28 March 2013 21:55 To: U2 Users List Subject: Re: [U2] Social Networks for MV The biggest issue I have this all of this social media craze (emperor's new clothes) is the time it takes to manage multiple ways to do predominately the same thing. Although with enough resources, these marketing avenues are manageable, for small businesses, there aren't enough resources in house. In addition, to outsource requires tremendous luck in the selection process. Secondly, the level of self-absorption in these social media outlets is so monumental, what can I say? It's like talking with someone who spends the entire time preening themselves in from me. Just a thought, or two... :-) Bill Untitled Page - Original Message - *From:* robert.hou...@fwic.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/28/2013 2:14 PM *Subject:* Re: [U2] Social Networks for MV Here's another article about social media. While it addresses more consumer facing data, you can easily see how some B2B companies can take advantage of the same concepts: http://www.thetibcoblog.com/2013/03/12/why-do-companies-find-it-so-har d-to-get-social-media-right/?goback=%2Egde_43707_member_225094184%2Egd e_43707_member_222896835 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: March-19-13 2:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Social Networks for MV From: Robert Houben And just to mess with your heads a bit more... http://smallbiztrends.com/2013/03/10-reasons-business-pinterest.html Oh dear, you seem to have provoked yet another blog. :) http://nebula-rnd.com/blog/tech/mv/2013/03/socialmv3.html Summary: It's not just the individual services. Each of us has different roles in life. Pinterest might not appeal to us as MV people but it might appeal to the companies we support who wish to use it for marketing. And while you might not want to tweet about your MV epiphanies, in the broad landscape of social media there are many APIs (web services) for extracting data into your MV system, and publishing data from your MV system. As professionals and business people, ignoring this can be a strategic mistake. Thanks for the ongoing inspiration. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Compressing PDFs
The main reason I like WinRAR is because is offers compression in command-line mode. This is very handy for me in the U2 environment, along with for Windows backups, etc. In addition, I can use its UI to create .zip files that are useful on Windows client machines. Bill Untitled Page - Original Message - *From:* 3xk547...@sneakemail.com *To:* u2-users@listserver.u2ug.org *Date:* 3/28/2013 8:58 AM *Subject:* Re: [U2] Compressing PDFs In addition to 7-Zip (the software, not just the compression algorithm), consider WinRAR. They're both based on the same UnRAR decompression. They both support multiple platforms, multiple compression methods, multiple volumes, security, etc. I hope I don't start a war by suggesting that anyone spend money for software or anything, but WinRAR is shareware for $30 and has Windows extensions for a UI that make it worth it to some people. You don't need to pay for it, and I'd guess most people do not, but it's a good thing to do, especially for a company. There is a tiny nag on file opens which is easy to dismiss. I've been using WinRAR for almost a decade and swear by it for all compression needs. For some people the choice is just a matter of personal preference where most other comparisons are similar. You'll see arguments out there about 128bit AES vs 256, or how many CPU cores are utilized, or whether you get 80% compression vs 85%. At some point it just comes down to feel. I'd recommend that you do not provide your trading partners with software, but tell them the compression mechanism you use and why, and then point them to a couple websites from which they can make their own choices. Otherwise you could get stuck providing support because YOU told them to use brandX. As to your local storage, consider delivering files to your trading partners in a format that's easy for Them to manipulate, but re-compress/store files in a way that's easy for You to manipulate. The content is ultimately the same and file transport/unpacking issues are rare and easy to remedy. HTH T From: Israel, John R. There are several issues here that I am dealing with for this project. #1 The company that we are sending the PDFs to is Windows based, so I am limited as to the formats they can accept (zip and 7z being two of them). #2 In my testing, I have found that 7z gives significantly more compression. In my test, I took a single PDF that was 17k in size. I made 3 copies of it for a total of 17 x 4 = 68k. Using a traditional zip, I was able to compact these 4 PDFs down into a 33k file (about half). HOWEVER, after compressing it down with 7z, those same 4 PDFs went down to only 8K! That is a SIGNIFICANT difference. #3 I wrote a program we all use that archives the intended file, then transmits the archive to the 2nd party. That way, if they did not get it, I can re-send it from the archive w/o having to try to re-create the data (which may have changed). Also, if there are any issues, I can look at the archive file and determine exactly what they got and then determine if the problem was mine or theirs. From: Israel, John R. HPUX, UniData SB: After a bunch of work, I have a UNIX directory that has a bunch of PDFs. I wish to bundle these PDFs up into a 7zip formatted compressed file. I see that there is a ported version of the Windows version of 7zip for UNIX called p7zip. Has anyone installed p7zip and if so, what else needed to be installed with it? Is it stand-alone or is it dependent on other software packages being loaded first? OR Does anyone have a simple way for UNIX to run the Windows command line version of 7zip against my UNIX PDF directory? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Social Networks for MV
The biggest issue I have this all of this social media craze (emperor's new clothes) is the time it takes to manage multiple ways to do predominately the same thing. Although with enough resources, these marketing avenues are manageable, for small businesses, there aren't enough resources in house. In addition, to outsource requires tremendous luck in the selection process. Secondly, the level of self-absorption in these social media outlets is so monumental, what can I say? It's like talking with someone who spends the entire time preening themselves in from me. Just a thought, or two... :-) Bill Untitled Page - Original Message - *From:* robert.hou...@fwic.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/28/2013 2:14 PM *Subject:* Re: [U2] Social Networks for MV Here's another article about social media. While it addresses more consumer facing data, you can easily see how some B2B companies can take advantage of the same concepts: http://www.thetibcoblog.com/2013/03/12/why-do-companies-find-it-so-hard-to-get-social-media-right/?goback=%2Egde_43707_member_225094184%2Egde_43707_member_222896835 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: March-19-13 2:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Social Networks for MV From: Robert Houben And just to mess with your heads a bit more... http://smallbiztrends.com/2013/03/10-reasons-business-pinterest.html Oh dear, you seem to have provoked yet another blog. :) http://nebula-rnd.com/blog/tech/mv/2013/03/socialmv3.html Summary: It's not just the individual services. Each of us has different roles in life. Pinterest might not appeal to us as MV people but it might appeal to the companies we support who wish to use it for marketing. And while you might not want to tweet about your MV epiphanies, in the broad landscape of social media there are many APIs (web services) for extracting data into your MV system, and publishing data from your MV system. As professionals and business people, ignoring this can be a strategic mistake. Thanks for the ongoing inspiration. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] REDBACK Fatal UniBasic errors
David: Sorry I can't help you on the Redback issue, but you'd be surprised what shows up in the UO logs. Also, do you have a UOLOGIN subroutine? In UD this subroutine always runs when a connection is made through UO. I've been known to cause myself trouble there. Bill Untitled Page - Original Message - *From:* dgr...@dagconsulting.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 3/25/2013 10:11 AM *Subject:* 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Cataloged programs // finding
In UniData, there's a CTLGTB file (not directory) with dictionary items and a catalog item with a format like: 4 Dev (0)- AE CTLGTB * 606 record(s) selected. 1 Top of MVNET.DICTWRITE in CTLGTB, 4 lines, 47 characters. *--: p 001: S 002: 3 003: E:\MVNET\MVNET.BP MVNET.DICTWRITE 004: admin Bottom. ...and the dictionaries look like: Dictionary of File: CTLGTB 14:01:27 Mar 25 2013 Dict Name.. Typ # Col-Heading Field-Definition Conversion.. Formt Assoc... @ID D 0 CATALOG NAME 28L S TYPED 1 1LS ARG D 2 #ofArguments 3RS ORIGD 3 ORIGINATOR 22L S WHO D 4 7LS 5 records listed ...and output looks like: 2 Dev (0)- SSCROLL CTLGTB BY ORIG ID-SUPP @ID FMT 35L TYPE ARG ORIG FMT 72L WHO FMT 12L Command = SORT CTLGTB 14:03:31 Mar 25 2013 CATALOG NAME. T ARG ORIGINATOR.. WHO. US_EXECUTOR S 5 @UDTHOME/SYS_BP US_EXECUTOR root help M 0 @UDTHOME/SYS_BP help root U2.MASTER.TRIGGER.D S 4 E:\AboE\Abo\BP\BP U2.MASTER.TRIGGER.D admin U2.MASTER.TRIGGER.U S 5 E:\AboE\Abo\BP\BP U2.MASTER.TRIGGER.Uadmin UOLOGIN S 2 E:\AboE\Abo\BP\BP UOLOGINadmin BAWEBEXEC S 2 E:\DESIGNBAIS\BA\DBI\DBI BAWEBEXEC admin DB.G.EOP.DATA S 0 E:\DESIGNBAIS\BA\DBI\DBI DB.G.EOP.DATA admin HTH, Bill Untitled Page - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org, sjos...@sjplus.com *Date:* 3/25/2013 1:28 PM *Subject:* Re: [U2] Cataloged programs // finding To be more clear. The path of the source code, is embedded at the tail of the opcode in the GLOBAL.CATDIR item for that catalogued routine name. If you can retrieve that path you can then parse it and compare it to what you know or think you know about where your code is stored from the *PICK* point-of-view (since the path will be fully specified, not Pick type). However If you simply try to READ the opcode that is the GLOBAL.CATDIR item, you have to be aware, that it CAN include CHAR(255) in that opcode. CHAR(255) to a STRING type variable means End Of String so seeing that in your STRING, will pre-maturely *truncate* the string on that character, making you think you've end the END of that variable. So you will never get the *full* opcode and thus probably never see the path you want, if you just happen to have a byte which is the CHAR(255) otherwise known as HEX FF. Hope that's more clear. In order to *around* this problem you can use the READBLK command instead of the READ command, and READBLK *one* *byte* *at* *a* *time*. Using the READBLK it will *not* attempt to interpret the FF as an end-of-string condition, so you can test for it, and skip over it and know as well that you still have *more* to read. That's not all there is. -Original Message- From: Wjhonson wjhon...@aol.com To: SJoslyn sjos...@sjplus.com; u2-users u2-users@listserver.u2ug.org Sent: Mon, Mar 25, 2013 11:41 am Subject: Re: [U2] Cataloged programs // finding I have this built into my VIEW routine which allows inter-call jumping but I don't have it as a sep program Just be aware that you *have* to read the opcode in BLOCK form (READBLK) because it *can* have embedded char 255's which will truncate any string read. Nice huh? So you have to step the code, byte by frickin byte :) -Original Message- From: Susan Joslyn sjos...@sjplus.com To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Mar 25, 2013 11:10 am Subject: [U2] Cataloged programs // finding Hi Geniuses. At a few of my customer sites I've seen people have these little hand-built utilities that help them identify the file/location of the source of a globally cataloged item. I could really use a handy little device like that - on both platforms, Universe and Unidata. Does anyone - ideally - have one of those they'd like to share for either platform? Or, at least know how to quickly put that together. I confess, I don't want to go do the research into this if I can just smile pretty and borrow it? But I'll go read up if that's what I need to do. TIA, Susan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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
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
Re: [U2] unidata env var
Jeffrey: I had to set it to 2500 in Windows, otherwise I had problems. HTH, Bill - Original Message - *From:* jbut...@hampshire.edu *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/21/2013 3:51 AM *Subject:* [U2] unidata env var We've had some issues with i-desc failing over years and the solution was to set the evironment variable VFIELDSIZE to some amount (6000 or more). My real question is does unidata care about case for this variable (on *nix, not windoze)? I've seen it documented both as VFIELDSIZE and vfieldsize and not sure unidata sees one or both of these. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] *** GMX Spamverdacht *** Re: I Descriptor no longer working in UniSQL after UD upgrade
Mecki: You need to when using the other stuff with UniData (non-telnet connectivity). ECL doesn't always represent what happens through a UO connection. :COMPILE.DICT MYFILE ...should do the trick. HTH, Bill Untitled Page - Original Message - *From:* mec...@gmx.net *To:* u2-users@listserver.u2ug.org *Date:* 3/5/2013 9:10 AM *Subject:* Re: [U2] *** GMX Spamverdacht *** Re: I Descriptor no longer working in UniSQL after UD upgrade I don't know about compiling I-descriptors in UD. Never done it and never needed to. The dict is marked as MV and has an association as well. It works just fine from ECL so when I type LIST PODET WITH PO_NBR = 98587 SCHED_DEL_DATE U_RPT_DATE I get 2 dates in both columns as expected. But when I go to sql and try SELECT SCHED_DEL_DATE,U_RPT_DATE from PODET_SCHED_DETAIL1 where PO_NBR = '98587' I get 2 scheduled dates but only one report date (current date) in the first row while in the second row it is null. I found a work-around by using an Active-X control in my DTS package, but I shouldn't have to do that. I also noticed that I-descriptors calling a Basic subroutine don't work any more through ODBC or OLE-DB even though they work in UniSQL. Maybe in 7.2 I have to convert them into V-types? I prefer I-types since I just don't seem to be able to get to grips with the V-type syntax. On 05/03/2013 13:52, David A. Green wrote: 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New Rocket Toolkit for .NET
Dan: I have to say... I have a pretty good idea of how mv.NET works, how it connects, what tools are included, and what kind of costs I can expect. I have no idea what the U2 toolkit includes, or its costs, and could never get past the marketing, which knows nothing about implementation and costs. :-) Bill Untitled Page - Original Message - *From:* dmcgr...@rocketsoftware.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/28/2013 7:15 AM *Subject:* Re: [U2] New Rocket Toolkit for .NET It is not based on MV.NET at all. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Wednesday, February 27, 2013 2:17 PM To: U2 Users List Subject: Re: [U2] New Rocket Toolkit for .NET Is this toolkit based on the MV.NET code that was licensed/purchased quite some time ago or is it something different? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, 28 February 2013 10:05 a.m. To: U2 Users List Subject: Re: [U2] New Rocket Toolkit for .NET Hey Will, The U2 Toolkit for .NET (U2NETDK) can be thought of as 2 pieces: U2NETDK Provider - this is the API that provides access to U2 from .NET, superceding both ADO.NET and UO.NET. It is complete free and can be downloaded from our website: http://u2.rocketsoftware.com/resources/downloads U2NETDK Developer - this gives you Visual Studio Add-ins for U2 which makes development a lot easier. This is chargable on a per machine basis. Both are provided in the same package, the Developer portion will require an authorization key to use, other Provider will work exactly the same as you are used to with the older UO.NET. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, February 27, 2013 1:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] New Rocket Toolkit for .NET Does this new toolkit cost something? We already use .NET with Universe, but we'd be interested in getting this if it's an upgrade or something to what we have. Or is it something that *comes with* a Universe install so we should just ask for our free disk? Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 full screen editor
Symeon: Well, there you go! Over here, we often figure if it's cheaper we'll make it work. :-) Untitled Page - Original Message - *From:* syme...@gmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 2/26/2013 12:38 AM *Subject:* Re: [U2] UV full screen editor I seem to remember when we used such things that the costs in the uk where pretty similar. Wintegrate also did some emulations that accuterm did not and we needed those, but the other problem I have with Accuterm is that it is very American (not being rude here) so it has some funny (to us Europeans) way of doing things, and always looks very old fashioned. Each to their own I guess -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 25 February 2013 20:14 To: U2 Users List Subject: Re: [U2] UV full screen editor Symeon: That may be true these days, but wIntegrate has always been significantly more expensive than AccuTerm, and AccuTerm always worked better with Linux and SSH (rather than using SSL like wIntegrate does/did). Also, AccuTerm's licensing was significantly easier to manage (we still have clients struggling with the old site-licensing of wIntegrate). Nowadays, however, we use UniObjects to connect to our servers and run our application. Even now, I still use AccuTerm mostly, and VS2010 (which I mostly dislike - but that's just the environment). I've tried xLr8, BST, Brian's but there's always something that just trips me up each and every day with these packages. Every time I get one of these set up and running, something changes or something I do on a common basis is just very difficult to accomplish. :-( Bill Untitled Page - Original Message - *From:* syme...@gmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 2/25/2013 10:56 AM *Subject:* Re: [U2] UV full screen editor Also If you want an editor integrated into your terminal emulator I have always found wintegrate to be the best solution out there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 full screen editor
Probably the simplest, and easiest to use, would be AccuTerm http://www.asent.com. It is a terminal emulator, probably the best in the MV market, that includes an editor. You can call the editor while within the UV environment (that is, logged into an account) straight from the command line. So, instead of... :ED SOMEFILE ItemId ...you would change the ED verb with WED, like... :WED SOMEFILE ItemId This solution is probably best if you spend most of your time inside the UV environment and aren't interested in installing software other than a telnet client. In addition, it is probably the cheapest of all telnet clients you can use, assuming you place any value on your time. :-) HTH, Bill - Original Message - *From:* nirvanwijesek...@hotmail.com *To:* u2-users@listserver.u2ug.org *Date:* 2/25/2013 6:04 AM *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
Re: [U2] UV full screen editor
Symeon: That may be true these days, but wIntegrate has always been significantly more expensive than AccuTerm, and AccuTerm always worked better with Linux and SSH (rather than using SSL like wIntegrate does/did). Also, AccuTerm's licensing was significantly easier to manage (we still have clients struggling with the old site-licensing of wIntegrate). Nowadays, however, we use UniObjects to connect to our servers and run our application. Even now, I still use AccuTerm mostly, and VS2010 (which I mostly dislike - but that's just the environment). I've tried xLr8, BST, Brian's but there's always something that just trips me up each and every day with these packages. Every time I get one of these set up and running, something changes or something I do on a common basis is just very difficult to accomplish. :-( Bill Untitled Page - Original Message - *From:* syme...@gmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 2/25/2013 10:56 AM *Subject:* Re: [U2] UV full screen editor Also If you want an editor integrated into your terminal emulator I have always found wintegrate to be the best solution out there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Quick Question on u2 toolkit for .net
Really? I've never heard that, or seen that either. Bill - Original Message - *From:* david.pet...@bluefinity.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/14/2013 7:33 AM *Subject:* 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] SETPTR
Doug: Great eye! I ran into this after moving to Windows 2008 R2 (which is 64 bit) back in the summer of 2010. Fortunately, Wally worked to get this fixed in UD v7.2.7. I've implemented UDT.OPTIONS 116 ON ever since, but it wasn't set in our demo account on this particular server. I must have moved the demo account from somewhere else. I knew this was familiar but couldn't remember what. Anyway, thanks very much! :-) Bill - Original Message - *From:* dave...@u2logic.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/2/2013 7:02 AM *Subject:* Re: [U2] [UD] SETPTR Hi Bill: We had this problem a while ago. You might try setting this UDT option. UDT.OPTIONS 116 OFF/ON Regards Doug www.u2logic.com Applications and tools for U2 shops On Fri, Feb 1, 2013 at 7:12 PM, Bill Haskett wphask...@advantos.net wrote: David: The ping doesn't respond on either machine. The printer is local on both dbms servers, not a network printer; although it is shared. Bill --**--** - Original Message - *From:* dgr...@dagconsulting.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 2/1/2013 5:54 PM *Subject:* 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-bounces@listserver.**u2ug.orgu2-users-boun...@listserver.u2ug.org [mailto:u2-users-bounces@**listserver.u2ug.orgu2-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-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://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] [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
Re: [U2] [UD] SETPTR
David: The ping doesn't respond on either machine. The printer is local on both dbms servers, not a network printer; although it is shared. Bill - Original Message - *From:* dgr...@dagconsulting.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 2/1/2013 5:54 PM *Subject:* 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
/...but I've created systems with master triggers that read a list of subordinate triggers from a control file and call them in order./ This appears to be the best practices of managing triggers in UD. Once explained, it seems the most logical method of managing triggers and allowing individual dbms accounts to use local versions of trigger subroutines. Bill - Original Message - *From:* br...@brianleach.co.uk *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 1/29/2013 1:08 AM *Subject:* Re: [U2] Triggers in Universe Peter Yes, they are still cached but you can derive the name - it's an overhead but I've created systems with master triggers that read a list of subordinate triggers from a control file and call them in order. Then these can have a version stamp appended when catalogued. IN practice I found the overhead of reading the list was minimal compared with the overheads on calling the trigger in the first place, and because it's happening all the time on a busy system that control file is constantly cached in memory anyway. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: 28 January 2013 23:26 To: U2 Users List Subject: Re: [U2] Triggers in Universe Could use the trigger program to call one or more external subroutines based on the trigger action required? I understand that the external subroutines are not cached and can be updated without needing to stop/start the master trigger. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Saturday, 26 January 2013 20:19 To: U2 Users List Subject: Re: [U2] Triggers in Universe Remember also that triggers, as subroutines, are cached in memory so if you recompile a trigger the changes won't be picked up by any processes that have not logged off or returned to TCL. Brian Sent from my iPad On 25 Jan 2013, at 22:18, Bobby Worley bwor...@coburns.com wrote: [snipped] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
Greg:
Can you do something like:
:select {FileName} WITH EVAL OCONV(MPAR.STATUS.DATE, 'D') =
This works fine on UniData in PICK mode, where an invalid conversion
returns a null (an empty string).
HTH,
Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Wednesday, 30 January 2013 8:38
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Searching for 'Bad' Dates
All,
Can anyone help me with a query to find instances where an external date has been
written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE ..
./... (the dates would be in the fomat: '12/16/12', but this field is set with
external formatting so I end up bringing back everything. Is there a way I can
'turn off' formatting for this field within the query?
Thanks,
Greg
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
Greg:
That was the point. What happens is an externally formatted date isn't
OCONV'd, if the dbms is configured to return an empty string for a bad
conversion. I've got this set up on our systems like this. So, when I
run the following code:
2 Dev (0)- BPTEST CRT 'OConverted Date--: ' : OCONV('01/29/13', 'D') ; END
Compiling Unibasic: SAVEDLISTS\BpTest_547690521 in mode 'p'.
compilation finished
OConverted Date--:
...I get what you're looking for, an empty string for dates filed in
external format. In UniData I need UDT.OPTIONS 56 ON.
Bill
- Original Message -
*From:* coe...@american.edu
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 1/29/2013 3:09 PM
*Subject:* Re: [U2] Searching for 'Bad' Dates
Bill,
This is only returning those records that do not have a value in
MPAR.STATUS.DATE. Unfortunately I looking for records where an external
date has been written instead of the internal date.
Greg
From: Bill Haskett wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
Date: 01/29/2013 06:01 PM
Subject:Re: [U2] Searching for 'Bad' Dates
Sent by:u2-users-boun...@listserver.u2ug.org
Greg:
Can you do something like:
:select {FileName} WITH EVAL OCONV(MPAR.STATUS.DATE, 'D') =
This works fine on UniData in PICK mode, where an invalid conversion
returns a null (an empty string).
HTH,
Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Wednesday, 30 January 2013 8:38
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Searching for 'Bad' Dates
All,
Can anyone help me with a query to find instances where an external date
has been written to a date field? I would like to use ...WITH
MPAR.STATUS.DATE LIKE ..
./... (the dates would be in the fomat: '12/16/12', but this field is set
with external formatting so I end up bringing back everything. Is there a
way I can 'turn off' formatting for this field within the query?
Thanks,
Greg
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
Just as an aside, there's also a UOLOGIN global cataloged routine that is always called before a UO login (I created it with that name). It's a very handy routine to use to manage connections. Bill - Original Message - *From:* aeger...@pobox.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 1/25/2013 11:23 AM *Subject:* Re: [U2] [UD] Disabling/blocking ODBC Dan, Is this also available in Universe? (Release 10.3.7 for windows) (Allen - Sent from my paperweight) On Jan 25, 2013, at 1:49 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: 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. If you are under a support contract, contact your support provider and they should be able to help you get ODBCLOGIN up and running. 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 bradley.sch...@usbank.com Sent: Friday, January 25, 2013 11:23 AM To: 'U2 Users List' Subject: [U2] [UD] Disabling/blocking ODBC We may need to figure out a way to disable ODBC access to UniData due to data access concerns. I've set up connections before, but have never approached ODBC from this perspective. I'm hoping there's a service we can turn off or a port we can block. One possible constraint is that we still need to be able to connect to UniData via DataStage. We use the native unidata connector, so I'm hoping that won't get in the way. Thoughts? UniData 7.1 AIX 5.3 TIA, 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
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 - Original Message - *From:* peter.che...@firstmac.com.au *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 1/23/2013 6:31 PM *Subject:* Re: [U2] Universal COMO Hi Will, I think the biggest *con* you might come up against will be concurrency issues with multiple processes writing to the one central location. If you had a solution where each session log is unique amongst all processes then that would work very well. You will still need to clean it out though whether it be one big centralised dir or one for each account. As others have indicated, and if you run a unix box, then an overnight cron job to find and clean out any COMO dirs older than a set number of days would an option for you. I would suggest that you identify any logs that were important historically to you and roll them first. Probably zipping them up and moving them to an archive area would be viable. Google may even cough up a log rotate script that you could adapt. Regards, Peter -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 4:28 To: u2-users@listserver.u2ug.org Subject: [U2] Universal COMO By default, Universe will create several files in each account you create. Like SAVEDLISTS, and ED... one of these default files is COMO which is where you can stick session logs. We use this constantly to monitor the output of phantoms, for review and debugging the next day. The logs are emailed to myself and some other programmers here. By altering the VOC entries in the accounts, we could have a central, universal COMO for all accounts, instead of one for each account. I see a *pro* in this, for the ease of cleaning up old logs from years ago, obviously no longer needed, which can be done from the O/S level. What might be a *con* ? Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- 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] How to check which sproc is called by user
Andy: The first place I'd look for any UO errors is the UO error log. In UD, you need to create a serverdebug item in the @UDTHOME directory (in my case this is in E:\U2\ud). The contents of this item is: udcs 10 E:\U2\ud\log\udcs\udcs.log ...which indicates maximum logging and the log should go to the location indicated. From there I've always been able to track down UO problems. They've mostly been with my UOLOGIN globally cataloged routine, but sometimes I see other problems. I'm not sure how to do this in UV, but it should be fairly easy to track down once you activate UO logging. HTH, Bill P.S. I set all of my UO connections to timeout in 5 minutes (in my E:\U2\unishared\unirpc\unirpcservices file). This causes the Basic Developer's Toolkit to not work properly, but you can use any other development client you want, as long as it sends a keepalive. - Original Message - *From:* akra...@rammutual.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 1/8/2013 6:43 AM *Subject:* Re: [U2] How to check which sproc is called by user I will chime in since I work with Ravi and I am dealing with this issue along with him. Thanks for the response Brian, PORT.STATUS should be useful for our situation. I'll try and be a little more specific and hopefully I know what I'm talking about: We have a web application which is using UniObjects and we are randomly getting multiple (we've seen as many as 9) user sessions in the LISTU which appear to be hung and it's causing us to reach our user limit. We have debugged the web application and verified that all sessions are being closed properly so we do not believe that it's on the web side of things. Although, we cannot duplicate this problem in the live application either, so we cannot say for sure it's not on the web side. My first thought was that the application is calling a PICK subroutine that is stalling (possibly waiting for input or stuck in an infinite loop or something). So, at this point all we know is we are getting these stalled sessions but we don't know how. Hopefully with PORT.STATUS we can see whether is a PICK subroutine that is stalling? Now, to limit the severity of this problem we discovered there is a Timeout property of the UniSession object. However, it seems in the past we were advised against setting this parameter by Rocket support and that this timeout should be handled in the unirpcservices file in the unishared directory? Does that sound right? UniAdmin uses the timeout in the unirpcservices file so I don't think we would want to shorten the timeout and be booted from UniAdmin sooner. Thanks in advance for any responses. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, January 08, 2013 3:35 AM To: 'U2 Users List' Subject: Re: [U2] How to check which sproc is called by user If it is a session hang you're possibly looking at locking issues so check the lock table to see what is waiting and also check for any group locks that persist. If it is UniVerse, It's also a good idea to check the errlog file in the uv account: if that does not exist, create it as a zero length file (you can go into the UV account and ED UFD errlog and just file it) and it will log the last 100 errors. If you can catch the session that has hung you can use the PORT.STATUS command to see where they were and their calling stack. Phil's idea of using the remote item security subroutine to audit calls is good once you've managed to identify the routine concerned, but it doesn't help you get to that point. How is your application constructed? Is it terminal based, UniObjects, Web? If it is terminal based, create a COMO on the LOGIN for that user session and see if that helps find it. If it is UniObjects based and you can clearly identify the user (and you have the time and space) and nothing else has worked, you can actually watch their session using a network tracer. I think we need to know a little more about the context of the problem. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ravindranath Wickramanayake Sent: 07 January 2013 21:55 To: u2-users@listserver.u2ug.org Subject: [U2] How to check which sproc is called by user Hi U2 Guru's Can I tell when a sproc was last executed or who executed it. If so how. Some way to get statistics and access logs. Reason we are asking this is we are having a session hang issue we have tracked it down to a session user but have no clue which sproc did the call to trouble shoot. Thanks in advance ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV win 2008 Workgroup - ED / COPY very slow
Manu: Have you checked with U2 support? What have they said? Bill Haskett - Original Message - *From:* e...@infodata.lu *To:* u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org *Date:* 12/11/2012 8:20 AM *Subject:* [U2] UV win 2008 Workgroup - ED / COPY very slow Hi group, Using Universe 11.1.9 on win2008/workgroup logged as Administrator, I get a perf trouble when using ED, COPY, BUILD.INDEX, the process use 10 seconds to start. After look inside, I detect each one use uv's subroutine -PERMISSIONS which seems check the user's write right on the file to update. The execution of these subr (non documented) use 10 seconds. I suspect a security/rights problem but where ? Any suggestions ? Thanks Manu Fernandes ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Creating XML nodes with a namespace prefix
Hey Gregor. Could you put that on the wiki? If not, could I? Thanks, Bill - Original Message - *From:* gregor.sc...@pentanasolutions.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 12/10/2012 10:11 PM *Subject:* [U2] Creating XML nodes with a namespace prefix If anyone has tried to use the UV XDOM api to create nodes with a namespace prefix (and failed), there is a non-obvious method you need to use. We recently had a need to do this, and with the help of Rocket U2 support we were able to achieve the required XML output. I have documented the method here for those inclined to use the XDOM API in this way, as it is obscure enough to not be obvious: http://gdoesu2.wordpress.com/2012/12/10/creating-xml-elements-with-a-namespace-prefix/ Regards, Gregor 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
