Re: [U2] Question about updating customer's systems...
I would also suggest either of the following: 1) If possible, run Dev/Test/Prod on separate machines. Obviously, this requests budget, but if your production system is the lifeblood of your company, it is worth it. Otherwise: 2) Have the accounts set up with appropriate file permissions (owner/group) and *separate login credentials* so someone if Dev cannot simply change a file pointer to start modifying production. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, 17 June 2011 4:58 AM To: U2 Users List Subject: Re: [U2] Question about updating customer's systems... We typically recommend that customers have at minimum two accounts, a test account and a live account which are virtually identical and share nothing. This allows us to install to the test account and have them test the code and then we take the same ravel files and roll it up to their production environment. For those customers where we develop on their system, we also recommend having a development account separate from the other two. We then roll from DEV - TEST - production. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logical error
In UniBasic, you could just do: CRT CHAR(27):[44m -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of sathish Sent: Wednesday, 8 June 2011 11:24 PM To: u2-users@listserver.u2ug.org Subject: [U2] Logical error Hi, I am having problem in using escape sequence in UniBasic coding.I cant use the following command in UniBasic code. Command: echo -e \033[44m. If i use this command in UniBasic code it shows error for using \.So can you suggest any solution for using this command in UniBasic coding. Thanks, Sathish ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] File Item Count Limit?
Assuming you're talking about a hash file, I'd hazard a guess that it would be only limited by: 1) File size 2) The ability of the tools to handle the file record list (such as SELECT) 2.1) I.e, memory limitations and 2.2) The count variable (assuming it is a 32bit signed int, that gives you a max 2^31 = 2147483648 records) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, 3 June 2011 6:38 AM To: U2 Users List Subject: [U2] File Item Count Limit? I'm on UV/Linux Just curious, is there a limit to the number of items you can have in a file? or just limited to overall file size? We have one file that has about 15M items at present. Not much data in each item, just a crap load of them. George George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pondering recent thread on compact framework
While you have a lot of great points in here Tony. I have to strongly disagree with the Don't ask why, just get on the bandwagon Asking why doesn't mean you won't do it. Asking why is fundamental to understanding the real reasons. If you don't understand the real reasons, you are doing no better than providing your own limited interpretation of the users actually want and run the very real risk of providing a solution that you think is what they want (for example, it provides a GUI) as opposed to a solution the users really want. Don't just find out 'what' the users want to achieve, understand 'why' as well. That is, unless you have the holy grail of users that are able to perfectly articulate the solution that works for them each and every time. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, 1 June 2011 8:19 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pondering recent thread on compact framework From: Symeon Breen Well what a conversation I think u2 has as much to do with mobile apps as sql server does. Completely divorced. As programmers we should take an interest in all sorts of technology , I don't call myself a picky i am a programmer, what language shall i use today ? What a conversation indeed. Dove-tailing with Symeon's note, technology is irrelevant, always is, it's the applications that are relevant. Find some app worth creating, and generate revenue selling it. That's the bottom line. Many of you are employed to provide intranet solutions but many of you, or your companies, derive income by providing solutions to a wider audience. We earn our income by selling what THEY want. Find out what that is and sell it to them. If you work for a company, find out what your management wants, and then provide it. This notion of trying to come up with an app to sell is kinda backwards - especially if the only thing you can think of (or know about) are games. I haven't responded to this thread recently because I've been doing some travelling around the country. One of my activities has been to do demos and get field feedback for a new SMS/texting-based service I've written backed by MV. (Universe may be used for international/unicode support.) We're not using apps because I don't want to get involved in the issues associated with Java or Objective-C, device-specific limitations, or mobile OS release issues. I need to pick low-hanging fruit. I'm not even jumping on the HTML5/CSS3 bandwagon yet. With 7 billion people on this planet, there are over 5 billion mobile devices in use. A significant percentage does not have internet access. While all the ads are for flashy app-driven devices, I believe most of the devices used today are very basic, sold without internet service plans. Most (I'll dare to say) users and devices make use of SMS/texting, and statistics for billions of text messages per day worldwide support a focus on that market. There are two points here. First, it all starts with the application, and all of us are involved with business apps in one way or another. If anyone here can't come up with a reason to use a mobile device, just ask real users. In my recent travels it was hard to keep up with the ideas that people had for using my software (and they don't know or care that it's MV or BASIC on the server). As a result of the feedback, we're planning of kicking off several small verticalized businesses in addition to supporting a more horizontal consumer offering. Users are in a better position than technologists to express how they use devices for business. People in this forum might not be able to come up with applications for mobile devices, but end-users sure as heck can. Talk to them! Find out what your users (or prospects) need! Don't feed people with technology (how can we use mobile?), ask people what problems THEY need to solve and ask if mobile would help. Second, if you think more in terms of Data, what you deal with every day, then the deployment method is totally irrelevant - and it's subject to change over time anyway. The thing about Mobile is that it's Mobile, not so much that it's pretty. Focus on the benefits and dynamics of mobile computing first, and the specifics of the UI can be discussed after you have designed a paradigm for retrieving server data from a mobile client. We're starting with SMS - we might later introduce device-specific apps as an enhancement, but we're Mobile first and app developers second. When GUI first arrived on the scene people in these MV forums were asking why GUI? and what would I do with a GUI? Even now people still ask how do I create a GUI?. Overall, we're in the business of Data Processing with a solid engine for development and execution of business rules, not User Interface Processing. UI's change continuously over time. Don't ask Why, just get on the
[U2] Multi-Value DM Comparisons WAS: uv 2 ud
Out of curiosity, is there anywhere that has a comprehensive Multi-Value DB comparison? Something like the Relational DB comparison on Wikipedia(http://en.wikipedia.org/wiki/Comparison_of_relational_database _management_systems) but more relevant to the MV world? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, 1 June 2011 12:24 PM To: U2 Users List Subject: Re: [U2] uv 2 ud I for one am absolutely blown away at the price/performance of QM. Just getting started with it here but looking forward to seeing how far I can push this. On Tue, May 31, 2011 at 12:21 PM, Bob McGrath b...@rm-consulting.biz wrote: Symeon Breen symeonb at gmail.com writes: Under these circumstances, another alternative is to migrate to OpenQM, which is very mature, low cost, and very feature rich. bobm... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] u2ug
u2ug has been unavailable for at least a day. Is it just me? ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects - What Is It?
Kevin, Have you seen the PHP PDO driver article on u2devzone.com? Although it is a 'build it yourself article', it does come with the source code so you should be able to just compile and use it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, 20 May 2011 2:26 PM To: U2 Users List Subject: Re: [U2] Uniobjects - What Is It? I'm interested to know more about how folks are using UOJ with PHP. I've tried making that connection numerous times but .. just haven't been successful yet. Big fan of PHP but using the UO connection on Windows is ... less than optimal for my needs. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pondering recent thread on compact framework
Tony, there is (at least) a fourth option that I see 4) Not directly connecting to U2 from the mobile phone, but some intermediate web server in between. Using a REST or Webservices API from the mobile device would probably be far more common than directly connecting to U2. For anyone (if there is) doing it this way, you wouldn't see any questions on that here. The other question would be, are the majority applications built on U2 covering a segment that so far doesn't have much penetration on mobile devices (whether it is a U2 system or other)? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, 19 May 2011 8:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] Pondering recent thread on compact framework Since it's a little slow here I'll open a discussion which is borderline between Tech and Community. The thread Uniobjects.Net Compact Framework and Visual Basic had an interesting resolution. I'd like to see more discussions on that topic. If only there were enough people interested in mobile connectivity, I'd get a WinMobile to replace my old Win PDA devices, and offer app development services for these devices. I've blogged about mobile development and have written proof-of-concept apps. But there is never a critical mass of demand for any device (Win, Android, iPhone, Blackberry, etc) to justify the investment required to do a lot of this. What I'm wondering of the U2 audience is: 1) Is there little to no interest in mobile computing for U2 systems despite hundreds of thousands of apps satisfying a hunger in the mobile-user marketplace? If that's the case, it's no wonder the Pick community continues to lose market share. 2) Is everyone with interest happily doing development internally? If that's the case, I'm surprised there isn't more discussion here. What are you folks doing to create mobile apps for your U2 business systems? 3) Are people resigned to I don't know how to do this therefore my company won't do it? Unfortunately that sort of thinking is quite common in the general Pick community, and it's no less than suicidal for the market and individual careers. In short - if you don't do it, you will be replaced by those who do - as many of you have seen over the years. So where do U2 developers stand with mobile? Personally I'm doing a lot with SMS rather than trying to write apps for every phone (all based on MV). That's just my solution. I'm also doing a lot with voice/telephony, virtual PBX integration for companies that want to shift from hardware solutions to more versatile phone systems backed by MV. This is only mobile because some companies have decided to forego the pleasures of the GUI for common voice menus. It's just another solution where mobile computing was once considered. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pondering recent thread on compact framework
Good points there David, which I notice a lot of people don't consider when dismissing the benefits of an app vs web. Another point is the better offline capabilities of a native app. I'm a lot of people on Vodafone over here in Australia (myself include) can understand the importance of this. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Thursday, 19 May 2011 2:11 PM To: U2 Users List Subject: Re: [U2] Pondering recent thread on compact framework Hi George I use a Windows phone 7. With a web page there is a cost of time for downloading a web page and a performance issue with screen loading. With an app, I conform to the user interface of the phone which are more intuitive to a phone user. The app loads quicker and runs quicker. However if you have users using android, blackberry, iphone, etc then you need to create a separate app for each phone. With the new phones you need to load the app from the marketplace which is difficult for an enterprise application. Hence the decision to use an app vs web is related to performance and intuitive interface vs portable and easier to load. Remember also that most phones have no virus protection and are a potential risk area for Trojans and viruses for web interfaces. An app is a bit more secure. Again there are other features I can use on the phone such as sending a spreadsheet of KPIs to the phone rather than having an application to access KPIs. There are just too many ways to skin a cat. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pondering recent thread on compact framework
Tony, I completely agree with you. I think you are misinterpreting my sor far ... much penetration to mean isn't appropriate Take for banking sector, which is typically quite reserved/slow in uptake of current technology vs the gaming sector on the other side of the spectrum. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, 19 May 2011 11:05 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pondering recent thread on compact framework For George, I think a question about what would be some potential uses characterizes our community, and is part of what prompted me to open the discussion. With hundreds of thousands of apps out there for every mobile device, there are any number of potential uses for mobile access, regardless of the platform on the back-end. With apologies for my directness and not the content: Pick people need to stop thinking like Pick people and start looking at what the rest of the world is doing in terms of data access and updates. To answer your question more directly however, many companies these days look for things like reporting, BI, dashboards, GUI, and web services to satisfy their needs to communicate current data to trading partners, management, and other employees. The mobile device is just another UI where you can gather and provide information on a timely basis. For Dan, your point on connecting indirectly is my preferred method, and was the suggestion I made when an issue was presented with UO/CF. As to U2 applications covering a segment that isn't covered by mobile devices - I think U2/MV has widespread applications in every market, and almost everyone has a cell phone these days. I don't think there's anything to separate the kind of people who use U2 apps from the kind of people who use cell phones. And one of my points is precisely that, that these things are unrelated. People who use mobile devices download apps of all kinds. There's no reason why apps based on U2 should be categorically any different. As many people would be ready to state, we're selling applications, not databases. Thanks for your responses. T From: George Gallen To further the question, what would be some potential uses of mobile phone with U2 that would not be covered with website usage with U2, with different screen layouts? Or are you talking about smartphone apps? From: Dan McGrath 4) Not directly connecting to U2 from the mobile phone, but some intermediate web server in between. Using a REST or Webservices API from the mobile device would probably be far more common than directly connecting to U2. For anyone (if there is) doing it this way, you wouldn't see any questions on that here. The other question would be, are the majority applications built on U2 covering a segment that so far doesn't have much penetration on mobile devices (whether it is a U2 system or other)? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pondering recent thread on compact framework
Sorry, that should have been I'm sure a lot of people as opposed to I'm a lot of people I can assure everyone, I am just a single person. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, 19 May 2011 2:36 PM To: U2 Users List Subject: Re: [U2] Pondering recent thread on compact framework Good points there David, which I notice a lot of people don't consider when dismissing the benefits of an app vs web. Another point is the better offline capabilities of a native app. I'm a lot of people on Vodafone over here in Australia (myself include) can understand the importance of this. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Thursday, 19 May 2011 2:11 PM To: U2 Users List Subject: Re: [U2] Pondering recent thread on compact framework Hi George I use a Windows phone 7. With a web page there is a cost of time for downloading a web page and a performance issue with screen loading. With an app, I conform to the user interface of the phone which are more intuitive to a phone user. The app loads quicker and runs quicker. However if you have users using android, blackberry, iphone, etc then you need to create a separate app for each phone. With the new phones you need to load the app from the marketplace which is difficult for an enterprise application. Hence the decision to use an app vs web is related to performance and intuitive interface vs portable and easier to load. Remember also that most phones have no virus protection and are a potential risk area for Trojans and viruses for web interfaces. An app is a bit more secure. Again there are other features I can use on the phone such as sending a spreadsheet of KPIs to the phone rather than having an application to access KPIs. There are just too many ways to skin a cat. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using DICT items in basic program
If you are using UniData you can create an I-type dictionary. For the location (attribute 2 in the dictionary) put either EXTRACT(@RECORD,2,2,0) or, alternatively, if you already have a D-Type dictionary for the 2nd field (let us call it ADDRESS for arguments sake), you could put EXTRACT(ADDRESS,1,2,0) Now, if we called the above dictionary item 'CITY', you can get your required listing (sorted by CITY, ascending) by: LIST CLIENT CITY BY CITY If you are using UniVerse, this should be fairly similar. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Vaishali Patil Sent: Monday, 16 May 2011 4:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using DICT items in basic program Hi, Can you tell me how can we crate a dict item to sort a specific multivalue. For eg a file name is CLIENT. And I want to list the CLIENT keys with 2nd multivalue of 2st field. i.e CLIENT Vaishali 1 2 Pune char(253)mumbai and when I list the result should appear like : Vaishali mumbai. Your help will be appriciated. Thanks, ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata RESIZE CONCURRENT
Upgrade to 7.2.8 before you try it. We tried this on 7.2.5 in Dev and required a reboot from corruption. We were informed we need to upgrade 7.2.8 to get the fix for it. As always, I'd suggest doing anything new a few times on a Dev server before trying it on a Production server. Cheers, dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Wednesday, 4 May 2011 8:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata RESIZE CONCURRENT Unidata 7.2.5 on RedHat. Historically, we have had downtime and a brief (1 hour) maintenance window each week where we memresize our files. We'd like to switchover to RESIZE/CONCURRENT to reduce downtime and would like to hear from anyone doing this on a production system. It's not that I don't trust it: I'm just looking for insight, gotchas, pros/cons of memresize vs RESIZE or other input from those who might've gone down this road already. TIA, -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata RESIZE CONCURRENT
Hi Wally, I just confirmed with our Admin that it was programs crashing, not a corrupt file that required the reboot. Thanks for the clarification and actual issue ID. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, 4 May 2011 10:02 AM To: U2 Users List Subject: Re: [U2] Unidata RESIZE CONCURRENT I am not aware of any problems with RESIZE CONCURRENT that resulted in a corrupt file. There is a problem that can occur that results in a WRITE failure, but not physical file corruption. From the 7.2.8 readme (for Linux you will need to upgrade to 7.2.9): Issue UDT-3787 - Problem Description UniBasic -- After a RESIZE CONCURRENT command had been run on any UniData file on a server, subsequent updates to records in another UniData file could result in a fatal UniBasic runtime error: U_LLM_Release error 7 This problem occurred very rarely. While it could occur with an update to any UniData file type, it had only been reported with updates to a DIR-type file within UniBasic. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Tuesday, May 03, 2011 4:23 PM To: U2 Users List Subject: Re: [U2] Unidata RESIZE CONCURRENT Upgrade to 7.2.8 before you try it. We tried this on 7.2.5 in Dev and required a reboot from corruption. We were informed we need to upgrade 7.2.8 to get the fix for it. As always, I'd suggest doing anything new a few times on a Dev server before trying it on a Production server. Cheers, dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Wednesday, 4 May 2011 8:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata RESIZE CONCURRENT Unidata 7.2.5 on RedHat. Historically, we have had downtime and a brief (1 hour) maintenance window each week where we memresize our files. We'd like to switchover to RESIZE/CONCURRENT to reduce downtime and would like to hear from anyone doing this on a production system. It's not that I don't trust it: I'm just looking for insight, gotchas, pros/cons of memresize vs RESIZE or other input from those who might've gone down this road already. TIA, -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received
Re: [U2] Disclosing technology - Was 'Has anyone ever heard of Kyle Stetson?'
Just as an aside, there are better reasons for not making your underlying technology public knowledge. A lot of companies have it in their security policy to not disclose this information. Knowing a company's underlying architecture makes it easier to look for specific vulnerabilities or execute 0-day exploits. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: Sunday, 10 April 2011 12:46 AM To: U2 Users List Subject: Re: [U2] Has anyone ever heard of Kyle Stetson? Thanks Dave for providing a first name. Is your name Dave Parkland? Are you willing to provide the name of your company? I think Laura mistook you as the OP for this post. I'm with Laura in thinking that in a forum like this, anonymity is not as professional nor as effective (or even comforting or happy) as letting us know who you are. I will grant that there could be reasons for such anonymity, however. There are companies that would not want anyone sending an email from their domain to any list related to any of their underlying technology, thinking it all to be part of their strategic advantage or possibly not wanting their competition, prospects or customers to know about their technology for other reasons. Perhaps most companies these days recognize there is some benefit to getting their name out there, even with employees asking technical questions on a list, but I'm guessing some still wish for more privacy. So, I am not opposed to you being somewhat anonymous if that is important to you. A good way for someone to do this is to indicate in some posting a name we can use, even if not your real name, and an indication that you work for a company that wishes to remain anonymous. Optimally I would like to know a person's full name and organization of those in a community like this one. I, for one, prefer thinking of you as Dave Parkland (which might not be your real name, but it works for me) to the not-a-name of Address, clever as that also seems. It makes what you write more trustworthy to me. It would be even better if you indicated your company as well. I'm sure there are social anthropologists (perhaps even among us) who could tell us why names are important within communities. cheers! --dawn On Sat, Apr 9, 2011 at 9:06 AM, Address mrparkl...@yahoo.com wrote: By the way my name is Dave. Not sure why you are ranting. --- On Fri, 4/8/11, Laura Hirsh la...@lhirsh.org wrote: From: Laura Hirsh la...@lhirsh.org Subject: Re: [U2] Has anyone ever heard of Kyle Stetson? To: u2-users@listserver.u2ug.org Date: Friday, April 8, 2011, 9:27 PM Hey Charlie, Thanks for your kind reply. The thread from Address was on the topic, Has anyone ever heard of Kyle Stetson? I was curious. Why *should* I have heard of him... why would this question be of interest to the U2 folks? But I felt silly addressing those questions to Dear Address or Hey mrparkland. Does Address have a first name? Is mrparkland even a name?? This person has been posting under this alias for a very long time - rarely, if ever, identifying themselves. The same complaint recently came up regarding FFT2001. I *knew* who this person was, but why hide??? FFT2001 has also been posting for quite a long time, rarely identifying himself by first/last name. I think that a professional group such as ours is for those who value the content of messages and the exchange of thoughtful comments. And as such, folks should identify themselves - at least in closing a message for goodness sake. If one doesn't want to own their comments, then they shouldn't post them!!! I can't wait till I'm in a meeting and am introduced... Laura, I'd like you to meet address and sitting next to him is fft2001. To me, *not* identifying oneself by name is rude and inappropriate - at least for this group. Just my .02 cents. Thanks again Charlie for your kind message, and for identifying yourself! g. Hope you are doing well! Laura Hirsh ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is
Re: [U2] U2UG Elections 2010 - Request For Comment
Thank you to Brian for responding as well as everybody else who was joined in on the discussion. You have all reasoned some valid points/issues. I think by posting this it has uncovered some more inherent issues that should be addressed/considered by the U2UG in coming months. I starting writing the below linked Open Letter 9 hours after receiving notification of these elections (not bad considering the wide timezone ranges). Understanding that a wide audience wouldn't see it just on my blog, I posted it solely on the mailing list to see 1) how much interest people had in the U2UG elections and 2) How many people would actually see it on what appears to be the main communication channel for U2. Sadly, there would seem to be 2 possible take-aways from this exercise: - The elections would appear to be a token (albeit well-meant) gesture as there is hardly enough time to have meaningful discussions since we haven't seen a single response from any of the candidates at this stage. Or - Maybe the mailing listing is not the 'wide' communication channel it has been touted as; assuming the candidates would want to respond, I can only assume they haven't noticed my questions yet. Now, I don't have a fanciful enough imagination to assume a large portion of the community would be interested in reading my post about the election, but given the numbers from Brian (roughly 3500 members of U2UG), it would seem from the paltry 43 hits (roughly 1.2%, including 4 from subscription channels) that communication via the mailing lists needs to be reconsidered as to its effectiveness. Susan makes a great point on her comment she posted on the post: ...that number one criteria for a board member is willingness to serve. Not just willingness to run for the office, but willingness to make showing up to those every-other-week one hour meetings a priority. While I in no way discount the effort they have/will/are putting in, maybe something to consider for future elections is that the nominees themselves have to start a discussion around why they are nominating for the position. At least this we way we have a demonstration up front that it isn't just a nomination because it is easy to nominate, but they are prepared to make it a priority as well as give us an idea of their intentions. If the public profile of the nominees is higher, wouldn't it stand to reason that community engagement would also be higher? There is still a few hours to go, but my votes will have to stay as Abstain since if asked why I nominated one person over another, there is no way I could intelligently answer, hence my vote would be at best naïve. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Tuesday, 15 March 2011 9:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2UG Elections 2010 - Request For Comment Hi all, I've posted an open letter regarding the U2UG elections to the nominees. I'd love to see more dialogue around these elections as I feel I don't really know what I'm voting for when I place my votes. http://u2tech.wordpress.com/2011/03/15/u2ug-elections-2011/ Along with this, I also wonder how many people on this list are members of the U2UG and how many actually vote? I've never seen any numbers. I know I'm one of two out of the roughly 20 U2 people at my work who know of the U2UG and am the only member. Not the greatest odds. On the positive side, it leaves a lot of room to expand. :) Regards, Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http
[U2] U2UG Elections 2010 – Request For Comment
Hi all, I've posted an open letter regarding the U2UG elections to the nominees. I'd love to see more dialogue around these elections as I feel I don't really know what I'm voting for when I place my votes. http://u2tech.wordpress.com/2011/03/15/u2ug-elections-2011/ Along with this, I also wonder how many people on this list are members of the U2UG and how many actually vote? I've never seen any numbers. I know I'm one of two out of the roughly 20 U2 people at my work who know of the U2UG and am the only member. Not the greatest odds. On the positive side, it leaves a lot of room to expand. :) Regards, Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
I blame it on current work conditions. It's contagious. :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Thursday, 3 March 2011 6:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Is this worth rewriting? You my friend get the micro-management award for this thread. In a message dated 3/2/2011 9:24:18 P.M. Pacific Standard Time, dmc...@imb.com.au writes: Actually, (at least in UniData) it is a performance improvement :). It has to do with how BASIC compiles the code into the object file and tags each line with a line number. Each time it jumps to a line or progresses to the next it must process the line number to update it for when it shows errors/warnings etc. By reducing the number of lines the instructions are on, you actually end up with both smaller object code and faster execution. How much though depends on how tight your looping and all but 99%+ cases the difference is dwarfed by disk access times, etc as to make it not worth it as a human optimisation task. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
Which unfortunately is a UniVerse option, not UniData. Unless of course it is one of the myriad of 'undocumented' features :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 3 March 2011 5:34 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? Which is where the -T option on the BASIC statement comes in handy, though debugging then become s much harder. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, 3 March 2011 4:24 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? Actually, (at least in UniData) it is a performance improvement :). It has to do with how BASIC compiles the code into the object file and tags each line with a line number. Each time it jumps to a line or progresses to the next it must process the line number to update it for when it shows errors/warnings etc. By reducing the number of lines the instructions are on, you actually end up with both smaller object code and faster execution. How much though depends on how tight your looping and all but 99%+ cases the difference is dwarfed by disk access times, etc as to make it not worth it as a human optimisation task. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 3 March 2011 4:16 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? The other thing to try, though not really a performance improvement, is the following: Replace: IF P7.100CM = '' THEN CUMO(M) += P12.101CM END ELSE CUMO(M) += P7.100CM END IF P7.101CM = '' THEN CUMO(M) += P12.133CM END ELSE CUMO(M) += P7.101CM END IF P7.102CM = '' THEN CUMO(M) += P12.134CM END ELSE CUMO(M) += P7.102CM END with CUMO(M) += (IF P7.100CM = '' THEN P12.101CM ELSE P7.100CM) CUMO(M) += (IF P7.101CM = '' THEN P12.133CM ELSE P7.101CM) CUMO(M) += (IF P7.102CM = '' THEN P12.134CM ELSE P7.102CM) Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 3 March 2011 3:13 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? A suggestion: Raise the @VM to @AM to improve dynamic array performance. Attribute lookups are way faster than value lookups, and you have already extracted the data to a new variable MONTHLY.USAGE: CM = MONTH + LY.CNT P12.101 = RAISE(PARMS(12)101) P12.133 = RAISE(PARMS(12)133) P12.134 = RAISE(PARMS(12)134) P7.100 = RAISE(PARMS(7)100) P7.101 = RAISE(PARMS(7)101) P7.102 = RAISE(PARMS(7)102) FOR M = 1 TO 12 CUMO(M) = P12.101CM + P12.133CM + P12.134CM IF P7.100CM = '' THEN CUMO(M) += P12.101CM END ELSE CUMO(M) += P7.100CM END IF P7.101CM = '' THEN CUMO(M) += P12.133CM END ELSE CUMO(M) += P7.101CM END IF P7.102CM = '' THEN CUMO(M) += P12.134CM END ELSE CUMO(M) += P7.102CM END NEXT M RETURN -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Thursday, 3 March 2011 2:22 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? All right, I just went ahead and rewrote this the way I would do it since I haven't written a single bit of code since I got laid off at the end of September. And I did it while my wife and I are watching Judge Judy - it was *fun* :-) Granted I can't use real var names since I don't know what these are, but using a simple var name replacement scheme, this illustrates what I would consider the least amount of overhead for this. A) reduced the overhead on the repetitive calls to over 100 attrs. The system needs to look at *every single byte* in the record until it gets to attr desired. If these are 25,000 byte records this would be a HUGE amount of needless throughput which you can calc by (iterations - 2) * average bytes to read before attr needed * number of times the statement is used in the loop B) Yup, got rid of the #. Not only does this make more sense, but # is REALLY doing two comparisons: and C) Got rid of the leading 7 digit indent to make it more readable D) I don't see the necessity of testing three vars to see if they aren't zero before adding them together. If they are zero, the equation will work. If they are not zero, the equation will work. I can see maybe doing that if the equation was doing any dividing to avoid the can't divide by zero error, but not on adding. E) I always make all my IF's block IF's to stub them out for future dev, as well as to make them easier to read. So I did that at the bottom even though it was just for one add stmt. F) My eyes are really getting old. I need spaces between VARs and operands so they don't
Re: [U2] Is this worth rewriting?
Yes, I understand all that. In fact I did electronics before I ever picked up computers, yet alone programming (following in my Grandfather's footsteps as I've come to understand now). We are getting a bit off-topic now, but it was about 10 years ago now that I actually realised companies still made tubes and they were used in high quality amps. After having been taught in school that they were antiquated and completely replaced by transistors, it was quite a revelation! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Thursday, 3 March 2011 5:05 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? Ok, just to be clear, there is a difference between an interpreted instruction and a hard wired machine code instruction. An actual BRANCH ON NOTEQUAL operand ANALOG *circuit* must be etched in silicon at the flip-flop level before it's a machine code instruction. So like, not impossible. But here's the cool point. Digital devices, are implemented with capacitors, transistors, resistors. Analog devices. I dunno, just makes me laugh every time I think about the fact that at the lowest level there is really no such thing as digital because electricity is analog lol Speaking of analog (how's that for a segue?), all guitar pros still use tube amps. I make tube amps! It's so different to work with 500 volt tubes and transformers than programming. [shameless brag] Here's an upcoming starlet using one of the Hiwatt DR504 clone amps I built by hand for her playing with Earl Slick (David Bowie's guitarist after Stevie Ray got himself fired) http://www.youtube.com/watch?v=wTx1Pi1_o4c [/shameless brag] -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, March 02, 2011 9:10 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? Yes, in the real instruction that gets send down those long multi-stage pipe lines in our multi-core CPUs :) They take the same amount of clock cycles to compare if a 32bit/64 bit value is equal, or not equal. When values are compared it merely sets one of the many flags in the CPU. This binary flag is used to determine if it was equal or not, the only difference in the machine code is whether you perform an action if the flag is true or perform an action if the flag is false. This is as true in RISC processors as it is in CISC. But yes, this sort of optimisation is rarely needed. In fact, if you were to ever write the code in C/C++ the compiler would automatically optimise the machine code far better than most mere mortals could :) For some reason, you mentioning your teacher made me think of The Story of Mel: http://www.catb.org/jargon/html/story-of-mel.html snip ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
If you are running UniData, you can also move the TEA, EAT, ATE, YAM, AMY MYA outside of the FOR M loop if you exclude CM. Inside you can than do TEACM = TEA1,CM, etc Of course, as stated by others, whether it is worth the changing/testing time cannot be known unless you have actually benchmarked this code to determine if it will make a meaningful difference. On the other hand, if you change it to actually make the variable names/code more meaningful so the next poor soul doesn't need to read in several times to understand it, then sure, go ahead. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Keith Johnson [DATACOM] Sent: Thursday, 3 March 2011 11:47 AM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Is this worth rewriting? Agreed that the dimensioned extract wouldn't make much difference, still the attributes numbers are quite high. The code below goes from 15 extracts maximum per for-next loop to 6. I can't help but think this might mean something if it takes 90 minutes to run. 001: MONTHLY.USAGE: 002: CM = MONTH + LY.CNT 003: FOR M = 1 TO 12 004: TEA = PARMS(12)101,CM 005: EAT = PARMS(12)133,CM 006: ATE = PARMS(12)134,CM 007: IF TEA # '' OR EAT # '' OR ATE # '' THEN CUM(M) = TEA + EAT + ATE 008: YAM = PARMS(7)100,CM 009: AMY = PARMS(7)101,CM 010: MYA = PARMS(7)102,CM 011: IF YAM # '' OR AMY # '' OR MYA # '' THEN 012: IF YAM # '' THEN CUMO(M) += YAM ELSE CUMO(M) += TEA 013: IF AMY # '' THEN CUMO(M) += AMY ELSE CUMO(M) += EAT 014: IF MYA # '' THEN CUMO(M) += MYA ELSE CUMO(M) += ATE 015: END 016: CM -= 1 ; IF CM = 0 THEN CM = 24 017: NEXT M 018: RETURN So I'd say AYE - or YEA, if you use meaningful variables Regards, Keith ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
#1 In x86 assembly, you use can use JE or JNE. So you do the comparison, then jump. How you jump (or don't jump) determines if it was an = or #. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Thursday, 3 March 2011 2:49 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? #1 In a binary register, in machine code, there is no such thing as #. There is NOT and = which is two comparisons. Now, granted, there have been significant improvements in cpu's since I did machine code in 1975, so maybe that has changed... #2 Ummmhey, that's funny. I think I did that when I got to the part about the pictures of bedbugs in Judge Judy, which was really disgusting and made my brain fall out lol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, March 02, 2011 7:30 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? 2 points of note for you. 1) In regards to B), I think I should just clarify that despite # also being able to be written as , is *not* 2 comparisons, but still one. 2) You don't need to reassign P* back into PARAMS after the loop since they are never updated. Cheers, Dan PS: Messing about with code would be a lot more fun than watching Judge Judy :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Thursday, 3 March 2011 2:22 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? All right, I just went ahead and rewrote this the way I would do it since I haven't written a single snip ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
Yes, in the real instruction that gets send down those long multi-stage pipe lines in our multi-core CPUs :) They take the same amount of clock cycles to compare if a 32bit/64 bit value is equal, or not equal. When values are compared it merely sets one of the many flags in the CPU. This binary flag is used to determine if it was equal or not, the only difference in the machine code is whether you perform an action if the flag is true or perform an action if the flag is false. This is as true in RISC processors as it is in CISC. But yes, this sort of optimisation is rarely needed. In fact, if you were to ever write the code in C/C++ the compiler would automatically optimise the machine code far better than most mere mortals could :) For some reason, you mentioning your teacher made me think of The Story of Mel: http://www.catb.org/jargon/html/story-of-mel.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Thursday, 3 March 2011 3:42 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? Oh yeah, assembly - no sweat, you could do that on an old IBM360 along with floating point math and hosts of really awesome and incredibly mind numbing complicated stuff. But non-relocateable machine code? You know, the stuff that's *really* doing the work? I've never seen any that could do a NOT and an = at the same time even on the 360. And with reduced instruction sets being all the rage, it's probably not been added, eh? In any event, it's not a significant enough to have any measurable effect on speed, but is easier to look at. Btw, the rumor was that the teacher that I had for year two of the 360 assembly, who used to write I/O routines in machine code for IBM at the time as his day job, lost his mind and sat in the corner laughing to himself before they finally gave him a padded suit. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, March 02, 2011 8:00 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? #1 In x86 assembly, you use can use JE or JNE. So you do the comparison, then jump. How you jump (or don't jump) determines if it was an = or #. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Thursday, 3 March 2011 2:49 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? #1 In a binary register, in machine code, there is no such thing as #. There is NOT and = which is two comparisons. Now, granted, there have been significant improvements in cpu's since I did machine code in 1975, so maybe that has changed... snip ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
Actually, (at least in UniData) it is a performance improvement :). It has to do with how BASIC compiles the code into the object file and tags each line with a line number. Each time it jumps to a line or progresses to the next it must process the line number to update it for when it shows errors/warnings etc. By reducing the number of lines the instructions are on, you actually end up with both smaller object code and faster execution. How much though depends on how tight your looping and all but 99%+ cases the difference is dwarfed by disk access times, etc as to make it not worth it as a human optimisation task. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 3 March 2011 4:16 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? The other thing to try, though not really a performance improvement, is the following: Replace: IF P7.100CM = '' THEN CUMO(M) += P12.101CM END ELSE CUMO(M) += P7.100CM END IF P7.101CM = '' THEN CUMO(M) += P12.133CM END ELSE CUMO(M) += P7.101CM END IF P7.102CM = '' THEN CUMO(M) += P12.134CM END ELSE CUMO(M) += P7.102CM END with CUMO(M) += (IF P7.100CM = '' THEN P12.101CM ELSE P7.100CM) CUMO(M) += (IF P7.101CM = '' THEN P12.133CM ELSE P7.101CM) CUMO(M) += (IF P7.102CM = '' THEN P12.134CM ELSE P7.102CM) Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Thursday, 3 March 2011 3:13 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? A suggestion: Raise the @VM to @AM to improve dynamic array performance. Attribute lookups are way faster than value lookups, and you have already extracted the data to a new variable MONTHLY.USAGE: CM = MONTH + LY.CNT P12.101 = RAISE(PARMS(12)101) P12.133 = RAISE(PARMS(12)133) P12.134 = RAISE(PARMS(12)134) P7.100 = RAISE(PARMS(7)100) P7.101 = RAISE(PARMS(7)101) P7.102 = RAISE(PARMS(7)102) FOR M = 1 TO 12 CUMO(M) = P12.101CM + P12.133CM + P12.134CM IF P7.100CM = '' THEN CUMO(M) += P12.101CM END ELSE CUMO(M) += P7.100CM END IF P7.101CM = '' THEN CUMO(M) += P12.133CM END ELSE CUMO(M) += P7.101CM END IF P7.102CM = '' THEN CUMO(M) += P12.134CM END ELSE CUMO(M) += P7.102CM END NEXT M RETURN -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Thursday, 3 March 2011 2:22 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? All right, I just went ahead and rewrote this the way I would do it since I haven't written a single bit of code since I got laid off at the end of September. And I did it while my wife and I are watching Judge Judy - it was *fun* :-) Granted I can't use real var names since I don't know what these are, but using a simple var name replacement scheme, this illustrates what I would consider the least amount of overhead for this. A) reduced the overhead on the repetitive calls to over 100 attrs. The system needs to look at *every single byte* in the record until it gets to attr desired. If these are 25,000 byte records this would be a HUGE amount of needless throughput which you can calc by (iterations - 2) * average bytes to read before attr needed * number of times the statement is used in the loop B) Yup, got rid of the #. Not only does this make more sense, but # is REALLY doing two comparisons: and C) Got rid of the leading 7 digit indent to make it more readable D) I don't see the necessity of testing three vars to see if they aren't zero before adding them together. If they are zero, the equation will work. If they are not zero, the equation will work. I can see maybe doing that if the equation was doing any dividing to avoid the can't divide by zero error, but not on adding. E) I always make all my IF's block IF's to stub them out for future dev, as well as to make them easier to read. So I did that at the bottom even though it was just for one add stmt. F) My eyes are really getting old. I need spaces between VARs and operands so they don't smush together. So I spaced accordingly to make everything just a tad more readable as well. Now, this takes more lines of code. But many times more lines of code can be way faster than fewer lines of code especially if the extra lines of code are OUTSIDE of the loop. MONTHLY.USAGE: CM = MONTH + LY.CNT P12.101 = PARMS(12)101 P12.133 = PARMS(12)133 P12.134 = PARMS(12)134 P7.100 = PARMS(7)100 P7.101 = PARMS(7)101 P7.102 = PARMS(7)102 FOR M = 1 TO 12 CUM(M) = P12.1011,CM + P12.1331,CM + P12.1341,CM IF P7.1001,CM = '' THEN CUMO(M) += P12.1011,CM END ELSE CUMO(M) += P7.1001,CM END IF P7.1011,CM = '' THEN CUMO(M) += P12.1331,CM END ELSE CUMO(M) += P7.1011,CM END IF P7.1021,CM
[U2] New Rocket U2 'Developer Zone'
Just putting it out there for anyone who did not attend one of the U2U conferences and like me, didn't hear about it through any other channel. www.u2devzone.com/ I think they are still sorting out some of the kinks, but it looks promising. Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Clear Message Initiative - Logging Errors to a U2 File
That only holds if you have implemented it wrong. Spend some time to think about how you would implement it. 1. Have a subroutine/function which handles the error. That is, it displays it as appropriate, as well as logging details as required. You pass it an error number and optional text for the user and optional text for the log. 2. In the user text, you always include the error number. This makes tracking it back to the exact code location easy as pie [find 'CALL MyErrorSub(88,'] We do it with one of our online systems and it is a damn site easier to maintain then other systems using the 'old-school' methodology (ha!) of error reporting. I see so many people blame the general idea of something for the issues they have, rather than the incorrect way it was implemented. A little thought into future maintenance/usage goes a long way... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Thursday, 10 February 2011 9:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Clear Message Initiative - Logging Errors to a U2 File Here's the problem I see with moving messages out of the code. It's perfectly fine *if* you have a developer environment of some kind that automatically pulls in messages while you're reviewing code. However in my experience, very few sites have anything close to this. As the next one to come along and maintain the code, I have, on the one hand, a user saying I have this message that says Error in Back-Order Received Quantity and on the other hand, I have code, which I didn't write, which refers to 25 different errors, all external to the code :) Now I have to sit and look up each error code to see which one of them *this* one is, so I even can figure out what part of the code is complaining and about what, and how to try to fix it. Been there, done that, got the T-shirt to prove it. So I'd say you need the environment update before the decision to start shifting the control elements out of code. It's fine for the original developer. It's a nightmare for the next developer. W -Original Message- From: Kate Stanton k...@walstan.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Feb 9, 2011 12:57 pm Subject: Re: [U2] Clear Message Initiative - Logging Errors to a U2 File Another thing we plan to do with messages some day is to set them up in a messages file, so different languages can be easily handled. It would also be nice to be able to maintain the message without program change - makes sense. On 10 February 2011 09:02, Bill Brutzman bi...@hkmetalcraft.com wrote: Thanks to Susan Joslyn for the excellent article on the Clear Message Initiative. I just received my copy of the magazine in the mail today. It happens that over the weekend, I was reading Code Complete 2 by Steve McConnell of Construx. Following an idea in Code Complete... Yesterday, I told my boss that I am planning to enhance the clarity of our error messages, send a workflow message to others who would need to know about that problem and also to LOG THE ERROR MESSAGE to a U2 file, user, time, date etc. --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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
3. Once for the VOC, once for the Local Catalog and once for the Global Catalog. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Wednesday, 9 February 2011 7:52 AM To: 'U2 Users List' Subject: Re: [U2] Does UV have a BLOCK command Would make sense -- I would guess you have 2 disk reads to 'find' the Global Catalog - once test for the 'direct' entry in the VOC, and then the read to the Global? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Tuesday, February 08, 2011 2:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Does UV have a BLOCK command On 08/02/11 00:31, Dan McGrath wrote: From my testing with the aforementioned project, directly cataloguing in the VOC results in noticeably faster calling than code that is catalogued globally. I don't have time at work at the moment do the tests again, I might try after I finish the day. That seems very odd to me, but global cataloguing probably came from PI, and was optimised to work fast on Primos (if you ran PI, you had special microcode in the CPU :-) I know Primes had blinding fast dynamic linking - okay their clocks are very slow by today's standards, but tick for tick they can knock x86 into a cocked hat. Changing topics within the thread, I much prefer Prime's condition handling (inherited from PL/1) to C++'s try/catch. But that's probably because it's not an OO type concept ... 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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] A new DML?
Development doesn't necessarily equate to innovation. U2 is under constant development, but I wouldn't count much of it as innovation, just (slowly) trend following. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: Wednesday, 9 February 2011 11:01 AM To: U2 Users List Subject: Re: [U2] A new DML? Only in part. Intersystems has many developers, all developing away. I'm trying not to sound like an advertisement here--just making the point that innovation is actively happening on at least 1 mv platform. On Feb 8, 2011, at 10:26 AM, Wols Lists wrote: On 08/02/11 13:38, Ed Clark wrote: I'll go on a limb and state my belief emphatically that we will never see another new language implemented within the DBMS itself. Not from universe/unidata/d3 maybe (and sadly), but this is what Intersystems did with Cache. They added mv basic as a language in the dbms (beside the original object script/M language and a vb style cache basic) along with object bindings to .net, java, C, and others. That was, to the best of my knowledge, Jim Idle's work (yup, the jBase guy). 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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
David, I just tested it and it doesn't. If it isn't catalogued it doesn't find it, regardless of whether or not the object code is in the same directory. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com) Sent: Wednesday, 9 February 2011 12:44 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Does UV have a BLOCK command Does it not check within the same BP file as the calling routine first; as cataloging is not then necessary? djm Dan McGrath-2 wrote: 3. Once for the VOC, once for the Local Catalog and once for the Global Catalog. - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Does-UV-have-a-%22BLOCK%22-command-tp30867376p3087 9242.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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
Ah, I didn't expect UV and UD to behave differently in that manner. It would be interesting to found out what precedence that check in the directory occurs. I'd assume it was last (and hence slowest) after the global catalog. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Wednesday, 9 February 2011 2:51 PM To: U2 Users List Subject: Re: [U2] Does UV have a BLOCK command Just tested on UV Pick flavour; where it does find an uncatalogued program in the BP(.O) file. Observes this behaviour: VOC, LOCAL, GLOBAL, BP -Original Message- David, I just tested it and it doesn't. If it isn't catalogued it doesn't find it, regardless of whether or not the object code is in the same directory. -Original Message- Does it not check within the same BP file as the calling routine first; as cataloging is not then necessary? djm Dan McGrath-2 wrote: 3. Once for the VOC, once for the Local Catalog and once for the Global Catalog. - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Does-UV-have-a-%22BLOCK%22-command-tp30867376p3087 9242.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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
I know you said no subroutines, but really, what is the issue with the following GOSUB CodeBlockThatDoesX ... CodeBlockThatDoesX: block code block code if condition then RETURN block code RETURN ;* End CodeBlockThatDoesX -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, 8 February 2011 7:48 AM To: U2 Users List Subject: Re: [U2] Does UV have a BLOCK command -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Monday, February 07, 2011 3:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Does UV have a BLOCK command On 2/7/2011 3:39 PM, George Gallen wrote: Why not just block code block code if not(condition) then block code end There could then be other conditions inside that if block that would cause it to need to drop out of the block there could be 3 or 4 conditions it would look really confusing (and I'm not a pessimist - I work better when not thinking in nots see what I mean. block code block code if not(condition) then block code block code if not(condition) then block code block code if not (condition) then block block code end end end then begin block (aka) Loop block code if condition then exit block code block code if condition then exit block code if condition then exit block code end block (aka) exit - repeat ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
It is also a way of breaking code up into understandable, single purpose blocks of code. This increases the chance someone will fully comprehend it quickly. Large runs of code, even if they do not have sections that a reused are someone else's nightmare in 5 years time. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, 8 February 2011 8:20 AM To: U2 Users List Subject: Re: [U2] Does UV have a BLOCK command My main aversion to the subroutine method is that to me, I think of subroutines as code that used in multiple places, if it's only used once, why not put in the main code. Yes, it can be used onceand still be a subroutine... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Monday, February 07, 2011 4:17 PM To: U2 Users List Subject: Re: [U2] Does UV have a BLOCK command Why not use a subroutine? You say you don't want to, then describe just what a subroutine is: a block of code for a specific purpose (hopefully documented at the top), with RETURN to get out back to the main code. Personally, I like subroutines! -- Kate Stanton ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
I had many months ago as part of a project I'm working on (performance pre-processor for UniBasic). I've recreated a (no-scientific) test to get some rough numbers. X=0 LOOPS = 99 STIME = SYSTEM(9) FOR I = 1 TO LOOPS X += 1 NEXT I CRT SYSTEM(9) - STIME X=0 STIME = SYSTEM(9) FOR I = 1 TO LOOPS GOSUB INC.X NEXT I CRT SYSTEM(9) - STIME STOP INC.X: X += 1 RETURN This results in: 385 608 So when an loop + addition takes 0.38 micro seconds The gosub adds an extra 0.22 micro seconds But, that isn't the whole truth. If you have a look at the byte code BASIC produces, you can clearly see that it adds 4 bytes for each line to indicate the line number. When it performs jumps (such as gosubs) it always jumps to the appropriate byte position that is left in the byte code to indicate the line number of the label. So, this means the above measurements are measure the overhead of the extra line identifies as well (which is fine in practice) The below code compensates for that: X=0 LOOPS = 99 STIME = SYSTEM(9) FOR I = 1 TO LOOPS X += 1 X += 1 X += 1 X += 1 NEXT I CRT SYSTEM(9) - STIME X=0 STIME = SYSTEM(9) FOR I = 1 TO LOOPS GOSUB INC.X NEXT I CRT SYSTEM(9) - STIME STOP INC.X: X += 1;X += 1; X += 1;X += 1 RETURN Now we are comparing a loop, 4 additions and 4 lines vs a loop, a GOSUB/RETURN, 4 additions and 4 lines. The results: 939 1048 Or, the GOSUB/RETURN takes .11 microseconds. It's quite clear from the above timings that the line count is a bigger performance overhead then using GOSUB/RETURN Sorry for the overkill :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com) Sent: Tuesday, 8 February 2011 10:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Does UV have a BLOCK command Has anyone measured the overheads of the various methods of subroutine calls within UniBasic? Is it of significance? djm Kate Stanton wrote: Why not use a subroutine? Personally, I like subroutines! - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Does-UV-have-a-%22BLOCK%22-command-tp30867376p3086 8821.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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
Ah. I think we have a terminology mix up. I was referring to the internal subroutine, not an external subroutine (why did they have to call the external code a subroutine as well!) Yes, external subroutines do invoke a much larger overhead. From my testing previously, I believe it first checks the VOC, then the local catalog and lastly the global catalog. From my testing with the aforementioned project, directly cataloguing in the VOC results in noticeably faster calling than code that is catalogued globally. I don't have time at work at the moment do the tests again, I might try after I finish the day. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com) Sent: Tuesday, 8 February 2011 11:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Does UV have a BLOCK command Dan, Interesting stuff. How was the subroutine cataloged? At all? Is there not a hierarchical system that UniBasic goes through attempting to find the subroutine? I would have thought the search would have taken significantly more effort as it may have to read from multiple files; the current BP file, the VOC, memory etc. All interesting stuff. Dan McGrath-2 wrote: I had many months ago as part of a project I'm working on (performance pre-processor for UniBasic). It's quite clear from the above timings that the line count is a bigger performance overhead then using GOSUB/RETURN Sorry for the overkill :) - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Does-UV-have-a-%22BLOCK%22-command-tp30867376p3086 9331.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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does UV have a BLOCK command
That isn't always the case, although I always advocate writing maintainable code over needlessly optimising. An example would be our system for which does some fairly heavy lifting that can handle just over 10 requests a second. Within this year we must scale it to 55 and to 500 within 5 years. All on basically the same hardware. We are adding a caching system in between the source of the requests and the subroutines that generate the response. While this makes the code harder to grok, it is very much needed for us to be able to scale as required One of the reasons people in C,C++, .NET et al are hand optimising code less and less is that the compilers have had a ton of work done to them to optimise the code at compile time for you. That means you get the best of both worlds. Easy to read people-efficient code that is then compile to machine-efficient code. UniData lacks this work on the compiler. I spent 2 days looking at the byte code it generated and then spent a few days in my spare time writing a Proof-of-Concept pre-processor that gave roughly a 6% speed increase on our existing code base. With more time to implement a proper parser we could get 10% quite easily. This is stuff that should be the bread 'n' butter of the compiler so we don't need to think about it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Tuesday, 8 February 2011 11:38 AM To: U2 Users List Subject: Re: [U2] Does UV have a BLOCK command We used to try to write machine-efficient code. Now machines are so fast, our emphasis is on people-efficient, ie easier to maintain. On 8 February 2011 12:58, Dan McGrath dmc...@imb.com.au wrote: I had many months ago as part of a project I'm working on (performance pre-processor for UniBasic). I've recreated a (no-scientific) test to get some rough numbers. X=0 LOOPS = 99 STIME = SYSTEM(9) FOR I = 1 TO LOOPS X += 1 NEXT I CRT SYSTEM(9) - STIME X=0 STIME = SYSTEM(9) FOR I = 1 TO LOOPS GOSUB INC.X NEXT I CRT SYSTEM(9) - STIME STOP INC.X: X += 1 RETURN This results in: 385 608 So when an loop + addition takes 0.38 micro seconds The gosub adds an extra 0.22 micro seconds But, that isn't the whole truth. If you have a look at the byte code BASIC produces, you can clearly see that it adds 4 bytes for each line to indicate the line number. When it performs jumps (such as gosubs) it always jumps to the appropriate byte position that is left in the byte code to indicate the line number of the label. So, this means the above measurements are measure the overhead of the extra line identifies as well (which is fine in practice) The below code compensates for that: X=0 LOOPS = 99 STIME = SYSTEM(9) FOR I = 1 TO LOOPS X += 1 X += 1 X += 1 X += 1 NEXT I CRT SYSTEM(9) - STIME X=0 STIME = SYSTEM(9) FOR I = 1 TO LOOPS GOSUB INC.X NEXT I CRT SYSTEM(9) - STIME STOP INC.X: X += 1;X += 1; X += 1;X += 1 RETURN Now we are comparing a loop, 4 additions and 4 lines vs a loop, a GOSUB/RETURN, 4 additions and 4 lines. The results: 939 1048 Or, the GOSUB/RETURN takes .11 microseconds. It's quite clear from the above timings that the line count is a bigger performance overhead then using GOSUB/RETURN Sorry for the overkill :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com) Sent: Tuesday, 8 February 2011 10:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Does UV have a BLOCK command Has anyone measured the overheads of the various methods of subroutine calls within UniBasic? Is it of significance? djm Kate Stanton wrote: Why not use a subroutine? Personally, I like subroutines! - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Does-UV-have-a-%22BLOCK%22-command-tp30867376p30 86 8821.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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ## # The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material
Re: [U2] What do you do with CallHTTP?
http://databases.about.com/od/sqlserver/a/mssql_editions.htm SQL Server 2008 Workgroup per processor (not per core) = $3899 That's unlimited client access. Where are the UniData licensing options that really compete with that for small business? (as you pointed out U2 on a single connection pool, single user is not really going to cut it) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Sunday, 6 February 2011 10:44 AM To: 'U2 Users List' Subject: Re: [U2] What do you do with CallHTTP? Hi Bill: Maybe there is a SQL Service license for 3,500. Maybe you can run U2 on a single connection pool with a single U2 user . We know that both statements are not true. The base software they purchased is 595.00 per user on SQL Server plus a multitude of other options. How much they forward to Microsoft for SQL Server I don't know. What I do know is they are using SQL version 2005. So they have limited maintenance on the database and have missed many releases, bug fixes, and security patches. And you need those on SQL Server. Because they were not running on our Web CRM and Distribution software for the last 3 years we lost maintenance and enhancement revenue, which we did not plow back into the product. So, it did have an impact. We had to fund that development internally. We spent hundreds of hours changing our interface to make it look relevant and new. We added additional options of skins. We spent countless hours improving our speed between Apache Tomcat and the client (browser). We added grid to grid drag and drop, so they can move data from one multi-value field to another. We added the ability to make different layouts of the grids such as 3 horizontal or 3 vertical. We added contextual menus to grids as well. These may not seem much but when we went in and demonstrated the software they had already seen years before, they did not recognized it. We got the oh wow factor and we closed the sale. As they say in the restaurant business: Presentation is everything. We need to learn that in the U2 world as well. Regards, Doug www.u2logic.com Eclipse based tool developer for U2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Saturday, February 05, 2011 2:48 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? Doug: I believe what you're saying. You ought to believe many of us who point out that we're familiar with partners and competitors who put their enterprise .NET applications for small businesses on an SQL Server machine with a single CPU license for $3,500. They run the application on an IIS server and pay nothing for connectivity because it's all part of the MS framework. Clearly this is a different scenario from you and has a serious impact on smaller businesses attempting to host their application, although it appears to have no impact on your business. Bill Doug said the following on 2/4/2011 3:49 PM: HI Bill: We are replacing a CRM and Distribution system running on Microsoft SQL Server that cost 10 times what Unidata does. The irony of this replacement is they are still running Unidata and could never get this software to running the way their current system does after 3 years. We are migrating them to the Web using our U2WebLink middleware in just 2 months. Regards, Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Friday, February 04, 2011 2:07 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? Doug: Let me point out an alternative perspective. An ISV's job is to sell our applications. If we can't compete in our business marketplaces, we need to make adjustments or look at alternatives. Competition mostly means we need to offer a product that benefits our customers at a price that is usually less than our competitors. From my perspective, your statement that you pay much higher rates for Oracle and Microsoft databases doesn't apply to my experiences. In fact, a number of our competitors use Microsoft technology and have much lower deployment costs in the small business environment than we do. I'm only saying my experiences differ from yours on this point, which is critical to our business. 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 __ This email has been scanned by the
Re: [U2] What do you do with CallHTTP (and everything)?
I couldn't agree more Tony. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, 7 February 2011 9:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] What do you do with CallHTTP? From: Doug Here what you do in your PHP code and really it is that easy: // Load Include and open session in Apache Tomcat: ?php require_once(java/Java.inc); [snip great example] With respect and appreciation for the solutions presented, if you have any interest in using U2 with other languages, consider that so far the solutions for python, Java, and PHP are completely different. This is why I created the standardized API mentioned earlier. A standardized API makes code in all languages look the same. This allows anyone familiar with the API to be helpful to other developers regardless of the target language. It allows anyone familiar with the API to transfer their skills quickly to another language. It abstracts out the communications tier, so that application code doesn't need to be bothered with How data is exchanged with a back-end server, it just is. And it allows us to write code which can be used for multiple MV platforms - something important to those of us who need it, and for anyone who thinks a migration could be in their future. So as we see these great examples of solutions created by individuals, generously provided here, just remember that we can (and IMO should) just have one way of doing it, in a consistent MV connectivity framework with any number of language bindings. When enough people get the itch for that elegance we can talk about what it will take to make this available for all of us to use. ( LOL We have SO many subthreads here that should all be in their own threads. This is far far from CallHTTP... ) Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] PickWiki
I seem to recall a while ago that there were plans to upgrade PickWiki to utilise MediaWiki. What ended up happening? Was the idea scrapped? (Question spurred from Tony's sig) ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] PickWiki
Error [39207] occurred on server. Possible client-side licensing failure. Make sure the LANG environment variable is set to C *both* where you startudt *and* where you run the UOJ code Oh U2 licensing... Refreshing it took me to a page that worked and it does look a heck of a lot friendlier/cleaner. remove.thisNebula-rnd.com/mediawiki/index.php?title=CodingStandards Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, 7 February 2011 3:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] PickWiki From: Dan McGrath I seem to recall a while ago that there were plans to upgrade PickWiki to utilise MediaWiki. What ended up happening? Was the idea scrapped? (Question spurred from Tony's sig) That's another community project that stalled, but this one was my fault. :) Ian McGowan still hosts the existing site. Rex Gozar, Ian, and I discussed and started the migration process, which then stalled in Jan/2010. See the prototype here: remove.thisNebula-RnD.com/mediawiki Where it says remove.this ... remove that part. That's not a new permanent home, that's just where I was staging the migration. Please don't update pages there, changes will be lost in the next conversion. Click the Random Page link to see various pages. From the Special Pages link you can find All Pages and more. Search for To Do to see what else needs to be done. MediaWiki is much better than the software being used now, and I still think this migration is a worthy project. The roadblock was converting from the current markup codes to MW-specific markup. We were doing this with BASIC, parsing documents and re-writing them in the new format, then importing them into MySQL. As you can see, most of the pages converted quite nicely. As with any programmatic language conversion however, there were some codes there were more difficult to convert than others, and lots of metadata needed to be generated from scratch. When pressed to generate income I put that project on hold, and there it now sits with a dozen other community projects just like it. If I can find some time (ha!) I'll try to publish code and notes on the live pickwiki.com so that others can help. This is a one-shot, and once all pages are migrated we don't need the code anymore. For as long as this has taken, it might have better to finish some of the document conversions manually. That said, considering the number of people who participate in community projects, I didn't think I could count on much human assistance for this one. Thanks for asking. T Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
The problem as I see it Tony is twofold. 1) By having to pay for something as elemental as language bindings, you are effectively limiting U2 to already established companies. Why would a start-up pay to experiment with U2 when there are better supported *free* development stacks with larger communities? It doesn't make sense. That's why U2 is limited and won't grow beyond the small community that already uses it. 2) Is it really that easily fixed without Rocket? How do create a language binding for U2 without several issues. Firstly, UniObjects is a bad interface on a security level (really, if I need to call a subroutine, the port allows them to run ECL commands as well? Is this 1980?), so building a binding on top of that is a horrible idea if you intend it to be widespread. So if not UniObjects, what? Native phantoms cannot fork so we cannot have an effective service running without an external OS dependent multiplexer in between. Yes, I can see people be lured by a DB that requires you to not only set it up, but also another service separated (and downloaded separated) just to use their language of choice when MySQL and brethren are supported out of the box. It isn't a matter of what you *can* do, it is how easily and effective you can do it compared to the other available stacks. When I develop in my free time where I don't have access to work's systems, why would I bother with U2 where I have to build not only the tool chain myself, but also the language bindings (or pay for them) when I can fire up CakePHP + MySQL where all already exists, is well documented, large support communities and it is easy to find other developers already skilled in it. Don't get me wrong though, I completely respect that you cannot always offer the toil of hours for free. It shouldn't be an issue with basic development tools though, why should we, as a community, build the toolset for a vendor to ultimately profit from? That's where Rocket's responsibility comes in. Their product, their prerogative as to whether they simply support the existing status quo or actively enable new players to enter the and expand the market space. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, 3 February 2011 7:34 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] What do you do with CallHTTP? From: Steve Romanow Look at the number of language bindings for most db's. U2 has 2, and they are ok, but only 2. MongoDB has like 10-20. That problem is easily fixed technically. Language bindings don't need to come from the DBMS vendors. And let's face it, they aren't that creative and they don't want to invest too much unless they see tangible returns in terms of license sales. So this like other projects will have to be a community undertaking anyway, as it is with every other platform out there. I've already started this project actually, and run it by some respected community members to validate the concept. As always, the problem is that projects like this, for the good of everyone, tend to fall on the few who often can afford it the least. I'm going to use I and me below, but this applies to anyone in this market who does free development as a community service. There are a lot of us here. I create things like language bindings because I think it's cool and because it will help our market. In the mean time there are people fearing for loss of their jobs because their platform of choice is too obscure and missing language bindings (for example) that are common everywhere else. Demand/motivation and supply/desire in this market must learn to meet in the middle. I know if I solicit donations so that I can pay my mortgage while providing you (collectively) with something that will increase the value of your platform, I'll be shunned for trying to sell yet another product (what a concept *sigh*). The public outcry will be deafening but it should be FREE, implying of course that someone else should do the work for free for everyone's benefit, like it is (supposedly) in the rest of the world. With no motivation, this project that has been in the queue for about two years, will remain on the bottom of the TODO list, and may never get finished. (Personal note: And for anyone who thinks I only do things for-fee, look for my name at Codeplex, Sourceforge, github, and elsewhere. I do contribute to FOSS, and I contribute freeware to this market as well. But when my free time translates to someone else's profitability or continued employment, I don't think it's unreasonable to ask for something in return. Generous does not equal stupid.) But if neither I nor anyone else does this (for free or fee), the net result will be that some years later people will still be lamenting in forums that such things don't exist and that it should all come from the DBMS vendors. Nothing will change. I've been saying that for years
Re: [U2] U2U Australia
Looks like it will be a small conference ;) See you there. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Thursday, 3 February 2011 1:19 PM To: U2 Users List Subject: Re: [U2] U2U Australia Hi Dan, Yes, I and my sister Eleanor have registered. See you there! Cheers, Kate Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.com On 3 February 2011 10:41, Dan McGrath dmc...@imb.com.au wrote: Anyone on here registered for U2U Aus yet? I want to try and put faces to names (or email addresses) when I'm there :) ## # The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ## # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Books?
Brian Leach has some. http://www.brianleach.co.uk/pages/books.htm -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Michael McGlothlin Sent: Friday, 4 February 2011 10:31 AM To: U2 Users List Subject: [U2] Universe Books? I'm trying to find books on Universe but very little seems to come up. Is there anything you can recommend for someone trying to teach themselves? Thanks, Michael McGlothlin ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2U Australia
Anyone on here registered for U2U Aus yet? I want to try and put faces to names (or email addresses) when I'm there :) ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What do you do with CallHTTP?
There are people who work on/drive cars much older than that. Yes, they still work, are functional and can sometimes look amazing. When it comes to utility though, they rarely match the total feature set available on the newer cars. Side Passenger Airbags, smoother rides, 5 star safety ratings, air conditioning... Point being, just because something is old and still in use, doesn't mean it is the best solution either technically or productively wise. It can have its place, but not every place. Unless of course they continue to evolve it, not just keep it running. I love MV databases and the unique opportunities it presents. It also has its issues that have been solved for a long time in 'the newest fashion fad' for which the MV databases desperately need to catch up with. Well, that is if they really want to increase the development/market share of the product, as opposed to merely 'supporting' current ISV solutions just enough to stop people absolutely needing to migrate away. * If I had anything remotely as useful/polished as Visual Studio to develop my life would be bliss. ** Development toolset in general is severely lacking * Licence model is frustration+ if you stray away from Telnet sessions ** It's so open to interpretation its ridiculous -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jerry Sent: Thursday, 3 February 2011 2:09 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? There are people on this list that have been working with this database for 40 years or more, can you say that about the products you are so hyped up on. This database/environment/platform has outlived all other databases. It has outlived it's creators. It survives because it does what it is supposed to do. It was created to live and evolve. Long after the databases that you are extolling the virtues of have biten the dust it will continue. What you and many other people see is the glitz and glamor the newest fashion fad while the Plain Jane over in the corner does it's job. All hail Plain Jane. Jerry On 2/2/2011 12:58 PM, phil walker wrote: Comments in line. There are know right or wrong answers here but I would rather not have to rely completely on one technology platform, even Microsoft ...or apple ;-) That was also a joke... So those of you who do not change or cannot get Rocket to change, good luck with your future business. ...probably enough has been said down this path... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Thursday, 3 February 2011 7:31 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] What do you do with CallHTTP? Let's not forget here that the business user wants a solution. [phil walker] That's right. If you can come in, with their solution, and no one else can, and you're a good salesperson, and the price is right, you get the signature most of the time. [phil walker] Why not get it all of the time. The reason products like Shims took off is because there was literally no competition in the marketplace they were addressing (small manufacturing and distribution companies), and what competition there was, was five times the price. That was a complete solution. Companies who *already* have an infrastructure and personnel investment in certain technologies, of course will desire to adhere to those. But that is not a show stopper, just a big boulder in the path. [phil walker] Rightly or wrongly it is a fairly big boulder. So why not pick your battles. If you can show how much more fabulous your business solution is, than the last guys, you can get companies to switch from PCs to Macs Ok that's a joke. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this
Re: [U2] What do you do with CallHTTP?
That's a false argument. They have been pandering that line ever since programming started as a profession. After all, wasn't that COBOL was meant to do? The business can do it! Programmers are NOT people who merely read/write code. Programmers are problem solvers. It will also be a speciality. At least until (if ever) we have a suitable AI and in that case, say good bye to almost every job and say hello to the world of Wall-E. As to being one of those people, while I may not have 40+ years experience, I've done everything from x86 ASM to .NET. What I appreciate are tools which can help abstract away pointless boilerplate code, reduce typing (Intellipoint), increase maintainability, scalability, etc. I want to concentrate on the business logic, not work out how I have to redesign solutions because the DB licence structure is restrictive (and excessively prohibitive in the age of the web). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jerry Sent: Thursday, 3 February 2011 3:48 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? Be careful what you wish for. I didn't start out as a programmer, my degree is in Electronics Engineering, my early career was designing, building, and repairing many of the early computer systems. As time went on I had to change what I was doing because with throw away computer parts you no longer need a person that can tell you what is inside of the box all you need is someone that can replace it. The same thing is happening in the software business. With all of the new point and click tools you will eventually no longer need someone that can actually read code. Why do you think all of the software jobs are being outsourced. A person that needs to read code is no longer needed. As soon as they can figure out how to make the tools build logic into it, you're gone. It's not that far in the future. Now if you are one of the people that could never read the code or make heads or tails of business logic I can see why you would want the stuff that does it for you, but I don't think you are. Jerry On 2/2/2011 9:42 PM, Dan McGrath wrote: There are people who work on/drive cars much older than that. Yes, they still work, are functional and can sometimes look amazing. When it comes to utility though, they rarely match the total feature set available on the newer cars. Side Passenger Airbags, smoother rides, 5 star safety ratings, air conditioning... Point being, just because something is old and still in use, doesn't mean it is the best solution either technically or productively wise. It can have its place, but not every place. Unless of course they continue to evolve it, not just keep it running. I love MV databases and the unique opportunities it presents. It also has its issues that have been solved for a long time in 'the newest fashion fad' for which the MV databases desperately need to catch up with. Well, that is if they really want to increase the development/market share of the product, as opposed to merely 'supporting' current ISV solutions just enough to stop people absolutely needing to migrate away. * If I had anything remotely as useful/polished as Visual Studio to develop my life would be bliss. ** Development toolset in general is severely lacking * Licence model is frustration+ if you stray away from Telnet sessions ** It's so open to interpretation its ridiculous -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jerry Sent: Thursday, 3 February 2011 2:09 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? There are people on this list that have been working with this database for 40 years or more, can you say that about the products you are so hyped up on. This database/environment/platform has outlived all other databases. It has outlived it's creators. It survives because it does what it is supposed to do. It was created to live and evolve. Long after the databases that you are extolling the virtues of have biten the dust it will continue. What you and many other people see is the glitz and glamor the newest fashion fad while the Plain Jane over in the corner does it's job. All hail Plain Jane. Jerry On 2/2/2011 12:58 PM, phil walker wrote: Comments in line. There are know right or wrong answers here but I would rather not have to rely completely on one technology platform, even Microsoft ...or apple ;-) That was also a joke... So those of you who do not change or cannot get Rocket to change, good luck with your future business. ...probably enough has been said down this path... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Thursday, 3 February 2011 7:31 a.m. To: u2-users
Re: [U2] UUID [was Data in Dict]
We also are using a form of UUID instead of sequential numbering on most of our new files. A lot easier to handle and makes maintenance easier. Thanks for the Stuart, I wasn't aware of that. For those using UniData, you can use the VOC as follows instead: UUID 0001 S 0002 !/etc/ncs/uuid_gen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Thursday, 27 January 2011 10:07 AM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] Most OSs have a call available for generating a UUID (Universally Unique ID) or GUID (Microsoft's acronym for Globally Unique ID). By definition and accepted generation standards these are almost guaranteed (!) to be unique (the probability of a clash is extremely small) across all computers. In UV you could use GCI to create a UV verb to invoke the OS call. Or just create a VOC item which you can execute and capture. There are usually options which affect the format of the output. For AIX the VOC item might look like this: UUID 0001 V 0002 /etc/ncs/uuid_gen 0003 U 0004 CGHIM For Linux use: /usr/bin/uuidgen For Windows (not installed by default): guidgen HTH -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, 27 January 2011 01:55 To: 'U2 Users List' Subject: Re: [U2] Data in Dict I'm curious what your logic is to generate the Unique ID -- can you share that without giving away a trade secret?? It's too bad it's not a database function call in UniData/UniVerse - we can do that in D3/Pick - it's a derivation of system Date/Time with AlphaSequencing if more than 1 hit in a given clock cycle - but it would only be unique on the 'machine' since another system could generate the same ID. So I am interested in the idea of generating a TRULY unique ID. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, January 25, 2011 7:24 PM To: U2 Users List Subject: Re: [U2] Data in Dict In some cases I am becoming a fan of UUIDs for db table keys. A UUID type one uses the mac address of the host along with the current time as salt so you don't have to worry about key collisions between accounts (I.e. TEST and PROD). Generating the next key is fast because there is no readu, update, write. They should hash pretty well since they are long and random. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 3.99 x 3 = 11
With I-types, are you aware you can store whatever you want in Attribute 1 after the data type? This is where we store any additional information required as such data integrity checks, date last changed, etc. Log out issues with dictionary compilation must be specific to UniVerse (?) as we do not have that issue in UniData. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Friday, 21 January 2011 3:46 PM To: U2 Users List Subject: [U2] 3.99 x 3 = 11 Does anyone else have a problem with this? We have (for about 30 years) allowed users to use a decimal point when entering quantity. In the dim dark past (was it under Prime or Ultimate? don't remember) we discovered that correlatives ignored anything after a decimal point, so wrote horrible correlatives multiplying the bit before the point by 1, appending to the bit after, taking the first 4 chars of this and adding it, doing arithmetic then dividing result by 1. In the slightly less dim dark past (before 1997, when we introduced our current change control system), we noticed that this problem had been fixed, and removed the complication from correlatives involving quantity. Now, many years and much development later, we extensively use dictionary output rather than programs for reports, forms (eg invoices) and queries. Inaccurate data is an unexpected result. On type S (or A) dictionaries, result of calculation in A or F correlatives is truncated to the decimal point (eg 3.99 x 3 = 11). Minor result is incorrect figures. Major result is under-reporting of totals which are not able to be reconciled to General Ledger (eg value of stock on hand). Rocket's response is that the manual says correlatives only do integer arithmetic. This is not quite true, as integer 3.99 x 3 would be 9. I-type dictionary items handle the data correctly (3.99 x 3 = 11.97). I-types have their own problems, in that fields after 10 are used for internal purposes, so are not able to carry extra information needed for data entry (such as data required, display only, validation rules, data change stamp, etc. I-types also are hard to work with as using a changed dictionary without compiling the dictionary logs the user out, and inadvertent attempt to display data in fields beyond F10 can lock user up, as well as untidily logging out. We are asking Rocket to consider this a bug. What do you think? TIA, Kate Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sparse array population in Pick
You could quite easily come up with an escaping scheme to convert any tag name into a valid escaped dictionary name. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Friday, 10 December 2010 1:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Sparse array population in Pick No David you cannot restrict the tag names to valid Dict names, they can be anything the user could possibly think up. And the user's can think up a lot of things! Think of the tags that you can apply on Amazon to products. You are not forced to pick your tags from a list, you can type in anything you want as a tag. And to Rob, the motivation for storing this in a U2 database, is because U2 needs to access it for further processing. Will ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sparse array population in Pick
Escaping/Encoding. As in how strings in C, C++, PHP, etc use \n to indicate a new line. How you escape can be arbitrarily determined if you are writing the code. For example, reserve the $ sign as the escape character. $$ gives you a literal $ in the tag name, $S gives you a space, $Q gives you a quote, etc. Do this for each character the user can enter that isn't a valid char for a dictionary name. Heck, you could even just Base64 Encode it you really wanted to go down that path and then you could fully support Unicode tag names. Having said that, the solution could come down to how you need to process the data. You could, for instance, organise the file layout differently: Record ID: Unique ID (like using a GUID in SQL, we have our own SR to do that here) 1: Item ID 2: Tag Name 3: Tag Value Using this method it is trivial to select/sort via Item Id, Tag Name or Tag Value, but sacrifices lookup speed for individual items. Even that could be partially alleviated though, by using a secondary index file keyed on Item ID with Attr1 a MV'ed list of all its records in the previous file. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Friday, 10 December 2010 1:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Sparse array population in Pick In a message dated 12/9/2010 6:18:24 PM Pacific Standard Time, dmc...@imb.com.au writes: You could quite easily come up with an escaping scheme to convert any tag name into a valid escaped dictionary name. Could you explain this more clearly? I don't understand what you mean. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sparse array population in Pick
100% agree, but this is pick doesn't mean disregard all rules of good DB design. Fair enough, MVDBs are designed around not subscribing to the 1st norm form rule; we should still present out data in the most structured manner possible, for this will give us the greatest flexibility if/when the system needs to be expanded. As I said though, it all comes down to how you need to work with your data. My form is not the most efficient for random access of individual items, but it does give you the flexibility of being able to sort and select on tag/value pairs. Additional benefits are that I could also index on tag names if required, which neither of the your original proposals can. I reiterate though, design all comes down to the intended purpose. Similar situations happen in SQL where you need determine if/where/how much you should denormalize your data. Work out the most important requirements/future requirements for your system and develop accordingly. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Friday, 10 December 2010 2:00 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Sparse array population in Pick But Dan you're just flattening the array. B This is Pick! The point of a method of populating a sparse array is to address the efficient storage of data when your array is sparse. In your method, you'd have to do several disk reads in order to collect all the tags for one item in one spot. The method I displayed, is a single disk read :) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sparse array population in Pick
I should probably expand on the good DB design statement. Take, for example, your second suggestion with the tags in Attr 1 and values in Attr 2 onwards. Once this system is implemented, how do you add and future fields that need to be catered for, such as created/modified timestamps for items, or worse, each tag in the item? Since you have already assigned all possible attributes 1-n you need to either create another file or rework all programs that use it. In the flattened solution I offer, it is a trivial exercise. I say this because we have a 15 year old system here that suffers from this issue and it causes as many headaches. I wish we had a system that used pick style where and only where it was appropriate. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Friday, 10 December 2010 3:18 PM To: U2 Users List Subject: Re: [U2] Sparse array population in Pick 100% agree, but this is pick doesn't mean disregard all rules of good DB design. Fair enough, MVDBs are designed around not subscribing to the 1st norm form rule; we should still present out data in the most structured manner possible, for this will give us the greatest flexibility if/when the system needs to be expanded. As I said though, it all comes down to how you need to work with your data. My form is not the most efficient for random access of individual items, but it does give you the flexibility of being able to sort and select on tag/value pairs. Additional benefits are that I could also index on tag names if required, which neither of the your original proposals can. I reiterate though, design all comes down to the intended purpose. Similar situations happen in SQL where you need determine if/where/how much you should denormalize your data. Work out the most important requirements/future requirements for your system and develop accordingly. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Friday, 10 December 2010 2:00 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Sparse array population in Pick But Dan you're just flattening the array. B This is Pick! The point of a method of populating a sparse array is to address the efficient storage of data when your array is sparse. In your method, you'd have to do several disk reads in order to collect all the tags for one item in one spot. The method I displayed, is a single disk read :) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons
Re: [U2] INPUTIF statement in Universe
Hi Eric, We get around this by using an optimistic locking strategy if and only if there must be user input between the original record read and final record write. Depending on the usage of your system, this might prove to be a better solution? Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Rosenzweig Sent: Wednesday, 27 October 2010 5:58 AM To: U2 Users List Subject: [U2] INPUTIF statement in Universe We are on an IBM AIX 5.3 box with 32 CPU and 32GB of memory running Universe 10.2.4 As we've increased our user count I'm noticing several applications that use the INPUTIF statement coming to the top of CPU usage. We have users that go into a product record, lock it, and then leave their desk or go onto something else leaving the lock and therefore keeping other people out of updating that record. We use the INPUTIF with a timer loop to gracefully exit the program and release the record if there hasn't been activity in 10 minutes. In testing, it's the INPUTIF statement that's utilizing the CPU, not the timer calculation. Is there a better, less CPU intensive way to do this? Thanks in advance. Here's the code we currently employ: OK = 0 ; START.DT = DATE() ; START.TM = TIME(); TIME.OUT = 900 LOOP INPUTIF PSN THEN OK = @TRUE ELSE OK = ((DATE()-START.DT)*86400)+TIME()-START.TM TIME.OUT IF OK THEN IF EDIT.FLG THEN PSN = '' ELSE PSN = 'Q' END END UNTIL OK DO REPEAT Eric Rosenzweig eri...@petco.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How many will be selected?
In UD it is HASH(record key, file modulo, type) to return a key's group. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, 20 October 2010 5:19 AM To: U2 Users List Subject: Re: [U2] How many will be selected? What is this? Doc Johnson's magic health tonic? Alas, I think the hair is gone for good. What function returns the group information? I don't remember seeing that one. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Tuesday, October 19, 2010 1:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How many will be selected? What you need to do is ask the system these questions: 1) How many groups are in this file? and 2) What group number am I in right now. The groups are processed so rapidly that this will be all you need to know to calculate your dreams and desires in this regard. And it will make your hair grow back. Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sequential Files Question
Yes, it will. Note: It will drop into the 'ELSE' clause if the file didn't exist to start with. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Thursday, September 09, 2010 8:55 AM To: u2-users@listserver.u2ug.org Subject: [U2] Sequential Files Question Unidata 7.1.20 I've never dealt with sequential files, but I have a need to output records to a text file. Each record will be a series of fixed-length fields. Each file will need to be created at the time of opening. The destination will be a Windows folder on one of our servers. I will be using OPENSEQ to open the file. However, since each file needs to be created at time of opening what do I use to create the file? My reading of OPENSEQ doesn't indicate that it will create it automatically if it doesn't exist. Thanks. Al DeWitt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sequential Files Question
If you run this code: OPENSEQ FNAME TO OUTFILE ON ERROR STOP 'FATAL ERROR: - Cannot open file ':FNAME END THEN STOP 'FATAL ERROR: - Already exiting file called: ':FNAME END ELSE CRT FILE OPEN SUCCEEDED! WRITESEQ Dummy data ON OUTFILE THEN NULL END What happens? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Thursday, September 09, 2010 10:03 AM To: U2 Users List Subject: Re: [U2] Sequential Files Question I forgot to mention that I'm on Windows. My output path is: C:\OUTPUT\ My file name isAPCHECKS where is a counter that gets incremented each time the program is run. FNAME would be C:\OUTPUT\APCHECKS so that my statement would read: OPENSEQ FNAME TO OUTFILE... However, since APCHECKS would be unique each time it doesn't exist. BTW when I try to display OUTFILE it gives me an Unitialized Variable, zero assumed error. Al DeWitt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, September 08, 2010 6:29 PM To: U2 Users List Subject: Re: [U2] Sequential Files Question Yes, it will. Note: It will drop into the 'ELSE' clause if the file didn't exist to start with. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Thursday, September 09, 2010 8:55 AM To: u2-users@listserver.u2ug.org Subject: [U2] Sequential Files Question Unidata 7.1.20 I've never dealt with sequential files, but I have a need to output records to a text file. Each record will be a series of fixed-length fields. Each file will need to be created at the time of opening. The destination will be a Windows folder on one of our servers. I will be using OPENSEQ to open the file. However, since each file needs to be created at time of opening what do I use to create the file? My reading of OPENSEQ doesn't indicate that it will create it automatically if it doesn't exist. Thanks. Al DeWitt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman
Re: [U2] Sequential Files Question
Interesting that the code was sent through malformed like that, but that's a different issue... Just before the offending stop, add CRT STATUS() This will return the reason it is dropping into the ON ERROR section. Value - Description --- 0 - The record does not exist. 1 - The file you specify is not a sequential-access file. 2 - The file does not exist. 3 - The READONLY clause was included in the command statement and the record does not exist. 4 - An unknown error occurred (such as having too many files open or permission problems). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Thursday, September 09, 2010 12:15 PM To: U2 Users List Subject: Re: [U2] Sequential Files Question I GET THE FOLLOWING MESSAGE [FATAL ERROR: - Cannot open file C:\OUTPUT\APCHECKS1002] and I'm sent to the colon prompt. Al DeWitt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, September 08, 2010 7:20 PM To: U2 Users List Subject: Re: [U2] Sequential Files Question If you run this code: OPENSEQ FNAME TO OUTFILE ON ERROR STOP 'FATAL ERROR: - Cannot open file ':FNAME END THEN STOP 'FATAL ERROR: - Already exiting file called: ':FNAME END ELSE CRT FILE OPEN SUCCEEDED! WRITESEQ Dummy data ON OUTFILE THEN NULL END What happens? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Thursday, September 09, 2010 10:03 AM To: U2 Users List Subject: Re: [U2] Sequential Files Question I forgot to mention that I'm on Windows. My output path is: C:\OUTPUT\ My file name isAPCHECKS where is a counter that gets incremented each time the program is run. FNAME would be C:\OUTPUT\APCHECKS so that my statement would read: OPENSEQ FNAME TO OUTFILE... However, since APCHECKS would be unique each time it doesn't exist. BTW when I try to display OUTFILE it gives me an Unitialized Variable, zero assumed error. Al DeWitt -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, September 08, 2010 6:29 PM To: U2 Users List Subject: Re: [U2] Sequential Files Question Yes, it will. Note: It will drop into the 'ELSE' clause if the file didn't exist to start with. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Thursday, September 09, 2010 8:55 AM To: u2-users@listserver.u2ug.org Subject: [U2] Sequential Files Question Unidata 7.1.20 I've never dealt with sequential files, but I have a need to output records to a text file. Each record will be a series of fixed-length fields. Each file will need to be created at the time of opening. The destination will be a Windows folder on one of our servers. I will be using OPENSEQ to open the file. However, since each file needs to be created at time of opening what do I use to create the file? My reading of OPENSEQ doesn't indicate that it will create it automatically if it doesn't exist. Thanks. Al DeWitt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has
Re: [U2] AUTO: Haydon Bishop is out of the office. (returning26/07/2010)
Aside from the usual Haydon Bishop is out of the office, I think he should remove the I will respond to your message when I return, as we never get a response! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Haydon Bishop Sent: Friday, July 23, 2010 8:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] AUTO: Haydon Bishop is out of the office. (returning26/07/2010) I am out of the office until 26/07/2010. I will respond to your message when I return. Note: This is an automated response to your message U2-Users Digest, Vol 15, Issue 19 sent on 22/07/2010 20:00:02. This is the only notification you will receive while this person is away. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UI standards
Even though I tend not to agree with everything Mr Spolsky writes, I'll second his book User Interface Design for Programmers. The interesting thing about Microsoft's User Experience Guidelines is that MS doesn't follow them in their own office software, although, I wouldn't say following them is a bad idea. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rex Gozar Sent: Tuesday, July 13, 2010 4:38 AM To: U2 Users List Subject: Re: [U2] UI standards As far as UI standards for data entry applications are concerned, I recommend Microsoft's User Experience Guidelines as a starting point. Google msdn windows 7 user experience guidelines, navigate to the MSDN page, find the PDF link and download the document. Most business people use Microsoft products daily. If your application follows the same basic layouts and uses the same keyboard shortcuts, your users will quickly learn your application; as a bonus, your application will teach them how to use their MS products. However, if your application works contrary to MS products, or requires them to memorize a different command set, then they'll despise you and your product. Have your developers read the book GUI Bloopers to avoid stupid GUI layouts. Also User Interface Design for Programmers is helpful. http://www.joelonsoftware.com/uibook/fog000249.html When is it okay to break out and show off a new interface? When it matches the user's imaginary model, not the developers! Finally, desktop and web applications are starting to blur into one another, so it's okay to borrow practices and standards from one and implement them in the other. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
I just checked on our system and I can call MESSAGE within a PHANTOM if it is executed from a normal session. With this in mind, a possible work around would be to run a 24/7 phantom that either accepts data from a named piped/socket or polls a file and sends out a message based on the data received. From your UV subroutine you could then just passed the required data by the appropriate method. It's dirty and obviously having it work natively from your UV sub would be better, but if it isn't possible... Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, June 30, 2010 1:39 PM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Oh, great - now I'm getting the same error for PHANTOM - so I can't use that workaround. VOC entry PHANTOM illegal as or in a procedure. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 9:50 AM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? I'm wondering if it's because MESSAGE can optionally prompt for input, and because the call statement is executed from the jsp page via executeQuery - maybe it won't allow input inside a query (similar to the rule about input inside a transaction). Perhaps if I execute a PHANTOM command to perform the MESSAGE commands in a different process - maybe that would work. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] @LOGNAME... Changing @variables
I looked into this and there appears to be 2 different type of system variables in UniData. There are those like @AM which cannot be changed and those like @LOGNAME which can be. It is not required to pass them to a subroutine to change those that can be. A program will not compile if you assign to the first type. First type (Those that cannot be changed): @ACCOUNT @AM @COMMAND @CRTHIGH @CRTWIDE @DATA @GID @LASTVERB @LEVEL @LPTRHIGH @LPTRWIDE @PARASENTENCE @PATH @RM @SM @SVM @SYS.BELL @SYSTEM.RETURN.CODE @TM @TRANSACTION @TTY @UDTNO @UID @VM @WHO Second type (Those that can be freely changed): @CONV @DATE @DICT (This is actual usage. Documented) @FORMAT @HEADER @ID (This is actual usage. Documented) @LOGNAME @MONTH @RECORD (This is actual usage. Documented) @RECUR0 (This is actual usage. Documented) @RECUR1 (This is actual usage. Documented) @RECUR2 (This is actual usage. Documented) @RECUR3 (This is actual usage. Documented) @RECUR4 (This is actual usage. Documented) @TIME @USER0 (This is actual usage. Documented) @USER1 (This is actual usage. Documented) @USER2 (This is actual usage. Documented) @USER3 (This is actual usage. Documented) @USER4 (This is actual usage. Documented) @USER.RETURN.CODE (This is actual usage. Documented) @YEAR Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Friday, June 18, 2010 8:29 AM To: U2 Users List Subject: Re: [U2] @LOGNAME on Unidata We ran into a similar situation in the past with uv on hpux Although @LOGNAME is documented as a readonly value, we found out that it is possible to change it ( and other readonly system variables ) by passing it as an argument to a subroutine - the subroutine can then change the value. I guess uv doesn't actually mark the variable as readonly in any way at run time - readonliness is a compile time attribute - so a subroutine has no idea that its calling args are readonly system variables - so in effect they aren't. Look for any subroutines called with @LOGNAME as an argument then check that the sub doesn't alter that argument. Given : ... CALL *SOMESUB( @LOGNAME ) ... DEFINE SUBROUTINE SOMESUB ( ARG ) ... * this will change the argument value in the calling routine * including 'readonly' system variables ARG=Something ... END Pass temp variable instead of @LOGNAME : CALL *SOMESUB( @LOGNAME: ) -or- CALL *SOMESUB( (@LOGNAME) ) -or- Ensure that argument is never modified in the routine -- DEFINE SUBROUTINE SOMESUB ( ARG.IN ) ARG=ARG.IN ;* the only place IARG is ever used ... ARG=SomethingElse ... END Note that this also applies to functions and routines called via SUBR() and once the variable is changed it is changed for the lifetime of the current session not just for the current program. Gerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: June 17, 2010 02:04 PM To: U2 Users List Subject: [U2] @LOGNAME on Unidata We recently migrated from Unidata 7.1.8 on Solaris to Unidata 7.2.5 on RedHat. We make use of @LOGNAME quite a bit to determine a person's username. Since our migration, however, we've documented some cases where @LOGNAME is not returning the proper username - it returns someone else's. What's bizarre is that most of the time it's right, but occasionally it's not. Has anyone seen or heard of this? When we had a report of this (with documentation) I thought it was weird. Today we just got a call about a different problem which I'm 99% sure is tied to this since it makes use of @LOGNAME. Like the above, sometimes it's correct, sometime it's wrong. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of
[U2] Langauge Def for Notepad++
Hey all, I seem to recall someone saying that they had a Notepad++ language def that would work for UniData. Does anyone know where I could get this or who it was that created it? Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code 128 Soft Font
Depending on the month of the year... In fact, I just recently had to ask for a new Windows license in the last week for a new service we are to run. But that's beside the point. I have friends working in purely Linux shops, with the odd exception for a manager's desktop. Now, you wouldn't want to run a service that you rely on a manager's desktop, so for all intents and purposes, they wouldn't have an 'old spare' Windows box laying around. That said however, different people, different situations. My point was that just because software is labeled as $99.95 + a free holiday, doesn't mean that the actual real-world cost will always be $99.95, which I believe was part of the point that Anthony was alluding towards as well. Of course, I have no doubt that both PrintWizard and mvPDF are excellent products and given a sufficient need, I would not rule them out of consideration for the same reason we wouldn't roll our own OS when we build a new desktop. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, May 20, 2010 6:30 PM To: 'U2 Users List' Subject: Re: [U2] Code 128 Soft Font So $199 for Windows 7 Pro, plus $100 for the $100 for the software. 'Cmon, are you seriously saying you don't have any old windows boxes lying around your organization? I can't speak for PrintWizard, but mvPDF will run happily on an old Win2000 box. Like PW it's written in Delphi, it is lightning-fast and offers a serious set of tools for document production, ranging from a full Basic API for real-time drawing and rendering (useful if you want to control layouts precisely) through document capture, merge forms with the usual support for barcodes, images and graphics, PCL import with Epson format barcode escapes.. document encryption and digital signing .. direct print output.. oh, and a fully featured banded report designer, page designer, report mining and graphical zone editing to allow you to reformat existing reports without redeveloping them... Which is way overkill if you just want to print barcodes grin And no, there are NO plans to run under Linux (even using Kylix or FreePascal). The printer architecture is just too weak and patchy (said in sorrow, I've been a fan of Linux since Slackware 2.0). You could possibly thoroughly test and warrant with a very limited number of printer models, but only Windows realistically gives you a sense of confidence across all printer manufacturers and types. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] -1 and Null values
Actually, I think I've just remembered part of it, but not the rest. Appends an empty string: REC = A REC-1 = Doesn't append an empty string: REC = REC-1 = Sets REC2 to an empty string: REC = A REC2,-1 = Doesn't append an empty string: REC = REC1,-1 = I think my mind hasn't returned from vacation yet... Interesting that it changed in UniVerse though, Kate. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Monday, May 03, 2010 3:53 PM To: U2 Users List Subject: Re: [U2] -1 and Null values Hi Dan, You are not the crazy one. It changed some years ago (UniVerse anyway) - we found out the hard way. That and the user number not being the user number for phantom (ie client) users have caused a great deal of heartache for us. Scary thing is what else might change! We avoid use of NOT() when data might be alpha, in case that changes to give runtime error. Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Ph: +64 9 360 5310 Fax: +64 9 376 0750 Mobile: +64 21 400 486 Email: k...@walstan.com - Original Message - From: Dan McGrath dmc...@imb.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, May 03, 2010 5:35 PM Subject: [U2] -1 and Null values Hi all, Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that doing a -1 to append an empty string would not actually appended anything. For example: REC = 'A' REC-1 = '' Would result in REC equaling 'A', not 'A':@AM In fact, I even have some in-house tools I wrote that rely on -1 trimming out empty strings. Now, it appears in UD 7.2.5 that this is no longer the case and it does equal 'A':@AM. I've been through all the release notes and cannot see any changes that would have affected this. I've also looked through all the UDT.OPTIONS and see nothing relevant... Am I going crazy or has this indeed changed? Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] -1 and Null values
Hi all, Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that doing a -1 to append an empty string would not actually appended anything. For example: REC = 'A' REC-1 = '' Would result in REC equaling 'A', not 'A':@AM In fact, I even have some in-house tools I wrote that rely on -1 trimming out empty strings. Now, it appears in UD 7.2.5 that this is no longer the case and it does equal 'A':@AM. I've been through all the release notes and cannot see any changes that would have affected this. I've also looked through all the UDT.OPTIONS and see nothing relevant... Am I going crazy or has this indeed changed? Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD: Phantoms
I tested it in UniData 7.2.5 and the problem I described exists. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Friday, 9 April 2010 7:34 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD: Phantoms Dan, what version of UniData are you running. I reported a similar bug several years ago and it was fixed in version 6.1.7. With that bug, it happened when the process was killed, and then even logging out wasn't sufficient; any process reusing the UDTNO of the killed process could no longer PAUSE until UniData was restarted. 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 Dan McGrath Sent: Wednesday, April 07, 2010 6:45 PM To: U2 Users List Subject: Re: [U2] UD: Phantoms Further to that, you can break PAUSE for an entire session by using the break key to kill it while active. To reproduce: At ecl, type in PAUSE and press enter. Use the break key to kill it. ECL should look like this now: :PAUSE BREAK: Enter Qreturn to Quit. Any other character to continueQ : Now, do a LIST.PAUSED. You will see your session is still listed as paused. Run PAUSE again. It will return straight away. Issue a WAKE for your paused session to remove it from the paused list. Run PAUSE again. It will return straight away. Run Bills test program. It will report 0 seconds as the time taken. PAUSE will now not work again in your session, time to log out. :( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, 8 April 2010 8:34 AM To: U2 Users List Subject: Re: [U2] UD: Phantoms Bill, I get similar results to your test program. INPUT PauseTime FOR I = 1 TO 10 StartTime = TIME() PAUSE PauseTime StopTime = TIME() CRT Total time taken is : OCONV(StopTime - StartTime, 'MTS'): CRT , expected : OCONV(PauseTime, 'MTS') NEXT I Run from ECL Input = 5, Times taken: 6,10,10,10,10,10... Input = 10, first time taken was 8, the next 9 where all 10. ... So, clearly PAUSE aligns itself to a 10 second boundary and can only operate on that. Given this, PAUSE works correctly for any 10 second increment, AFTER the first pause statement. Something like this should be added to the document, because according to the manuals 'PAUSE 5' should work, but in practice, it will actually running a 'PAUSE 10' with the first PAUSE statement pausing for an undefined period. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, 8 April 2010 3:38 AM To: U2 Users List Subject: Re: [U2] UD: Phantoms Well. I have to apologize for disparaging PAUSE. I ran tests by: PauseTime = 30 StartTime = TIME() PAUSE PauseTime StopTime = TIME() CRT Starting at : OCONV(StartTime, 'MTS') CRT Stopping at : OCONV(StopTime, 'MTS') CRT Total time taken is : OCONV(StopTime - StartTime, 'MTS') ...and the total time taken was rarely the PauseTime. So I ran the test with SLEEP and it worked properly. So I replaced SLEEP with PAUSE in our background service program and it wakes up every minute on the exact second. So, I guess, my test program wasn't working. Don't know why though. :-( Bill Bill Haskett said the following on 4/7/2010 10:02 AM: Dean: I ran some tests on PAUSE and it never seemed granular enough to properly work when the time it wakes up important. In other words, I'd pause for 30 and it would pause for sometimes 26 seconds, sometimes 28 seconds, sometimes 23 seconds, sometimes 25 seconds, but never over 30 seconds. SLEEP, however, always seemed to be on time. PAUSE was also cool in that I could find out which lines were paused with the LIST.PAUSE command. I could also WAKE the process from another line. Our UD service program wakes up every minute on the minute. I figure out how many seconds until the next minute then, per Wally's suggestion, I loop for that many seconds then SLEEP 1. This has been hitting the wake-up on the minute over quite a few machines for the past week or two. It appears PAUSE wouldn't come close to waking up at the right time. Anyway, directing my attention to a previously unused BASIC statement is always fun. Thanks, Bill dean.armbrus...@ferguson.com said the following on 4/7/2010 7:59 AM: As an alternative to SLEEP, use PAUSE. A process in PAUSE will return the call stack via PORT.STATUS. SLEEP, CALLC, PCPERFORM, and waiting on a record lock are some of most common conditions which will not return a call stack via PORT.STATUS. Dean Armbruster System
Re: [U2] UD: Phantoms
Bill, I get similar results to your test program. INPUT PauseTime FOR I = 1 TO 10 StartTime = TIME() PAUSE PauseTime StopTime = TIME() CRT Total time taken is : OCONV(StopTime - StartTime, 'MTS'): CRT , expected : OCONV(PauseTime, 'MTS') NEXT I Run from ECL Input = 5, Times taken: 6,10,10,10,10,10... Input = 10, first time taken was 8, the next 9 where all 10. ... So, clearly PAUSE aligns itself to a 10 second boundary and can only operate on that. Given this, PAUSE works correctly for any 10 second increment, AFTER the first pause statement. Something like this should be added to the document, because according to the manuals 'PAUSE 5' should work, but in practice, it will actually running a 'PAUSE 10' with the first PAUSE statement pausing for an undefined period. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, 8 April 2010 3:38 AM To: U2 Users List Subject: Re: [U2] UD: Phantoms Well. I have to apologize for disparaging PAUSE. I ran tests by: PauseTime = 30 StartTime = TIME() PAUSE PauseTime StopTime = TIME() CRT Starting at : OCONV(StartTime, 'MTS') CRT Stopping at : OCONV(StopTime, 'MTS') CRT Total time taken is : OCONV(StopTime - StartTime, 'MTS') ...and the total time taken was rarely the PauseTime. So I ran the test with SLEEP and it worked properly. So I replaced SLEEP with PAUSE in our background service program and it wakes up every minute on the exact second. So, I guess, my test program wasn't working. Don't know why though. :-( Bill Bill Haskett said the following on 4/7/2010 10:02 AM: Dean: I ran some tests on PAUSE and it never seemed granular enough to properly work when the time it wakes up important. In other words, I'd pause for 30 and it would pause for sometimes 26 seconds, sometimes 28 seconds, sometimes 23 seconds, sometimes 25 seconds, but never over 30 seconds. SLEEP, however, always seemed to be on time. PAUSE was also cool in that I could find out which lines were paused with the LIST.PAUSE command. I could also WAKE the process from another line. Our UD service program wakes up every minute on the minute. I figure out how many seconds until the next minute then, per Wally's suggestion, I loop for that many seconds then SLEEP 1. This has been hitting the wake-up on the minute over quite a few machines for the past week or two. It appears PAUSE wouldn't come close to waking up at the right time. Anyway, directing my attention to a previously unused BASIC statement is always fun. Thanks, Bill dean.armbrus...@ferguson.com said the following on 4/7/2010 7:59 AM: As an alternative to SLEEP, use PAUSE. A process in PAUSE will return the call stack via PORT.STATUS. SLEEP, CALLC, PCPERFORM, and waiting on a record lock are some of most common conditions which will not return a call stack via PORT.STATUS. 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 Wally Terhune Sent: Friday, April 02, 2010 2:05 PM To: U2 Users List Subject: Re: [U2] UD: Phantoms Not sure. We do use signaling to 'interrupt' the running process and get it to tell the PORT.STATUS session what it is up to. IIRC, we use SIGUSR2, specifically. So - there could be some system calls that the udt process is in that cannot be interrupted. For instance, I tested a phantom that was running 'SLEEP 120' - and experienced the same result as Bill (no call stack printed). I changed this to a loop FOR 120 that was printing a line, then SLEEP 1 Here is the result: :LISTUSER Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total ( 32 + 32 ) / 64 2 0 0 0 2 UDTNO USRNBR UID USRNAME USRTYPE TTYIP-ADDRESSTIME DATE 1 5372 305730 WTerhune udt pts/1 Console 11:53:11 Apr 02 2010 2 6020 305730 WTerhune phantom pts/2 Console 11:58:05 Apr 02 2010 3 2384 305730 WTerhune udt pts/3 Console 11:55:11 Apr 02 2010 :PORT.STATUS PID 6020 CALL.STACK Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total (32 + 32) / 64 2 0 0 0 2 Udtno Pid User UserType Port Last command processed 2 6020 WTerhune phantom 8443624 level line BASIC callstack 1 4 BP\_WWW Session no command stack. : Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From:
Re: [U2] UD: Phantoms
Further to that, you can break PAUSE for an entire session by using the break key to kill it while active. To reproduce: At ecl, type in PAUSE and press enter. Use the break key to kill it. ECL should look like this now: :PAUSE BREAK: Enter Qreturn to Quit. Any other character to continueQ : Now, do a LIST.PAUSED. You will see your session is still listed as paused. Run PAUSE again. It will return straight away. Issue a WAKE for your paused session to remove it from the paused list. Run PAUSE again. It will return straight away. Run Bills test program. It will report 0 seconds as the time taken. PAUSE will now not work again in your session, time to log out. :( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, 8 April 2010 8:34 AM To: U2 Users List Subject: Re: [U2] UD: Phantoms Bill, I get similar results to your test program. INPUT PauseTime FOR I = 1 TO 10 StartTime = TIME() PAUSE PauseTime StopTime = TIME() CRT Total time taken is : OCONV(StopTime - StartTime, 'MTS'): CRT , expected : OCONV(PauseTime, 'MTS') NEXT I Run from ECL Input = 5, Times taken: 6,10,10,10,10,10... Input = 10, first time taken was 8, the next 9 where all 10. ... So, clearly PAUSE aligns itself to a 10 second boundary and can only operate on that. Given this, PAUSE works correctly for any 10 second increment, AFTER the first pause statement. Something like this should be added to the document, because according to the manuals 'PAUSE 5' should work, but in practice, it will actually running a 'PAUSE 10' with the first PAUSE statement pausing for an undefined period. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, 8 April 2010 3:38 AM To: U2 Users List Subject: Re: [U2] UD: Phantoms Well. I have to apologize for disparaging PAUSE. I ran tests by: PauseTime = 30 StartTime = TIME() PAUSE PauseTime StopTime = TIME() CRT Starting at : OCONV(StartTime, 'MTS') CRT Stopping at : OCONV(StopTime, 'MTS') CRT Total time taken is : OCONV(StopTime - StartTime, 'MTS') ...and the total time taken was rarely the PauseTime. So I ran the test with SLEEP and it worked properly. So I replaced SLEEP with PAUSE in our background service program and it wakes up every minute on the exact second. So, I guess, my test program wasn't working. Don't know why though. :-( Bill Bill Haskett said the following on 4/7/2010 10:02 AM: Dean: I ran some tests on PAUSE and it never seemed granular enough to properly work when the time it wakes up important. In other words, I'd pause for 30 and it would pause for sometimes 26 seconds, sometimes 28 seconds, sometimes 23 seconds, sometimes 25 seconds, but never over 30 seconds. SLEEP, however, always seemed to be on time. PAUSE was also cool in that I could find out which lines were paused with the LIST.PAUSE command. I could also WAKE the process from another line. Our UD service program wakes up every minute on the minute. I figure out how many seconds until the next minute then, per Wally's suggestion, I loop for that many seconds then SLEEP 1. This has been hitting the wake-up on the minute over quite a few machines for the past week or two. It appears PAUSE wouldn't come close to waking up at the right time. Anyway, directing my attention to a previously unused BASIC statement is always fun. Thanks, Bill dean.armbrus...@ferguson.com said the following on 4/7/2010 7:59 AM: As an alternative to SLEEP, use PAUSE. A process in PAUSE will return the call stack via PORT.STATUS. SLEEP, CALLC, PCPERFORM, and waiting on a record lock are some of most common conditions which will not return a call stack via PORT.STATUS. 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 Wally Terhune Sent: Friday, April 02, 2010 2:05 PM To: U2 Users List Subject: Re: [U2] UD: Phantoms Not sure. We do use signaling to 'interrupt' the running process and get it to tell the PORT.STATUS session what it is up to. IIRC, we use SIGUSR2, specifically. So - there could be some system calls that the udt process is in that cannot be interrupted. For instance, I tested a phantom that was running 'SLEEP 120' - and experienced the same result as Bill (no call stack printed). I changed this to a loop FOR 120 that was printing a line, then SLEEP 1 Here is the result: :LISTUSER Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total ( 32 + 32 ) / 64 2 0 0 0 2 UDTNO USRNBR UID USRNAME
Re: [U2] BDT is anyone using it?
We looked into using, but it had way too many issues, which meant wED was still far more productive/useful for us. For the record, locking code was not one of the issues. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Saturday, 3 April 2010 6:46 AM To: 'U2 Users List' Subject: [U2] BDT is anyone using it? Being a VAR for Rocket Software, we support BDT. We have this Universe customer that tells us about this new BDT release that got of the download site. Oops, we did not know there was a new release. This release does not match the one that we gave them. Anyways, they have this multilevel file the wanted to see if it displayed on BDT. Of course it did not work. After spending time in the Universe documentation I found what the structure of VOC item should be. Oh, the VOC was correct. We checked Unidata LF and LD. BDT worked on one and failed on the other. This was not looking good. Just for grins, we tested our product XLr8Editor. XLr8Editor failed on both Unidata and Universe. Not good either. Together with my Java programmer two days ago we issued a Bugzilla to fix this. The code was fixed today. So we have updated our download site with the new code. XLr8Editor allows editing of data and programs, so this fix had to be done. 1. BDT does not allow editing of data files so why should we care? 2. We got one client with one programmer trying BDT that seems to be on the fringe? 3. Does anyone use this product except for my one obscure client? Regards, Doug www.u2logic.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick on Mac
MaxOSX is built on Darwin which largely comes from FreeBSD. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Tuesday, 30 March 2010 9:11 PM To: U2 Users List Subject: Re: [U2] Pick on Mac The MAC OS is a version of openBSD I believe, and Universe did have a BSD implementation in the past. If Rocket had a business case for doing it, I suspect Rocket could put UniVerse on Mac. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Regex searching UD files
I've written a small utility to be able to run egrep on a UD file (not UD directory), however its implementation is not ideal. Essentially, I select the file I'm searching, writing each record one at a time to a temp UNIX file and running egrep on it as follows !egrep -q -f MyTempRegexFile MyTempRecordFile ; echo $? Where MyTempRegexFile is a file containing the desired regex pattern stored earlier and MyTempRecordFile is a file name unique to each user. My problem with it is that I have to do a READ on each record, followed by a WRITE then have egrep read it in as well. That's a lot of seemingly unneeded disk IO if I could only stream the record to egrep without have to do a WRITE after the READ. Any ideas? I feel I'm missing something quite obvious. Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regex searching UD files
Not even close... We run in ECLTYPE P and don't have access to EVAL and the like. ^[Cc][Hh][Qq].*[5-8][0-9][0-9][0-9]x Unless you can explain how to duplicate the above search with ESEARCH? @Stuart, that would be ideal, but unfortunately I can't go dumping out multi-gigabyte files. :( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, 30 March 2010 5:22 AM To: U2 Users List Subject: Re: [U2] Regex searching UD files Does UniData ECL ESEARCH command not fill the bill already? Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Monday, March 29, 2010 12:22 AM To: U2 Users List Subject: Re: [U2] Regex searching UD files I think this should be one for Rocket to implement a RegexSearch in U2. However, if it's size non-impactive, what I would normally do is copy the file to a temporary directory then run grep across that. Stuart Boydell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, 29 March 2010 17:08 To: U2 Users List Subject: [U2] Regex searching UD files I've written a small utility to be able to run egrep on a UD file (not UD directory), however its implementation is not ideal. Essentially, I select the file I'm searching, writing each record one at a time to a temp UNIX file and running egrep on it as follows !egrep -q -f MyTempRegexFile MyTempRecordFile ; echo $? Where MyTempRegexFile is a file containing the desired regex pattern stored earlier and MyTempRecordFile is a file name unique to each user. My problem with it is that I have to do a READ on each record, followed by a WRITE then have egrep read it in as well. That's a lot of seemingly unneeded disk IO if I could only stream the record to egrep without have to do a WRITE after the READ. Any ideas? I feel I'm missing something quite obvious. Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Regex searching UD files
Thanks for the reply Will, but I do understand how U2 files work. That's why I'm using UniBasic to read the record then write it out to UNIX. If the files we search weren't so big I would just dump a copy to a dir than search it, but that isn't practical in most cases for us. Maybe I can improve it to write the records in blocks of 'x', search them. That would at least save some of the processing cost of jumping around, but it doesn't solve the Disk I/O bottleneck. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Tuesday, 30 March 2010 5:14 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Regex searching UD files Dan you can't do it because the records in Universe are not files at all, not even logical files. They are just possible frame-discontinous streams of bytes that *Universe* interprets in run-time as a connected record. Nothing else is going to be able to do that, without re-writing the frame(block)-walker directly in Unix. Alternatively you could write egrep in Universe yourself which would probably be easier! But I wouldn't read and write after each record, I would read and write the entire file at *once*. And then egrep. I sure that would save on thrashing at least. If you're processing at least 10 percent of the file, then you might see that writing the whole file, then switching to Unix for the rest will still be faster than breaking after each write. Will Johnson In a message dated 3/28/2010 11:22:25 P.M. Pacific Daylight Time, stuart.boyd...@spotless.com.au writes: I think this should be one for Rocket to implement a RegexSearch in U2. However, if it's size non-impactive, what I would normally do is copy the file to a temporary directory then run grep across that. Stuart Boydell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, 29 March 2010 17:08 To: U2 Users List Subject: [U2] Regex searching UD files I've written a small utility to be able to run egrep on a UD file (not UD directory), however its implementation is not ideal. Essentially, I select the file I'm searching, writing each record one at a time to a temp UNIX file and running egrep on it as follows !egrep -q -f MyTempRegexFile MyTempRecordFile ; echo $? Where MyTempRegexFile is a file containing the desired regex pattern stored earlier and MyTempRecordFile is a file name unique to each user. My problem with it is that I have to do a READ on each record, followed by a WRITE then have egrep read it in as well. That's a lot of seemingly unneeded disk IO if I could only stream the record to egrep without have to do a WRITE after the READ. Any ideas? I feel I'm missing something quite obvious. Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than
Re: [U2] ECLTYPE U mode [was RE: Regex searching UD files]
Interesting! Is that in the manuals? I don't recall coming across it... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, 30 March 2010 8:57 AM To: U2 Users List Subject: [U2] ECLTYPE U mode [was RE: Regex searching UD files] Regarding your ECLTYPE P comment... Any application has access to ECLTYPE U and associated features. If you use the lowercase version of any standard ECL verb - U mode parsing is forced. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, March 29, 2010 3:13 PM To: U2 Users List Subject: Re: [U2] Regex searching UD files Not even close... We run in ECLTYPE P and don't have access to EVAL and the like. ^[Cc][Hh][Qq].*[5-8][0-9][0-9][0-9]x Unless you can explain how to duplicate the above search with ESEARCH? @Stuart, that would be ideal, but unfortunately I can't go dumping out multi-gigabyte files. :( ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
Hi Clif, I'd be interesting in reading. I write the occasional piece and probably should use more encompassing terms to enhance future search-ability and to promote the database style. Regarding ECL/TCL/etc, since I'm normally in Unix/Linux land, I normally think of them as shells, which brings MultiValue Shell (MVSH) to mind. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Wednesday, 24 March 2010 4:19 PM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide Well, the terminology issue is something we (Spectrum magazine in particular) can promote since we are already committed to promoting the term MultiValue (note the mid-cap casing) and the MultiValue Logo. We just add such terms to our Style and Usage Guide and use them in the magazine. Side note: Is there any interest in us having our Style and Usage Guide available online? I'm interested in hearing what folks would find an acceptable term for TCL/ECL/etc. As to the idea of of a generic book, groups of experts, etc., that sounds like a fame and glory no profit Open Source kind of thing. A lot of the experts you might want to attract are dudes and dudettes trying to make a living. That goes back to some of Tony's comments. How could that be made worthwhile for said experts to forgo revenue producing time to produce a non-profit book? Considering some other Open Source documentation efforts, I'm not saying it can't be done. I'm just challenging everyone to present detailed ideas for how it could be made to work. Regards, Clif On Mar 23, 2010, at 6:09 PM, James Canale, Jr. wrote: I think it would be great do something like this. Multivalue Query [mvQuery] Multivalue Basic [mvBasic] Multivalue PROC [mvPROC] I also think it would be great if someone could write a piece of a book that is very generic (keep it at a 20,000 foot view) which covers each major topic area. Once complete, a group of experts-at-large in the various flavors add platform specific details. When complete, one or more of the know-it-alls [like some of the gurus on this list] combine the common parts, while leaving the unique areas in place. Basically, a wiki to book transformation. Many of the books sold today have two, three, and even more authors (especially the technically oriented books). Something like this could reduce the work required (just doing a piece of the whole) and increase the potential market (supports most platforms) for sales. I see a lot of talent on this list that can pull something like this off, it just needs a great leader (and I see many of them here too). Regards, Jim -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Tuesday, March 23, 2010 6:39 PM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide In Spectrum magazine, we use the term MultiValue Basic to talk about the programming language in articles that are not platform specific. I put it in the style and usage guide for just the reasons being brought up here. I don't see any reason not to add other MultiValue generic terms. MultiValue Query comes to mind. I'm open to suggestions about that and other terms. Post them here, or if you'd rather not, just send them to me at edi...@intl-spectrum.com (or my regular e-mail address). Regards, Clif -- Clifton Oliver, Managing Editor International Spectrum Magazine Spectrum Tel: +1 720 259 1356 Clif's Direct Tel: +1 619 460 5678 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB.
Re: [U2] UD - Error Logging
Far be it from me to suggest how they actually implement the logging in the code base, but it is hard to go past the log4* libraries. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Tuesday, 23 March 2010 7:53 AM To: 'U2 Users List' Subject: Re: [U2] UD - Error Logging Wally, I guess I'm the taker. There is this nice open source product called log4c. It can log to files, syslog or any other destinations. It is modeled after an open source product we use called log4j. It runs on HP, RedHat, Solaris, AIX, and Windows. But since it is open source, you can port it any other platform as well. Perhaps the best part is the logging levels (TRACE, DEBUG, INFO, WARN, ERROR, and FATAL). That adds standard granularity to the logging. Additionally you can reformat the logging into any format you want. You can control the size and the number of logs you want to keep. I pulled this from our log4j configuration on our U2WebLink middleware product: # Loggers log4j.logger.com.u2logic.XLr8U2Interface.U2WebLinkLogger=INFO,U2WebLinkF ileA ppender log4j.logger.com.u2logic.XLr8U2Interface.XLr8ReplicatorLogger=INFO,XLr8R epli catorFileAppender log4j.logger.org.quartz=INFO,QuartzSchedulerFileAppender log4j.logger.org.directwebremoting=INFO,DirectWebRemotingFileAppender # # U2WebLink Log File Appender log4j.appender.U2WebLinkFileAppender=org.apache.log4j.RollingFileAppende r log4j.appender.U2WebLinkFileAppender.File=logs/U2WebLink.log log4j.appender.U2WebLinkFileAppender.Append=true log4j.appender.U2WebLinkFileAppender.ImmediateFlush=true log4j.appender.U2WebLinkFileAppender.layout=org.apache.log4j.SimpleLayou t log4j.appender.U2WebLinkFileAppender.MaxFileSize=1000KB log4j.appender.U2WebLinkFileAppender.MaxBackupIndex=10 What this means is your entire code must be changed to accommodate this new logging structure. Additionally, you could use standard tools for you log analysis instead of writing your own. We use an open source tool in Eclipse to analyze our logs that even allows us to see them live over the internet. Regards, Doug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Monday, March 15, 2010 8:06 PM To: U2 Users List Subject: Re: [U2] UD - Error Logging I would be happy to entertain (and formally register) a detailed, coherent proposal for logs, error logs, diagnostic logs - location and management. Do you still want the saved_logs directory concept? (20 or configurable? Iterations saved) What happens at 'startud'? Anything happen at 'stopud'? Is the trunclog command useful? Should the detailed UniBasic run-time error message logging provided by 7.2.0 /usr/ud72/include/msglevelconfig be placed separate from udt.errlog? Should RFS have a separate log for error messages? Should RFS Archiving - have a separate log for offload messages? Client/server debug logs are inconsistent in configuration and activation. What would you propose in this area? Locations must be discoverable by tools that collect information for diagnostics (such as udtdiag). What else am I missing? Whereas I am constantly requesting more usable content of the messages, can we just focus on the overall architecture for this specific proposal? This would be something to be considered by PM for UniData.NEXT and prioritized with the rest of the enhancements. Other venues for proposals such as this are u2-users better and better forum and the UniData CAB (just recently formed by PM). Any takers? Regards, Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The
Re: [U2] UD - Error Logging
Of course log files belong in the bin directory! I get tripped up every second time I got hunting for them... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, 16 March 2010 12:12 PM To: 'U2 Users List' Subject: Re: [U2] UD - Error Logging I've made the same complaint and pretty much feel like I received an 'eye roll' of 'who would be that stupid...' My argument was how easy it would be to have someone shut down their systems by deleting required files while trying to clean up log files that are stored in bin... That would SEEM to be a rational business case. But I got the impression we're likely to never see that fixed... David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, March 15, 2010 8:05 PM To: U2 Mail List Subject: Re: [U2] UD - Error Logging A business case, eh? How about any world-class dbms must have consistent, comprehensive, and easily configurable error logging. If U2 doesn't have this then it needs to get it...period! Every one of us in the applications market know we have to incorporate basic industry functionality (plus logging) into our application, otherwise we eventually lose business. Why doesn't this rule apply to UD? Because they can blow us off and tell us to migrate to UniVerse? (Perhaps I'm being a little unfair.) Just IMHO, of course. :-) Bill Doug Averch said the following on 3/15/2010 5:16 PM: Bill, That is where in Engineers put them originally. Makes no sense today nor did it years ago when I worked there. Also, you have many ways to turn on the severity of each log as well as getting logs for non-daemons. I put in a request last year to fix this. No business case, so it was rejected. Regards, Doug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, March 15, 2010 4:37 PM To: U2 Mail List Subject: [U2] UD - Error Logging Does anyone know why most of the various UniData logs are in the @UDTHOME/bin directory? Why aren't they in the @UDTHOME/log directory? Maybe there's a @UDTLOG environment variable? Thanks, Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Error Logging
Location, if fixed: $UDTHOME/log[s]/server/ $UDTHOME/log[s]/client/ This allows client and server logging to be on separate mount points if the admin desires, without needing the configuration options If configurable, just make the parameter a path relative to $UDTHOME Saved_logs: Yes. Saved_logs is the right concept. Having it either in the log[s] directory or configurable relative to $UDTHOME would be an acceptable option. Trunclog: I do believe it is useful. We have at least 1 application here that would have benefitted from this command. One caveat, however. Having the possibility of log data being lost is not acceptable in a production environment. Maybe instead of 'trunclog' a 'SwitchOutLog' would be better. This would instead to processes that are logging to close there current log file, move it out to the saved_logs directory and open a new one. A slightly more complex solution of writing to a temporary log file while the trunclog/switchoutlog was in process would prevent data loss without causing a system to pause while the logs are processed. RFS: Having RFS logging separate would make any automation of monitoring them easier to tune. If something is considered a separate sub-system, it should either have its own log file, or the log file contents should be structured in a manner where the particular sub-system in question can be found in a consistent manner/location. I cannot really speak about RFS logging however, as we are not running it so I have no idea of the volume of logging data being generated. This isn't a detailed proposal (or perhaps even coherent), as I'm not sure work would be happy with me doing it on the clock, but it is some general ideas on the architecture. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, 16 March 2010 1:06 PM To: U2 Users List Subject: Re: [U2] UD - Error Logging I would be happy to entertain (and formally register) a detailed, coherent proposal for logs, error logs, diagnostic logs - location and management. Do you still want the saved_logs directory concept? (20 or configurable? Iterations saved) What happens at 'startud'? Anything happen at 'stopud'? Is the trunclog command useful? Should the detailed UniBasic run-time error message logging provided by 7.2.0 /usr/ud72/include/msglevelconfig be placed separate from udt.errlog? Should RFS have a separate log for error messages? Should RFS Archiving - have a separate log for offload messages? Client/server debug logs are inconsistent in configuration and activation. What would you propose in this area? Locations must be discoverable by tools that collect information for diagnostics (such as udtdiag). What else am I missing? Whereas I am constantly requesting more usable content of the messages, can we just focus on the overall architecture for this specific proposal? This would be something to be considered by PM for UniData.NEXT and prioritized with the rest of the enhancements. Other venues for proposals such as this are u2-users better and better forum and the UniData CAB (just recently formed by PM). Any takers? Regards, Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Decoding URL in UniBasic
Hi Charles, Just to add to Doug, I'll assume you are encoding '\' as '\\' well? Otherwise you would have no way to send the string '\' without it being (incorrectly) decoded as just ''. If this is the case, don't forget to SWAP '\\' with '\' before you fix up the rest. So it should look something like: VALUE = CHANGE(VALUE,'\\','\') VALUE = CHANGE(VALUE,'\','') VALUE = CHANGE(VALUE,\',') Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Thursday, 4 March 2010 10:48 AM To: 'U2 Users List' Subject: Re: [U2] Decoding URL in UniBasic Hi Charles: Try: VALUE = CHANGE(VALUE,'\','') Regards, Doug www.u2logic.com XLr8Editor for U2 -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: Wednesday, March 03, 2010 3:03 PM To: U2 Users List Subject: [U2] Decoding URL in UniBasic I just ran into something that I'm surprised I haven't run into before. I'm passing some data into a UniBasic subroutine from PHP using UniObjects for Java. When the string contains a single quote or a double quote, it is being escaped. It is sent as 5 Ring but arrives as 5\ Ring. I am encoding it in JavaScript and decoding it in PHP before using UniObjects for Java to send it to the UniBasic subroutine. If I don't decode it in PHP and send it through encoded, is there a way to decode it in UniBasic? Unidata 7.1. 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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] How do associations, @NS and @NV work in UniData Dictionaries?
Does anyone have a quick example of how Associations, @NS and @NV work in UniData? I'm trying to work out associations in dictionary items but cannot get them to do anything. For example, in a record 1,1 = A 1,2 = B 2,1 = Apple 2,2 = Banana I created 3 dictionary items. LETTER and FRUIT, COMBO as follows LETTER: 1 = D 2 = 1 3 = 3 = Letter 4 = 6L 5 = M 6 = COMBO FRUIT: 1 = D 2 = 1 3 = 3 = Letter 4 = 6L 5 = M 6 = COMBO COMBO: 1 = PH 2 = LETTER FRUIT Doing a 'LIST LETTER FRUIT' or 'LIST COMBO' has no difference to when LETTER and FRUIT do not have an association declared in 6. At this point I thought it might group multivalues together when SELECTing so I created another record as such: 1,1 = A 1,2 = B 2,1 = Banana 2,2 = Apple Doing 'SELECT MyFile WITH LETTER = A and FRUIT = Apple' selects both records, so that cannot be it either. I then tried changing LETTER to be: 1 = I 2 = EXTRACT(@RECORD,1,@NV,1);EXTRACT(FRUIT,1,@NV,1);@1: (:@2:) : @NS 3 = 3 = Letter 4 = 6L 5 = M 6 = COMBO Hoping it that a `LIST MyFile LETTER` would bring back all the different letters with their associated fruit in parentheses. That didn't work either as now LETTER only ever displayed the first Multivalue instead of all of them. For Eg: LIST MyFile LETTER 14:05:22 26 FEB 2010 1 MyFile LETTER.. RECORD2A (Banana)1 RECORD A (Apple)1 2 records listed The manuals don't go any further then saying the word association. Is anyone able to clarify this for me? Thanks! Dan PS: The question is also posted here: http://stackoverflow.com/questions/2339276/how-do-associations-ns-and-nv -work-in-unidata-dictionaries ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections
I'll third that, through mvopen.org -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter S. Goldberger Sent: Friday, 5 February 2010 9:02 AM To: U2 Users List Subject: Re: [U2] U2UG Elections Logged in to u2ug.org and voted w/o any problems Wally Terhune wrote: Worked fine for me Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections
Sorry, u2ug.org. I was reading mvopen.org and wonder what that was, so naturally typed it instead. :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Friday, 5 February 2010 9:05 AM To: U2 Users List Subject: Re: [U2] U2UG Elections I'll third that, through mvopen.org -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter S. Goldberger Sent: Friday, 5 February 2010 9:02 AM To: U2 Users List Subject: Re: [U2] U2UG Elections Logged in to u2ug.org and voted w/o any problems Wally Terhune wrote: Worked fine for me Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD7.1 BDT
For those who use StackOverflow, the question is also posted here: http://stackoverflow.com/questions/2156751/u2-basic-developer-toolkit -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of danmcg...@gmail.com Sent: Thursday, 28 January 2010 9:49 PM To: u2-users@listserver.u2ug.org Subject: [U2] UD7.1 BDT Hi all, Does anyone here run the BDT with UD7.1? At U2U I was given the impression that it works fine, however, when opening up Database Files in an account, every single DIR type file gives a loading error dialog and doesn't register any records in them. Thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD7.1 BDT
Thanks Doug, I was aware of that. I just want to know if anyone on 7.1 currently uses it since I was told at U2U that it should work fine. As to the [ad], I would love too try it, however we appear to be allergic to most technology here. :( It would take me 5 months to get a trial install approved to be considered. Think of the Hitch Hikers Guide to the Galaxy signed in triplicate section. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Monday, 1 February 2010 10:07 AM To: 'U2 Users List' Subject: Re: [U2] UD7.1 BDT BDT was released for 7.2 or greater. There is another Eclipse U2 Editor that works on 6.0 or greater of Unidata. [ad]XLr8Editor is available for trials and can be licensed currently for 49.00 per year See www.u2logic.com/tools.html. [/ad] Regards, Doug www.u2logic.com Full range of U2 tools for Eclipse -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of danmcg...@gmail.com Sent: Thursday, January 28, 2010 3:49 AM To: u2-users@listserver.u2ug.org Subject: [U2] UD7.1 BDT Hi all, Does anyone here run the BDT with UD7.1? At U2U I was given the impression that it works fine, however, when opening up Database Files in an account, every single DIR type file gives a loading error dialog and doesn't register any records in them. 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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 Web Services
Thanks to all who responded to the question. As always, I'm being made to jump around different projects, so I may get back to some of you in the near future. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, 19 January 2010 10:41 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 Web Services From: Symeon Breen The simplest solution is to use uniobjects (either .net or for java) and write your own webservice - in asp.net for example it is about 20 lines of code, asp.net then handles all your soap, or rest, or json stuff for you - there have been examples posted on here before, plus i think in the wiki. I agree with Symeon and I write web services all the time. Nay-sayers can say what they will, it's fast and it works. Thanks to our client, Scott, for the nod. He had been down this route, went through standard U2 resources, found lots of problems, and then I created a solution for him with ASP.NET Web Services - and he got full source when the project was complete. Note that while most web services take just a few minutes, the services I wrote for Scott's company took about 10 hours in documentation, code, and testing, because very detailed settings were required to conform to an existing environment. Anyone writing their own services won't have to deal with such issues. Take a look at a video I have on our web site. It shows two ways to create web services in 20 minutes, and it would take less time if I wasn't explaining it. See remove.thisNebula-RnD.com/products/gallery.htm. I used mv.NET because it's a Swiss Army knife for a ton of projects [ad], but as Symeon said, you can easily use UO.NET too. Follow the concept, don't worry about the connectivity product. You can do this for Free and within Minutes! Also, search PickWiki.com for web services and you'll find some solutions there. (Side note: we're porting PickWiki.com into MediaWiki soon. See home page for info.) Finally, here's another video, (1min40sec) of someone who evaluated U2 Web Services and decided to do something else: http://www.youtube.com/watch?v=276F-xKqflQ If you need any help, let me know. Our business is based on doing the things that others find too tough. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse RetreiVe how do I query a file for all of its column's values?
Hi Evan, It is not often you would do something like this as it is generally not required in the U2 World. We may be able to provide you with better solutions if we understood what you are trying to achieve by listing every column? Unidata/UniVerse files are a lot more complex than SQL Tables in data structure. Generally they are not just a simple collection of columns. On top of that, each 'column' can have names with different settings in the dictionary (What you see when you do LIST DICT file). They can even be collections of columns, etc. To add another issue, it is entirely possible that not all 'columns' have defined dictionaries, so they will not appear when you do LIST DICT file. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Evan Carroll Sent: Thursday, 21 January 2010 11:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse RetreiVe how do I query a file for all of its column's values? This is a repost from a stackoverflow question I asked: http://stackoverflow.com/questions/2068026/universe-retreive-how-do-i-qu ery-a-file-for-all-of-its-columns-values === START REPOST === In UniVerse you can't query a file for all of its columns unless the @ phrase in your file's dictionary is set to all of the tables columns. If it isn't how do you query a table for all of its column's values? So I can get the total column listing (column name display name) using: LIST DICT file NAME This will return a listing of all columns and their display names. How do I then query the table for all of the columns it has? LIST file Will only query it for LIST file @id (@id is the only thing in @). === END REPOST === I'd like to follow up with a request to see if anyone has a copy of a BASIC program that does this, I imagine it is something every heavy universe must keep in arms reach. Thanks a ton, -- Evan Carroll System Lord of the Internets ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 Web Services
Hi all, Are there any people out there currently using U2 Web Services in production? Do you find it stable? From the information I have, I cannot see how we can send SOAP Faults depending on the results of a subroutine call (For example, an error message parameter # ), which makes it impossible to use to integrate with some 3rd party products. Does anyone else have third party products that use SOAP/XML to communicate with Unidata and use something other than U2 Web Services to handle it? Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Credit Card info
Indeed. You don't want to be on the wrong side of those requirements either, VISA can come down pretty hard... As always with this sort of stuff, don't attempt to reason your own scheme. Find out what you should REALLY be doing from an official source. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Sunday, 17 January 2010 12:08 PM To: 'U2 Users List' Subject: Re: [U2] Credit Card info Actually, it's a Visa REQUIREMENT to print only the last 4 digits of a Visa card number on sales receipts, etc. Larry Hiscock Western Computer Services ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SELECTs on FILEs
Thanks Wally, By primary groups, does that mean the key and data sections? In other words, if there are no level 1 or 2 overflows, does that mean the entire file will be read into memory? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, 15 December 2009 12:22 AM To: U2 Users List Subject: Re: [U2] SELECTs on FILEs There is a 'key section' to each group in a UniData hashed file. If you have no level 2 overflow, selecting on the keys will result in just the primary groups being read from disk. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Sunday, December 13, 2009 5:15 PM To: U2 Users List Subject: [U2] SELECTs on FILEs Hi all, Just a quick question on SELECTs for UD. I was under the impression that performing a wildcard SELECT with @ID would only result the key section of a FILE been read. Eg, SELECT MYFILE WITH @ID = prefix] Is this incorrect? Does it actually result in the entire FILE being read into memory to complete this SELECT? Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] SELECTs on FILEs
Hi all, Just a quick question on SELECTs for UD. I was under the impression that performing a wildcard SELECT with @ID would only result the key section of a FILE been read. Eg, SELECT MYFILE WITH @ID = prefix] Is this incorrect? Does it actually result in the entire FILE being read into memory to complete this SELECT? Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData - TANDEM verb
[ESC]+[M] Allows you to write on there screen, but not enter data that is registered by anything other than the client. If you are root, you can do [ESC]+[F] which also you to actually input data. This is true for both UniVerse and UniData. Although, GoToMeeting, WebEx, RDP, etc, etc, are far better options than TANDEM these days. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, 9 December 2009 5:37 AM To: U2 Mail List Subject: [U2] UniData - TANDEM verb Kevin: D3 used to have a TANDEM verb for both Windows and Linux. It worked perfectly for us for years and years. U2 never had it but UD got it at least several years ago. However, when one tandems to another port one cannot enter data on the other person's computer. We can enter a [ctrl]+(?) to activate key input but I could never get it to work anywhere near what D3's did. That said, today we use GoToMeeting and wouldn't think of using tandem; so the verb has much less value today than it used to. There are a lot of other desktop sharing applications so these are worthwhile for workstations. But with terminals, I guess TANDEM is better than nothing. :-) Bill Kevin King said the following on 12/8/2009 7:15 AM: And it may be in the underlying operating system (!tandem) rather than a TCL verb. On Mon, Dec 7, 2009 at 8:57 PM, Dan McGrath dmc...@imb.com.au wrote: Dave, Did you check if they had the TANDEM VOC entry. Depending on their setup, it may have been removed meaning only administrators can access it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav Sent: Tuesday, 8 December 2009 1:46 PM To: U2 Users List Subject: Re: [U2] UniData - TANDEM verb Dave, I didn't know they had it. Most people I know set up webinars to see the other person's PC. Also, Microsoft has office communicator, which has session sharing! Brad - Original Message - From: David Wolverton dwolv...@flash.net To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thursday, December 03, 2009 12:35 PM Subject: [U2] UniData - TANDEM verb Does someone know offhand when TANDEM was added to UniData under Windows? I have a site that I need that function, but they say 'TANDEM' just returns a 'verb?' response. Thanks! David 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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other
Re: [U2] PORT.STATUS affecting program
Thanks again Wally. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, 9 December 2009 12:44 AM To: U2 Users List Subject: Re: [U2] PORT.STATUS affecting program Since your process is continuing (not core dumping, apparently), likely a different permutation. If the system call is blocking the signal we are using, we may not be able to remedy for you. If you need to progress this issue, please provide your test case, UniData version, platform, os version to your UniData support provider. Also - readmes are publicly available on the Product Availability Matrix - regarding fixed issues. https://u2tc.rocketsoftware.com/matrix.asp regards, Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, December 07, 2009 9:11 PM To: U2 Users List Subject: Re: [U2] PORT.STATUS affecting program Thanks Wally! According to our IT policy, we are not actually allowed to divulge any details on what software versions, etc, we are using. That's why I simply posted a message asking if anyone knew anything offhand. Being relatively new to the U2 style of through ISV support, when issues are detected with previous releases (then fixed), are they only available through the readme's of later releases or are notifications passed down through the food chain? Obviously having to wait for and then scan the readme's of each new release is a slow of tedious method of finding out about potential issues with your system. I can see how our signalling issue would fit into this, but was run at the moment the target udt process was freeing shared memory doesn't make sense when the process is sitting waiting at a blocking call for pipes? Is this a different issue or was this all fixed as part of that? Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, 8 December 2009 10:59 AM To: U2 Users List Subject: Re: [U2] PORT.STATUS affecting program Assuming this is UniData, (though you don't specify db, version or os), you may be encountering a signal issue that is fixed at 7.2.3. From the readme: Issue 11687 - Problem Description UniData -- When using the PORT.STATUS command with the PID option to review the CALL.STACK or another udt process, the target udt process may have abnormally terminated and produced a core file. This occurred if the PORT.STATUS command was run at the moment the target udt process was freeing shared memory. This problem has been fixed. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, December 07, 2009 4:07 PM To: U2 Users List Subject: [U2] PORT.STATUS affecting program Hi all, just wondering if anyone has encountered this before? I was running some tests and discovered that doing a PORT.STATUS PID pid CALL.STACK on a program that is waiting to open a named pipe with OSOPEN caused it to bomb out. I looked and it didn't have an ON ERROR statement, so I added it and checked again. Every time I made the PORT.STATUS call, it caused it to drop into the ON ERROR section. My guess would be to perform the check on the program; it has to interrupt it, hence causing it to bomb out of any blocking calls. Until now, I had assumed the PORT.STATUS command would not affect a program, but now it appears that it can, meaning it could potentially be dangerous to use in a production environment. Is this documented anywhere? Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB
[U2] Test
List still down? :( ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] PORT.STATUS affecting program
Hi all, just wondering if anyone has encountered this before? I was running some tests and discovered that doing a PORT.STATUS PID pid CALL.STACK on a program that is waiting to open a named pipe with OSOPEN caused it to bomb out. I looked and it didn't have an ON ERROR statement, so I added it and checked again. Every time I made the PORT.STATUS call, it caused it to drop into the ON ERROR section. My guess would be to perform the check on the program; it has to interrupt it, hence causing it to bomb out of any blocking calls. Until now, I had assumed the PORT.STATUS command would not affect a program, but now it appears that it can, meaning it could potentially be dangerous to use in a production environment. Is this documented anywhere? Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData - TANDEM verb
Dave, Did you check if they had the TANDEM VOC entry. Depending on their setup, it may have been removed meaning only administrators can access it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav Sent: Tuesday, 8 December 2009 1:46 PM To: U2 Users List Subject: Re: [U2] UniData - TANDEM verb Dave, I didn't know they had it. Most people I know set up webinars to see the other person's PC. Also, Microsoft has office communicator, which has session sharing! Brad - Original Message - From: David Wolverton dwolv...@flash.net To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thursday, December 03, 2009 12:35 PM Subject: [U2] UniData - TANDEM verb Does someone know offhand when TANDEM was added to UniData under Windows? I have a site that I need that function, but they say 'TANDEM' just returns a 'verb?' response. Thanks! David 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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [AD] Code Coverage Project
It does sound like an amazing tool, but I believe they are completely different. mvScan looks to be a static code analysis tool. -Original Message- Brian Leach has an amazing tool called mvScan... http://www.brianleach.co.uk/pages/mvscan.htm --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Coverage Project
Hey Charlie, If you get it working in jBASE can you send a copy back so I can create a jBASE branch for it? If you need me to explain what is going on in a section, feel free to ask. Cheers, Dan -- Message: 3 Date: Sat, 28 Nov 2009 07:10:38 -0600 From: Charlie Noah To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] Code Coverage Project Message-ID: 4b11214e.2090...@comcast.net Content-Type: text/plain; charset=ISO-8859-1; format=flowed If I can get it to work in Jbase (assuming I can figure out how it works), I will definitely use it as a programming tool. Anything I can do to keep egg off my face, as well as keeping my boss from asking just how much I had tested, is a good thing, and trying to test every pathway through a program is hard! I think most of us would agree that a programmer is not the best person to test his/her own work. Charlie Noah Sr. Systems Analyst Inland Truck Parts Company ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Coverage Project
Yes, we use it in QA to ensure that we have tested all major sections so that we are more confident in sending it to User Acceptance Testing and then Production. However, we doing use it in production support and programming too. Say you have a large processing program with several complex conditions being required to be met before it will continue. If it isn't met, it doesn't tell you why. You could: 1) Modify the program to include CRT trace statements to determine where it bailed 2) Walkthrough it with debugging on. 3) Run it with code coverage and check the report, which will quickly show you where it bailed. Obviously, you would prefer the program to have been better in the first place, but when working with 3000+ programs, most of them circa 1995 or before, you don't always have that luxury. We have used this method to decent effect in speeding up the time to locate and fix bugs. Obviously, YMMV and it shouldn't be used as a silver bullet, just were most effective. As a final note on the subject, I am unsure of why you would think being a UniBasic programmer should make a difference? Software development is software development. Being on a U2 system doesn't (and shouldn't) mean modern practices do not apply. As to why not just modified jcoverage or the like. Firstly, BDT does not work for us. We can not actually run or debug via BDT due to several architectural problems that cannot be solved on our system. We also could not run any variety that ran directly on the OS for the UD box either due to a lot of red tape of access privileges and security policies. This left us with the requirement that it must be coded and run in native UniBasic, hence this project. Naturally, other people my be in a different boat from us and this project may be useless to them. However, maybe it will benefit somebody else, so here it is. Horses for Courses, as the saying goes. Dan ** It won't be used by programmers but would by QC/QA types to check and see if the code is being used or is just a bunch of fluff. One good example would be if your company is using outsourcing to do your programming and the outsource is getting paid on the amount of code they produce, instead of the correct way of getting paid on the quality of their code. You can check to see if all paths through the code are being used or not. Jerry Banker -Original Message- From: u2-users-bounces at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users [mailto:u2-users-bounces at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users] On Behalf Of Doug Sent: Friday, November 27, 2009 10:47 AM To: 'U2 Users List' Subject: Re: [U2] Code Coverage Project Dan, Although I missed code coverage in programming school, I'm not sure how much UniBasic programmers would or could use code coverage. That being said, why not take an existing program that is fully developed and change the syntax to handle basic syntax. This way you do not have to develop the entire infastracture to run this tool. My suggestion is there are several open source plug-in for Eclipse that can be modified to handle code coverage. There are several examples like jcoverage or gcov that could be used for this type of project. Regards, Dougwww.u2logic.com Native U2 drivers for PHP -Original Message- From: u2-users-bounces at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Coverage Project
Hi Tony, If you are unfamiliar with Code Coverage, this may help: http://en.wikipedia.org/wiki/Code_coverage Does this identify where variables are used? No Variables that aren't used? No, not directly. Although, you may find some as a result of below When they are changed? No Why they mean? No? How data moves from one program to another? No When statements are executed? Yes. This is the purpose of Statement level code coverage. Essentially, it is like the profiling option UniData provides, but at a statement level, not at a called subroutine level. What statements cannot be executed? If you replace 'cannot' with 'have not', then yes. I hope it makes more sense now, Dan I've read your blog notes and anything else I can find but I have no idea what this does. Could you please define the term coverage in this context? Does this identify where variables are used? Variables that aren't used? When they are changed? Why they mean? How data moves from one program to another? When statements are executed? What statements cannot be executed? I have written many parsers and pseudo compilers and code interpreters - but I'm sorry I just don't understand what this one does. :) Thanks. T * From: Dan McGrath** For those that are interested, I have setup a project ** on SourceForge for a Statement Level Code Coverage ** Tool for UniBasic. It is based on the prototype for a ** similar tool we now use at my current employer.** ** Although this version is incomplete, it still enables ** statement level coverage for multiple ** programs/subroutine with html output. The parser (I ** really shouldn't use that term) is still quite ** primitive in this version and may not work with how ** some programs are coded.* * * ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Code Coverage Project
Hi all, For those that are interested, I have setup a project on SourceForge for a Statement Level Code Coverage Tool for UniBasic. It is based on the prototype for a similar tool we now use at my current employer. Although this version is incomplete, it still enables statement level coverage for multiple programs/subroutine with html output. The parser (I really shouldn't use that term) is still quite primitive in this version and may not work with how some programs are coded. http://sourceforge.net/projects/ucov/ For a screen shot of the output and a short post about it, visit: http://u2tech.wordpress.com/ Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Coverage Project
Sorry, I should have mentioned: It is only currently available from the SVN repository there. After I finish work for the day(it is just on 9am here) I will upload a zip of the latest files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, 27 November 2009 8:55 AM To: 'U2 Users List' Subject: Re: [U2] Code Coverage Project Hi - there do not seem to be any files available for download on sourceforge -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: 26 November 2009 21:35 To: U2 Users List Subject: [U2] Code Coverage Project Hi all, For those that are interested, I have setup a project on SourceForge for a Statement Level Code Coverage Tool for UniBasic. It is based on the prototype for a similar tool we now use at my current employer. Although this version is incomplete, it still enables statement level coverage for multiple programs/subroutine with html output. The parser (I really shouldn't use that term) is still quite primitive in this version and may not work with how some programs are coded. http://sourceforge.net/projects/ucov/ For a screen shot of the output and a short post about it, visit: http://u2tech.wordpress.com/ Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users