Re: [U2] [Universe] [Windows]
Check your directories, specifically any TMP/TEMP directories, for a maximum number of entries. HD Root directories, savedlists, ph, anything that would have temporary files created in them. This caught me once before and it took forever to stumble on the idea that windows does seem to have a maximum number of files condition. If you can delete a handful of temp files in a directory and the read starts to work, that's the one you need to be looking at. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 10:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Universe] [Windows]
This sounds like it's back to permissions. If it was UNIX, then I'd say the owner/user for the records(files) was deleted from the system and then editing them assigns a new, valid, owner. You said you're on windows, though. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] Yes, Yes, No, Yes, No :) Here's an update. IF I open one of these in notepad, and just add an extra char to the end and then file it, the last modified date now appears for that file, but none of the other ones of course. And doing that, makes it so, in TCL, I can now EDit that particular record, but none of the other records, which still cause the fatal abort. So that's odd. But at least, I can go through and edit every single bleeping entry in the directory, file it, and make it editable again in Universe. WHY this has occurred, and WHETHER it's going to continue with new entries, is still an open question -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 11:30 am Subject: Re: [U2] [Universe] [Windows] Can you open the .csv file (the Windows File item within the Windows Directory) with a text editor? Does it look like text? Is there a sub-directory within this directory? Are the permissions of this .csv file the same as the rest of the items within the directory? You're not getting that stupid desktop.ini item within the directory, are you? Just a few thoughts. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 5/6/2014 10:04 AM *Subject:* [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Dictionary question
Just to make sure, you're wanting FIELD 178 and the first value of that field. Correct? Because you have a length of 1, left justified I want to make sure you're not looking for the first character of the 178th field. Maybe if you showed what you're wanting and what you're getting, instead, then we'd be sure to give you an answer that makes sense. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, February 04, 2014 11:45 AM To: U2 Users List Subject: Re: [U2] UniVerse Dictionary queston Martin: This is the only way to do accomplish the defined task in UniData. Maybe @RECORD178,1 is the preferred method in UV. Bill Untitled Page - Original Message - *From:* msch...@martinscholl.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 2/4/2014 11:33 AM *Subject:* [U2] UniVerse Dictionary queston UniVerse. I want to create a dictionary item that extract value 178,1 I thought 1. I 2. EXTRACT(@RECORD,178,1,0) 3. . 4. . 5. 1L 6. S Would do but it does not give me the desired result. Any suggestions? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Please recommend a Pick-based upgrade for QuickBooks (SECURITY=Unclassified)
Normally, I'd be quick to agree with you, Mike, but I've had a little exposure to GAAP. For the request that generated Georges response, I'd have no problem whatsoever echoing the recommendation to consider GAAP as a possible U2 solution to replace Quickbooks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of HENDERSON MIKE, MR Sent: Wednesday, December 18, 2013 12:34 PM To: 'U2 Users List' Subject: Re: [U2] Please recommend a Pick-based upgrade for QuickBooks (SECURITY=Unclassified) I'm sorry, but the chances of me buying anything from a company whose website says under the heading Latest News that something is scheduled for release Jan '07 is very, very close to zero. In my view, a company that hasn't updated its website in seven years is - if still in business at all - obviously way out of touch and not going to be the supplier of anything I care about. Bah, humbug! Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George R Smith Sent: Thursday, 19 December 2013 6:20 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Please recommend a Pick-based upgrade for QuickBooks http://www.gaap.com/ Pick based for over 30 years. George -Original Message- From: Wjhonson Sent: Wednesday, December 18, 2013 10:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] Please recommend a Pick-based upgrade for QuickBooks For a client who is currently using QuickBooks. Just essentially the same functionality as QuickBooks, doesn't need added bells and whistles. No one who's going to charge 50K please :) 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 The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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
Maybe it's a good thing you're not interviewing me, Kevin. My immediate answer would be I don't know. Let me check the documentation and get back to you. I've never had to do anything like that so it's not something I'd know off the top of my head. I'm sure there's probably and OCONV format that would get me started but. Oh! I know! I'd as this list! silly smile Does that count? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, December 14, 2013 8:15 AM To: U2 Users List Subject: Re: [U2] [OT] Interview Questions David, I've used many of these questions in the past but where it fell down was that it didn't give any real picture of technical ability. The one question I've been using lately to assess technical thinking is how would you calculate the last Thursday in a month? The answers have been everywhere from accurate to sheer ridiculous. The unexpected takeaway from this question is that it has helped to identify people who simply want to answer quickly without thinking - not a good trait unless the answer is right and to date that's happened a total of zero times - vs people who think first and then give a reasoned response. I've just found it too easy for people to stretch the truth when explaining their technical ability, so I'm asking questions intended to give some evidence. On Saturday, December 14, 2013, David Sharp wrote: Here is something I have used: What single project or task would you consider the most significant accomplishment in your career so far? * Can you give me a detailed overview of the accomplishment? * Tell me about the company, your title, your position, your role, and the team involved. * What were the actual results achieved? * When did it take place and how long did the project take. * Why you were chosen? * What were the 3-4 biggest challenges you faced and how did you deal with them? * Where did you go the extra mile or take the initiative? * Walk me through the plan, how you managed to it, and if it was successful. * Describe the environment and resources. * Describe your manager's style and whether you liked it or not. * Describe the technical skills needed to accomplish the objective and how they were used. * Some of the biggest mistakes you made. * Aspects of the project you truly enjoyed. * Aspects you didn't especially care about and how you handled them. * How you managed and influenced other, with lots of examples. * How you changed and grew as a person. * What you would do differently if you could do it again. * What type of formal recognition did your receive? Regards, David Sharp Date: Fri, 13 Dec 2013 12:27:18 -0800 From: i...@keyway.net javascript:; To: u2-users@listserver.u2ug.org javascript:; Subject: Re: [U2] [OT] Interview Questions Please email me in regards to your ads. I am currently in between contracts/assignments/projects and looking for my next assignment. Multivalue languages I have been programming in: * CACHE (language: MV BASIC) * INFORMATION (language: INFO/BASIC) * jBASE (language: jBC, jBASE BASIC, jBASIC) * MENTOR System (language: DATA/BASIC, DATABASIC, DATA BASIC) * MVENTERPRISE (language: MVENTERPRISE BASIC) * MVON/ONWARE (language: ONWARE BASIC) * OPENINSIGHT (language: BASIC+) * OPENQM, QM (language: QMBASIC) * PICK, Advanced PICK, D3 (language: PICK BASIC) * Power95 (language: DATA/BASIC, DATABASIC, DATA BASIC) * REALITY System (language: DATA/BASIC, DATABASIC, DATA BASIC) * REVELATION, Advanced REVELATION (language: R/BASIC, REVELATION BASIC) * UNIDATA (language: UNIBASIC) * UNIVERSE (language: UNIVERSE BASIC) * UNIVISION (language: UVBASIC) * WebSphere DataStage (language: DSBASIC, DataStage BASIC) Robert Norman, Multivalue Programmer/Analyst (951) 541-1668 On 10/7/2013 7:35 PM, Kevin King wrote: This is not specifically a job posting, but I do have ads up on Monster and LinkedIn looking for talent. At the risk of confessing too much, I have historically been far too easy in the interview process. As a result, I have had some less-than-excellent hires and spent far too much time and money trying to rescue underperforming and/or recalcitrant staff. Therefore, I'm planning to be much more discriminating this time around, and am building a series of technical questions to help quickly identify those that have the right skills, abilities, and attitude for our team compared to those who may not. That being said, I have a question for the group: Technical questions aside, what are the best interview questions you've asked, been asked, or otherwise heard about that help differentiate between the candidates worthy of additional consideration vs. those that are not? Each company is different of course, but that aside I'm hoping to
Re: [U2] Exporting to File regularly
Hi David, Though this is not a great option, you could create a new file and either just copy the current contents of the file you want to watch into it or just a fingerprint record if all you need is a record exists type of monitoring. Then a simple SELECT of the first file followed by an NSELECT of the fingerprint file would give you a resulting active select list, if any, of the new records which you could use to update your fingerprint file. These would be done inside a new., small program that you could then send an email message from. Run it from the OS's task scheduler and it's fully automated. Like I said, this is probably NOT the best solution but it gives you another approach to consider, depending on your needs. It also is completely separate from the current system you have with no interference of the vendors application. I'd be happy to give you more specifics if you want to try this. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Campbell Sent: Tuesday, December 10, 2013 9:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Exporting to File regularly Hi Everyone, I'm new to universe (a complete noob) and I couldn't quite find what I was looking for on google and I've been smashing my face against this for a while until I stumbled upon this mailing list so I was wondering if anyone could help me out here. I'm writing a script that will hopefully alert me via email whenever a new record is added to a particular universe file, if there is a better way to do this I would be all ears. I'm working around another proprietary system which operates on universe and I dont know enough about universe to really say for sure what is proprietary and what is universe standard code and the proprietary stuff is covered in NDA's and no touchy hand slappy orders so I cannot really modify the way it works, I just need to know when a new entry appears, preferably via an smtp email. My Current plan works like this I'm looking to regularly (every 5 minutes) output data into a text or csv file, doesn't matter really, so long as it is not full of characters that batch scripts hate and it can happen in an automated fashion. The closest thing I can get to what I want right now is SP.ASSIGN HS LIST FILE.NAME LPTR this lists all the records and dumps them in a spool file under /var/spool/uv/ and then a script I have written in the past retrieves that spool file for me, I have trained that spool file to look for specific markers in the first line of the file and apply a particular script to it This spooled print job gives me a list of the records that I can then sort numerically, pick the highest number, check that number against what the number was last time and alert me via email if its different. Ultimately I would love for a regularly running script to just output the highest record (maybe sort numerically and give me the highest number and dump just that number into a file on the unix box for me to retrieve and the work with. Any help would be greatly appreciated! -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regul arly-tp42264.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UvRestore error
One of the ways that I've used in the past to check for @VM's, @SVM's, and @TM's is to do a simple SELECT of the file, a SAVE.LIST, then EDIT.LIST. A simple scan usually shows the errant record ID's because they are usually longer than the rest of the record ID's making them stick out like a sore thumb. You could also make an I-descriptor that just does a DCOUNT on @ID. Then you can simply select the I-descriptor for the bad keys. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, November 26, 2013 1:50 PM To: U2 Users List Subject: Re: [U2] UvRestore error The examples I posted below appear to be when it builds the INDEX on the table CLIENT. I'm just not sure if it's referring to the actual ID of the record.. or a field inside that CLIENT record? Date: Tue, 26 Nov 2013 13:44:34 -0800 From: jhes...@momtex.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] UvRestore error There appear to be some in the examples you posted. They appear as ý in a lot of terminal emulations. You can verify how they appear on your screen by editing one into a record: ED BP MV.TEST I ^253 -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, November 26, 2013 1:39 PM To: U2 Users List Subject: Re: [U2] UvRestore error John, Thanks for the reply. I'll write a utility to parse the ID's on that table and see if I find any @VM's.. I did notice some unconventional ID's being used when I did a LIST by ID.. probably best to remove those and re-index. Chris Date: Tue, 26 Nov 2013 13:35:42 -0800 From: jhes...@momtex.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] UvRestore error I'm just guessing, but I think the problem is a value mark (ASCII 253) embedded in the item IDs. The 3rd party backup software we use also balks at backing up items with value marks in the ID because they're not valid UTF-8 characters. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, November 26, 2013 8:16 AM To: u2-users@listserver.u2ug.org Subject: [U2] UvRestore error Hello, I noticed an error when doing a UVRESTORE. We have a UniVerse region with client information and data. When doing a UVRESTORE I get the following Restoring c:\CHRIS/I_CLIENT (21:35:56) Restoring c:\CHRIS/I_CLIENT/INDEX.000 (21:35:56) Restoring c:\CHRIS/I_CLIENT/INDEX.001 (21:35:58) Unable to write item Z2988M8280ýA38385000 . Unable to write item Z29864873 ýA38385000 . Unable to write item Z2986R6163ýA38385000 . Unable to write item Z2986G5760ýA38385000 . Unable to write item Z2986D3700ýA38385000 . Unable to write item Z2986C2830ýA38385000 . Unable to write item Z2986C26938000ýA38385000 . Unable to write item Z2986C2670ýA38385000 . It looks like it's producing the error when attempting to write the INDEX (I_CLIENT/INDEX.001). Does anyone know how to fix these types of errors or what they might mean? Thanks. Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Mysterious Error Message
Since it's in the Redback log, that's where I'd be looking. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 9:06 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Sorry for the typo. We thought of looking for the program giving the error. We do not have the source code for it, so even if we found it as a string, we could not read the rest of the object code. Even so, I have tried doing an ESEARCH on some of the SB files, but I have yet to find it. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, November 25, 2013 11:57 AM To: U2 Users List Subject: Re: [U2] Mysterious Error Message Given that Corrupt is missing a T (itself being corrupt?) I would think it's not an OS related message. Since your HPUX, can you do a file content find in unix for RECORD CORRUP! to find out where it's coming from? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, November 25, 2013 11:46 AM To: U2 Users List Subject: [U2] Mysterious Error Message We use UniData/HPUX w/ SB and Redback. We are running Epicor's Avanté which uses iConnect. For arguments sake, I have 3 UniData accounts: TEST, PILOT LIVE. I have 3 web sites (TEST, PILOT LIVE) that connect as you would expect. 3-4 weeks ago, a change was made in Sales Order Entry in SB. I had to make a minor tweak for this to work via the web sites. All was good with all three web sites. Due to unrelated issues, our TEST account has a temporary stand-alone copy of DMSECURITY. Other people on my team have made a few changes in SB Sales Order Entry and asked that I verify that the web site still worked. One change was in TEST and another (untested) one was in PILOT. Order Entry was now failing on both web sites, but LIVE was still working. The change in PILOT was unrolled, but we still had the problem. The actual error we are getting in the Redback log is II RECORD CORRUP! - CONTACT SYSTEM ADMINISTRATOR If the problem were only in TEST, I would blame my local copy of DMSECURITY. Since the problem is also in PILOT but NOT in LIVE (which share the standard DMSECURITY file), this tells me it is not the DMSECURITY file, but rather something that is local to each account. Has anyone seen this before? Any thoughts or suggestions? JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/k-Kr3x0p41ASyOY-OqenD4kPtPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejozkD2l8XVUagQJeIadHv6loYKrgQJeIadHv6loYKrovhupd7ar_nVeZT3hOU_RXBQQhP79Lcnd7bXDbnhIyyHuWfaxVZicHs3jq9JcTsTsS03fBitfyp-fdFJAu00U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rvjpd79I5-Aq83iS4QPiWq81IJivNBlKxEw6ENH4Qg3vQFF7PtPvrjguueZ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCNAq3zqbbPX9EVushjdTdEThjvKztcQsCQrEFLThjhd79J6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVJxZ5VAQsFLZvAXTsd7bz_nKnjh7csCYNsQsLKsJt6OaaJXEYG7DR8OJMddFCQPtPtPo0c-l9Q-9DUYSCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JZdAQsCMnWhEwdbojjdbFEw6OR9_6lmW6y0qz6Ijh0d_iCAvdTdTg5hgbhsZS93 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] moving UV from one server to another (windows)
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 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] moving UV from one server to another (windows)
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 Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Stumped on a WRITE failure
Hi folks, I have a UNIDATA program that is being run from a Windows Task Schedule entry that is failing on a WRITE statement and I'm having a heck of a time figuring out why. Here are some key observations and discoveries so far: - The WRITE statement has an ON ERROR that is not being executed. - Just before the WRITE statement, FILEINFO shows the file is OPEN and has a permissions value of 6 (R/W). - It does not always fail but when it does fail, it will continue to fail on that input file every time the program is run from the Windows Scheduler. - If I run the program directly, from my logged in session, it works perfectly every time. - Every tool I have says there is nothing wrong with the file I'm writing into. - There are 3 indexes on this file but they are all flagged to allow duplicates. - There are 2 triggers on this file that monitor and report for specific record ID's. (Very basic/simple logic.) I've pretty much exhausted ways, and things, that I know of to check for. This is a very specific problem that is somehow related to the data that is being processed. Can anyone think of something else I can check for? Thanks for your thoughts, Bob W ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stumped on a WRITE failure
Hi John, It is random and I've not been able to identify a common indicator between the files that work and the ones that don't. The source files are coming in from the other side of the world so it's happening in the very early hours of the morning. By the time I get in, the scheduler has tried to run the program on the bad file a couple of times. I've not tried using COMO, yet. This is exactly why I like this list so much. I'll put this in right away. I'll dig into the udterrorlog file, too, as Colin suggests. Thanks! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, August 16, 2013 10:17 AM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Bob, Can you re-create the error on demand (from the Scheduler) or is it random? Have you tried capturing anything with a COMO? Are these on NEW records, existing records or both? Are the indexes being updated to reflect the writes even if the primary file is not? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, August 16, 2013 1:09 PM To: U2 Users List Subject: [U2] Stumped on a WRITE failure Hi folks, I have a UNIDATA program that is being run from a Windows Task Schedule entry that is failing on a WRITE statement and I'm having a heck of a time figuring out why. Here are some key observations and discoveries so far: - The WRITE statement has an ON ERROR that is not being executed. - Just before the WRITE statement, FILEINFO shows the file is OPEN and has a permissions value of 6 (R/W). - It does not always fail but when it does fail, it will continue to fail on that input file every time the program is run from the Windows Scheduler. - If I run the program directly, from my logged in session, it works perfectly every time. - Every tool I have says there is nothing wrong with the file I'm writing into. - There are 3 indexes on this file but they are all flagged to allow duplicates. - There are 2 triggers on this file that monitor and report for specific record ID's. (Very basic/simple logic.) I've pretty much exhausted ways, and things, that I know of to check for. This is a very specific problem that is somehow related to the data that is being processed. Can anyone think of something else I can check for? Thanks for your thoughts, Bob W ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/1jWVIpdEIzD71OpEVusdTdEThjvKztcQsCQrEFLThjhd79J6W arZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVJV2P_TjvW_ 8FELLcLZuVtdcsZO8VMQsFLzKmKzp5dmWbfaxVZicHs3jq9J4TsTsS03fBitfyp-fdFJAu00 U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rp7fLCPiS4QPiWq81y rqGTE6y2I3h1FEw0k5xE96zh0XIzSU-rKrg9A6 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Stumped on a WRITE failure
We have not installed these tools. Not sure they could help as I'm not able to generate the problem, yet. I've read where others were talking about SysInternals but never got around to really checking it out. Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Friday, August 16, 2013 10:17 AM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Can you trace the process using the SysInternals tools? Sent from my iPhone On 16 Aug 2013, at 18:09, Woodward, Bob bob_woodw...@k2sports.com wrote: Hi folks, I have a UNIDATA program that is being run from a Windows Task Schedule entry that is failing on a WRITE statement and I'm having a heck of a time figuring out why. Here are some key observations and discoveries so far: - The WRITE statement has an ON ERROR that is not being executed. - Just before the WRITE statement, FILEINFO shows the file is OPEN and has a permissions value of 6 (R/W). - It does not always fail but when it does fail, it will continue to fail on that input file every time the program is run from the Windows Scheduler. - If I run the program directly, from my logged in session, it works perfectly every time. - Every tool I have says there is nothing wrong with the file I'm writing into. - There are 3 indexes on this file but they are all flagged to allow duplicates. - There are 2 triggers on this file that monitor and report for specific record ID's. (Very basic/simple logic.) I've pretty much exhausted ways, and things, that I know of to check for. This is a very specific problem that is somehow related to the data that is being processed. Can anyone think of something else I can check for? Thanks for your thoughts, Bob W ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Stumped on a WRITE failure
Hi John, Not applicable in this case. The scheduler runs the program every two hours. The files are staged from another server via an OS level COPY and are only something like 5 to 20k. Good thought, though. Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, August 16, 2013 11:12 AM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Bob, If you are loading data from an outside source, might you be grabbing a data file that is not 100% written to disk? I have seen this a number of times. The 2 solutions to this that I recommend are either: 1) look for a 2nd file that indicates the 1st is 100% complete (be sure to delete the stub file after processing) or 2) look at the size or date/time of the data file, sleep for 10 seconds, then look again. Repeat this process until the criteria does not change Might or might not be applicable in your case. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, August 16, 2013 2:05 PM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Hi John, It is random and I've not been able to identify a common indicator between the files that work and the ones that don't. The source files are coming in from the other side of the world so it's happening in the very early hours of the morning. By the time I get in, the scheduler has tried to run the program on the bad file a couple of times. I've not tried using COMO, yet. This is exactly why I like this list so much. I'll put this in right away. I'll dig into the udterrorlog file, too, as Colin suggests. Thanks! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, August 16, 2013 10:17 AM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Bob, Can you re-create the error on demand (from the Scheduler) or is it random? Have you tried capturing anything with a COMO? Are these on NEW records, existing records or both? Are the indexes being updated to reflect the writes even if the primary file is not? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, August 16, 2013 1:09 PM To: U2 Users List Subject: [U2] Stumped on a WRITE failure Hi folks, I have a UNIDATA program that is being run from a Windows Task Schedule entry that is failing on a WRITE statement and I'm having a heck of a time figuring out why. Here are some key observations and discoveries so far: - The WRITE statement has an ON ERROR that is not being executed. - Just before the WRITE statement, FILEINFO shows the file is OPEN and has a permissions value of 6 (R/W). - It does not always fail but when it does fail, it will continue to fail on that input file every time the program is run from the Windows Scheduler. - If I run the program directly, from my logged in session, it works perfectly every time. - Every tool I have says there is nothing wrong with the file I'm writing into. - There are 3 indexes on this file but they are all flagged to allow duplicates. - There are 2 triggers on this file that monitor and report for specific record ID's. (Very basic/simple logic.) I've pretty much exhausted ways, and things, that I know of to check for. This is a very specific problem that is somehow related to the data that is being processed. Can anyone think of something else I can check for? Thanks for your thoughts, Bob W ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/1jWVIpdEIzD71OpEVusdTdEThjvKztcQsCQrEFLThjhd79J6W arZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVJV2P_TjvW_ 8FELLcLZuVtdcsZO8VMQsFLzKmKzp5dmWbfaxVZicHs3jq9J4TsTsS03fBitfyp-fdFJAu00 U9GX33VkDa3JsrjbJQ-d3rqptKDNEn8lrxrW0E-l9Q-9DUYSCShU02rp7fLCPiS4QPiWq81y rqGTE6y2I3h1FEw0k5xE96zh0XIzSU-rKrg9A6 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/2DRPosd2gQrhp7ee3D4THCXCQrEFLThKCqejqdQkTXEFECzAS zt5d-WdSrCQrEFCzBZBxwQsCN6Fe4GhTPMkxFqtokrm-cGNVsSxFqtokrm-cGNVsSe86zBPX FLZvATC7zhOyDRXBQkQT-ojohjd7b_bnhIyyHsQsEYG7DR8OJMddECSjtPtPo0c-l9Q-9DUY SCShU03wCHIcfBisEeRNJcKTjUQdJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JZNNMS2_id4 1Fr2qpFtd40NdJlrQ3h1m1EwQQg0a2MQ4zhEwtShXsvdTdDo5ApJT-v9f ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/5fHCMUg40USyOess7e9LndTdEThjvKztcQsCQrEFLThjhd79J 6WarZQrITdEThjd7bXb31EVdydis9kzLDwF3iQWMESJYplzOVJ3iQWMESJYplzOVIsgd7bDT jvW_9Lcf6zB5fHTbEFFLYMCMyCqen-mKzp55mVEVhVkffGhBrwqrjdICXCXCM0pYGjFYjfNV JdIzM071dnoovaAVgtHzqptKDNErrjbJQ
Re: [U2] [UD] BASIC Code Failing
If this occasional problem is consistently the same lines then just validate the insert afterwards: 0106.1 MV.CNT = DCOUNT(SUPREC2,@VM) 0107: SUPREC = INSERT(SUPREC,2,1,0,POLREC6) 0107.1 IF SUPREC2,1 NE POLREC6 THEN 0107.2MV.CNT2 = DCOUNT(SUPREC2,@VM) 0107.3IF MV.CNT = MV.CNT2 THEN GOSUB REPORT.ERROR 0107.4 END With this logic, you're verifying the value and that a new value is, in fact, being created in the attribute. You may want to tweak the logic a bit to match your exact specifics, like if POLREC6 is a non-null value, but this should give you an idea. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Friday, July 26, 2013 6:42 AM To: U2 Users List Subject: Re: [U2] [UD] BASIC Code Failing This is all very interesting to hear. I have a customer who has occasional instances when they complain that a supply receipt has failed to update the last receipt fields. This is the code: 0092: *** 0093: 7000:* UPDATE SUPPLIES 0094: *** 0095: SUPKEY = POLREC2 0096: GOSUB 7300 * reads suprec 0097: IF SUPREC EQ THEN 0098:RETURN 0099: END 0100: SUPREC16,1 = SUPREC16,1 + OCONV(POLREC13,RCPSUB,MD4) 0101: NEWQTY = 0 0102: LOCCNT = DCOUNT(SUPREC15,@VM) 0103: FOR LOCSUB = 1 TO LOCCNT 0104:NEWQTY = NEWQTY + SUPREC16,LOCSUB 0105: NEXT LOCSUB 0106: SUPREC3 = NEWQTY 0107: SUPREC = INSERT(SUPREC,2,1,0,POLREC6) 0108: SUPREC = INSERT(SUPREC,11,1,0,POLREC11,RCPSUB) 0109: SUPREC = INSERT(SUPREC,12,1,0,FIELD(POLKEY,.,1)) 0110: SUPREC = INSERT(SUPREC,13,1,0,VNDKEY) 0111: GOSUB 7400* writes suprec 0112: RETURN : I have never been able to figure out why line 106 gets executed but 107 - 110 do not. My customer refers to it as the lawnmower man. dale ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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
Not a problem, Tony. I never want someone to just blindly accept a quick fix. It would be great if manufacturer's would commit the kind of resources you mention when I submit an intermittent/can't replicate/seems to only be on my system type of problem, but my experience is with this kind of one-off, small potato client's problem, I'm lucky if I get a first-tier, new to their helpline, fresh out of training rookie to even give me a call to verify if I knew what I was saying. To me, a work-around is far more desirable to try and gather more information in the error reporting than to leave the situation as is with nothing to give back to the system owner besides a shoulder shrug. If the problem changes, this is as good a piece of information as any that it's most likely not data related and that the problem really does need the type of resources you mentioned. As always, Tony, you have very good, valid information that you generously share with everyone. We all appreciate that of you. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, July 26, 2013 10:13 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] BASIC Code Failing From: Woodward, Bob If this occasional problem is consistently the same lines then just validate the insert afterwards... Dale, don't accept that solution. (Sorry Bob) Note, we're still not really Sure yet that this is a good definition of the problem, just a working theory... Overall, the problem seems to be that some statements can't be trusted to be executed - not specific statements or functions, but random lines of code in different systems. The problem might not be something wrong with the statements themselves but just where they happen to be in the program. The issues might be fixed with some extra code, or by putting the few lines in question into an internal subroutine just to move the bytecode to a different location. But a solution like that is random and subject to just moving the problem to an as yet unknown and perhaps more critical location. When you can't trust a line of code to be executed in a linear series of statements the reliability of everything we do comes into question. If this is indeed the problem, fixing it by writing work around code isn't good for anyone here. It's tough to call in Support when the problem is so vaguely defined but having sat in the chair as a QA Manager and Product Manager for a related product, I can tell you the resolution starts with finding sites that seem to have this issue, assigning someone to the task of gathering data and scheduling tests on the target systems, getting engineers to verify the issue, and establishing a pattern from which a problem can be diagnosed. I don't know who has to initiate that with Rocket Software but I'd assume it starts with paying clients filing formal requests with Support and committing to follow-through toward a resolution. And while re-compilation might indeed be the correct fix, don't accept a tier-1 techie solution intended to just get you off the phone! HTH 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
Re: [U2] [UD] BASIC Code Failing
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
Re: [U2] Flip Case command?
You can use CONVERT. DATA1 = abcde...ABCDE... (The full alphabet lower case AND uppercase) DATA2 = ABCDE...abcde... (Again, full alphabet but now start with uppercase) INPUT DATA.IN DATA.FLIPPED = CONVERT(DATA1,DATA2,DATA.IN) That should get you what you want. If you want to do something with any other characters, just add them to the list. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, July 05, 2013 2:50 PM To: u2-users@listserver.u2ug.org Subject: [U2] Flip Case command? Does anyone know of an internal command of any sort that will allow one to flip the case of some input stream ? That is, not just make it all lower case or all upper case, but actually make all lower case input upper, AND at the same time all upper case input lower. That is truly flip the case of each input character ? I'm going to write my own, unless someone has one. Thanks ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TCL input and response logging such as COMO
Hi maybe! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Joslyn Sent: Thursday, April 25, 2013 12:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] TCL input and response logging such as COMO Hi. I'm with Tom on this - capturing EVERYTHING that EVERYONE types is a lot of data - much of it not interesting. May be smarter to identify the verbs that can actually cause 'change' and put them in a remote voc. That way you can put both preventive and detective controls on them as well. PRC can do this for you, too. (PRC is software configuration management / software life cycle management/ IT Governance for U2). This is crazy but .call me maybe! Susan Joslyn SJ+ Systems Associates, Inc. sjos...@sjplus.com (954-796-9868) Message: 6 Date: Wed, 24 Apr 2013 17:54:36 -0400 From: Tom Whitmore tewhitm...@ratex.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] TCL input and response logging such as COMO Message-ID: BA2E471C9317804EB8470750F458BD9801EC7D8D3D38@public Content-Type: text/plain; charset=us-ascii Hi, Can you provide more information on what you are trying to capture? (edits, list commands, etc.) I suspect that you may be able to put security on the commands you are concerned with and address the problem with less pain. The problem with using the command stack or a COMO is that they are easily modifiable. You may want to consider using a Unix Tee to capture all output which isn't as easy to turn off. Having said that, I'm not a Unix expert so I can't offer the command string you should use but I'm sure someone will provide it. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Scott Zachary Sent: Wednesday, April 24, 2013 4:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL input and response logging such as COMO For PCI compliance, we are tasked to log/capture all TCL entries and responses. I am familiar with COMO, which is one possible solution. 1) What other TCL logging methods are available in UniVerse besides COMO? 2) What AIX Unix tools are available to capture keyboard input and responses at TCL? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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
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
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
Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER
I forget exactly how I solved a similar problem sending control codes to a printer like that but it had something to do with an automatic reset code being automatically sent between an initialization string and the actual data. I think the way I figured it out was by changing the port of the printer definition to write the output to a disk file then using a hex editor to pick apart the codes in the data stream. At least that's what comes to my mind. Good luck. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Monday, March 25, 2013 10:32 AM To: U2 Users List Subject: Re: [U2] SENDING BARCODE COMMANDS TO OKI PRINTER As I look at the book, your codes are exactly right. Perhaps the char(10) is getting post-translated from linefeed to return-linefeed. I suggest you try a 9-digit code for comparison. On Mon, 25 Mar 2013, Nancy Fisher wrote: I'm having some problems getting the internal barcode to print on an okidata 320 turbo: Sending to an aux printer: PRINT CHAR(18): PRINTTEST PRINT PRINT CHAR(27):CHAR(16):CHAR(65):CHAR(8):CHAR(2):CHAR(0):CHAR(1):CHAR(1):CHA R(2):C HAR(2):CHAR(3):CHAR(1): PRINT CHAR(27):CHAR(16):CHAR(66):CHAR(10):1234567890 PRINT PRINT PRINT CHAR(20) I get the TEST and sometimes I get '67890'. I could certainly have the Aux codes messed up, or just about anything as this is my first attempt at sending codes to an OKIDATA. It says it's the IBM PPR emulation Mode, and has the internal barcode (using code 39). Nancy Fisher Peninsula Truck Lines, Inc Federal Way, Washington 253/929-2040 Visit our Website http://www.peninsulatruck.com www.peninsulatruck.com mailto:nan...@peninsulatruck.com nan...@peninsulatruck.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] History..
Let's not forget the all important VOC file. From the command prompt, usually a colon : you can type the RUN command as outlined below, but there are also stored paragraphs and the locally cataloged programs that are in the VOC file. You can see a lot of those with LIST VOC. There are also other types of entries in the VOC file so not everything that comes up from the LIST command is going to be executable. You can get a lot of the available commands by typing the command HELP UNIDATA or HELP UNIQUERY. Other help commands are HELP SQL and HELP UNIBASIC. The HELP command by itself has all this but it's kind of difficult to pull that information out of what you're given in just the HELP command. Folks here are very helpful and very knowledgeable. Welcome to the world of Multivalues. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Wednesday, March 20, 2013 11:25 AM To: U2 Users List Subject: Re: [U2] History.. John answered your sentence stack commands, so I'll take a shot at how to execute a program. Typically programs are stored in type 1 files, aka directories or folders, (terminology usually depends upon base operating system, *ix or windows). There's a corresponding file containing the object code. To execute the program, you would typically enter RUN filename programname at the command prompt. Then, there's cataloged code which is a method of storing object code so that it can be referenced by multiple users, (unless it's cataloged locally). You can also execute a program directly from its native host without entering UniData if you know where the binary executable lives. The last three are included only for some semblance of completeness, I believe that the answer you're looking for right now is paragraphs two and three. On 3/19/2013 11:17 AM, Sathya wrote: Hi all,.. I'm pretty new to Unidata. just wanted to know the command for listing the history of commands and how to select nth number of command. Also how to execute a unidata program. I know my questions will be very simple. But as I'm entirely new to this, unable to find that anywhere :-( TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ISO Date Format
I guess you need to be on a more current version of UD than 6.1 for this to work. DYMD[4,2,2] works just fine but everything I've tried is proving that in this version, anyway, there MUST be a delimiter between the parts of the date. It does not matter what delimiter as I've tried space, period, slash, even a comma but for both ICONV and OCONV adding a quote of any type, null/space/dash/etc, to the numeric only gives undesired results. I have to strip out the delimiter in OCONV results and make sure some kind of delimiter is there for ICONV to get me back to the internal date value. An interesting note is using the OCONV(IDATE,'D-YMD[2,2,2]') format, the dash can be replaced with the digits 5 to 9 but using the digits 0 to 4 result in an output delimited with a space. Would have been acceptable (and nice) to have been able to get 13003011 but oh well. I guess I could use 'D5YMD[2,2,2]' to give me the value 13503511 just as well. Fun with dates! BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, March 11, 2013 8:08 AM To: U2 Users List Subject: Re: [U2] ISO Date Format By the way, you can also completely eliminate the dash (or slash, etc.) delimiters: OCONV( 16507 , DYMD[4'',2'',2] ) -- 20130311 ICONV( 20130311, DYMD[4'',2'',2] ) -- 16507 Notice that ICONV'ing the OCONV'd or OCONV'ing the ICONVd result gets you bat to where you started. That makes it particularly useful in dict conversion fields. I learned that on this list, but I do not remember from whom. There are too many people I've learned from. cds On 11 March 2013 13:56, Jeff Schasny jscha...@gmail.com wrote: Has anyone come up with an OCONV string that will product an ISO standard date (-MM-DD)? After a vendor insisted on this last week I ended up creating a subroutine called by an I descriptor but it seems like there should be an easier way. A quick trip through the Universe Basic manual, my old Prime Info-Basic manual, and Pick Basic: A programmer's guide didn't shed any light. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] ISO Date Format
With a couple of corrections, yes, it did work. PRINT OCONV(16507,D-YMD[2,2,2]:@VM:MCN) This returned the value 130311. You were missing the last 2 and the year is 2013, not 2012. This was a good thought, though. Cool -Original Message- From: Charles Stevenson [mailto:stevenson.c...@gmail.com] Sent: Monday, March 11, 2013 10:59 AM To: U2 Users List Cc: Woodward, Bob Subject: Re: [U2] ISO Date Format Bob, I'm curious,on UD6.1 does this work, using 2 conversion codes with a value mark between? : OCONV( 16507, D-YMD[2,2,]: @VM: MCN ) -- 120311 cds On 3/11/2013 12:16 PM, Woodward, Bob wrote: I guess you need to be on a more current version of UD than 6.1 for this to work. DYMD[4,2,2] works just fine but everything I've tried is proving that in this version, anyway, there MUST be a delimiter between the parts of the date. It does not matter what delimiter as I've tried space, period, slash, even a comma but for both ICONV and OCONV adding a quote of any type, null/space/dash/etc, to the numeric only gives undesired results. I have to strip out the delimiter in OCONV results and make sure some kind of delimiter is there for ICONV to get me back to the internal date value. An interesting note is using the OCONV(IDATE,'D-YMD[2,2,2]') format, the dash can be replaced with the digits 5 to 9 but using the digits 0 to 4 result in an output delimited with a space. Would have been acceptable (and nice) to have been able to get 13003011 but oh well. I guess I could use 'D5YMD[2,2,2]' to give me the value 13503511 just as well. Fun with dates! BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, March 11, 2013 8:08 AM To: U2 Users List Subject: Re: [U2] ISO Date Format By the way, you can also completely eliminate the dash (or slash, etc.) delimiters: OCONV( 16507 , DYMD[4'',2'',2] ) -- 20130311 ICONV( 20130311, DYMD[4'',2'',2] ) -- 16507 Notice that ICONV'ing the OCONV'd or OCONV'ing the ICONVd result gets you bat to where you started. That makes it particularly useful in dict conversion fields. I learned that on this list, but I do not remember from whom. There are too many people I've learned from. cds On 11 March 2013 13:56, Jeff Schasny jscha...@gmail.com wrote: Has anyone come up with an OCONV string that will product an ISO standard date (-MM-DD)? After a vendor insisted on this last week I ended up creating a subroutine called by an I descriptor but it seems like there should be an easier way. A quick trip through the Universe Basic manual, my old Prime Info-Basic manual, and Pick Basic: A programmer's guide didn't shed any light. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
The sample has a LOCKED which the lock is not obtained so that's okay. It also has a THEN clause with a WRITE statement so the lock is released. The only condition not covered is if there is no record currently in the file. The lock is obtained and unless there is a WRITE or RELEASE below the last END, then the lock is held by the program until the program terminates. You are correct and there should be an ELSE clause added with a RELEASE to cover all conditions. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Sunday, February 10, 2013 2:36 PM To: Jon Wells; U2 Users List Subject: Re: [U2] Record locks (Unidata 7.2) In the example below what happens to the lock? Does it release if the write is not executed? If not shouldn't you have a RELEASE statement at the end after the last END? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Saturday, 9 February 2013 3:57 To: U2 Users List Subject: Re: [U2] Record locks (Unidata 7.2) I should add that (in our test account) I switched to the READU statement along with a LOCKED clause - READU STU.REC FROM STU.FILE, STU.ID LOCKED CRT STU.ID: RECORD IS LOCKED END THEN STU.REC48 = INST.CRED STU.REC49 = INET.CRED WRITE STU.REC ON STU.FILE, STU.ID END I locked one of the records in the list I was processing. When the program was working on that record, the CRT statement was executed, and the program moved right along processing the rest of the list; and record I had locked was not updated. Looking through the 'UniBasic Commands Reference' PDF, I found 'RECORDLOCKED (file.var, rec.id.expr)'. Perhaps this could be used within a LOOP to control things, allowing terminal input where the user can choose what to do about the record lock? I've decided to write the data to a new file, so this is no longer a big issue for me. If I had created the program using our vendor's tool kit, the generated code would have added all the appropriate gunk the system uses for record locks. The responses have been interesting as I've been looking for a chance to better understand how Unidata shops handle locks. Thank you, Jon Wells From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Sent: Friday, February 8, 2013 2:30 AM Subject: Re: [U2] Record locks (Unidata 7.2) I think people understand exactly what you're saying, but disagree. Most applications don't use the more rigorous coding for having a Locked clause that provides additional information to the user, retries, etc. That's not wrong, it's just not necessary ... depending on the site. That said, when we used to have a lot of people in an office and a dumb terminal beeping was a recognized message to everyone, it was OK (generally) to just do the READU. These days with more alternative UIs, thick-client, thin-client, web services, mobile, etc, there's no one to hear that beep. So for modern development I would agree that you really don't want an unconditional lock hanging around, you want a Locked clause with logic to rollback the transaction and exit gracefully, perhaps with a message sent to the site admin. The penalty for Not having a Locked clause with a new UI is that the port will hang, the UI will receive a timeout (which many clients aren't prepared to process), and the DBMS port could be sitting there indefinitely with no one aware of the condition. This can cascade to multiple ports until suddenly everything grinds to a halt and GUI users around the world are unable to access the app. I believe some heads will be nodding here because I hear about this happening occasionally. T From: Wjhonson Then you're misunderstanding what I'm saying. From: Kevin King +1. Well stated. Woodward, Bob wrote: In an active user session where users are obtaining a lock for a length of time, you're right. There are lots of times, though, that lock intervention is not a benefit. It all depends on the need of the application and many situations where I would highly recommend using the default locking system of READU. From: Wjhonson I wouldn't however *recommend* this approach to locking as the user can never tell if their terminal is waiting on a lock, or just hung in some other odd manner, or perhaps processing a batch of something. So it's rather a nasty trick to play on the user, to just use READU without a LOCKED clause ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
You should have written it something like this: TRY.AGAIN: READU STU.REC FROM STU.FILE, STU.ID LOCKED CRT STU.ID: RECORD IS LOCKED SLEEP 2 GOTO TRY.AGAIN END THEN STU.REC48 = INST.CRED STU.REC49 = INET.CRED WRITE STU.REC ON STU.FILE, STU.ID END You have to add the label TRY.AGAIN: so you have a jump point then add the SLEEP command for 2 seconds and lastly the GOTO command so after the SLEEP expires, execution remains at the READU command. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Friday, February 08, 2013 9:57 AM To: U2 Users List Subject: Re: [U2] Record locks (Unidata 7.2) I should add that (in our test account) I switched to the READU statement along with a LOCKED clause - READU STU.REC FROM STU.FILE, STU.ID LOCKED CRT STU.ID: RECORD IS LOCKED END THEN STU.REC48 = INST.CRED STU.REC49 = INET.CRED WRITE STU.REC ON STU.FILE, STU.ID END I locked one of the records in the list I was processing. When the program was working on that record, the CRT statement was executed, and the program moved right along processing the rest of the list; and record I had locked was not updated. Looking through the 'UniBasic Commands Reference' PDF, I found 'RECORDLOCKED (file.var, rec.id.expr)'. Perhaps this could be used within a LOOP to control things, allowing terminal input where the user can choose what to do about the record lock? I've decided to write the data to a new file, so this is no longer a big issue for me. If I had created the program using our vendor's tool kit, the generated code would have added all the appropriate gunk the system uses for record locks. The responses have been interesting as I've been looking for a chance to better understand how Unidata shops handle locks. Thank you, Jon Wells From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Sent: Friday, February 8, 2013 2:30 AM Subject: Re: [U2] Record locks (Unidata 7.2) I think people understand exactly what you're saying, but disagree. Most applications don't use the more rigorous coding for having a Locked clause that provides additional information to the user, retries, etc. That's not wrong, it's just not necessary ... depending on the site. That said, when we used to have a lot of people in an office and a dumb terminal beeping was a recognized message to everyone, it was OK (generally) to just do the READU. These days with more alternative UIs, thick-client, thin-client, web services, mobile, etc, there's no one to hear that beep. So for modern development I would agree that you really don't want an unconditional lock hanging around, you want a Locked clause with logic to rollback the transaction and exit gracefully, perhaps with a message sent to the site admin. The penalty for Not having a Locked clause with a new UI is that the port will hang, the UI will receive a timeout (which many clients aren't prepared to process), and the DBMS port could be sitting there indefinitely with no one aware of the condition. This can cascade to multiple ports until suddenly everything grinds to a halt and GUI users around the world are unable to access the app. I believe some heads will be nodding here because I hear about this happening occasionally. T From: Wjhonson Then you're misunderstanding what I'm saying. From: Kevin King +1. Well stated. Woodward, Bob wrote: In an active user session where users are obtaining a lock for a length of time, you're right. There are lots of times, though, that lock intervention is not a benefit. It all depends on the need of the application and many situations where I would highly recommend using the default locking system of READU. From: Wjhonson I wouldn't however *recommend* this approach to locking as the user can never tell if their terminal is waiting on a lock, or just hung in some other odd manner, or perhaps processing a batch of something. So it's rather a nasty trick to play on the user, to just use READU without a LOCKED clause ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
Sorry Mecki but I think you have the LOCKED in the wrong place. At least in my version of Unidata. It comes before the THEN segment so the full, proper syntax would be: READU xxx FROM xxx, xxx ON ERROR Xxx what to do if a hard error like file not open END LOCKED Xxx what to do if locked END THEN Xxx what to do if lock is obtained and record is read END ELSE Xxx what to do if lock is obtained but record does not exist. END There is a second format for the READU command but it's a lot easier if the OP just reads about, himself, in the HELP information. HELP UNIBASIC READU from ECL in Unidata will get him that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, February 07, 2013 12:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Record locks (Unidata 7.2) The READU statement has a LOCKED clause that is true if a record is locked. You can put all your locking ha logic in there. READU record FROM filevariable,itemID THEN code if record exists and isn't locked (optional) LOCKED code to handle locked record condition (optional) END ELSE code if record doesn't exist (required) END Now if you put that into a loop you can display a message and give the user the option to try again or abort. And if you put the code into a subroutine you can use that in all your programs with a single line like this. CALL SR.READU(record,filevariable,ItemID,Option,Err) On 06/02/2013 21:52, Jon Wells wrote: Hi all, I have not looked at the world of record locks since my R83 Pick days. I'm hoping to add the ability for the program I'm working on to: * Check if a record is locked * Wait until the lock is removed * Once the lock is removed, or if the record is not locked: * Lock the record * Perform the WRITE statement I'm hoping someone can share an example of how to accomplish this in UniBasic. Thank you, Jon Wells Campbell University ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
With the LOCKED clause included, the READU does not pause. You can put anything you want in that section but just realize that the statement fully executes and proceeds to the next command. If you want to simulate wait until I obtain the lock then you just have to create this into a small loop. Something like this: LOCKWAIT: READU xxx FROM yyy, zzz LOCKED Xxx commands, if you want to do anything other than just loop GOTO LOCKWAIT END THEN Xxx got the lock and have read the record so do whatever Xxx14 = I was here END ELSE Xxx got the lock but it's a new record. Xxx = Xxx14 = I was here END Do some more stuff. WRITE xxx ON yyy, zzz You don't HAVE to do anything in the locked section other than just goto your label. You could add a small delay, if you wanted, just so your process isn't in a super tight loop chewing up all your computers horsepower. Also, remember, you need to do something with the lock, even if it's a new record. Either a WRITE or RELEASE statement on the zzz key value. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Thursday, February 07, 2013 12:47 PM To: U2 Users List Subject: Re: [U2] Record locks (Unidata 7.2) What I'm wondering is; what can I put into the 'Xxx what to do if locked' section whereby it waits until the record lock clears, once it clears, set my own lock, read the record, alter the record, and then write the record (which would release my lock)? Thank you, Jon Wells From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, February 7, 2013 12:35 PM Subject: Re: [U2] Record locks (Unidata 7.2) Sorry Mecki but I think you have the LOCKED in the wrong place. At least in my version of Unidata. It comes before the THEN segment so the full, proper syntax would be: READU xxx FROM xxx, xxx ON ERROR Xxx what to do if a hard error like file not open END LOCKED Xxx what to do if locked END THEN Xxx what to do if lock is obtained and record is read END ELSE Xxx what to do if lock is obtained but record does not exist. END There is a second format for the READU command but it's a lot easier if the OP just reads about, himself, in the HELP information. HELP UNIBASIC READU from ECL in Unidata will get him that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, February 07, 2013 12:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Record locks (Unidata 7.2) The READU statement has a LOCKED clause that is true if a record is locked. You can put all your locking ha logic in there. READU record FROM filevariable,itemID THEN code if record exists and isn't locked (optional) LOCKED code to handle locked record condition (optional) END ELSE code if record doesn't exist (required) END Now if you put that into a loop you can display a message and give the user the option to try again or abort. And if you put the code into a subroutine you can use that in all your programs with a single line like this. CALL SR.READU(record,filevariable,ItemID,Option,Err) On 06/02/2013 21:52, Jon Wells wrote: Hi all, I have not looked at the world of record locks since my R83 Pick days. I'm hoping to add the ability for the program I'm working on to: * Check if a record is locked * Wait until the lock is removed * Once the lock is removed, or if the record is not locked: * Lock the record * Perform the WRITE statement I'm hoping someone can share an example of how to accomplish this in UniBasic. Thank you, Jon Wells Campbell University ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
You're exactly right. The only time you REALLY need the LOCKED clause if there is some need to change that approach. That was what I attempted to show in my first response. I guess I was a bit terse in that one, though. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthonys Lists Sent: Thursday, February 07, 2013 2:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Record locks (Unidata 7.2) On 07/02/2013 20:46, Jon Wells wrote: What I'm wondering is; what can I put into the 'Xxx what to do if locked' section whereby it waits until the record lock clears, once it clears, set my own lock, read the record, alter the record, and then write the record (which would release my lock)? Somebody will correct me if I'm wrong, but I thought that was exactly what READU did! If you don't provide a LOCKED clause, READU will hang and wait until the lock clears, then read and lock the record. As I say, check the docu and make sure I'm right ... I've never had to bother much with locks ... Cheers, Wol Thank you, Jon Wells ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
In an active user session where users are obtaining a lock for a length of time, you're right. There are lots of times, though, that lock intervention is not a benefit. It all depends on the need of the application and many situations where I would highly recommend using the default locking system of READU. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, February 07, 2013 3:41 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Record locks (Unidata 7.2) I wouldn't however *recommend* this approach to locking as the user can never tell if their terminal is waiting on a lock, or just hung in some other odd manner, or perhaps processing a batch of something. So it's rather a nasty trick to play on the user, to just use READU without a LOCKED clause -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Feb 7, 2013 2:43 pm Subject: Re: [U2] Record locks (Unidata 7.2) You're exactly right. The only time you REALLY need the LOCKED clause if there is some need to change that approach. That was what I attempted to show in my first response. I guess I was a bit terse in that one, though. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthonys Lists Sent: Thursday, February 07, 2013 2:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Record locks (Unidata 7.2) On 07/02/2013 20:46, Jon Wells wrote: What I'm wondering is; what can I put into the 'Xxx what to do if locked' section whereby it waits until the record lock clears, once it clears, set my own lock, read the record, alter the record, and then write the record (which would release my lock)? Somebody will correct me if I'm wrong, but I thought that was exactly what READU did! If you don't provide a LOCKED clause, READU will hang and wait until the lock clears, then read and lock the record. As I say, check the docu and make sure I'm right ... I've never had to bother much with locks ... Cheers, Wol Thank you, Jon Wells ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
READU blah blah blah THEN/ELSE WRITE blah blah blah END Can't get much more straight forward than that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Wednesday, February 06, 2013 1:53 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Record locks (Unidata 7.2) Hi all, I have not looked at the world of record locks since my R83 Pick days. I'm hoping to add the ability for the program I'm working on to: * Check if a record is locked * Wait until the lock is removed * Once the lock is removed, or if the record is not locked: * Lock the record * Perform the WRITE statement I'm hoping someone can share an example of how to accomplish this in UniBasic. Thank you, Jon Wells Campbell University ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
In Unidata the problem would be that the trigger has to be cataloged globally, not locally. I'm not sure how to do that in Universe, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, January 25, 2013 1:33 PM To: U2 Users List Subject: [U2] Triggers in Universe I'm up against a wall here - trying to use triggers for the first time, on Universe. Can't seem to get my test to work - Universe on AIX: RELLEVEL 001 X 002 11.1.9 003 PICK 004 PICK.FORMAT 005 11.1.9 BASIC BDW TRIGTEST Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' * Compilation Complete. CATALOG BDW TRIGTEST TRIGTEST cataloged. .L TRIGTEST TRIGTEST 001 V 002 BDW.O/TRIGTEST 003 B 004 BNP 005 006 PICK.FORMAT 007 S²N²P²I²A²E²H 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP 009 BDW.O CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR EACH ROW CALLING 'TRIGTEST'; Unable to locate trigger program BDW.O/TRIGTEST. -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.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 6.1.13/AIX 5.3 Stops Unexpectedly
Hi Kevin, I can't help you with what you're asking for, directly, but as a suggestion on something to try, if you make a small script that dumps the currently running processes into a date/time stamped text file, new for each time it runs, then you could set it up in the system scheduler to run every x number of minutes. You could schedule it to start running at something like 1:00am. It might help to isolate exactly what processes are running just before the lock-up and give you some more information to work with. I'm guessing that it's a process and not something like the /tmp location getting full for some reason. Good luck. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, January 16, 2013 10:40 AM To: U2 Users List Subject: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly We have a customer with a box as described in the subject that has recently been experiencing something odd. Overnight, the system will just lock up and stop responding. Normally there isn't anyone doing anything at night; the backup runs, that sort of thing, but then some days when they come in early in the morning the entire machine is unresponsive. Connecting with telnet there is no login prompt, just a blank screen. It happened last night and I've confirmed from the logs that the backup (which is using a split mirror backup strategy) ran successfully and finished at 2:02am. Sometime between then and 4am, when there really should not have been anything going on, it just locked up. Are there any logs that can be enabled on AIX to record some evidence for these kinds of failures so we can figure out what's going on with this machine? -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client question
I've never had this problem but I'd look at the terminal emulation you're using. You might try using a different terminal type then see if you can replicate the problem. I would imagine you don't use the insert key since it seems to mess you up (only at TCL???) so maybe redefine just that key? Good luck. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 2:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB Client question Hi All, This is a question that has been puzzling me for years and I am finally going to ask if there is help for me. :-) What happens is I will be typing at real TCL (on HP9000 Unix running SB+ 5.2) and I will accidentally hit the 'Insert' key that it just to the right of the 'Backspace' key. Well, after I do this my backspace will no longer work. What I see on the screen when I enter the backspace key is the letters to the left are displayed to the right of the cursor preceded by a space. I can enter the replacement character(s) and they will work but when I look at the line to check it the line will always have: '*--:' appended to the end of the line. It does not matter what I do after this to try to get back to what was working before. (I do plenty of backspacing so this is not a small problem.) The only thing that works is to logoff and then log back on. This will reset the editor to work correctly again. I have tried hitting the 'Insert' key again, thinking that it would switch back to the original mode, to no avail. Has this happened to anyone else? Or am I the only lucky one with this problem? If it has happened to you, do you have another fix besides logging off the system? Thanks in advance, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client question
I would not expect changing terminal type to fix the problem once you've got the problem. Do you have some specific coding or other requirements for the Wyse60? Does the same thing happen if you start a clean session using Wyse50 or Wyse120? I know I'm not helping discover what to do to fix your problem but without a bunch of time and the ability to duplicate the problem the best I can really help with is to try and avoid the problem in the first place. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 2:50 PM To: U2 Users List Subject: Re: [U2] SB Client question The terminal emulation is Wyse60. I don't use the insert key when at TCL because I just enter 'I' at the command prompt when I am in the editor and there is never a reason for insert key to be pressed otherwise. I am not sure how to reassign the key but I don't think that I want to do that because I do use the insert key when I am in the full-screen editor or SB+ screen. I went to the Setup tab and changed the terminal type to VT220 and the editor worked like it should but when I changed it back to Wyse60 it had the same old problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, December 07, 2012 2:40 PM To: U2 Users List Subject: Re: [U2] SB Client question I've never had this problem but I'd look at the terminal emulation you're using. You might try using a different terminal type then see if you can replicate the problem. I would imagine you don't use the insert key since it seems to mess you up (only at TCL???) so maybe redefine just that key? Good luck. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 2:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB Client question Hi All, This is a question that has been puzzling me for years and I am finally going to ask if there is help for me. :-) What happens is I will be typing at real TCL (on HP9000 Unix running SB+ 5.2) and I will accidentally hit the 'Insert' key that it just to the right of the 'Backspace' key. Well, after I do this my backspace will no longer work. What I see on the screen when I enter the backspace key is the letters to the left are displayed to the right of the cursor preceded by a space. I can enter the replacement character(s) and they will work but when I look at the line to check it the line will always have: '*--:' appended to the end of the line. It does not matter what I do after this to try to get back to what was working before. (I do plenty of backspacing so this is not a small problem.) The only thing that works is to logoff and then log back on. This will reset the editor to work correctly again. I have tried hitting the 'Insert' key again, thinking that it would switch back to the original mode, to no avail. Has this happened to anyone else? Or am I the only lucky one with this problem? If it has happened to you, do you have another fix besides logging off the system? Thanks in advance, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client question
Ya know, someone needs to come up with a fat keyboard for those of us with fat fingers. smile -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 3:09 PM To: U2 Users List Subject: Re: [U2] SB Client question The problem is only for the session that I mistakenly entered the insert key. I can open another session - which I often do - and continue on with my tasks. I was just hoping that there was a keystroke that I could use to reset the default value to the insert key. I try to be careful but sometimes my fat finger will co-hit the backspace and insert key and then the fun begins again. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, December 07, 2012 3:01 PM To: U2 Users List Subject: Re: [U2] SB Client question I would not expect changing terminal type to fix the problem once you've got the problem. Do you have some specific coding or other requirements for the Wyse60? Does the same thing happen if you start a clean session using Wyse50 or Wyse120? I know I'm not helping discover what to do to fix your problem but without a bunch of time and the ability to duplicate the problem the best I can really help with is to try and avoid the problem in the first place. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 2:50 PM To: U2 Users List Subject: Re: [U2] SB Client question The terminal emulation is Wyse60. I don't use the insert key when at TCL because I just enter 'I' at the command prompt when I am in the editor and there is never a reason for insert key to be pressed otherwise. I am not sure how to reassign the key but I don't think that I want to do that because I do use the insert key when I am in the full-screen editor or SB+ screen. I went to the Setup tab and changed the terminal type to VT220 and the editor worked like it should but when I changed it back to Wyse60 it had the same old problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, December 07, 2012 2:40 PM To: U2 Users List Subject: Re: [U2] SB Client question I've never had this problem but I'd look at the terminal emulation you're using. You might try using a different terminal type then see if you can replicate the problem. I would imagine you don't use the insert key since it seems to mess you up (only at TCL???) so maybe redefine just that key? Good luck. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Friday, December 07, 2012 2:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] SB Client question Hi All, This is a question that has been puzzling me for years and I am finally going to ask if there is help for me. :-) What happens is I will be typing at real TCL (on HP9000 Unix running SB+ 5.2) and I will accidentally hit the 'Insert' key that it just to the right of the 'Backspace' key. Well, after I do this my backspace will no longer work. What I see on the screen when I enter the backspace key is the letters to the left are displayed to the right of the cursor preceded by a space. I can enter the replacement character(s) and they will work but when I look at the line to check it the line will always have: '*--:' appended to the end of the line. It does not matter what I do after this to try to get back to what was working before. (I do plenty of backspacing so this is not a small problem.) The only thing that works is to logoff and then log back on. This will reset the editor to work correctly again. I have tried hitting the 'Insert' key again, thinking that it would switch back to the original mode, to no avail. Has this happened to anyone else? Or am I the only lucky one with this problem? If it has happened to you, do you have another fix besides logging off the system? Thanks in advance, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 6.1.15 Oddity
Hi Kevin, Two times in my Unidata career I've had a problem like this where something doesn't work in a subroutine. My work around, both times, was to add a simple line of code at the beginning of the program. Usually just assigning a value to a new, unused, variable like JUNK=JUNK is all it would take. With it, the program would work flawlessly but if I took it back out, or commented it out, the odd behavior returned. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, November 07, 2012 4:26 PM To: U2 Users List Subject: [U2] Unidata 6.1.15 Oddity We have a customer who has a system that was rebooted a couple days ago. Since then, and only in one certain subroutine, when doing an MCU conversion on a multivalued list, the ASCII 253 value marks are replaced with ASCII 221. Understanding that the difference between an lower and upper case A is 32 in the ASCII table (97 - 65), it seems like Unidata is treating the delimiters like normal characters. But again, this only happens in certain programs. If I extract the lines of code that exhibit this behavior into its own program, the problem does not occur. Any ideas what might be causing this and only in one subroutine? Both my test program and the real program with the problem are $BASICTYPE U. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selection Suggestions for using UV instead of SQL
I use it for EQUATE names to remind me that I can't change it when I'm waist deep in a program. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, October 18, 2012 9:40 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL What is the purpose of using a $ in one of your variable names? -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Oct 18, 2012 9:24 am Subject: Re: [U2] Selection Suggestions for using UV instead of SQL George: I wrote a TREE.CHECK program that does the following: 2 Dev (0)- TREE.CHECK MASTER -IINDEX_2 Index Check: MASTER, INDEX_1 ?Key... Indexed Value. ?350 1432 1434 G ST CONDO ASSOC ?50 ABBOTT WOOD TOWNHOMES ASSOC ?70 ASPEN HEIGHT CONDO OWNERS ASSC ?80 AUTUMN RIDGE HOMEOWNERS' ASSOC ?90 BONNIE CUSACK ESTATES ASSOC ?110 BOSTON SQUARE CONDOMINIUMS ?115 BRIARCLIFF TOWNHOMES ASSOC ?130 BROOKSHIRE CONDOMINIUM ASSOC ?120 BROOKVIEW CONDOMINIUM ASSOC ?135 CAMPBELL CREEK DUPLEX OWNERS ?140 CAPE HATTERAS AT COMMODORE PRK ?170 CEDARCREST CONDO ASSOC ?175 CHANDELLE ACRES P/O ASSOC ?215 CHUGACH MEADOWS II CONDO ASSOC ?160 CHUGACH MEADOWS TOWNHOME ASSOC ?150 CHUGIAK HANGARS ASSOCIATION ?185 CLEAR CREEK CONDOMINIUM ASSOC ?190 CONCORD HILL HOMEOWNER ASSOC ?180 CREEKSIDE TWNHOMES CONDO ASSOC ?200 CREEKVIEW CONDO ASSOC ??? [N]ext Pg, [P]rev Pg, [F]irst Pg, [L]ast Pg, [A]ccept, [S]top ? I wonder if this would help? Bill By the way, I did post the LSELECT code to pickwiki, under UniQuerySource. - Original Message - *From:* ggal...@wyanokegroup.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 10/18/2012 6:15 AM *Subject:* Re: [U2] Selection Suggestions for using UV instead of SQL I'll have to play with this later - thanks for the info... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, October 18, 2012 6:50 AM To: 'U2 Users List' Subject: Re: [U2] Selection Suggestions for using UV instead of SQL Since the index files are actually type 25 files, you can always (though of course I would NEVER recommend this ... ) create a file pointer direct to the INDEX.nnn and read the entries as records ... saves grabbing a select list .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 09:53 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 18/10/12 09:29, Martin Braid wrote: I think you mean SELECTINDEX index.name[,key.val] FROM file.var [TO list.num] Martin Followed by a READLIST ... Quite possibly - I can't remember. One *important* point to note - if you are planning to call this from an i-descriptor, as I did, don't forget you MUST save that to a non-default list, or any attempt to LIST the idescriptor will go horribly wrong... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2012 08:55 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 16:40, George Gallen wrote: How would I get the contents of the Index? George Don't have the UV BASIC manual in front of me, but it's something like READINDEX variable FROM filedescriptor, indexname[, indexvalue] If you only pass filedescriptor and indexname, it will return a list of all the index values. If you also pass indexvalue, it will return a list of all keys for that value. I'll have a look later and see if I can find that routine - it's probably on my system somewhere, but my archives aren't that organised... Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, October 17, 2012 11:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selection Suggestions for using UV instead of SQL On 17/10/12 14:59, George Gallen wrote: Ok. I have file1 - people that has @ID of PID I have file2 - registration that has @ID of PID+EID+RID (EID = event id, RID = registration id) I want to select people who are not in the registration file with an EID of 1. With an SQL statement - I could
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Seems like the simple solution would be in your subroutine, before you
need to generate your select, test the SYSTEM variable to see if an
active select is already in use. If it is, do a READLIST into a
variable. Then at the end of your subroutine, if anything is in your
variable, do a UNIBASIC SELECT to reestablish the active select list.
You might just always check for an active list at the beginning of your
subroutine as a normal setup function then as a exit routine, restore
the active list.
Just a thought.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Monday, September 24, 2012 10:43 AM
To: U2 Users List
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Well, that success was short lived. While the READLIST and FORMLIST
allow my SUBR(..) field to not consume the active select list zero,
these two commands produce different results:
LIST ORDER.LINE WITH fieldName fieldName
...this will show the lines that have this field set, and will show the
field properly. However, this command returns no items:
SELECT ORDER.LINE WITH fieldName
Basically my program is doing this:
READLIST ACTIVE.LIST FROM 0 ELSE NULL
*
CMD = select ... TO 2
EXECUTE CMD CAPTURING OUTPUT
*
EOF = @FALSE
LOOP
READNEXT ID FROM 2 ELSE EOF = @TRUE
UNTIL EOF DO
..
REPEAT
*
CLEARSELECT 2
*
FORMLIST ACTIVE.LIST TO 0
All other input/ideas appreciated.
On Mon, Sep 24, 2012 at 11:26 AM, Kevin King ke...@precisonline.com
wrote:
And we have a winner! Thank you everyone! The READLIST and FORMLIST
will work; seems kinda kludgy, but hey, it's working.
On Mon, Sep 24, 2012 at 11:21 AM, David A. Green
dgr...@dagconsulting.com
wrote:
If you already have an active list then you'll have to save it, then
restore it. See READLIST and FORMLIST.
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 Kevin King
Sent: Monday, September 24, 2012 10:11 AM
To: U2 Users List
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
It's all fine if the program controls both lists, but in this case
the
SUBR(..) type field could be accessed in just about any context, from
TCL, from a download, from MITS, from another BASIC routine, with or
without a select list...
The RTNLIST doesn't solve the problem of my select command
consuming the active list 0. It seems that the PASSLIST extension to
EXECUTE is designed specifically for this purpose, but it produces
nothing but compilation
errors:
CMD = select ...
EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2
...produces a compilation error about the misuse of RTNLIST,
despite the documentation saying this should be possible.
The point is that I want to leave select list 0 entirely alone, which
is why I'm using $BASICTYPE U. BASICTYPE P - standard on these
SB+ systems - does not allow one to READNEXT from anything but list
0, and I want to leave list zero untouched.
Gotta be a way, right?
-K
On Mon, Sep 24, 2012 at 10:56 AM, Martin Braid mbr...@epicor.com
wrote:
Hi Kevin, Any reason why you are using type U ? This
certainly
works using P ...
S='SELECT SOMEFILE WITH SOMETHING = OOJIT'
EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT
EOF=0
LOOP UNTIL EOF DO
READNEXT MYID FROM MYLIST THEN
GSOUB MYMESS
END ELSE EOF=1
REPEAT
Martin
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker
Hughes
Sent: 24 September 2012 17:49
To: 'U2 Users List'
Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Can you use SELECT yourfile WITH whatever TO 8 {specific list
number} in the master process, and let your SUBR virtual field
default to list
0 {zero}?
The other option could be to do a READLIST within the SUBR function
and reset the list when RETURNing, but this could be onerous in
terms of processing speed.
HTH
-Baker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin
King
Sent: Monday, September 24, 2012 11:43 AM
To: U2 Users List
Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists
How does one manage multiple active select lists in Unidata? I
could have sworn I've done this before, but for some reason it's
not working at all as I recall.
I have this SUBR(..) type field in file A that selects records from
file B to calculate an aggregate. This works fine when listing
file A and showing the field. However, if there's an active select
list when file A is listed with this field, the select statement in
my SUBR(..) is consuming the active select list 0 and returning
incorrect results.
My subroutine is $BASICTYPE U
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Guess I should have waited to decide I had the answer until I paid attention to ALL of the message you typed. sigh I wonder if there is a difference between FORMLIST and just plain SELECT. As long as your variable exists, even if it's empty, you should get the same contents in cursor 0 as when processing entered your subroutine. Unless maybe it was using 0 as a variable NAME instead of cursor 0. Maybe? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 11:02 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Bob, this is exactly what I'm attempting, to save the current 0 list and restore it. David, checking the list before the FORM.LIST appears to have solved the problem. Thank you. Has this kind of thing always been this onerous? I recall doing it much more easily - on Unidata - but it's been years. On Mon, Sep 24, 2012 at 11:57 AM, Woodward, Bob bob_woodw...@k2sports.comwrote: Seems like the simple solution would be in your subroutine, before you need to generate your select, test the SYSTEM variable to see if an active select is already in use. If it is, do a READLIST into a variable. Then at the end of your subroutine, if anything is in your variable, do a UNIBASIC SELECT to reestablish the active select list. You might just always check for an active list at the beginning of your subroutine as a normal setup function then as a exit routine, restore the active list. Just a thought. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 10:43 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists Well, that success was short lived. While the READLIST and FORMLIST allow my SUBR(..) field to not consume the active select list zero, these two commands produce different results: LIST ORDER.LINE WITH fieldName fieldName ...this will show the lines that have this field set, and will show the field properly. However, this command returns no items: SELECT ORDER.LINE WITH fieldName Basically my program is doing this: READLIST ACTIVE.LIST FROM 0 ELSE NULL * CMD = select ... TO 2 EXECUTE CMD CAPTURING OUTPUT * EOF = @FALSE LOOP READNEXT ID FROM 2 ELSE EOF = @TRUE UNTIL EOF DO .. REPEAT * CLEARSELECT 2 * FORMLIST ACTIVE.LIST TO 0 All other input/ideas appreciated. On Mon, Sep 24, 2012 at 11:26 AM, Kevin King ke...@precisonline.com wrote: And we have a winner! Thank you everyone! The READLIST and FORMLIST will work; seems kinda kludgy, but hey, it's working. On Mon, Sep 24, 2012 at 11:21 AM, David A. Green dgr...@dagconsulting.com wrote: If you already have an active list then you'll have to save it, then restore it. See READLIST and FORMLIST. 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 Kevin King Sent: Monday, September 24, 2012 10:11 AM To: U2 Users List Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists It's all fine if the program controls both lists, but in this case the SUBR(..) type field could be accessed in just about any context, from TCL, from a download, from MITS, from another BASIC routine, with or without a select list... The RTNLIST doesn't solve the problem of my select command consuming the active list 0. It seems that the PASSLIST extension to EXECUTE is designed specifically for this purpose, but it produces nothing but compilation errors: CMD = select ... EXECUTE CMD CAPTURING OUTPUT RTNLIST 2 PASSLIST 2 ...produces a compilation error about the misuse of RTNLIST, despite the documentation saying this should be possible. The point is that I want to leave select list 0 entirely alone, which is why I'm using $BASICTYPE U. BASICTYPE P - standard on these SB+ systems - does not allow one to READNEXT from anything but list 0, and I want to leave list zero untouched. Gotta be a way, right? -K On Mon, Sep 24, 2012 at 10:56 AM, Martin Braid mbr...@epicor.com wrote: Hi Kevin, Any reason why you are using type U ? This certainly works using P ... S='SELECT SOMEFILE WITH SOMETHING = OOJIT' EXECUTE S RTNLIST MYLIST CAPTURING ANYOUTPUT EOF=0 LOOP UNTIL EOF DO READNEXT MYID FROM MYLIST THEN GSOUB MYMESS END ELSE EOF=1 REPEAT Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 24 September 2012 17:49 To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Re: [U2] Comparing Two Dynamic Arrays
Is it a DIM array or a DYNAMIC array? I would think that a DIM array would probably be false because it's space is assigned in memory using initial values of whatever data was in that location. I would expect a DYNAMIC array to work, though, as it's really just a single location in memory. No proof but that's what I'd expect, anyway. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, July 20, 2012 1:23 PM To: U2 Users List Subject: [U2] Comparing Two Dyamic Arrays Begin case Case array1 = array2 ; sameThing = true Case 1; sameThing = false End case When I tried to use an equals sign... I did not get the right answer. While the COMPARE function works ok... and I presume that it is a compiler thing... It is not clear to me why the equals sign has been disempowered. Insights would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mailing list delays
I'm reading your message at 1:15pm so it's only 6 minutes, depending on your time zone. The email header says you sent it at 12:09pm instead of 1:09pm. I'm on the West coast in Seattle. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, July 12, 2012 12:09 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Mailing list delays Is anyone else having 1+ hour delays when posting responses to this list? Almost all of my replies are delayed (I'm sending this at 1:09pm for reference) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] EXIT ; EXIT inside a loop
Not from what I see. Only the first EXIT seems to apply as it executes immediately, skipping over the second EXIT. You would have to add the same test of G = H after the NEXT A2 statement. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Thursday, April 19, 2012 1:36 PM To: u2-users@listserver.u2ug.org Subject: [U2] EXIT ; EXIT inside a loop Given: FOR A1 = 1 TO X FOR A2 = 1 TO Y little twisted logic IF G = H THEN EXIT ; EXIT twisted little logic NEXT A2 twisting little logic NEXT A1 little twisting logic The question is, if G = H, will the two EXIT commands drop out of both loops, skipping BOTH twisted little logic and twisting little logic, and resume execution at little twisting logic ? PLOUGH Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com http://www.hubbardsupply.com Delivering Products, Services and Innovative Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] SB Report page counter
Hi group,
I'm having a problem with page breaks and page number counter in a SB
Form report. I have a report that is set up with Headings, Column
Headings, and a Detail line defined. I have a dict item defined,
PAGE.OF with a derived field definition of:
('Page ':@RV.MV.PAGE:' of ':@RV.MV.PAGE.CNT)
On the report, I am getting this value as:
Page 1 of 1
Unfortunately, it's not changing for a more than one page listing. The
format of the report is that it's a single record with multiple details
from the AMV group of the record. It's like an invoice record where the
structure is a single record with MV attributes for the detail lines.
If there are enough values, the printout starts with the headings on
page one, then the column headings, then a number of detail (MV) lines.
It then reprints the headings and column headings then continues with
the rest of the detail (MV) lines.
If I send the report to the HOLD file then edit the output, I see the
printer initialize escape sequences at the top, before the first
heading, but at the point where the headings are printed a second time,
I am not seeing a Form-Feed escape sequence.
Anyone have thoughts on where I might look for what controls the page
length and what triggers the update to the two @ variables? Hope I've
explained this properly.
TIA,
BobW
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Report page counter
Hi Dave,
It was the negative value in Max MV Lines that fixed it. Thanks!
BobW
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Friday, April 13, 2012 11:54 AM
To: U2 Users List
Subject: Re: [U2] SB Report page counter
Is your Multiple Records Per Page set to N?
Are your multi-valued fields set up with negative Max MV Lines?
I've not encountered this problem in my forms.
Make the entire report in the D section - you don't really need an
actual heading section for a form-style report.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob
Sent: Friday, April 13, 2012 2:38 PM
To: SB Solutions; U2 Users List
Subject: [U2] SB Report page counter
Hi group,
I'm having a problem with page breaks and page number counter in a SB
Form report. I have a report that is set up with Headings, Column
Headings, and a Detail line defined. I have a dict item defined,
PAGE.OF with a derived field definition of:
('Page ':@RV.MV.PAGE:' of ':@RV.MV.PAGE.CNT)
On the report, I am getting this value as:
Page 1 of 1
Unfortunately, it's not changing for a more than one page listing. The
format of the report is that it's a single record with multiple details
from the AMV group of the record. It's like an invoice record where the
structure is a single record with MV attributes for the detail lines.
If there are enough values, the printout starts with the headings on
page one, then the column headings, then a number of detail (MV) lines.
It then reprints the headings and column headings then continues with
the rest of the detail (MV) lines.
If I send the report to the HOLD file then edit the output, I see the
printer initialize escape sequences at the top, before the first
heading, but at the point where the headings are printed a second time,
I am not seeing a Form-Feed escape sequence.
Anyone have thoughts on where I might look for what controls the page
length and what triggers the update to the two @ variables? Hope I've
explained this properly.
TIA,
BobW
___
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.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]h
ttp://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com
This message is intended exclusively for the individual or entity to
which it is addressed. This communication may contain information that
is proprietary, privileged or confidential or otherwise legally exempt
from disclosure. If you are not the named addressee, you are not
authorized to read, print, retain, copy or disseminate this message or
any part of it. If you have received this message in error, please
notify the sender immediately by e-mail and delete all copies of the
message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Detecting idle time in INPUT statement.
Any solution is going to require modifying your system, as far as I know, other than educating your users. The best solution would be to add the LOCKED clause so you can find out who is the offending user and concentrate on increasing their knowledge. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Robinson Sent: Tuesday, March 27, 2012 6:27 AM To: U2 listserver Subject: [U2] Detecting idle time in INPUT statement. Hello all, We are running Universe 10.1 on AIX with about 500 users. We have a problem with users opening up a record which puts a lock on it and just letting it sit at the INPUT statement for a long time. Most of the locking within the application does not use the LOCKED clause so when a second person needs the locked record, their session waits. What is the best way to detect the user hasn't typed anything for a period of time, say 2 minutes? This needs to be simple as we have no desire to rewrite the application! IIRC, some other MV systems have a timeout on the INPUT but I can't find anything about this in the UV manual. Thanks, Don Robinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 lock
Come on, people! Let's not get into another pissing contest of who programs the right way and who doesn't. As stated, the original question was if there is a way to tell how long a lock has been in place. Nothing else was given so the assumption that the OP was ONLY looking at locks placed programmatically is actually straying off topic. Without further information, specific to why they need the length of time a lock is in place, speculation of percentages or how to generate a timeline does not really seem to take anyone closer to really answering the original question. The only thing, so far, that I've seen that was a semi-direct answer is that maybe UniAdmin can provide the necessary information. Even at that, we don't know if the OP needs to just be able to find this out or if it's needed inside a program. Now is there a SYSTEM() value or maybe a LIST.READU option that provides this? THAT would be answers of value. climbing off soap box -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Friday, March 23, 2012 11:44 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Record lock I whole-heartedly disagree... 1) I have numerous processes that lock/update/release the same record repeatedly running 24x7 - on the sale process id. 2) I don't want code that works 98% of the time - that's unacceptable. I don't want calls in the middle of the night because it appears processes are locked up when in fact they are running perfectly fine because some program fails 2% of the time. To this end, ALL READU's are wrapped inside of a subroutine that tracks blocking, time held, etc. Exceptions are a part of programming... Not dealing with the exceptions is bad programming practice. Would you not validate input because the user is expected to enter the right result 98% of the time, and the other 2% is ok? Years ago, we changed from a 5 digit numeric specimen id to 5 alpha/numeric... I sat in the pre-live meeting, and brought up the fact that words could be spelled. Words we might not want patients to see... With over 60 million possible permutations, the likelyhood was well under 2%. Would that have been an acceptable error rate to you? It's not to us. We excluded the vowels so words couldn't be spelled... That's programming for the exception. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New U2 BDT - V3
We're using Unidata 6.1 and I don't see us upgrading any time soon. Will V3 of the DBTools work for us? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Friday, March 16, 2012 9:14 AM To: U2 Users List Subject: Re: [U2] New U2 BDT - V3 Sunny, download the U2 DBTools package here: http://www.rocketsoftware.com/u2/resources/downloads -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sunny Matharoo Sent: Friday, March 16, 2012 9:52 AM To: U2 Users List Subject: Re: [U2] New U2 BDT - V3 Where can we get V3 as everywhere it is V1.2.4 BDT Sunny -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 16 March 2012 15:11 To: U2 Users List Subject: Re: [U2] New U2 BDT - V3 Hi Symeon, This means that BDT doesn't have permission to update XTOOLSUB in $UDTHOME/sys/SYS_BP. All of our eclipse tools will try to automatically update XTOOLSUB to make them easier to use with earlier U2 databases. You can try setting up a connection using a user that has sufficient privileges or you can follow the old process using the public technote for updating XTOOLSUB. Engineering has also already addressed the error message to make it more meaningful in the next release. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, March 16, 2012 5:55 AM To: 'U2 Users List' Subject: Re: [U2] New U2 BDT - V3 Just upgraded to v3 - I get this error whern connecting to my udt 7.2. Build: (3865) system on redhat Base64 decoding on server failed. Status of ENCODE=4 -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver. u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo un...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 15 March 2012 16:59 To: U2 Users List Subject: Re: [U2] New U2 BDT - V3 The in-product documentation for BDT has also undergone a revamp which will be available the upcoming release. -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver. u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo un...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, March 15, 2012 10:40 AM To: U2 Users List Subject: Re: [U2] New U2 BDT - V3 There is a Rocket BDT manual available for download. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver. u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo un...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Thursday, March 15, 2012 11:30 AM To: U2 Users List Subject: Re: [U2] New U2 BDT - V3 I would like to live in this tool all day long. I have experimented with BDT some. I just installed BDT v3.0.0 so I'm anxious to learn what is new about it. I'm having to be able to be productive quickly, so I find myself reverting back to WED when I have to get something done quick. It would be helpful if there is an online tutorial, so I could transition to BDT full time. ? (I'm only interesting in learning about BDT, not any other alterative EDIs at this time, thanks) -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver. u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo un...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Monday, March 12, 2012 2:46 PM To: U2 Users List Subject: Re: [U2] New U2 BDT - V3 The new BDT is version 3.0.0. Considering that I live in this tool almost all day long, I appreciate Rocket's updating it very much indeed. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.comhttp://www.avg.com Version: 10.0.1424 / Virus Database: 2113/4871 - Release Date: 03/14/12 ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB+ screen question
Hi Bruce, Make a brand new screen with just the four WORK fields. If the problem persists in the new screen then the problem is how you're loading the data and calling the screen. If the problem does not appear in the new screen then start adding bit by bit, saving and testing in small steps until you either start seeing the problem again, or you get the screen completely built. It's got to be an assumption you're making somewhere along the line that coming up from behind and biting you. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, March 12, 2012 5:14 PM To: 'U2 Users List' Subject: Re: [U2] SB+ screen question Interestingly, it still fails after I remove the process from the field. There is nothing in any field definition to control the logic flow. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, March 12, 2012 3:35 PM To: U2 Users List Subject: Re: [U2] SB+ screen question So theoretically, the one process is what's causing the skipping action of the Earned Date field. To test that theory, take it off completely. This should let the cursor move between the LI# and Earned Date field, line by line, each time, regardless if you change any of the values or not. After you prove that it is, in fact, this process that's causing the issue then I'd say our next step is to look at what's happening inside the process. Is it a PROC or a BP program? Maybe we should take this off-list instead of flooding everyone's inboxes. I'm far from an expert in this but I'm willing to explore possibilities with you. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, March 12, 2012 3:20 PM To: 'U2 Users List' Subject: Re: [U2] SB+ screen question Yes they are MV fields. There is nothing on the LI# or Award fields. The sequencing is left to right with no extra processing and they are just @WORK variables. I tried to move the process from Process After entrty slot to the Validation slot and it behaves a little better but it still skips from line 1 to 2 and so on without stopping at the Earned Date field. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, March 12, 2012 2:15 PM To: U2 Users List Subject: Re: [U2] SB+ screen question So are these MV fields or SV fields? Also, you only have a process-after on the Earned Date? Nothing on the LI# or Award fields? I'm also assuming your sequence of prompting in the screen is straight forward, left to right for these 4 prompts, and you have no extra processes on the DICT entries for these. You said they are just @WORK variables, right? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, March 12, 2012 1:53 PM To: 'U2 Users List' Subject: Re: [U2] SB+ screen question Hi Bob, Thanks for the reply. I agree with you - Kevin's book is fantastic! I have been using it for many years and still refer to it when I need guidance. As for the problem: Maybe I am using the wrong processing slot. What I have is something like this: LI# Award Earned Date Paid Date --- - --- --- 999 x DD MMM DD MMM I have the LI# field as input but do nothing else with it. I have the Award field as no input; display only. I have the Earned Date field as input with a Process After process to determine what to do with the Paid Date. In the process I will populate the Paid Date if it is not already there. I will change the Paid Date to be the same as the Earned Date if the Earned Date was changed and the Paid date was the same as the original Earned Date. If the Paid Date is not the same as the original Earned Date I will leave the Paid Date alone. And lastly, the Paid Date field is diplay only. To me, this means that I have to prompt the user for the Earned Date - I cannot skip the field until I know if they are wanting to change the field so I then will know what to do with the Paid Date. If they do not change the Earned Date then I will leave the Paid Date as it is. I also put a DISP line showing the value of the original Earned Date and the current one in the Process After for the Earned Date and it will show correctly the first time I enter the screen (after I hit enter in the the Earned Date field.) but it will show after I enter the LI# field, the next time I open the screen and skip the Earned Date field. Thanks again, Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, March 12, 2012 12
Re: [U2] SB+ screen question
Hi Bruce, It may have to do with your concept of how the work flow is going in screen and the way your process is working to control your entry. If you have access to a copy of Kevin King's green System Builder book SB+ Solutions, check the sections in Special Processing for Multivalued Fields starting on page 3-145. Specifically where it talks about the fact that in an Multivalue field, the Process Before the Prompt is only executed one time for the first value, not before each value of the field. This might be where you're having the problem. I love this book, by the way!!! Thanks Kevin! BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, March 12, 2012 10:40 AM To: u2-users@listserver.u2ug.org Subject: [U2] SB+ screen question Hi All, I have created a new screen in SB+. The data is built into the work record and then I want to have the user be able to go through the lines one at a time in order to change a date field. The date field itself will only be able to be changed when another associated date field is not already present. I have the screen working pretty well except for something strange that is happening. That is, I can call the screen up from the menu and when I hit enter at the first line it move over to the the date to be modified. But when I exit the screen and come back into it, the cursor will not move over to the date but just down to the next line, and the next line again if I continue to hit the enter key. It never goes over to the date field, just down a line. When it reaches the bottom of the data it cycles back to line one and continues to go down the page with each enter key. Now it gets really interesting. When I exit the screen and then go back into the screen it will work correctly. And if I exit and re-enter it will fail again. It just toggles between working correctly and not working at all. I have tried to debug this by putting in DISP statements into the Process After Display (the first process is called from here) but I do not see what is causing the screen to react the way that it is. I don't know if I have explained it very well but has anybody else had this problem before and know how to fix it? Thanks in advance, Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB+ screen question
So are these MV fields or SV fields? Also, you only have a process-after on the Earned Date? Nothing on the LI# or Award fields? I'm also assuming your sequence of prompting in the screen is straight forward, left to right for these 4 prompts, and you have no extra processes on the DICT entries for these. You said they are just @WORK variables, right? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, March 12, 2012 1:53 PM To: 'U2 Users List' Subject: Re: [U2] SB+ screen question Hi Bob, Thanks for the reply. I agree with you - Kevin's book is fantastic! I have been using it for many years and still refer to it when I need guidance. As for the problem: Maybe I am using the wrong processing slot. What I have is something like this: LI# Award Earned Date Paid Date --- - --- --- 999 x DD MMM DD MMM I have the LI# field as input but do nothing else with it. I have the Award field as no input; display only. I have the Earned Date field as input with a Process After process to determine what to do with the Paid Date. In the process I will populate the Paid Date if it is not already there. I will change the Paid Date to be the same as the Earned Date if the Earned Date was changed and the Paid date was the same as the original Earned Date. If the Paid Date is not the same as the original Earned Date I will leave the Paid Date alone. And lastly, the Paid Date field is diplay only. To me, this means that I have to prompt the user for the Earned Date - I cannot skip the field until I know if they are wanting to change the field so I then will know what to do with the Paid Date. If they do not change the Earned Date then I will leave the Paid Date as it is. I also put a DISP line showing the value of the original Earned Date and the current one in the Process After for the Earned Date and it will show correctly the first time I enter the screen (after I hit enter in the the Earned Date field.) but it will show after I enter the LI# field, the next time I open the screen and skip the Earned Date field. Thanks again, Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, March 12, 2012 12:09 PM To: U2 Users List Subject: Re: [U2] SB+ screen question Hi Bruce, It may have to do with your concept of how the work flow is going in screen and the way your process is working to control your entry. If you have access to a copy of Kevin King's green System Builder book SB+ Solutions, check the sections in Special Processing for Multivalued Fields starting on page 3-145. Specifically where it talks about the fact that in an Multivalue field, the Process Before the Prompt is only executed one time for the first value, not before each value of the field. This might be where you're having the problem. I love this book, by the way!!! Thanks Kevin! BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, March 12, 2012 10:40 AM To: u2-users@listserver.u2ug.org Subject: [U2] SB+ screen question Hi All, I have created a new screen in SB+. The data is built into the work record and then I want to have the user be able to go through the lines one at a time in order to change a date field. The date field itself will only be able to be changed when another associated date field is not already present. I have the screen working pretty well except for something strange that is happening. That is, I can call the screen up from the menu and when I hit enter at the first line it move over to the the date to be modified. But when I exit the screen and come back into it, the cursor will not move over to the date but just down to the next line, and the next line again if I continue to hit the enter key. It never goes over to the date field, just down a line. When it reaches the bottom of the data it cycles back to line one and continues to go down the page with each enter key. Now it gets really interesting. When I exit the screen and then go back into the screen it will work correctly. And if I exit and re-enter it will fail again. It just toggles between working correctly and not working at all. I have tried to debug this by putting in DISP statements into the Process After Display (the first process is called from here) but I do not see what is causing the screen to react the way that it is. I don't know if I have explained it very well but has anybody else had this problem before and know how to fix it? Thanks in advance, Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users
Re: [U2] SB+ screen question
So theoretically, the one process is what's causing the skipping action of the Earned Date field. To test that theory, take it off completely. This should let the cursor move between the LI# and Earned Date field, line by line, each time, regardless if you change any of the values or not. After you prove that it is, in fact, this process that's causing the issue then I'd say our next step is to look at what's happening inside the process. Is it a PROC or a BP program? Maybe we should take this off-list instead of flooding everyone's inboxes. I'm far from an expert in this but I'm willing to explore possibilities with you. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, March 12, 2012 3:20 PM To: 'U2 Users List' Subject: Re: [U2] SB+ screen question Yes they are MV fields. There is nothing on the LI# or Award fields. The sequencing is left to right with no extra processing and they are just @WORK variables. I tried to move the process from Process After entrty slot to the Validation slot and it behaves a little better but it still skips from line 1 to 2 and so on without stopping at the Earned Date field. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, March 12, 2012 2:15 PM To: U2 Users List Subject: Re: [U2] SB+ screen question So are these MV fields or SV fields? Also, you only have a process-after on the Earned Date? Nothing on the LI# or Award fields? I'm also assuming your sequence of prompting in the screen is straight forward, left to right for these 4 prompts, and you have no extra processes on the DICT entries for these. You said they are just @WORK variables, right? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, March 12, 2012 1:53 PM To: 'U2 Users List' Subject: Re: [U2] SB+ screen question Hi Bob, Thanks for the reply. I agree with you - Kevin's book is fantastic! I have been using it for many years and still refer to it when I need guidance. As for the problem: Maybe I am using the wrong processing slot. What I have is something like this: LI# Award Earned Date Paid Date --- - --- --- 999 x DD MMM DD MMM I have the LI# field as input but do nothing else with it. I have the Award field as no input; display only. I have the Earned Date field as input with a Process After process to determine what to do with the Paid Date. In the process I will populate the Paid Date if it is not already there. I will change the Paid Date to be the same as the Earned Date if the Earned Date was changed and the Paid date was the same as the original Earned Date. If the Paid Date is not the same as the original Earned Date I will leave the Paid Date alone. And lastly, the Paid Date field is diplay only. To me, this means that I have to prompt the user for the Earned Date - I cannot skip the field until I know if they are wanting to change the field so I then will know what to do with the Paid Date. If they do not change the Earned Date then I will leave the Paid Date as it is. I also put a DISP line showing the value of the original Earned Date and the current one in the Process After for the Earned Date and it will show correctly the first time I enter the screen (after I hit enter in the the Earned Date field.) but it will show after I enter the LI# field, the next time I open the screen and skip the Earned Date field. Thanks again, Bruce -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, March 12, 2012 12:09 PM To: U2 Users List Subject: Re: [U2] SB+ screen question Hi Bruce, It may have to do with your concept of how the work flow is going in screen and the way your process is working to control your entry. If you have access to a copy of Kevin King's green System Builder book SB+ Solutions, check the sections in Special Processing for Multivalued Fields starting on page 3-145. Specifically where it talks about the fact that in an Multivalue field, the Process Before the Prompt is only executed one time for the first value, not before each value of the field. This might be where you're having the problem. I love this book, by the way!!! Thanks Kevin! BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: Monday, March 12, 2012 10:40 AM To: u2-users@listserver.u2ug.org Subject: [U2] SB+ screen question Hi All, I have created a new screen in SB+. The data is built into the work record and then I want to have the user be able to go through the lines one at a time in order to change a date
Re: [U2] uvrestore - Unable to create or attach the Printer Segment
Since you're able to get to the DOS prompt using telnet, type SET to look at the environment variables. Check them against when you're on the server and able to get into UV. Something is probably different. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, February 28, 2012 10:30 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment I tried going to a DOS shell on the server directly and typed UV and it worked. Just not with Telnet. I would like to avoid a PCAnywhere solution since we've always been able to use Telnet. To: u2-users@listserver.u2ug.org From: wjhon...@aol.com Date: Tue, 28 Feb 2012 13:26:39 -0500 Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment Connect to your server directly through RADMIN or PCAnywhere. Start a DOS Shell without going into Universe. Go to the Universe directory Try uv then. -Original Message- From: Chris Austin cjausti...@hotmail.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Feb 28, 2012 10:15 am Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment xactly what you said. I login to Universe through TCL and then type DOS, then V. I then get that error message: C:\CHRISuv fatal error has occurred in uniVerse nable to create or attach the Printer Segment To: u2-users@listserver.u2ug.org From: wjhon...@aol.com Date: Tue, 28 Feb 2012 13:12:53 -0500 Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment Do you mean you log into Universe, go to TCL, type DOS, get the DOS prompt, hen try uv at that point? -Original Message- From: Chris Austin cjausti...@hotmail.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Feb 28, 2012 9:57 am Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment rian, I changed the PATH on the server and that fixed the 10.1 from showing when I o UV on a CMD prompt. I now see 1.1 which is good but I still cannot execute the UV command from TELNET like I ave always been able to do before. Even when I sit on the server and try UV in a TELNET prompt it won't work, owever the CMD prompt does.. Chris From: br...@brianleach.co.uk To: u2-users@listserver.u2ug.org Date: Tue, 28 Feb 2012 17:24:31 + Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment Just a thought - you've changed the uv directory, has your path environment variable changed to the new \u2\uv\bin ? Could it be trying to run the old binaries? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 28 February 2012 16:56 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment We did an upgrade by using the 'modify' option during the install. We also used the option during the install to copy all the files from the old \IBM\UV directory to the new U2\UV directory. I'm not sure if that has anything to do with it. I have not executed UVREGEN, should I do that? What does that command do? I didn't see it in the command reference guide. Chris Date: Tue, 28 Feb 2012 17:51:39 +0100 From: aalo...@quiter.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] uvrestore - Unable to create or attach the Printer Segment Hi. You said you just upgraded. Have you executed uvregen after the upgrade? Regards -- Augusto 2012/2/28 Chris Austin cjausti...@hotmail.com I just upgraded my UniVerse server from version 10.1.18 to 11.1.1. Everything seems ok except when I try and run the uvrestore command from one of our UniVerse version 10.3.3 backups. I don't know if this is a problem with just uvrestore or other uv commands but when I try to execute a uvrestore I get: A fatal error has occurred in uniVerse Unable to create or attach the Printer Segment Any idea what would be causing this? Anything to do with connection pooling? (our new install has connection pooling set at 0) Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Universe's DOS command
The /c is to close the command session when the supplied process/batchfile completes. This returns you back to your originating session of Universe. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, February 15, 2012 10:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe's DOS command The DOS command in Universe takes a /c argument and then you can specify a bat file like DOS \c test.bat What does \c mean? Are there other arguments like \z or \x that it can take? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] [mildly ot] - EDI and drop shipments
Are you setting up specifications or do you already have a set that you're working from? You should be able to isolate the N1 loops from each other within a dataset so that each loop is a functional subset. Then, based on the BT/ST code determine what kind of information you have and apply it accordingly to you generating sales order process. The issue you are going to struggle with is going to be the unknown code (phone number) to your system. You probably won't have a customer master records to link to. At least this is one of the issues we're struggling against currently in our efforts to do this. The direction we're going is our sales orders have the extra fields for an actual third-party name and address that is a manual entry on our screens. They are not tied to the customer master file. Our documents and labels that will need to use this third-party address will have to be set so if it exists, it uses it, otherwise it will use the normal ship-to information. For the drop ship orders, the ship-to will have to default to one of the partners normal ship-to's, just to be safe and ensure the shipment never gets lost. Oh, and there really isn't a way to do drop shipments using the SDQ segment unless you have a matching ID of each SDQ CODE/QTY pairing already in your customer master file. At least not without redefining industry standards of the EDI format. I guess/assume you're using the VICS standard. This is a big monster of a change so if you want to talk concepts, we could take this off-list. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, February 10, 2012 1:07 PM To: U2 Users Subject: [U2] [mildly ot] - EDI and drop shipments For those EDIers on the list. Do any of you process drop shipments using EDI for 850's? What method do you use? We were thinking : First N1 loop - N1 segment contains the BT and use the SAN (15 code) Second N1 loop - N1 segment contains the ST but use phone# for identification (12 code) N2 segment for Drop Ship Name N3 Segment(s) for Drop Ship Address (2 lines per N3 segment) - maximum 2 N3's N4 Segment for Drop Ship City, State, Zip and Country Currently we do not process drop shipments using EDI, and neither does this partner with any of Their other suppliers... George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [mildly ot] - EDI and drop shipments
Without seeing your approach to handling your data, and more importantly how you're feeding this data into your sales order system, I'm not real sure what you're asking for. The only thing I really see in your original question is about recognizing what the data in the N1 loop is. That's what the BT and ST are for. Your approach of how you keep track of the data inside your program is going to be based on the way you think. Myself, I like more descriptive variables like BILLTO.ID and SHIPTO.NAME kind of things. Don't know if I'm clearing the water or stomping in the mud but I hope it helps. Good luck. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, February 10, 2012 1:51 PM To: U2 Users List Subject: Re: [U2] [mildly ot] - EDI and drop shipments Aside from phone#, the other thought was just a straight text DROPSHIP, other than That, I wouldn't be relating the phone number to anything, other than a piece of data Isolating the loops isn't a problem. I have a subroutine that converts the EDI To a dynamic array, and it knows that N1 is a loop, and will create separate Them by @VM's N11,x will go with N21,x where x is the loop number. Were using customized programming, so it's not a problem to do unique things Based on the partners ID, or the a specific SAN. Thanks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, February 10, 2012 4:43 PM To: U2 Users List Subject: Re: [U2] [mildly ot] - EDI and drop shipments Are you setting up specifications or do you already have a set that you're working from? You should be able to isolate the N1 loops from each other within a dataset so that each loop is a functional subset. Then, based on the BT/ST code determine what kind of information you have and apply it accordingly to you generating sales order process. The issue you are going to struggle with is going to be the unknown code (phone number) to your system. You probably won't have a customer master records to link to. At least this is one of the issues we're struggling against currently in our efforts to do this. The direction we're going is our sales orders have the extra fields for an actual third-party name and address that is a manual entry on our screens. They are not tied to the customer master file. Our documents and labels that will need to use this third-party address will have to be set so if it exists, it uses it, otherwise it will use the normal ship-to information. For the drop ship orders, the ship-to will have to default to one of the partners normal ship-to's, just to be safe and ensure the shipment never gets lost. Oh, and there really isn't a way to do drop shipments using the SDQ segment unless you have a matching ID of each SDQ CODE/QTY pairing already in your customer master file. At least not without redefining industry standards of the EDI format. I guess/assume you're using the VICS standard. This is a big monster of a change so if you want to talk concepts, we could take this off-list. BobW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] DesignBais Website
I found an email address if you're looking to get hired and live in Sydney Australia. i...@designbais.com You can try going to the link http://www.designbais.com/downloads/DesignBaisWebinars2011a.pdf to see if you can get to their Webinar Schedule. It just gives the same email address for a contact. Guess they really don't want to talk to anyone in person. shoulder shrug Good luck. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, January 12, 2012 11:47 AM To: U2 Users List Subject: Re: [U2] DesignBais Website Hi Harold, I just tried it with Firefox and was able to get the site up - perhaps they just had a momentary glitch. I couldn't find a phone number anywhere, though, just a support contact form. Regards, Charlie Noah On 01-12-2012 1:38 PM, Oaks, Harold wrote: I am interested in showing my boss DesignBais and would like to download the trial copy. Unfortunately, when trying to open the website www.designbais.com I see nothing at all, except the message Done, but with errors on the page in a bottom bar. I don't even have a phone# to call because the webpage is blank. Can anyone help me out? At least to inform DesignBais that their web page has a problem. Thanks- Harold Oaks Clark County, WA, USA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] redhat version
I'm with you. Go with the current version or make your hosting partner give you specific reasons why you shouldn't. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, December 06, 2011 8:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] redhat version Hi group We are getting a new machine to replace our aging redhat 4 box. Our hosting partner has suggested that the best stable version of redhat is 5.7. Even tho 6.2 is now out. Personally I would rather go 6.2 just to ensure we have the latest. The unidata matrix lists redhat 5 and 6 is supported for udt 7.2.12 Anyone have any comment to make on the relative merits of redhat versions 5 and 6 ? Cheers 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
[U2] Simple SB screen display question
Hi folks, I sent this to the SB-Solutions list first but I think something is messed up with my registration there. Anyway, I have a simple need, I think. I have a screen that has a MV field that I want to display the first two values when I leave the field. The user may enter a number of values and in the process after I'm going to a basic program where I'm doing some data manipulation. When I'm done, I have everything in RECORD14,1 and 14,2 with the rest of the values cleared. On the screen, the last two values, which are now empty, is what's displayed. How can I re-display the now updated contents of RECORD14 (and VALUE)? I thought REFRESH = 2 would do it but no joy. Thanks. BobW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple SB screen display question
Thanks Marco. I've tried both 2 and -2 but neither seems to do the trick. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Antonio Rojas Castro Sent: Wednesday, November 30, 2011 3:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Simple SB screen display question Hi Try this REFRESH = -2 Regards, Marco Date: Wed, 30 Nov 2011 12:30:31 -0800 From: bob_woodw...@k2sports.com To: u2-users@listserver.u2ug.org Subject: [U2] Simple SB screen display question Hi folks, I sent this to the SB-Solutions list first but I think something is messed up with my registration there. Anyway, I have a simple need, I think. I have a screen that has a MV field that I want to display the first two values when I leave the field. The user may enter a number of values and in the process after I'm going to a basic program where I'm doing some data manipulation. When I'm done, I have everything in RECORD14,1 and 14,2 with the rest of the values cleared. On the screen, the last two values, which are now empty, is what's displayed. How can I re-display the now updated contents of RECORD14 (and VALUE)? I thought REFRESH = 2 would do it but no joy. Thanks. BobW ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] [semi-ot] JE Sisk basic book on the eBay
I don't know why. She's quite a looker! And I'm sure Allen doesn't deserve her. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, November 10, 2011 8:03 AM To: U2 Users List Subject: Re: [U2] [semi-ot] JE Sisk basic book on the eBay Allen, IMHO... she's gonna kill you! ;-) Charlie Noah Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds Info, Forum: http://www.TinyBearMarketing.com Store:http://Stores.TinyBearMarketing.com On 11-10-2011 8:40 AM, Allen E. Elwood wrote: Just for the book (pun intended), I was only mildly enthused, not anywhere close to excited. Now that 30 year old picture of my wife I found buried in the garage yesterday THAT was exciting :-) http://i1132.photobucket.com/albums/m561/EBB_Amps/DSCN0202.jpg -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, November 09, 2011 4:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [semi-ot] JE Sisk basic book on the eBay From: Allen E. Elwood Anyone need/want the original JES pick basic book, here's your chance to pick it up for a mere $10 spot, give or take a few cents. This market could Really use new books that include platform-specific nuances, communications with different languages and protocols, and other modern concerns. But in a market that gets excited about $10 books that are over 20 years old, there's just no incentive for authors to create the material. I was in a MV user group meeting a couple years ago where the consensus was that no one reads documentation anyway so why bother writing or maintaining it. WTH? We've collectively created the market that we live in, and it's being killed off by the hand of people who claim to love it so well. I wrote about the book problem a few years ago: nospamNebula-RnD.com/blog/tech/mv/2007/05/mvbooks1.html 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using 'MATCH'
You might also be able to use COUNT. IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE Not knowing what your potential codes are, though, they may or may not fit your needs. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: Monday, October 31, 2011 10:44 AM To: U2 Users List Subject: Re: [U2] Using 'MATCH' Hi Greg, I would convert your string to a VM array, use the LOCATE syntax to add it if relevant and then convert back to a string. Martin (I am not going to worry why you aren't just using an array) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: 31 October 2011 17:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using 'MATCH' Hey Guys, I am concatenating an alpha code into a string providing that the code does not already exist (in the string). If my existing string = X.STRING and my code = X.CODE should the following work? IF X.STRING MATCH X.CODE THEN END ELSE X.STRING = X.STRING:',':X.CODE END Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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 is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniBasic Question
There are key differences between the two types of selects. The EXECUTE SELECT... guarantees you access all the records that fit your criteria at the moment of the execute. The BASIC SELECT processes node by node of the datafile which allows for the possibility of records being added, deleted, or even just plain skipped in the case of a group move of a dynamic file, between the start of your program execution and the end of its execution. Granted, most of the time it's a non-issue because the time involved is pretty small. As long as you're aware of this difference and don't blindly think the two selects are identical in execution, then you should be okay. Also, I'd agree with the statement that the BASIC SELECT is faster... TO PROCESS THE FIRST TRANSACTION. But for the total execution time of any given run of the whole process, I think you'll find it's pretty darn close with only a slight difference. BobW -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: Tuesday, October 25, 2011 2:14 PM To: U2 Users List Subject: Re: [U2] UniBasic Question Unless you know the keys to the records you're selecting, even the EXECUTE SELECT ... is going to have to read each record, how else would it know which records to throw out? SELECT is definitely faster than EXECUTE SELECT... and I try and use it first. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] UniBasic Question
Add a second selection criteria and the benefit of the index is washed out. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Tuesday, October 25, 2011 2:39 PM To: U2 Users List Subject: Re: [U2] UniBasic Question True on UV, too. Compare output of these using EXPLAIN keyword: LIST FILE WITH indexed_field = soemthing EXPLAIN LIST FILE WITH indexed_field = soemthing EXPLAIN NO.INDEX Or forget EXPLAIN, but do it with a large file and notice the speed differnce. On 10/25/2011 4:29 PM, charles_shaf...@ntn-bower.com wrote: I don't know if I agree that SELECT is faster. If you are using indexed fields, SELECT is definitely not the good choice. Are you saying that when there is an index, the system does not need to read the record at all? It just gets the SELECT list from the index? Is this only true in Unidata? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] LIST.READU EVERY's waiters when there are writes w/o explicit readu.
I would think that because you are not trying to obtain the lock in a WRITE statement, it would not be classified as a waiter. True, it's waiting because of the lock but by not trying to obtain the lock, it's only waiting for the blockage to clear. If it were to be classified as a waiter then I would expect to see a LOCKED clause on the WRITE statement like there is on the READU. For that matter, I'd expect to see a WRITEU command as well and the standard WRITE to completely ignore locking. Just my guess, though. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, October 24, 2011 2:12 PM To: U2 Users List Subject: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu. UV 10.2.10 on Windows is behaving differently from what I recall. Are my expectations out of line? Suppose Session A holds a readu lock; and Session B attempts a WRITE to same record withOUT!!! 1st explicitly getting the readu lock. Session B waits for Session A to release the lock before writing the record. While Session B is waiting, does it show up as a waiter in LIST.READU EVERY? I expected so, but it doesn't. Session A Session B _ ___ 1A. ED VOC DUMMY (this sets the readu lock.) 2A. (stay in editor)2B. run this: 01:OPEN 'VOC' TO F ELSE STOPM 'nope' 02: ***READU REC FROM F, 'DUMMY' ELSE NULL 03:WRITE '' TO F, 'DUMMY' 3A. Within ED: XEQ LIST.READU EVERY If I UN-comment line 2, LIST.READU EVERY shows something like this: Active Read Waiters: Owner Waiter Device Inode Userno Userno 746117947232860913 61163396 But when I comment out line 2, LIST.READU is silent. I have not yet explored what the deadlock daemon does. TIA, cds P.S. Yes, yes, Bad Form, Legacy Software, 20 min wait is configurable, . . . we can talk later. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] LIST.READU EVERY's waiters when there are writes w/o explicit readu.
Oh I agree! I was just thinking round-robin that if we're going to talk about adding a LOCKED clause to the WRITE statement, matching the structure of READU, then we ought to have a WRITEU, too. Didn't say I liked the idea -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Monday, October 24, 2011 3:30 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu. Now why would anybody want to use a WRITE without a READU? I can possibly understand that somebody would want to do it with a WRITEV (i.e writing a flag on a record) but WRITE? And WRITE totally ignoring locking would be outright stupid. On 24/10/2011 22:28, Woodward, Bob wrote: I would think that because you are not trying to obtain the lock in a WRITE statement, it would not be classified as a waiter. True, it's waiting because of the lock but by not trying to obtain the lock, it's only waiting for the blockage to clear. If it were to be classified as a waiter then I would expect to see a LOCKED clause on the WRITE statement like there is on the READU. For that matter, I'd expect to see a WRITEU command as well and the standard WRITE to completely ignore locking. Just my guess, though. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, October 24, 2011 2:12 PM To: U2 Users List Subject: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu. UV 10.2.10 on Windows is behaving differently from what I recall. Are my expectations out of line? Suppose Session A holds a readu lock; and Session B attempts a WRITE to same record withOUT!!! 1st explicitly getting the readu lock. Session B waits for Session A to release the lock before writing the record. While Session B is waiting, does it show up as a waiter in LIST.READU EVERY? I expected so, but it doesn't. Session A Session B _ ___ 1A. ED VOC DUMMY (this sets the readu lock.) 2A. (stay in editor)2B. run this: 01:OPEN 'VOC' TO F ELSE STOPM 'nope' 02: ***READU REC FROM F, 'DUMMY' ELSE NULL 03:WRITE '' TO F, 'DUMMY' 3A. Within ED: XEQ LIST.READU EVERY If I UN-comment line 2, LIST.READU EVERY shows something like this: Active Read Waiters: Owner Waiter Device Inode Userno Userno 746117947232860913 61163396 But when I comment out line 2, LIST.READU is silent. I have not yet explored what the deadlock daemon does. TIA, cds P.S. Yes, yes, Bad Form, Legacy Software, 20 min wait is configurable, . . . we can talk later. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Green Screen - Wide Screen
Ouija board? ROFLMAO Oh! Sorry. snicker I know you're serious but I just couldn't stop myself. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Monday, October 17, 2011 2:57 PM To: U2 Users List Subject: [U2] Green Screen - Wide Screen We have a large application that runs in Dynamic Connect... and needs more in the way of columns. DC is limited to approx. 132 characters. I believe that wIntegrate (when in text mode) is the same. We need maybe five times that. While I have almost concluded that this app needs to be re-written in GUI... before punting... are there any other angles worth consider... such as AccuTerm or some other text-based terminal emulator. Is there a way to do this in DC or wIntegrate? --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] Finding Triggers on files
I can't find any of them documented. What's 27 and 28 listed as? And thanks for 25 26. I've been looking for something like those, which works great! (UD 6.1) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Monday, October 10, 2011 1:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Finding Triggers on files I also find it interesting that it isn't in the UniBasic Commands Reference manual, even though 27 28 are there. We saw 25 26 in a README for a previous release and have been using it ever since. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 10, 2011 4:38 PM To: U2 Users List Subject: Re: [U2] Finding Triggers on files Dean: This is interesting to know! 2 Dev (0)- BPTEST OPEN '', 'ARTMASTER' TO ARTMASTER ELSE STOP 201, 'ARTMASTER' ; CRT FILEINFO(ARTMASTER, 25) ; CRT FILEINFO(ARTMASTER, 26) ; END Compiling Unibasic: SAVEDLISTS\BpTest_487376561 in mode 'p'. compilation finished U2.MASTER.TRIGGER.U U2.MASTER.TRIGGER.D This isn't in my most recent UD BASIC Reference manual (although 27 28 are). Thanks, Bill - Original Message - *From:* dean.armbrus...@ferguson.com *To:* jbut...@hampshire.edu, u2-users@listserver.u2ug.org *Date:* 10/10/2011 1:22 PM *Subject:* Re: [U2] Finding Triggers on files FILEINFO 25 - Returns update trigger 26 - Returns delete trigger Dean Armbruster Information Technology, System Analyst Ferguson Enterprises, Inc. 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1 (757) 989 2839 * F: +1 (757) 989 2801 www.ferguson.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, October 10, 2011 11:40 AM To: U2 Users List Subject: [U2] Finding Triggers on files Unidata 7.2.9 on RedHat Is there a programmatic way to determine if a file has a trigger on it? I've looked at FILEINFO and it doesn't indicate that any parameter would return trigger information. I know I can do something like: EXECUTE LIST.TRIGGER MY_FILE CAPTURING X.RESULT and parse X.RESULT, but was curious if there's a better way. I've occasionally been bitten by converting a file from static to dynamic hashing, losing an update trigger in the process so I want to write some code to check these and let me know if something's awry. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Finding Triggers on files
Thanks Dean. Haven't used encryption, yet, so I'll just add this to my system notes for now. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Monday, October 10, 2011 2:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Finding Triggers on files From BASR.pdf, UD 7.2: 27 Is the file encrypted? ALL 0 - File is not encrypted 1 - File is encrypted 28 Type of file encryption ALL Returns a dynamic array containing the following information: ? For a file encrypted with the WHOLERECORD option: -1@SMkeyid@SMalgorithm ? For a file encrypted at the field level: location@SMkeyid@SMalgorithm@SMfield_name ? Returns an empty string if the file is not encrypted. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, October 10, 2011 4:50 PM To: U2 Users List Subject: Re: [U2] Finding Triggers on files I can't find any of them documented. What's 27 and 28 listed as? And thanks for 25 26. I've been looking for something like those, which works great! (UD 6.1) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Monday, October 10, 2011 1:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Finding Triggers on files I also find it interesting that it isn't in the UniBasic Commands Reference manual, even though 27 28 are there. We saw 25 26 in a README for a previous release and have been using it ever since. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 10, 2011 4:38 PM To: U2 Users List Subject: Re: [U2] Finding Triggers on files Dean: This is interesting to know! 2 Dev (0)- BPTEST OPEN '', 'ARTMASTER' TO ARTMASTER ELSE STOP 201, 'ARTMASTER' ; CRT FILEINFO(ARTMASTER, 25) ; CRT FILEINFO(ARTMASTER, 26) ; END Compiling Unibasic: SAVEDLISTS\BpTest_487376561 in mode 'p'. compilation finished U2.MASTER.TRIGGER.U U2.MASTER.TRIGGER.D This isn't in my most recent UD BASIC Reference manual (although 27 28 are). Thanks, Bill - Original Message - *From:* dean.armbrus...@ferguson.com *To:* jbut...@hampshire.edu, u2-users@listserver.u2ug.org *Date:* 10/10/2011 1:22 PM *Subject:* Re: [U2] Finding Triggers on files FILEINFO 25 - Returns update trigger 26 - Returns delete trigger Dean Armbruster Information Technology, System Analyst Ferguson Enterprises, Inc. 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1 (757) 989 2839 * F: +1 (757) 989 2801 www.ferguson.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, October 10, 2011 11:40 AM To: U2 Users List Subject: [U2] Finding Triggers on files Unidata 7.2.9 on RedHat Is there a programmatic way to determine if a file has a trigger on it? I've looked at FILEINFO and it doesn't indicate that any parameter would return trigger information. I know I can do something like: EXECUTE LIST.TRIGGER MY_FILE CAPTURING X.RESULT and parse X.RESULT, but was curious if there's a better way. I've occasionally been bitten by converting a file from static to dynamic hashing, losing an update trigger in the process so I want to write some code to check these and let me know if something's awry. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] SLOW
I use to work for a place that they THOUGHT they were running SLOW but it turned out it was an old copy of KARELuSS that had been infected by a lot of KNOTACLUE. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Drew William Henderson Sent: Friday, October 07, 2011 1:51 PM To: U2 Users List Subject: Re: [U2] SLOW There seems to be a direct correlation with either system (but more predominate on Windows) that, the longer it runs without a reboot, the greater the likelihood it's running SLOW. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Horacio Pellegrino Sent: Friday, October 07, 2011 4:50 PM To: U2 Users List Subject: Re: [U2] SLOW Windows ? Linux ? On Fri, Oct 7, 2011 at 4:21 PM, Drew William Henderson d.hender...@moreheadstate.edu wrote: with apologies to Jeff and Peggy...and, ok, everyone else, too! My boss has noticed today that we've been running SLOW, and isn't happy about it. He wants to know if SLOW is industry standard, and what other U2 shops might be running SLOW. I told him that I didn't know about other U2 shops, but that I know a lot of SQL shops have been running SLOW for years, and seem to be very satisfied. I also let him know that running SLOW on Friday afternoons was almost industry standard, but I'm not sure he's buying it. So, if you're running SLOW in your environment, please let me know; otherwise, we might not be running SLOW on Monday morning. (sorry...couldn't help myself! Have a good weekend, all!) Drew Henderson Director, Enterprise Systems Architecture and Security Morehead State University 301 Howell-McDowell Bldg Morehead, Ky 40351 606/783-2445 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- *hp* ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Changing TCL prompt?
I know this could be done in Universe but I'm pretty sure it cannot be done in Unidata. I think it had to do with the amount of space in memory that is allocated to the prompt character (singular). It's been quite a long time ago that looked into this, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of gcan...@coverys.com Sent: Wednesday, October 05, 2011 11:06 AM To: u2-users@listserver.u2ug.org Subject: [U2] Changing TCL prompt? Hi everyone, Maybe I am going back to my Prime INFORMATION days, but I thought there was a way to set the '' prompt to a free form prompt, or to display the account name you were in as the TCL prompt. I know that can be done at the OS level. Am I dreaming, or is there a (fairly easy) way without having to write code to do it? Thanks Gary P. Canedy Senior Database Analyst P: 617.757.6775 F: 617.428.9803 gcan...@coverys.com (Embedded image moved to file: pic24821.jpg) 101 Arch Street, 4th Floor Boston, MA 02110 www.coverys.com Toll Free: 800.225.6168 -- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I-type Subvalue question
Wait a minute... How do you point to the previous expression? @-1 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, September 15, 2011 9:05 AM To: U2 Users List Subject: Re: [U2] I-type Subvalue question On 15/09/11 14:38, Charles Stevenson wrote: Allows you to reference this I-descriptor from another I-descriptor in the future. UV doesn't let you do that if there are multiple expressions separated by semi-colons. There is no good reason for that restriction other than internal, how it was implemented. I think Prime might have had the same restriction. But it's because UV doesn't reference one I-descriptor from another, it expands it and all the @s end up pointing to the wrong place. Actually, so if your @ merely points at the previous expression, it should work. It's as soon as you use @1 @2 etc that it'll blow up. 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] UV 9.6.2.1/uvbackup questions
It's just you. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of cheetah...@comcast.net Sent: Wednesday, September 14, 2011 11:03 AM To: U2 Users List Subject: Re: [U2] UV 9.6.2.1/uvbackup questions Is it just me, or does anybody else absolutely cringe when here in late 2011 we see anyone still running W2K for any reason? - Original Message - From: Bob Wyatt bwyatt_...@comcast.net To: u2-users@listserver.u2ug.org Sent: Tuesday, September 13, 2011 10:44:27 PM Subject: [U2] UV 9.6.2.1/uvbackup questions I ran into a client with UniVerse 9.6.2.1 on Windows 2000 Server with SP4. It looks like uvbackup does some strange things on this system, and I'm wondering if someone may have seen this or know how to change it. The uvbackup command is essentially uvbackup -f -limit 1 -v -s logfile -t z:\backupfile.img -walk d:\uvdb\accounts The backup starts at 10 P.M., and finishes around 7 A.M. for a 37 GB database resulting in a 28.4 GB backup image file. The z:\backupfile.img file is a remote server path for the backup only. For the entire 9 hours, z:\backupfile.img file never exists - it doesn't get created until the job is done, it runs out of resources, or falls into some error that causes uvbackup to ask to continue with the current file, change the file, or quit. The z: location still has plenty of disk space - more than triple the space needed. It happens with or without the -limit 1 argument. The next day, it may run fine - completes the backup without error. The hardware is a 3.06 GHz Xeon processor with 3 GB of memory, SATA-1 drives on a RAID controller in a RAID-5 array (doing over 400 MB/sec transfer speed on Reads), and the network is 1 Gb. Has anyone noticed that their backup file does not (or did not) grow or exist until the backup is done? Does anyone know of a way to convince uvbackup to use the target file immediately without awaiting completion? Does anyone know if this happens in newer UniVerse releases this same way? Lastly, if d:\uvdb\accounts has a few accounts I don't want to back up, it looks like I cannot skip them in the backup unless I create a file with a list of all of the files I want to back up. This would be several hundred thousand files, and there are new files created every day. And I can't move the accounts I don't care about. I was thinking about SourceForge findutils, but am wondering if someone has experience with this or similar Windows find utilities and uvbackup? Any insight would be greatly appreciated. Bob Wyatt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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
