Re: [U2] [OT] My XML is Chinese!?!
I suspect I know what is happening, though I can't tell you WHY. The view source function is using an encoding that doesn't match your actual file. For example the view source may think its using UTF-16 for some reason, but since its really using UTF-8 the characters are all mangled. Its just a guess. I would recommend saving the file to disk and the use another editor like notepad++ which can tell you what the file encoding is. This is likely just a bug in IE 11. There are so many better editors out there for xml data, I would just use one of those instead. On Fri, May 9, 2014 at 10:05 AM, George Gallen ggal...@wyanokegroup.comwrote: OKI've got a strange thing happening on my Win 7 IE 11 If I use IE 11 to open an XML file - it renders fine - no problems. BUT...if I right click and choose View Source - all I see are Chinese characters? I know the XML is plain text and no extended codes And it only happens on my machine, if I use another PC same setup (except IE 9) It shows English when you view Source HTML renders fine, and View Source for HTML displays English. My XML declaration line looks like: ?xml version=1.0 encoding=utf-8 ? Firefox view source displays English, as does Chrome and Safari - It's just IE11 doing it. Any Ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] BDT Sluggish
That is great, Bill, good to know if I ever see that behavior! *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, Dec 3, 2013 at 3:16 PM, Bill Brutzman bi...@hkmetalcraft.comwrote: Aaron: In line with Doug's suggestion... I created a tech support case with Rocket. BDT has a command prompt -clean launch option... that fixed it right away. Rocket also had some additional server-side troubleshooting measures that I did not try since step one corrected the problem. I suppose that I contact Rocket maybe once a year. As usual... I found Rocket's response to be... first rate. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: Tuesday, December 3, 2013 2:05 PM To: U2 Users List Subject: Re: [U2] BDT Sluggish Hello Bill, I use the BDT all day, every day, and I've never experienced this behavior, even over remote connections. I leave the syntax checking turned on all the time, and still I do not have any sluggishness or delayed behavior. I am wondering if you could be more specific as to exactly how you are using the BDT, as this may make a big difference. What specific task are you doing when you press a key and the delay appears? Is this in the resource view, or when editing a basic program, or editing file data? Finally it would be worth pointing out that the BDT is built on the Eclipse IDE, which is a notoriously heavy java program. I typically see the eclipse java process consuming over 500mb of memory even when idle. You would want to make sure that as a result of this you are not causing your computer to page the application. This may be happening if you have a lot of other applications open and not enough RAM. -Aaron On Thu, Nov 21, 2013 at 4:32 PM, Doug Averch dave...@gmail.com wrote: Hi Bill: I did notice a delay when you type in a program. BDT has a very long pause between characters. It has something to do with how the implemented their on the fly compiler. You will have to submit a issue with them. Hopefully, they will get it resolved in a few months or so. Regards, Doug www.u2logic.com/tools.html XLr8Editor for Universe and Unidata programmers On Thu, Nov 21, 2013 at 2:17 PM, Bill Brutzman bi...@hkmetalcraft.com wrote: 1. I just downloaded the latest Oct2013. 2. As with the earlier BDT release... each time I press a key... it takes two seconds to appear on the screen. 3. My PC that I am using BDT is Windows Pro 8.1... and the latest Symantec EndPoint Protect AntiVirus. 4. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] BDT Sluggish
Hello Bill, I use the BDT all day, every day, and I've never experienced this behavior, even over remote connections. I leave the syntax checking turned on all the time, and still I do not have any sluggishness or delayed behavior. I am wondering if you could be more specific as to exactly how you are using the BDT, as this may make a big difference. What specific task are you doing when you press a key and the delay appears? Is this in the resource view, or when editing a basic program, or editing file data? Finally it would be worth pointing out that the BDT is built on the Eclipse IDE, which is a notoriously heavy java program. I typically see the eclipse java process consuming over 500mb of memory even when idle. You would want to make sure that as a result of this you are not causing your computer to page the application. This may be happening if you have a lot of other applications open and not enough RAM. -Aaron On Thu, Nov 21, 2013 at 4:32 PM, Doug Averch dave...@gmail.com wrote: Hi Bill: I did notice a delay when you type in a program. BDT has a very long pause between characters. It has something to do with how the implemented their on the fly compiler. You will have to submit a issue with them. Hopefully, they will get it resolved in a few months or so. Regards, Doug www.u2logic.com/tools.html XLr8Editor for Universe and Unidata programmers On Thu, Nov 21, 2013 at 2:17 PM, Bill Brutzman bi...@hkmetalcraft.com wrote: 1. I just downloaded the latest Oct2013. 2. As with the earlier BDT release... each time I press a key... it takes two seconds to appear on the screen. 3. My PC that I am using BDT is Windows Pro 8.1... and the latest Symantec EndPoint Protect AntiVirus. 4. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TU.TO.EXCEL path
What about not specifically putting a path at all, but rather just the executable name and allow windows to find the executable in the path automatically? *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Thu, Sep 19, 2013 at 12:52 PM, Lunt, Bruce bl...@shaklee.com wrote: Hi All, I wrote a program to provide a file to download to Excel. It works fine for me but when I ask the helpdesk to run the report it fails with the error: Microsoft Excel cannot access the file 'c:\progra~1\micros~3\office13\'. The user's path is: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office\Microsoft Excel 2010.lnk How can I fix this? Do I have to always have Excel installed in the same path? Or can the path be stored in a table per user? Thanks for any help, 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] [UV] ED PERMISSIONS subroutine
hmm.. ten doesn't seem like that much. The way you describe the problem it sounds like a directory-level performance issue, i.e. its scanning directories in the filesystem and there is some directory with a very large number of entries -- far larger than it should be. I would typically guess PH or COMO might have a large number of entries, but then again not sure why STATUS function would go after those. If this was Linux or Unix, what I would do to figure this out is to put a truss / strace on the uvsh process, and use the option to show timestamps on the function calls. You'd then be able to see which OS level operation was actually consuming the time. Usually that will be a dead give away as to where the problem is. I'm not sure how to accomplish the equivalent of this on Windows platforms. I did a quick search on the internet and I came up with a sysinternals tool called Process Monitor. While I can say that I've used many of the sysinternals tools in the past and had success, I've never done this particular type of tracing on windows so I don't know how to give you specific instructions. http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, Aug 20, 2013 at 4:29 PM, Dianne Ackerman dia...@aptron.com wrote: c:\level contains about 10 universe accounts. All are local directories, none are remote. -Dianne On 8/20/2013 4:24 PM, Aaron Titus wrote: Hi Diane, a couple of questions. How many other directories exist within c:\level ? Is C:\ACCOUNT a local directory and c:\level remote? *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, Aug 20, 2013 at 2:00 PM, Dianne Ackerman dia...@aptron.com wrote: OK, I've found the PERMISSIONS subroutine (APP.PROGS PERMS.B) and have narrowed this issue down more. It's actually a slowness in the basic command STATUS. It's instantaneous in an upper level account (eg C:\ACCOUNT) but takes 4-5 seconds in a lower level account (eg C:\level\ACCOUNT). Any thoughts? Thanks -Dianne On 8/15/2013 9:50 AM, Dianne Ackerman wrote: Does anyone know anything about the -PERMISSIONS subroutine used by the ED verb in Universe? Running 11.1.12 on Windows, the ED verb has a huge delay and we've tracked it down to that subroutine call in the basic ED program. If I could look at that subroutine to see what it's doing, maybe I can figure out what's causing that delay. Thanks! -Dianne ED BP ED.B The file BP is read-only and cannot be updated. 3988 lines long. : L PERMISSIONS 0153: PERMISSIONS = '-PERMISSIONS' : L 0308: CALL @PERMISSIONS(EDIT.FILE,EDIT.PERM.MODE,EDIT.PERM.IN,EDIT .PERM.OUT) : EX ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-usershttp://listserver.u2ug.org/**mailman/listinfo/u2-users http**://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] ED PERMISSIONS subroutine
Hi Diane, a couple of questions. How many other directories exist within c:\level ? Is C:\ACCOUNT a local directory and c:\level remote? *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, Aug 20, 2013 at 2:00 PM, Dianne Ackerman dia...@aptron.com wrote: OK, I've found the PERMISSIONS subroutine (APP.PROGS PERMS.B) and have narrowed this issue down more. It's actually a slowness in the basic command STATUS. It's instantaneous in an upper level account (eg C:\ACCOUNT) but takes 4-5 seconds in a lower level account (eg C:\level\ACCOUNT). Any thoughts? Thanks -Dianne On 8/15/2013 9:50 AM, Dianne Ackerman wrote: Does anyone know anything about the -PERMISSIONS subroutine used by the ED verb in Universe? Running 11.1.12 on Windows, the ED verb has a huge delay and we've tracked it down to that subroutine call in the basic ED program. If I could look at that subroutine to see what it's doing, maybe I can figure out what's causing that delay. Thanks! -Dianne ED BP ED.B The file BP is read-only and cannot be updated. 3988 lines long. : L PERMISSIONS 0153: PERMISSIONS = '-PERMISSIONS' : L 0308: CALL @PERMISSIONS(EDIT.FILE,EDIT.**PERM.MODE,EDIT.PERM.IN,EDIT .PERM.OUT) : EX __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Configuration --
I wouldn't be concerned about the default value being too high. The main reason to modify the tunables is to increase them when you are hitting a limit. Years ago, when kernels had very little shared memory in their out-of-the-box configuration, the tunables were set quite low so that Universe would function after installation. With decent sized concurrent users (or lots of phantoms) it would frequently need to be increased. The defaults now are more reasonable. smat -a will show all the lock tables; with that you can see where you are at a given point in time. Increase it if you are reaching the limit but there is no reason to lower them if you are not. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Wed, Aug 14, 2013 at 6:23 PM, Rick Nuckolls r...@lynden.com wrote: The link to SQL makes some sense. My original thought was RLOWNER was to Shared Locks (RL) as RLTABSZ is to Exclusive (RU) locks, but the default (300) seemed a little high for tracking RL locks, especially if that is 300 x GSEMNUM. Also, the only reporting that I can find is as a RL entry in the LIST.READU output, with multiple locks on a single record appearing as a single record lock in the Active Group Locks list. Interestingly, smat -r shows the user info for the shared locks, but not the exclusive locks. This makes me wonder if the configuration value is still relevant, or if the tables have been combined. In that there seem to be very minimal uses for shared locks outside of SQL, 300 seems a bit high for the average Legacy PI/OPEN install. Thanks, Rick -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Wednesday, August 14, 2013 2:00 PM To: U2 Users List Subject: Re: [U2] Universe Configuration -- The RLOWNER parameter relates to record shared locks and were introduced to Universe when the SQL syntax was. The value determines the number of slots available to hold the user information of the processes holding the shared locks. If any shared locks are held against a record an exclusive lock, READU or FILELOCK, EXCLUSIVE will fail or take the locked clause. If you do not use SQL or specifically request a READL lock in basic then you can basically ignore it I believe from memory. Regards Phil -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Thursday, 15 August 2013 6:06 a.m. To: 'U2 Users List' Subject: [U2] Universe Configuration -- Can anyone provide a cogent explanation of the RLOWNER configuration parameter in UV? How does it relate to the GSEMNUM and GLTABSZ/RLTABSZ? What are the contents duration of an associated entry? Is there any way to determine the number in use (as opposed to the configured number)? The manual's explanation is a bit short. Thanks, Rick Nuckolls ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Type 30 files modified when LISTed? (UV 10.0.2)
If I remember correctly, Universe always opens files for update, regardless if you actually write to the file or not. This will cause the modified time on the file to be changed. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Wed, Aug 7, 2013 at 10:27 AM, George Gallen ggal...@wyanokegroup.comwrote: If I LIST a Type 30 file, Then execute a ls -la FILENAME it shows the last time DATA.30 portion was modified was when I did the LIST. Why would a LIST modify the date/time stamp that a file was modified? The OVER.30 wasn't changed at this point. 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] Type 30 files modified when LISTed? (UV 10.0.2)
Type 19/1 files are actually directories at the operating system, not files. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Wed, Aug 7, 2013 at 11:09 AM, Manu Fernandes e...@infodata.lu wrote: hi, When uv open a T30, it's header is loaded into uv's shared memory (until all user session which adress the file terminate), ready for writing. File is open for writing, I suppose some header info are updated at open time. Manu George Gallen ggal...@wyanokegroup.com a écrit : If I LIST a Type 30 file, Then execute a ls -la FILENAME it shows the last time DATA.30 portion was modified was when I did the LIST. Why would a LIST modify the date/time stamp that a file was modified? The OVER.30 wasn't changed at this point. George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
I'm pretty sure Universe can open windows SMB drives, but I don't know that I ever tried it with other MV systems. Keep in mind the most important thing about windows SMB drive shares: unless you are logged into the desktop, it doesn't automatically map them. You may need to issue a net use command to authenticate the share (or set it up within windows so that authentication is not needed.) *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Mon, Aug 5, 2013 at 9:31 AM, Kevin King ke...@precisonline.com wrote: I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] XML or JSON converter for Unibasic
JSON is far more lightweight vs XML. Also if you upgrade to 7.3 Unidata, the built-in JSON library (called UDO) is very easy to use. This would be my recommendation. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Fri, Aug 2, 2013 at 12:59 PM, charles_shaf...@ntn-bower.com wrote: We use UNIX on our web and database servers, so the mvScript wouldn't help in our case. I would like to learn more about the built-in restful services you mentioned. That is built-in to Unidata? We are at 7.2. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org, Date: 08/02/2013 11:41 AM Subject:Re: [U2] XML or JSON converter for Unibasic Sent by:u2-users-boun...@listserver.u2ug.org My preferred solution is to use a middle tier web service in C#, that exposes method calls for either XML or JSON (automatic, just depends on the content-type in the request). Then you can call that from anything that expects JSON or SOAP. But that's only because I began doing that long before restful web services got built into the product. Or bypass PHP and use mvScript if you can live with IIS. Brian -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: 02 August 2013 17:12 To: U2 Users List Subject: [U2] XML or JSON converter for Unibasic I am looking for a way to send the output of a Unidata data query in Unibasic back to a web server (PHP) for building web pages. Up until now I have used a proprietary method (LF, HTAB, etc.), but I would like to simplify/standardize the method. Seems like this could be done with XML, or JSON or something I don't know about. Has anyone had experience with this and could you offer some advice? Hoping for a simple subroutine approach as opposed to a comprehensive commercial package. Management here is very price sensitive. When I say price sensitive, I mean that if it costs anything, they get their panties all in a bunch. A few hundred dollars might be sellable, a few thousand would not be. 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 -- This email was Virus checked by UTM 9. http://www.astaro.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] Mobile phones
Symeon, are you planning to send the sms message directly through a local gateway at your company, or through a third party provider, or via email? If the latter, in the US, all the carriers have different email gateways. It sounds to me like you need to collect more information than just the phone #. With other web sites I have used (like airline web sites for example) they always ask you if a number is a mobile number, and which carrier you are using. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Wed, Jul 10, 2013 at 8:43 AM, Brenda Ives bren...@marketamerica.comwrote: There is a company that has an API that determines that. It will with 1 number or a list of numbers. Don't know how well it works. www.phonevalidator.com Brenda Ives -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, July 10, 2013 7:12 AM To: u2-users@listserver.u2ug.org Subject: [U2] Mobile phones Hi I have an application that is based in the UK, one of the things it does is allow entry of a phone number, I then determine if this is a mobile (cell phone) and send a text (easy in the uk as all mobiles begin with 07) We are embarking upon our first US client (well existing uk customer with a US presence) so my question is - how with US phone numbers can I determine if it is a cell phone ? Thanks 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SAN?
With Universe, its a different IO pattern than most system administrators are familiar with, especially when you put an entire account on non-local storage. In particular things like the PH folder (from phantoms) and COMO files from traces. Files are frequently opened and closed, created and deleted. These operations are far more expensive on non-local storage. File locking is particularly problematic on NFS. The pattern may vary considerably based on what your application code actually does. I would highly recommend using analysis tools to take a DETAILED picture of what your IO pattern looks like today, and then show it to the vendor of your SAN and make sure its being tuned properly to handle it. When I say detailed, what I mean is looking at all of the metrics like frequency of operations (open,close,write,delete), the latency of those operations, disk queue length, etc and not just the relative amount of read/write. The most common cause of poor disk performance is taking too simplistic of a view when setting requirements. This is especially true in shared environments. While shared often is cheaper and easier to maintain, this is frequently accompanied by decreased performance when the applications that are sharing the storage have substantially different IO patterns. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, Jul 2, 2013 at 1:50 PM, Ty Haller thal...@sefcu.com wrote: Thanks. I'm aware of the advantages. I was more concerned with the IO requirements and how that would impact shared storage. Ty Haller SEFCU Lead Administrator - System Services thal...@sefcu.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Tuesday, July 02, 2013 11:13 AM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] SAN? Ty, We have used a NetApps SAN for a number of years with Solaris for Universe data. (For Universe) there is the obvious tweak of allowing direct access to NFS, and depending on the type of SAN, there are probably some mount options to optimize the throughput. It also helps to have a fair amount of memory for file caching, but it works great and provides many important advantages. A couple of caveats: Do not allow access to snapshots through the same NFS mount as the primary data. For NetApps, at least, the snapshot has the same inode as the live data file, so the snapshot tree must be mounted as a separate device to avoid confusing (Universe) with conflicting file headers and data. NFS mounts work fine, as long as access to a particular directory tree is managed by a single data server. Oracle supports this same configuration, though I do not think that Rocket has much experience with it. Although difficult, it is possible to install Universe a SAN, and then run it on a VM, which means that you can snapshot almost all of the UV environment at once! Rick Nuckolls Lynden Inc -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Ty Haller Sent: Tuesday, July 02, 2013 6:15 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] SAN? Morning, I am curious if anybody has UniData Accounts running off a Shared Enterprise SAN? We currently have an Enterprise SAN for our VMware Environment and would like to put a handful of UniData Test Accounts on it. We are using UniData 7.2 on an IBM P6 running AIX 6.1, the SAN would be 4GB Fiber Attached. Thoughts? Ty Haller | Lead Administrator - System Services | SEFCU | thal...@sefcu.com 700 Patroon Creek Blvd. Albany, NY 12206 | Phone: 518-464-5210 | Fax: 518- 464-5209 This message may contain confidential information and is intended for the sole purpose of communication with the addressee. Dissemination or publication in any format is strictly prohibited. If you have received this communication in error please notify SEFCU immediately. Help save a tree. Please print this e-mail only if it is truly necessary. Thank you. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This message may contain confidential information and is intended for the sole purpose of communication with the addressee. Dissemination or publication in any format is strictly prohibited. If you have received this communication in error please notify SEFCU immediately. Help save a tree. Please print this e-mail only if it is truly necessary. Thank you. ___ U2-Users mailing list
Re: [U2] How do I get the U2 Metadata Manager to work
Hi Dan, With respect to BDT version, I installed it a month or two ago, and recently applied an update (mine shows version 3.0.6) but note that in the text description it still says March 2012 as the date. Can we assume that 3.0.6 is the current version or did we miss something? Also, when using libraries like UDO for example, the syntax highlighting flags unassigned variable warnings; is there a way to teach it to avoid this? -Aaron *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Thu, Jun 6, 2013 at 3:35 PM, Daniel McGrath dmcgr...@rocketsoftware.comwrote: Hi Mecki, It sounds like you are running a old copy of BDT. Unassigned variable warnings from CALL statements was fixed sometime last year. Follow the instructions here (http://updates.rocketsoftware.com/u2/) to make sure you have the latest versions. I can't recall which version, but if you are on too old of a release, that update site won't work for you, so you would have to download the full version again before you can use it. The latest full package is MAR2013. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 1:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I'll keep that refresh option in mind. Still a hassle and I would prefer if they would just get rid of that 'feature'. I also noticed that unassigned variable error that pops up for all functions including CALL that return a new variable. Some people may regard assigning a value before you use a function as good coding standard, I don't see the point, though. I haven't tried this in anger, but I recall that BDT treats all files as data files and you can edit data as well. Maybe this is a feature they could add to keep Dict files and hashed files separate so you don't have to look for the BP within 1000 data files every time. I have been using an external editor (mv developer) for several years now. I always save the program to disk, open it with ED, add a blank line somewhere and file it with FIBC. That takes care of PRC. Locking works when you open a program externally, so the only chance that someone could snatch the program ab incorporate it into another project is in that short period between saving in the external editor and opening it with ED on the UD server for the first time. Since I am the only UD programmer in the company it is virtually impossible that will ever happen. Well, and as long as you have OS.ED you can bypass PRC anyway. OK, if you NEVER EVER fix data with ED then you could probably remove it, but who would voluntarily block the only fire escape? We have a really old version of PRC (3.9) and I can't make a business case to invest in new software. There are other tools like mv.SSIS that I'd rather get first. Especially since tools like Rocket's Metadata Manager don't seem to work or I am too stupid to install them properly. I managed to get at least VSG to work on one SQL Server 2008 box, but that is a really primitive tool and I hate it. And I am still looking for a way to read data from a relational database in a Basic program. On 06/06/2013 18:30, Tom Whitmore wrote: Hi Mecki, One think that I always do with BDT is right-click on the program, select refresh, then open the program. That seems to be the only way to make sure I have the current version. Currently, BDT is sort of working with PRC but it isn't honoring file ownership so I'm unable to let the programmers use BDT. You do need to get some programs from Susan for things to work as I have it now. I'm told the latest version of PRC supports BDT. We are currently testing the new version of PRC but I haven't had an opportunity to try BDT on this version.. As far as false errors, the latest version of BDT is greatly improved. However, I have noticed couple of false errors: 1) if the numeric subroutine label does not have a : BDT doesn't recognize the label (like 99*). 2) LOCATE(J,ORIG.PH,2;XXXPOS) THEN FOUND=1 ELSE FOUND=0 , BDT will report that XXXPOS was never assigned a value. There are other instances of this type of problem. One thing I wish I could do is edit records in hashed files, but I don't see how to accomplish this. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 12:06 PM To: U2 Users List Subject: [U2] How do I get the U2 Metadata Manager to work Ever since we finally upgraded UniData at work I have been trying out the new tools and don't seem to have much fun with them. The best one is XAdmin and I use it a lot these days. IMHO the interface is a bit
Re: [U2] Help needed..
I don't think you should be using OSOPEN. This is for block IO. Aren't you reading a sequential file one line a t a time? *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, May 7, 2013 at 7:54 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: Note that if the file was built in Windows, it may have a CR:LF combination at the end of each line. Reading it in, PICK will cleanly distinguish one as a line delimiter, but you will still have the extra (unwanted) character at the end of ROW. I forget which one is which, but any time you read in a row from a TXT file, you will want to convert the unwanted character (I believe it is a CHAR(13)). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Tuesday, May 07, 2013 7:46 AM To: U2 Users List Subject: Re: [U2] Help needed.. Hi, Personally, I would use OPENSEQ and READSEQ. Each READSEQ would read the next field in the record. The file needs to be a type 1 or type 19 for OPENSEQ. An example of this is: OPENSEQ FILE.NAME2, KEY.TXT TO SOURCE.FN ELSE STOP 'Unable to open ':KEY.TXT LOOP READSEQ ROW FROM SOURCE.FN ELSE EXIT ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If the file isn't a type 1 or 19 then use the REMOVE function on the internal array. It is very fast. An example is: READ TXT.REC FROM F., KEY.TXT TXT.REC=TXT.REC LOOP REMOVE ROW FROM TXT.REC SETTING POS UNTIL ROW='' AND POS=0 ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If you need to reprocess the array then add TXT.REC=TXT.REC and start the process again. The reason is that assigning the array to itself will reset the internal pointer REMOVE uses to keep track of where it is. One caveat, REMOVE goes to the next delimiter (field, value, subvalue or text mark) so you need to know the data you are working with. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, May 07, 2013 12:36 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help needed.. Wjhonson wjhonson at aol.com writes: That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. Hi I just used OSOPEN to open the file and the file is not getting recognized. Here is the piece of script I have used. OSOPEN FILE.NAME2 TO F.KEYFILE ELSE STOP CAN Not find file Where FILE.NAME2 is the path and the file name. Also as suggested below, how could I use get list for a file which is opened from server. Thanks in Advance, Sathya V. -Original Message- From: Israel, John R. JohnIsrael at daytonsuperior.com To: 'U2 Users List' u2-users at listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO at FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-bounces at listserver.u2ug.org [mailto:u2-users-bounces at listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users at listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users
[U2] revision control with git/github
I am curious to know if *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] revision control with git/github
Oops. Hit send a little too soon. I am curious to know if anyone has implemented revision control with git or github for Unibasic programs, and system builder objects. If so, how did you do it? *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, Apr 30, 2013 at 10:12 AM, Aaron Titus ati...@fwdco.com wrote: I am curious to know if *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] bdt in juno
I did this yesterday using the eclipse software update installation site that rocket has. There is a webinar on rocket's web site that explains exactly how to to it. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Fri, Mar 8, 2013 at 7:57 AM, Symeon Breen syme...@gmail.com wrote: That's good to hear Doug - what url did you use for the plugin, or did you do it manually ? If manually did you coppy everything in the plugins directory or just certain pieces ? Thnaks Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: 07 March 2013 15:23 To: U2 Users List Subject: Re: [U2] bdt in juno Hi Symeon: I have installed BDT as a plug-in on Juno SR2. I found no problems with it even when using our XLr8 plug-ins. I like it better than the stand alone because I can use a java 1.7 instead of 1.6 and I can use current Eclipse 4.1 instead of 3.5. Regards, Doug www.u2logic.com/tools.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] bdt in juno
I don't remember off the top of my head but its contained in the slides for the webinar. They are freely downloadable in PDF form. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Fri, Mar 8, 2013 at 12:12 PM, Symeon Breen syme...@gmail.com wrote: URL please of the update site ?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: 08 March 2013 16:47 To: U2 Users List Subject: Re: [U2] bdt in juno I did this yesterday using the eclipse software update installation site that rocket has. There is a webinar on rocket's web site that explains exactly how to to it. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Fri, Mar 8, 2013 at 7:57 AM, Symeon Breen syme...@gmail.com wrote: That's good to hear Doug - what url did you use for the plugin, or did you do it manually ? If manually did you coppy everything in the plugins directory or just certain pieces ? Thnaks Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: 07 March 2013 15:23 To: U2 Users List Subject: Re: [U2] bdt in juno Hi Symeon: I have installed BDT as a plug-in on Juno SR2. I found no problems with it even when using our XLr8 plug-ins. I like it better than the stand alone because I can use a java 1.7 instead of 1.6 and I can use current Eclipse 4.1 instead of 3.5. Regards, Doug www.u2logic.com/tools.html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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