Re: [U2] Web service
Hi Ruby You need to add the service to the C# project in the add services in the same menu as you add references to your project. Once it is added, it is a datasource that can use. Ie you can link it to a DataGridView as an objectdatasource. You can also link the update, select, insert, delete to methods on the webservice. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 Database provider for .Net
David Jordan Has anyone loaded the U2 provider for .Net into Visual Studio 2012. I cannot get VS to recognise U2 as a database provider and hence cannot use it in the entity model. The provider works at the text level in application code, but I cannot use it with any of the VS tool.s Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Secrets was Vinnie Smith
Will. No one is stopping you from doing it. We explained the problems why it is hard to get this list together. But if you can put it together, happy to support you. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Secrets was Vinnie Smith
Hi Will What you are raising is the issue of internal customised U2 sites which are a dying breed. The new market is applications where people buy the applications, not the database. Vendors see no benefit from advertising that they use U2 where they get no financial benefit and they could disadvantage themselves. Even Oracle based packages are talking less about Oracle. If a site is Microsoft SQL Server, why get yourself knocked off the list. The trend is such that Oracle is buying ERP tools to sell, because people no longer make decisions on Databases. SAP is moving the customer to their purchased Sybase database. The market is all moving towards applications as the decision making process. George and I advertise that we run on U2 product, but many of the ISVs don't see any benefit. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Secrets was Vinnie Smith
Hi Will They won't look for video software on the Rocket site, they are going to look for solutions in trade journals and on the internet. That is where the ISVs are focusing their advertising. With the issue about finding solutions, make contact with a local sales person at Rocket or one of the Distributors. They should be able to point you to references. They can give you a one off verbal, that would not be allowed if it went to print or the internet. If it is published it has to go to legal, if it is a verbal comment made one off, it does not require legal. That is why George raised it is easier to make a phone call. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem with openpath in UniVerse on windows server
Has anyone had a similar problem. Our application uses openpath to read some csv files from a directory on windows server 2008R2. However a couple of sites, only the owner is able to open the directory with openpath, all other users fail. Even with the users given administration rights, it still fails. This is not a problem with all sites, just 2 of them. I run into the same problem with openseq. I tried even setting Authorisation in the program to the owner name and still no luck. I am not sure what else to try. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem with openpath in UniVerse on windows server
They are all running on Rel 11 on Windows 2008R2. The file is not open by another application. It is to do with the directory owner being the only one able to access the file. Even the same user copying a file to that directory, cannot read it from UniVerse. Regards David Jordan Managing Director ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
A good CEO knows the first rule of employing. First look at attitude, then capability and last experience. When you write a resume, don't list experience, list your capability to pick up languages, ability to adapt and ability to understand the business. It is also worth looking at how to get jobs a different way to the usually job markets. Politicians spin bad news to good news, your competitors in the job market spin their lack of ability to win jobs. Step back and look at your resume a different way. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
I didn't say it was easy, I am saying if you want to increase your opportunity change the dynamics. You can curse and disparate the selection until the cows come home and it won't change a thing, you have to change the way you get the job interview. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Chap Up, Chap Down, Chap chap chap the chapper
Chap down a user would make them miss slots in the execution queue freeing it up for other users. It was a Primos option, I have never tried it outside of Primos and don't know if it actually works or was there for compatibility reasons. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Variable Interpolation
I wrote one myself. There is some capability with one of the conv commands but it is limited to 255character. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, 24 August 2012 1:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Variable Interpolation From: jjuser Does UniBasic have a way to do variable interpolation (without writing to a file, compiling it as a program, and calling it)? Do you mean something like this? VAL = 0 CALL @SUB FOO(X,Y);Y=X+1;RETURN( 3, VAL ) CRT VAL ; * 4 That would be Awesome! I don't believe any of the MV platforms do that because I've been looking for it for 15 years. It can be simulated in various ways, but you did limit the scope of the challenge. I think you're trying to avoid this?: CODE = \ CRT DATE()+20\ EXECUTE PGEN :CODE CAPTURING OUT * OUT is 16327 In this case the PGEN program reads from TCL, writes, compiles, runs, and that output gets captured. But at least the mechanism for performing that task is abstracted from this client/application code. Cache' allows you to enter code at TCL and then execute it without saving/compiling. That can also be simulated in U2. I don't think I've ever seen anyone else ask for it here - certainly no one willing to pay for it. ;) Out of curiosity, what's your application for this? And please correct the above if I've misunderstood the question. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Select Statement Invalid
Have you tried putting spaces between the IDs you are selecting. David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2] Professional Development
The issue is that pick jobs are not disappearing, it is an issue that they are changing as in all technologies. There is a move from internal custom applications to packaged solutions. U2 sales are growing but it is in ISV solutions. What is a problem is a mismatch of current skills and new demands for skills. The U2UG is setting up a professional development program to help build skills, career opportunities and opportunities. However we need your feedback to make this work. U2 developers and sales people are professionals whse skills go beyond just pick code. As a user group we want to create an environment to recognise that professionalism that can be put on a CV. We are looking at how to expand training opportunities and keep costs down. This is an opportunity to raise U2 experience and awareness and I look forward to your support in helping the user group to help its members. Regards David Jordan U2UG President ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] training material on LOCKS
Brian You are too generous, I am stunned at how few SQL developers understand locking. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Professional Development Program
As part of the Board's deliberations on ensuring that the user group continues to be relevant to the needs of its members, the user group is implementing a professional development program from the 1st of May 2012. Individuals who maintain professional development in other technologies such as Microsoft and IBM are recognised for their efforts. Their professional development in those technologies adds value to their resume and benefits their career development. The user group wants to create the same advantage for U2 Developers, to have the same recognition and benefits for building U2 skills as their peers do in other disciplines. Please read the full announcement and joint letter from David Jordan and Susie Siegesmund on the U2UG Website. http://www.u2ug.net/download/LetterFromU2UGPresident.pdf Regards David Jordan President of the U2UG ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Issue with SQL Users and Active Directory
Is anyone using SQL SCHEMAS and TABLES in UniVerse in a Windows Environment with Active Directory. I have an intermittent issue where SQL Users are suddenly not recognised and I have to grant them access again. It is an intermittent problem and cannot identify what is causing it. Like to hear if anyone else has had similar experiences. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New U2 BDT
Will I was pointing out eclipse gives the ability to run a tool on windows and linux. The alternative is that Rocket built a tool that only runs on windows. Whilst I am not particularly fond of eclipse I understand the reasoning for it. Similar reason why Doug uses it as a base for his tools. Eclipse comes from IBM and has a number of third party development tools that can interface with that environment. For U2 Developers, they have access to a free tool, the same for web developer, restful services, etc. Other environments may have attracted a charge for the base tools the environment is built. Whilst it is easy to knock a solution, the key is to provide a better alternative and at this stage I have not seen a better alternative for Rocket to base its tools on. David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Sunday, 11 March 2012 9:49 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New U2 BDT What specific advantage does Eclipse give to U2 developers ? It's a standard doesn't really impress me, unless there is something I can use myself, today. I'm not asking what BDT gives me, what does Eclipse give me. And the ability to use BDT is not a valid argument. -Original Message- From: David Jordan da...@dacono.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Sat, Mar 10, 2012 10:01 pm Subject: Re: [U2] New U2 BDT Bill Eclipse is a pain, but at the moment it provides a base that works for windows and linux offerings. It is a standard base for Rocket tools including datavu, webservices, restful servives, EDA, etc. I support David's comments that rather than putting down products, we need to work with Rocket in how to improve the products. There are many opportunities for test tools and other development tools to be integrated with BDT that could help developers productivity. However Rocket will not invest in this product if we constantly put it down. It is also something as developers should look at how they manage source code. Maybe the source code that is to be edited should be taken out of a library and stored in a development spot which would have a local directory. Whilst there is still work to go on BDT, it is an evolving product and something that makes U2 look more professional something that the community has had to battle with in the eyes of management and consultants Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Sunday, 11 March 2012 5:32 AM To: U2 Users List Subject: Re: [U2] New U2 BDT Thanks, Doug. Not much of a tool, especially when you have to download and install all the junk that goes with it! :-( Bill - Original Message - *From:* dave...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/10/2012 9:55 AM *Subject:* Re: [U2] New U2 BDT Hi Bill: After testing BDT, I'm wrong. BDT does recognize environment variables. However, you cannot open or edit any files that are not DIR files. So you are trying to edit an LD file and it does not let you. I figured this out when our editor allowed editing of those files. So there really is not a bug but a BDT feature. Regards, Doug www.u2logic.com XLr8Editor the other Eclipse editor ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New U2 BDT
Hi Will Eclipse is the same interface for the U2 Web Services, the U2 Restful Services, the U2 xml tools, the U2 EDA tools, U2 Web Developer. It is a common interface for the range of U2 products, not just BDT. It is an IDE used by other technology companies to host their tools. It also has interfaces for other products. Even Microsoft has an interface for Eclipse tools to integrate with Azure cloud services. Eclipse also runs on Apple's Macintosh. With a growing base in that market, Rocket can provide tools for developers who prefer to work in that environment. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] New U2 BDT
Bill Eclipse is a pain, but at the moment it provides a base that works for windows and linux offerings. It is a standard base for Rocket tools including datavu, webservices, restful servives, EDA, etc. I support David's comments that rather than putting down products, we need to work with Rocket in how to improve the products. There are many opportunities for test tools and other development tools to be integrated with BDT that could help developers productivity. However Rocket will not invest in this product if we constantly put it down. It is also something as developers should look at how they manage source code. Maybe the source code that is to be edited should be taken out of a library and stored in a development spot which would have a local directory. Whilst there is still work to go on BDT, it is an evolving product and something that makes U2 look more professional something that the community has had to battle with in the eyes of management and consultants Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Sunday, 11 March 2012 5:32 AM To: U2 Users List Subject: Re: [U2] New U2 BDT Thanks, Doug. Not much of a tool, especially when you have to download and install all the junk that goes with it! :-( Bill - Original Message - *From:* dave...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/10/2012 9:55 AM *Subject:* Re: [U2] New U2 BDT Hi Bill: After testing BDT, I'm wrong. BDT does recognize environment variables. However, you cannot open or edit any files that are not DIR files. So you are trying to edit an LD file and it does not let you. I figured this out when our editor allowed editing of those files. So there really is not a bug but a BDT feature. Regards, Doug www.u2logic.com XLr8Editor the other Eclipse editor ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Hello
I set up a function to open files. Instead of using the open file command in a program, I call the function. The function first calls the fileinfo command to see if the file is open and then returns otherwise it opens the file and returns. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Editors and environments we like to use--digression from talking about mvToolBox.
How would you do this in a GUI Editor I can use the TCL Editor in universe to change a variable name in a 1,000 programs in a program file by the following process. ED ED PROG.CHANGE 2: C/OLD.ATTRIBUTE.NAME/NEW.ATTRIBUTE.NAME/G1000 3: FI 4: LOOP 2 1000 ED BP * .X PROG.CHANGE There are pros and cons of both environments David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Editors and environments we like to use
Whilst these editors can do it to a file in the directory, they are bypassing the record locking within UniVerse. I am playing devil's advocate, that whilst there are some things easier to do in a Gui, there are some things easier to do in a green screen editor. I jump back and forward between GUI editors and green screen editors all the time to take advantage of their different functionality. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Tuesday, 21 February 2012 10:02 AM To: U2 Users List Subject: Re: [U2] Editors and environments we like to use I just read this article on tools and the concept of a backplane as an IDE. Read the article and the linked articles inside it to see that this discussion about X v Y is really pointless. :) http://www.johndcook.com/blog/2012/02/17/whats-your-backplane/ David, I think most common IDEs/editors I can think of will do this type of universal search and replace across selected sets of files or entire directory trees. Most of them allow regex too which ED does not. Cheers, Stuart ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] mvToolbox
Whilst I understand where you are coming from Doug. I think we get too caught up that telnet is negative. Microsoft had to bend to demand for a command line system for Windows because the tech guys said it was too slow to do things in Windows forms. When I talk to Oracle databases, SQL Server database, I am still working with command prompt windows with some flash around them. Remember that easily 40% of code is still written in Cobol. There are mainframes in multinationals across the world still using green screen systems and paying a lot of money for them. Systems administrators across the world are driving unix, linux and windows systems through command prompt windows. The concern about telnet is more in the heads of U2 developers than in the customer base. It is like the aversion to the word PICK, people are nervous about a negative reaction from mainstream IT. But we have a new generation of IT people who have never heard of PICK, never mind having a closed mind to it. Rather than getting caught up debating whether people are against telnet, we should promote its positives. I have seen a company just buy a brand new cobol GL system. If they would buy a Cobol system, why wouldn't they buy a PICK GL. We are our own worst critics. If anyone has worked in a mainframe site and saw some of the systems they are working with, they would be shocked. I think we have an incredible opportunity to grow U2 business in the current economic environment, if it was not for us tripping ourselves up by underselling U2 technology. My 2c David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Import XML data [not-secure]
Hi Tony I partly agree with you. But I should be able to process xml data in UniVerse far simpler than at the moment. I should not have to read xml in one application, convert it to a dynamic string and then send it to universe/unidata, I should just be able to do it one step. This is a failing of Rocket to provide suitable interfaces to unibasic. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Saturday, 28 January 2012 4:40 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Import XML data [not-secure] From: John Thompson This is where I think languages like php get it right. Their simple XML stuff makes it simple to parse even the junk you may get from somewhere else. I've commented here and blogged on this topic a number of times. I shake my head at the pain people continually subject themselves to when trying to force the square peg of XML into the round hole of Pick BASIC just because that's the comfort zone. There are any number of other tools out there specifically designed to work with XML. If you go to many other forums, developers aren't focused on the XML processing. They deftly convert to/from XML (and JSON) without a problem, and their questions are largely focused on what to do with the data. MV professionals need to shift focus from doing everything within the MVDBMS to making the best use of all tools available and integrating the MVDBMS with whatever utility does the job that's required. At the core of it, even when using external tools we convert XML to something and that something ultimately needs to be saved in an MV structure. (Similarly for outbound XML.) But if you're focused on namespaces and attributes then the tools you're using aren't providing adequate abstraction from the XML, and you might want to consider tools that convert XML to something else which is easier for you to use. The reality is, that there are a lot of sites and places out there that will send you all kinds of xml, and I found that since I was not proficient at massaging those non-standard feeds into what the U2 xml tools wanted, I just found it easier to do it another way. Whoe - stop right there. I tend to angle away from DBMS-oriented tools for processing XML, but in all fairness we can't expect any tool to behave properly if the data doesn't conform to standards. No, I haven't seen a lot of sites sending all kinds of XML that is non-standard. If you have a trading partner that doesn't produce or consume industry-standard documents, you need to talk with their IT people, and escallate to management on both sides if you're not getting cooperation. Respectfully, I'm guessing you're just not familiar with some of the details of XML, and when the U2 tools don't seem to address one of those details I'm guessing you're considering the document to be non-standard rather than the U2 tools. Again, in all fairness to the U2 team, I'm guessing this is a documentation issue or some lack of understanding along the way rather than any entity being non-standard. If indeed the U2 tools aren't providing standard functionality, well, see paragraph 1 above. :) Good luck. 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 http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno NEW! http://groups.google.com/group/mvdbms/about ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Redback Connection Problem
Hi John Check beyond Redback. Have you checked things like access to the temp directory. I assume the pilot and test machines are different to the live site and it could be an issue of security being tied down further than on the test machines. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, 24 January 2012 7:04 AM To: 'U2 Users List' Subject: Re: [U2] Redback Connection Problem Correct. That was part of my checking. File pointers, catalog pointers, etc... SPIDER command is working everywhere. Very frustrating. It is almost like there is something set up SOMEWHERE that says rbadmin can access everything except LIVE.DATA. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, January 23, 2012 2:54 PM To: U2 Users List Subject: Re: [U2] Redback Connection Problem And no pointers missing in live back to eportal SFxxx files? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, January 23, 2012 11:49 AM To: 'U2 Users List' Subject: Re: [U2] Redback Connection Problem Correct -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, January 23, 2012 2:48 PM To: U2 Users List Subject: Re: [U2] Redback Connection Problem I'm just throwing out some ideas, in hopes it would spark something for you or anyone following... Check the global.asa in your live site one more time 1) You are setting Application(ERPAccount) = LIVE.DATA 2) Your rgwresp has the same account, as #1 3) Before you do the oOrder.Open2 accnt,SF:oOrder,userid,passwd , you do accnt=Application(ERPAccount). Correct? Also, In your simple test page with connection test only, can you switch it to try and open something in the ECP module, like ECP:oOrders? Just wondering if you've only been using the ecp side of things so far, if it's possible you might be missing some pointers in live, like to SFINCLUDE or OORDER, or something like that -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, January 23, 2012 11:18 AM To: 'U2 Users List' Subject: Re: [U2] Redback Connection Problem Yes and No. ePortal has been up and running for years. StoreFront (the on-line ordering) has NEVER been live. I have a due date of next week and tried to get it up and running over the past weekend in case I had issues (which I clearly did). I do not know why Epicor coded it the way they did. It works perfectly in TEST It works perfectly in PILOT I have run compare utilities against everything and cannot find any differences that are not intentional (like the name of the desired account, the web site, etc.) The horribly annoying and confusing thing is it works in TEST and PILOT! All of ePortal works cleanly until it tries to connect to LIVE.DATA. Thanks John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cook, Amy Sent: Monday, January 23, 2012 1:57 PM To: U2 Users List Subject: Re: [U2] Redback Connection Problem I'm guessing you're up and running on your production eportal site, and this is just a new method you're implementing, so the questions below are probably moot - but just in case If it's something specific to the Avante account, have you verified: 1) login paragraph in live is the same as in pilot? 2) the workdir in your rgwresp.ini is correct path to your Avante account? 3) the port to your live.data account isn't blocked Other than that, I haven't ever gotten anything useful out of this, but can you set trace and/or verbose levels in rgwresp.ini and see if you get any better information in the redback logs? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, January 23, 2012 10:16 AM To: 'U2 Users List' Subject: Re: [U2] Redback Connection Problem It is not returning an error to the web page at all (just the generic 500 error message). If I look at the server logs, it is giving a meaningless error stating it basically had a problem on the server and did not finish correctly. I tracked it down to the open2 method that tried to connect to the Avanté account. Everything looks good, so I am at a loss. I build a simple web page that does nothing but attempt to make this connection, and if successful, give the pertinent parameters involved. This works flawlessly in TEST and PILOT, but fails in LIVE. I have a call into Epicor, and have been waiting for a call back
Re: [U2] Redback Connection Problem
Hi John My guess is that there are security restrictions on the Live system that are not on the test system Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Sunday, 22 January 2012 2:53 PM To: 'U2 Users List' Subject: [U2] Redback Connection Problem I have 3 UniData accounts (LIVE.DATA, PILOT.DATA TEST.DATA). Each has its own web site (live, pilot test). We are using Redback (U2 Web DE). We are using Epicor's Avanté backend and a HEAVILY customized version of their ePortal web software. Over the past few months, I have developed code in TEST and moved it to PILOT for user testing. Everything works 100% in TEST and PILOT. Today, I loaded everything from PILOT to LIVE (UniData code, web stuff, Redback objects, etc.) There are 2 ways that the web pages connect to UniData: myCart.Open2 account,SF:oPreOrder - where myCart is the object account is the ePortal account (sister account to the Avanté account) and oOrder.Open2 accnt,SF:oOrder,userid,passwd- where oOrder is the object, accnt is the Avanté account userid is the Redback login passwd is the Redback passwd I have never been told the reason for a difference, but it works cleanly in TEST and PILOT , but the 2nd type of connection is failing in LIVE. I have confirmed that the userid and password are correct (the same in TEST and PILOT since Redback is global) and accnt is the intended Avanté account. If I do not get success over the weekend, I will be contacting Epicor for help, but I would REALLY like to get this working before Monday. Any thoughts? John John Israel Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44380 Fax: 937-865-9182 johnisr...@daytonsuperior.com This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Uniobjects and Record Locking
It is possible that design base is running a separate locking mechanism that it is caching. The Uniobjects connection involves pooling where multiple user accesses use one UniVerse Login. This is different to a telnet connection with one user per login. If DesignBase cannot identify the process that updates as being the same as the one that locks the record then you could have a problem. You cannot identify who locked the record in a pooling environment as 10 people would have the same user ID, hence it has to be managed by designbase rather than universe. What you are doing is pessimistic locking. With a web based environment and pooling, you should be thinking optimistic locking where you only do locking at the time of update and compare before and after images. If a user locks a record over an internet connection and then loses a connection, then that record can remain locked until an administrator releases it manually, this is why pessimistic locking is avoided in this environment. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Sunday, 8 January 2012 10:16 AM To: U2 Mail List Cc: DesignBais Support Subject: [U2] Uniobjects and Record Locking I'm using DesignBais and have run into an unusual problem. When I display some data on a web form the dbms is contacted through UO and the returned data is displayed. When I click on the [Save] button the same UO connection is used to contact the dbms and run whatever program is required to update the record. In the called update program, the record is read and locked. If it's already locked the program terminates and a message is returned informing the user the record is locked (try again). If it's not locked the record is updated and, of course, the program terminates in the same manner. Problem: if I edit the record via UniData's AE editor (LIST.READU shows a record lock) and try to update the record via the DesignBais form, the LOCKED clause is taken. This is good. However, after I release the record via the AE editor (LIST.READU now shows nothing locked), then click on the [Save] button, the LOCKED clause is still taken, even though no record is locked! If I kill the UO connection, DesignBais will make another UO connection and all works fine. So, it appears a UO connection won't release a lock under whatever circumstances I've happened to stumble upon. Any ideas what causes this and how to work-around the problem? Thanks, Bill Haskett Advantos Systems, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Uniobjects and Record Locking
Hi Bill Where is the update program. If it is a UniData subroutine, then UniObjects is not in the process. As far as I know UniObjects has no locking process of its own, it uses Unidatas lock table. I have not experienced this problem, this issue like this sounds like a program bug. I would step through the logic carefully, as you may be locking the record twice in 2 different processes as part of the update. Is DB doing an update through its application at the same time you are doing an update. Check the subroutines call logic. Check the security access, does the user have write access. I suspect a process is aborting somewhere that leaves a record locked which is only cleared when the UniObject session is cleared. Have you done a list.readu all after a record locked message has occurred, as you might identify the lock has occurred then. PS did you do LIST.READU or LIST.READU ALL Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, 9 January 2012 6:34 AM To: U2 Users List Subject: Re: [U2] Uniobjects and Record Locking David: Thanks for the input. This has nothing to do with DB, as the message that displays is generated by the update program due to the LOCKED clause being taken, even though there is no record locked. We do a quasi-optimistic locking and only lock records during those few milliseconds where updating occurs. A record is NEVER locked until an update occurs, and since locks release when a program terminates (even a subroutine returns) we shouldn't be having such problems ( i.e. a record is never locked then left alone). This is why I'm thinking it has something to do with Uniobjects. Thanks again, Bill - Original Message - *From:* da...@dacono.com.au *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 1/8/2012 1:33 AM *Subject:* Re: [U2] Uniobjects and Record Locking It is possible that design base is running a separate locking mechanism that it is caching. The Uniobjects connection involves pooling where multiple user accesses use one UniVerse Login. This is different to a telnet connection with one user per login. If DesignBase cannot identify the process that updates as being the same as the one that locks the record then you could have a problem. You cannot identify who locked the record in a pooling environment as 10 people would have the same user ID, hence it has to be managed by designbase rather than universe. What you are doing is pessimistic locking. With a web based environment and pooling, you should be thinking optimistic locking where you only do locking at the time of update and compare before and after images. If a user locks a record over an internet connection and then loses a connection, then that record can remain locked until an administrator releases it manually, this is why pessimistic locking is avoided in this environment. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Sunday, 8 January 2012 10:16 AM To: U2 Mail List Cc: DesignBais Support Subject: [U2] Uniobjects and Record Locking I'm using DesignBais and have run into an unusual problem. When I display some data on a web form the dbms is contacted through UO and the returned data is displayed. When I click on the [Save] button the same UO connection is used to contact the dbms and run whatever program is required to update the record. In the called update program, the record is read and locked. If it's already locked the program terminates and a message is returned informing the user the record is locked (try again). If it's not locked the record is updated and, of course, the program terminates in the same manner. Problem: if I edit the record via UniData's AE editor (LIST.READU shows a record lock) and try to update the record via the DesignBais form, the LOCKED clause is taken. This is good. However, after I release the record via the AE editor (LIST.READU now shows nothing locked), then click on the [Save] button, the LOCKED clause is still taken, even though no record is locked! If I kill the UO connection, DesignBais will make another UO connection and all works fine. So, it appears a UO connection won't release a lock under whatever circumstances I've happened to stumble upon. Any ideas what causes this and how to work-around the problem? Thanks, Bill Haskett Advantos Systems, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] Uniobjects and Record Locking
Hi Bill You cannot assume the exit of a subroutine clears locks. The way DB works, I suspect that DB has a worker program that calls routines. If that worker program does not stop then locks may not be cleared. When you restart UO you are only then clearing a persistent lock. Also check that the locked message is from the routine you think it is. I don't know your code, I am just passing issues I have seen in the past. Do you have triggers doing an update. It sounds like a lock from a previous step has not cleared. Put a RELEASE statement in the routine before it exits and see if that helps. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] NEWVERSION
This is not my experience. Check that it is not put in shared memory. Also double check the voc item is pointing to the right source code. Also check that the uniobject application is logging into the same account that you catalogued the program, I have seen programmers leave behind a redirection hard coded in the application or a divert to another account is occurring somewhere. I have even had dumb moments of actually logging into the wrong account at the end of the long day where we had multiple test environments and wondering why nothing had changed. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] MS-SQL Question
You should be able to just use PID in the where clause.
David Jordan
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 29 December 2011 2:51 AM
To: U2 Users
Subject: [U2] MS-SQL Question
I'm querying a sequel server , I have a column in one table that the data is in
the form of X|Y|Z.
I have the following in my SELECT:
substring(colname ,charindex('|',colname)+1, charindex('|',colname,
charindex('|',colname)+1) - charindex('|',colname) -1) as PID
Is there anyway that I can then use the PID designation in a where clause,
without having to retype the string again?
I can't add a virtual column to the table , and I can't add a procedure either.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://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] MS-SQL Question
You created PID as a synonym in the SELECT statement, you should be able to use
it in the where clause. I am sure I have done that before in the past with SQL
Server.
Regards
David Jordan
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 29 December 2011 7:09 AM
To: U2 Users List
Subject: Re: [U2] MS-SQL Question
That didn't work because it is not a virtual column defined in the table
layout. What I did was Created a variable in my program that contained the full
string, and when I was creating the SQL String to pass to the server, I used
the variable name instead.
It worked in the sense, I didn't have to retype the string multiple times, but
the SQL query that Was passed to the MSSQL machine did have it multiple times
still, but at least it's more manageable
From a programming standpoint, where I only have to make changes to one spot.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan
Sent: Wednesday, December 28, 2011 3:04 PM
To: U2 Users List
Subject: Re: [U2] MS-SQL Question
You should be able to just use PID in the where clause.
David Jordan
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 29 December 2011 2:51 AM
To: U2 Users
Subject: [U2] MS-SQL Question
I'm querying a sequel server , I have a column in one table that the data is in
the form of X|Y|Z.
I have the following in my SELECT:
substring(colname ,charindex('|',colname)+1, charindex('|',colname,
charindex('|',colname)+1) - charindex('|',colname) -1) as PID
Is there anyway that I can then use the PID designation in a where clause,
without having to retype the string again?
I can't add a virtual column to the table , and I can't add a procedure either.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is there any ORM's for Universe. NHibernate, Entity Framework etc
What I would like to see is that U2 builds stronger interface between UniBasic Subroutines and DataSets/entity frameworks. The current methodology is to create a 3 tier environment with a database server, an application server and a client server where U2 is just a simple data server. If you use U2 as the data server and the application server, you have greater ability to take advantage of the performance benefits of multivalue databases and you simplify the transaction process and disaster recovery. ORMs work with stored procedures, so why not subroutines. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Graph DataBase
There is a dozen ways to achieve the same types of scalability. Moving to a cloud environment, I am dealing with vm machines where the vm machine can be increased and reduced In memory and disk by software, not hardware. It changes the thinking again. There are techniques to spread U2 databases across multiple machines. The issue is also a question of what is the bottleneck, read/write or the transformation process. With U2 you could run multiple servers with multiple web servers handling the transaction process, that then sends data to another server for read/write. But the other issues are the handling of transaction controls, rollback recover, backup. I believe that the next few years with cloud computing, people are going to have to change the way they think about systems design. No one has a magic answer even the new NOSQL databases. I think software design and techniques are more critical than having a database to automate the process through techniques like sharding. The issue with licensing, Rocket is already working on providing alternative methods of licensing. If there is a different way you want to do licensing, talk to them, they may be able to find a solution to accommodate or they may look at new licensing techniques. The question to ask, would you be happy to have your banking transactions run on some of these NOSQL Databases, would they pass scrutiny of regulators and auditors for disaster recovery, security, etc. These are the areas that are concerning mean, not the technology. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, 19 December 2011 12:11 AM To: 'U2 Users List' Subject: Re: [U2] Graph DataBase Scaling means more than just 'can it cope with so many million hits per minute', it is about the ability to easily scale upwards and downwards according to demand. Sure I can get a big box with 32 processors 128 gig of ram etc and it will perform impressively, but what if the business plan is to double demand for the next three months - will that cost me half a million for another massive box? Typical 'scalable' databases can be clustered or sharded across multiple low spec machines, so scaling up requires the addition of 5 or 10 new commodity servers into the cluster. Both the technology built into the database, and their licencing schemes make this a very easy operation. Running multiple u2 servers in read write formation is very difficult and expensive -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: 17 December 2011 05:40 To: U2 Users List Subject: Re: [U2] Graph DataBase I have to pick you up on scaling. U2 scales really well there are some staggering performance test that have been done. U2 does things differently, but it does scale. An area that NOSQL databases are not demonstrating in what I have looked at, is the transactional processing and security that a commercial database requires. It is not to say that Rocket does not have some work to do in some areas, but I don't get that something new is the be all and end all and that something that is mature is outdated. I like to try and get the best out of both. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com) Sent: Saturday, 17 December 2011 1:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Graph DataBase I also, to some extent, agree with Dawn. The mv, NF**2, post relational, PICK, or whatever the correct model name is, it is not a relational database. There are very strict definitions to a relational database, namely, but not complete, normalisation, SQL, joins etc. Yes, the mv model can emulate a relational database. But, it you throw away the dict part of a file, the data is actually in a form of a document. And, if you go way back to the definition of a database model created for analysis - Entity-Relationship by Chen in the early 1980's, the mv model is very close to the ER model. So, if you add back the dictionaries, the database model could be a DDERDBMS - Dictionary Driven Entity-Relationship Data Base Management System. Anyway, whatever mongoDB classify themselves as, so should the PICK model. But then, U2 is not that well known, as it is not marketed to end users per se. It is an embedded database for VAR's. The focus is on the application, not the underlying database. This could be seen as a problem in some markets. So, it could be seen to be lost energy promoting the database to end users or developers within the nosql market as U2 is not open source, hence costs money, does not scale that well (sharding and/or federation) and is not really for high volume loads within a web service delivery
Re: [U2] Graph DataBase
I have to pick you up on scaling. U2 scales really well there are some staggering performance test that have been done. U2 does things differently, but it does scale. An area that NOSQL databases are not demonstrating in what I have looked at, is the transactional processing and security that a commercial database requires. It is not to say that Rocket does not have some work to do in some areas, but I don't get that something new is the be all and end all and that something that is mature is outdated. I like to try and get the best out of both. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com) Sent: Saturday, 17 December 2011 1:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Graph DataBase I also, to some extent, agree with Dawn. The mv, NF**2, post relational, PICK, or whatever the correct model name is, it is not a relational database. There are very strict definitions to a relational database, namely, but not complete, normalisation, SQL, joins etc. Yes, the mv model can emulate a relational database. But, it you throw away the dict part of a file, the data is actually in a form of a document. And, if you go way back to the definition of a database model created for analysis - Entity-Relationship by Chen in the early 1980's, the mv model is very close to the ER model. So, if you add back the dictionaries, the database model could be a DDERDBMS - Dictionary Driven Entity-Relationship Data Base Management System. Anyway, whatever mongoDB classify themselves as, so should the PICK model. But then, U2 is not that well known, as it is not marketed to end users per se. It is an embedded database for VAR's. The focus is on the application, not the underlying database. This could be seen as a problem in some markets. So, it could be seen to be lost energy promoting the database to end users or developers within the nosql market as U2 is not open source, hence costs money, does not scale that well (sharding and/or federation) and is not really for high volume loads within a web service delivery environment. It's a good solid product for well established actively-promoted vertical market applications which need to extend to the surrounding I.T. ecosystem. Dawn Wolthuis wrote: I do disagree with this. If neo4j meets the not-determined criteria (except by marketing departments) then MV products do too. MV vendors might have suggested they are relational at varying points in their history (again marketing depts) but they do not meet Relational or at least SQL-only DBMS criteria. We are very much in the not-SQL-only camp whether we proclaim it or not. No product in that mix does everything. I put Tom del's nodal logo on a blog entry in 2006. It is someone in the MV space that has the nodal domains. We are NoSQL, no doubt, but we can decide to stay in our MV sandbox rather than joining the game if we so choose. --dawn - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Graph-DataBase-tp32982649p32989774.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe and SQL
You can use BCI and it works effectively. You can write basic programs to select and update data on other databases. EDA is another option where you could treat an RDBMS as if it were a UniVerse file. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Saturday, 10 December 2011 8:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe and SQL I see a lot of stuff on Universe accessing it's own files as SQL tables, and also on how you can use OLE to access Universe tables using SQL. But can Universe, access SQL tables which are *not* in Universe? They are just other SQL tables in other places around the network that usually is update by other non Pick software. Can Universe also access those tables? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse/NT default login account
Hi Kathleen Try any directory. You will run into a problem with UAC in Windows and will have to set it to the lowest security level and then reboot. Then try changing the directory and see if that works. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter Sent: Saturday, 10 December 2011 6:14 AM To: 'U2 Users List' Subject: Re: [U2] UniVerse/NT default login account In UniAdmin I have the option set to ANY UV ACCOUNT, tried it as UV HOME and it still did not work. On the window user account the profile has all the path blank. Is there any way to know where it is getting this path from. The only Admin user can log on because you have to enter a path. Everyone else is going to who knows where. I cannot make every user an Admin user. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, December 07, 2011 4:01 PM To: U2 Users List Subject: Re: [U2] UniVerse/NT default login account Hi Kathleen The uniadmin telnet area is where you resolve this. It is currently pointing at their login directory on windows. You have options to change to login into particular uv.account, or directory. There can be a problem here with Windows UAC that inhibits this from working properly. Are you getting a permissions error when you access the telnet menu in uniadmin. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter Sent: Thursday, 8 December 2011 9:57 AM To: 'U2 Users List' Subject: Re: [U2] UniVerse/NT default login account We use wIntegrate to telnet to the server. The UniVerse logon prompt appears, the user logins in and enter their password. Then the message This directory is not set up for UniVerse... Y/N. No matter what the user answers it logs them off. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, December 07, 2011 12:53 PM To: U2 Users List Subject: Re: [U2] UniVerse/NT default login account Kathleene: When you say ...does not work, what does that mean? With networking all kinds of things are happening and isolating the problem is imperative. For instance, in order for anyone to log into our UD server, running on Windows 2008 R2, they need to have a Windows user and be a member of the appropriate group(s) (those given to the dbms directory). Active Directory adds a level of abstraction, but you should be able to create a simple domain user who has access to the machine. Anyway, once the user is created and they're a member of the same group that the dbms directory gives full privileges to, then you should be able to log in to the UV account (I can in UD). When I make a telnet connection I should be able to see the UV login prompts. This is also where problems might arise; if you can't see the UV login prompts your problems are prior to the user/group and UV login issue. So, I guess my question is; can you be more specific regarding your problems? e.g. what appears, what you've tried, what were the results, etc? HTH, Bill - Original Message - *From:* kmhun...@resolutionprovider.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 12/7/2011 12:35 PM *Subject:* Re: [U2] UniVerse/NT default login account Tried this and it does not work -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, December 07, 2011 12:22 PM To: U2 Users List Subject: Re: [U2] UniVerse/NT default login account Open up UniAdmin and log into the server. Go to Network Services, then Telnet Server. Select the Users tab then edit the DEFAULT user. Set the Startup Directory to what you want then save by clicking [Ok] (a couple of times). If users aren't logged in, try looking at their permissions. We restrict permissions to our U2 dbms directories, so not everyone can log in. HTH, Bill -- -- - Original Message - *From:* kmhun...@resolutionprovider.com *To:* 'U2 Users List'u2-users@listserver.u2ug.org *Date:* 12/7/2011 12:12 PM *Subject:* Re: [U2] UniVerse/NT default login account On the new box when I created the account I pick ones as my default account. If there is someplace else let me know. But my users are still not being placed there. When a user logins into the new server, it states that This directory is not set up for UniVerse. SO I do not fine know where they are being placed. All administrators are prompted for the account
Re: [U2] UniVerse/NT default login account
Hi Kathleen There are options in uniadmin under the telnet menu that have default login options. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter Sent: Thursday, 8 December 2011 6:57 AM To: 'U2 Users List' Subject: Re: [U2] UniVerse/NT default login account I believe that it is a register entry on the server that but I am on virtual windows 2008 server with UniVerse 10.3.10. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter Sent: Wednesday, December 07, 2011 11:54 AM To: 'U2 Users List' Subject: Re: [U2] UniVerse/NT default login account Not sure. Is there a way in the UV.LOGINS not to list ever user that will be login but a default one so that if the user is not listed that it does to that one. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, December 07, 2011 9:48 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse/NT default login account Do you mean the UV.LOGINS file in the UV account ? That lists, for each login, what path (universe account) they will go into when they log in -Original Message- From: Kathleené M Hunter kmhun...@resolutionprovider.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Dec 7, 2011 9:43 am Subject: [U2] UniVerse/NT default login account Can anyone tell me where identify the default login account for all users hat log into UniVerse. am setting up a new server and the old server it working fine. All the ser login in with wIntegrate, there is no users in the telnet services isted, plus the user on the domain has no default path listed. Thank you, athleené __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Cloud Legal Question - and a request for Contact Info - IT Legal Issues
Something people do not understand with many cloud applications. When they say multitenant, that means that I have 1 table per function for all clients. So my customer file would have a key client.no*customer.no, my parts file would be client.no*part.no and so on. How client 1 sees only client 1 data is dependent on the software selecting client 1 from each table. You cannot secure a database on the basis of an index, so client 1 and client 2 have the same access to the database and depend on security written in the program. You can then understand why the contract has such a term on it. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Thursday, 1 December 2011 8:25 AM To: U2 Users List Subject: [U2] Cloud Legal Question - and a request for Contact Info - IT Legal Issues The company I work for is looking at a product that stores a bunch of our sales data in the cloud Our internal legal person had a look at the contract that the company is proposing and apparently it has a little clause in their that they are not liable if the data gets stolen. Is this standard with cloud products? Also, I remember some folks at Spectrum talking about this, and I still have the business cards, but, I am not in the office, AND I foolishly forgot to store them in my contacts. Susan J., I think you probably talked about this? Maybe I can have my legal person fill out a contact form on your site? (sj+ dot com) -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] AD Re: Converting an account from UniVerse to UniData AD
Hi Dave I am almost finished, but I am glad there is something out there for the next time I do a conversion. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor Sent: Saturday, 26 November 2011 6:57 AM To: U2 Users List Subject: [U2] AD Re: Converting an account from UniVerse to UniData AD Hi David, AD Sorry I missed your inquiry last week. We developed a product called File Caddy that consists of two programs, TAPE.DUMP and TAPE.LOAD. TAPE.DUMP performs a series of T-DUMPs from a source database and TAPE.LOAD performs a series of T-LOADs onto the target database from the t-dumps on tape. You can specify either one or more specific files to dump or all the files in an account, including the VOC. Both the DICT and DATA sections of each selected file are dumped and then loaded. The necessary characteristics of each section of each file are stored in the label of the T-DUMP so that the file can be automatically recreated on the target database if it does not exist at the time of the T-LOAD. These programs use any tape media that are the same type of media (eg. QIC, virtual tape, etc) on both databases and that support the T-DUMP and T-LOAD commands on both databases. I 'll be glad to send you more detailed information if you think this might help. AD/ Best regards, Dave Dave Taylor Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: David Jordan da...@dacono.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, November 15, 2011 1:05 PM Subject: [U2] Converting an account from UniVerse to UniData Does anyone have experience converting a UniVerse account to UniData. I have used the UV_RESTORE. It creates the files but does not copy the data. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse to UniData Conversion
I am converting some UniVerse code to UniData. The UniVerse code has a COMPARE function for comparing strings rather than just an = to handle some quirks about string comparisons of numbers. Is there an equivalent in UniData. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Collaboration
The U2UG board has been discussing with Rocket how to encourage excitement that U2 is not legacy but is a technology leader. I was at a presentation of a U2 VAR and they demonstrated product that would be indistinguishable from any other player in open systems, Service architecture, interoperability, web intefaces, etc. How do we get this across to the market. With collaboration, we need to first excite. How do we excite people in U2 technology. Is it looking at a major enhancement of the BASIC programming language or a new one within U2. What other things do we look at. Currently young programmers are excited by web technology's, mobile apps, the sexy stuff. They are not interested in the backend, whether Oracle RDBMS, SQL Server or U2. This is a problem across the industry. The board of the user group are interested in areas to look at and how to create infrastructure to make this happen. If we can reignite excitement in the product and create a place for collaboration where that excitement can be put to good use then I believe we can achieve success. However our success depends on a group of people not a few individuals. If this is to occur, it is time for people to become involved in shaping a future. Regards David Jordan VP U2UG ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Cloud Collaboration
I have had discussions with Rocket on running UniVerse on Azure and I have been experimenting with running UniVerse on Azure. I believe Rocket was setting up a project to look at it, but have not heard anything more. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, 18 November 2011 9:26 AM To: U2 Users List Subject: Re: [U2] Cloud Collaboration I do not have a clear picture on where the Rocket is going regarding Cloud Computing. Is the Rocket so far out in space that... there are no clouds? Is the Rocket on the launch pad... waiting for an Azure-blue sky? --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Thursday, November 17, 2011 3:55 PM To: U2 Users List Subject: Re: [U2] Code Collaboration The U2UG board has been discussing with Rocket how to encourage excitement that U2 is not legacy but is a technology leader. I was at a presentation of a U2 VAR and they demonstrated product that would be indistinguishable from any other player in open systems, Service architecture, interoperability, web intefaces, etc. How do we get this across to the market. With collaboration, we need to first excite. How do we excite people in U2 technology. Is it looking at a major enhancement of the BASIC programming language or a new one within U2. What other things do we look at. Currently young programmers are excited by web technology's, mobile apps, the sexy stuff. They are not interested in the backend, whether Oracle RDBMS, SQL Server or U2. This is a problem across the industry. The board of the user group are interested in areas to look at and how to create infrastructure to make this happen. If we can reignite excitement in the product and create a place for collaboration where that excitement can be put to good use then I believe we can achieve success. However our success depends on a group of people not a few individuals. If this is to occur, it is time for people to become involved in shaping a future. Regards David Jordan VP U2UG ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Collaboration
I am not sure what you are talking about David You can buy a copy of U2 and PE allows development. Rocket has to earn income or there will be no U2, so they do realistically expect commercial operations to pay for licenses. For developers developing code there is a range of options, talk to Rocket. Any code that is written does not belong to Rocket, Rocket licenses the software that it runs on not the code that is developed on it. Source code licensing and copyright is related to the person who writes the code or the employment contract around that developer. I see no difference in using Pick to using Oracle, DB2, Microsoft software. The same restrictions, licensing and copyright apply across the board and are not unique to Pick/U2. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Suppress not found in RetrieVe
Hi Perry You could use transaction control, where you prevent deletes until the report is completed. For instance a GL report with Debits and Credits need to balance, you cannot allow the database to change in the middle of the report, so you wrap transaction control around to prevent updates until the report is complete. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Converting an account from UniVerse to UniData
Does anyone have experience converting a UniVerse account to UniData. I have used the UV_RESTORE. It creates the files but does not copy the data. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] uvcs Memory leak problems on 11.1.3
That triggered a memory. If you are using an older version of uniobjects in the .Net you can get memory issues when you upgrade the database. Have a look at upgrading the uniobject .Net to the lastest release. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Monday, 14 November 2011 8:27 PM To: 'U2 Users List' Subject: Re: [U2] [UV] uvcs Memory leak problems on 11.1.3 On unidata I have had to process many an xml file outside of the DB as the memory just shoots right up If you are using uniobjects then I presume you have .net or java at the front end and it is likely that these environments are better suited to 'handling' the xml and simply passing data arrays to the universe layer to work on. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: 11 November 2011 20:05 To: U2 Users List Subject: Re: [U2] [UV] uvcs Memory leak problems on 11.1.3 Hello, In order to save connection time on Uniobjects API requests, I came up with an Api which could contain several XML requests into one, Process each one in the requested order and return the answer of each request in the resulting XML request. On Universe 10.2.11, the API runs anywhere from 10 to 50 requests in a batch like this taking no more than between 45 and 59 megs of ram on a HP-UX server. Starting with Universe 11.1.3, doing far fewer requests (ei from 5 to 9) the memory requirements go up as high as 100 to 122 megs of Ram on a HP-UX. Somewhere it looks like Universe's XML generation routines are gobbling up memory and this memory is not getting freed. It seems that many memory leaks were fixed from 10.2.1 to 11.1.3 according to the release notes but a huge new one was introduced. I know of the memory used by the process because I have a job which produce the output of the top command once a minute, so the memory used by a process extracted from the output of the top command and logged. Has anyone else experienced anything like this ? Jacques G. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1411 / Virus Database: 2092/4010 - Release Date: 11/11/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Using EDA
Has anyone got experience in using EDA to push data onto an RDBMS. We need to do this for tender reasons, not practical reasons. I get an error message when verifying the data that there is a problem with converting from varchar to float, but there is nothing about which attribute is impacted. I actually suspect that it is related to a multivalue field, where it is taking the @VM as being text instead of treating it as a multivalue column. The documentation is light on converting attributes with multivalue fields. I would appreciate anyone's comments on the best approach to tackling Multivalue columns as I cannot seem to get this working correctly. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to fnuxi a SQL table
Hi Mark I am sure I have fixed SQL Tables from uniadmin without any problems. Sometimes there are conflicts in schemas, you would use VERIFY.SQL SCHEMA schema FIX in other times, however I am not sure that will work for UV_TABLES in the UV account. You may also be running into an issue of SQL permissions above directory permissions. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: Friday, 4 November 2011 8:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] How to fnuxi a SQL table UV 10.0.13 on RH8.0 I tried to create a Trigger on a UV file, but got an error telling me to fnuxi the UV_TABLES file. But when I try to fnuxi it, I get another error saying it's an SQL file and may not be fnuxi'ed. Details Below. Any ideas how I can fix the UV_TABLES file? Note; this system has been running for 10+ years, and may have migrated from different hardware as some point Thanks, Mark CREATE TRIGGER TEST BEFORE INSERT OR UPDATE OR DELETE ON VS FOR EACH ROW CALLING 'VS.TRIGGER'; ?Byte-swapped magic number in operating system file /adv/uv/sql/catalog/UV_TABLES, use fnuxi /adv/uv/sql/catalog/UV_TABLES to convert. UniVerse/SQL: Unable to open UV_TABLES. ED VOC UV_TABLES 3 lines long. : L22 0001: F 0002: /adv/uv/sql/catalog/UV_TABLES 0003: /adv/uv/sql/catalog/D_UV_TABLES Bottom at line 3. : EX SH $ cd /adv/uv/sql/catalog $ /adv/uv/bin/uv UniVerse Command Language 10.0 (c) Copyright IBM Corporation 2001. All rights reserved. catalog logged on: Tue Jul 5 08:15:29 2011 LIST UV_TABLES Byte-swapped magic number in operating system file /adv/uv/sql/catalog/UV_TABLES, use fnuxi /adv/uv/sql/catalog/UV_TABLES to convert. Unable to open UV_TABLES file. SH $ /adv/uv/bin/fnuxi UV_TABLES Processing 'UV_TABLES'. File 'UV_TABLES' is an SQL file and may not be fnuxi'ed. $ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.
Hi Charles Just a thought. When you ED VOC Dummy, you are creating a new record, where you are locking the Key to not be used by another process rather than locking the record. I am not sure where the locks are on the file system, but I wonder if Dummy already existed before you edited, whether this would be different. Also it would be worth test the difference of using READL and READU. David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Sunday, 30 October 2011 10:22 AM To: Charles Stevenson Cc: U2 Users List Subject: Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu. I hate to bring it up after 50+ responses over 4 days, but . . . Did anyone ever actually run my little test? On something other than my UV10.2/Win? Unix? Before UV10.2? Knowing that would help me assess the size age of our problem. I still think that in times past, a waiterfor a lockvia WRITE or DELETEwould show up at the 3rd section of LIST.READU EVERY, even as the typical READU (or FILELOCK, RECORDLOCKU) does. The original test was request was this: On 10/24/2011 4:11 PM, Charles Stevenson wrote: UV 10.2.10 on Windows is behaving differently from what I recall. Are my expectations out of line? Suppose Session A holds a readu lock; and Session B attempts a WRITE to same record withOUT!!! 1st explicitly getting the readu lock. Session B waits for Session A to release the lock before writing the record. While Session B is waiting, does it show up as a waiter in LIST.READU EVERY? I expected so, but it doesn't. Session A Session B _ ___ 1A. ED VOC DUMMY (this sets the readu lock.) 2A. (stay in editor)2B. run this: 01:OPEN 'VOC' TO F ELSE STOP 02: ***READU REC FROM F, 'DUMMY' ELSE NULL 03:WRITE '' TO F, 'DUMMY' 3A. Within ED: XEQ LIST.READU EVERY If I UN-comment line 2, LIST.READU EVERY shows something like this: Active Read Waiters: Owner Waiter Device Inode Userno Userno 746117947232860913 61163396 But when I comment out line 2, LIST.READU is silent. I have not yet explored what the deadlock daemon does. TIA, cds P.S. Yes, yes, Bad Form, Legacy Software, 20 min wait is configurable, . . . we can talk later. Later is already past. I'm not talking about that P.S. again! thank-you, cds ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] DataVu
The cost is a fraction of Cognos and DataVu provides more development functionality. You also don't have the cost of adding an SQL Server database and work to copy from UniData to the SQL Server that you would normally do with a Cognos environment. There is a development license and web based licenses for users to access the reports. I am not experienced with MITS, but from my knowledge MITS first role is to develop a data warehouse and then has reporting facility against the datawarehouse. It may not be the right tool if you are not building a data warehouse, however I may not be correct in that assessment. DataVu is a tool that allows users to develop visual dashboards and reports from working data rather than data warehouse database like Cognos depends on. However it would make life easier to probably set up a separate account that you put reporting data into. The product is not so much a matter of learning how to use, but about getting your head around how to use it which is no different to other products. DataVu provides flexibility to achieve functionality at a low cost. It resolves a problem that most sites have of giving users more access to querying data themselves. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin Sent: Tuesday, 25 October 2011 3:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] DataVu Does anyone have solid experience with this product yet? I am particularly interested in the license costs for a Unidata environment and some sense of what development efforts are required and the quality of the results, especially when compared with Cognos or MITS or the others in the space.Cheers,Kebbon ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] test
test ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Rocket Authorization Page
It was impacting the USA authorisation, not the international one last Friday. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Monday, 19 September 2011 10:31 AM To: 'U2 Users List' Subject: Re: [U2] Rocket Authorization Page Looks like a certificate on one of their internal servers has expired, and their ISA server is barfing on it. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Sunday, September 18, 2011 5:17 PM To: U2 Users List Subject: [U2] Rocket Authorization Page Is anyone able to access https://u2tc.rocketsoftware.com/ today? -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ENCRYPT in Universe
Hi John I have not played around with the encryption, but to my knowledge this is not the way it works. The password is related to the data encrypted, not to the user, so every user would require the same key for the data. To change the key you need to unencrypt and reencrypt the data. The other option is encryption at rest where the whole database is encrypted. This has been greatly enhanced in Rel11 of UniVerse. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, 12 September 2011 10:35 PM To: U2 Users List Subject: Re: [U2] ENCRYPT in Universe As far as passwords are concerned, I could use their password as the key? That way it would be different every time, and in order for it to be decrypted, they would have to supply the right password, otherwise, they would have to reset it... Is that a decent way of doing it? I've also noticed that in the manual they seem to have encrypted files, where this is handled somewhat automatically. But all of that seems much more complex to manage than this ENCRYPT() BASIC function. I think... Anyone ever use the encrypted file/field commands from TCL and had any luck with them? It appears you have to jump through a lot of hoops form upgrade to upgrade though, which I'm not too fond of. On Fri, Sep 9, 2011 at 9:25 PM, John Hester jhes...@momtex.com wrote: The key can be any text string you want and it's completely up to you how you store it. I would use a long, random mix of characters. The most secure place to store it would probably be on removable media that has to be inserted for the application to work, but that's probably overly inconvenient for most applications. Storing it in the same file as the encrypted data is probably the least secure place. Storing the key in a separate file is a relatively secure method, IMHO. There is some security by obscurity here since only someone with knowledge of the inner workings of the application would have any idea where the key is stored. It's also up to you if you want to re-use a single key or not. You could use a different key for every piece of data, but you have to be able to correctly marry the keys back to the right data to decrypt. Having another file with data that points to the IDs in the encrypted file could also tip off an attacker as to what the keys are for. I suppose you could get elaborate and encrypt the keys themselves, then the keys for those keys, etc., making it very difficult for an attacker to determine the decryption sequence. You could also re-encrypt the already encrypted data a few more times with multiple keys. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 09, 2011 8:44 AM To: U2 Users List Subject: [U2] ENCRYPT in Universe I am exploring the Universe data encryption features... Its my first try at this really. I have decent understanding off ssh and ssl, just not the U2 stuff. My questions are... Where is a safe place to store the key (as referred to in the docs) that the function needs to do encrypting and decrypting? How would I generate this key? Do I use the same key every time? Is there a thing to generate a key... like in ssh? For example, lets say I have a program that encrypts the user's password and then writes it to the data file like so... *A test for storing encrypted passwords. OPEN \BAS.USERS\ TO f_bas_users ELSE CRT \Cannot open BAS.USERS file.\ STOP END * CRT \Enter your email address: \: input email_address CRT \Enter your password: \: input password * key= \thisismykey\ result = \\ encrypt_status = \\ encrypt_status = ENCRYPT(\des3\, 1, password, 1, key, 1, 1, \\, \\, result, 1) CRT user_password *Apparently a status of 0 is a success. Which is just plain weird. IF encrypt_status = \0\ THEN WRITEV result ON f_bas_users,email_address,3 END -- Now lets say I want to check the password to see if it is correct and decrypt the data to do that... *A test for reading encrypted passwords. OPEN \BAS.USERS\ TO f_bas_users ELSE CRT \Cannot open BAS.USERS file.\ STOP END * CRT \Enter your email address: \: input email_address CRT \Enter your password: \: input password * READV stored_password FROM f_bas_users,email_address,3 ELSE stored_password = \\ END key= \thisismykey\ result = \\ decrypt_status = \\ decrypt_status = ENCRYPT(\des3\, 3, stored_password, 1, key, 1, 1, \\, \\, result, 1) ; *This is actually decrypting, the 3 indicates
Re: [U2] DataVu Query [ad]
I spoke to Jackie Burhans at Rocket about the issues raised in this list on behalf of the user group and she is putting a team onto looking at how to improve the documentation and installation process for DataVu. This is a product U2 users want to persevere with as it will make U2 stronger in the market and reduce the potential for competitor products pushing U2 out of a site. It needs some issues ironing out, but the potential is great. Regards David Jordan VP U2UG ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Hi Steve There have been 2 betas and I have been on both and requests were made through the Rocket newsletter. The issues are probably a combination of people implementing on a broader spectrum of environments than was tested and also an issue of not being as intuitive to install. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Thursday, 8 September 2011 11:27 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] That is cool. Wish we could have done a beta and help shake some of these out. Thank you Rocket for continuing to push the platform. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] DataVu Query [ad]
Mecki You do not need a JDBC driver, it uses uniobjects. There is a video showing how to install and read the documentation. The installation is not intuitive, but it is not hard. I made the mistake first not to read the documentation which takes you through step by step. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: Wednesday, 7 September 2011 1:00 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Well, I can't even connect to the host. A get an error message U2DB1004. I reckon you guys really need to make this a lot easier if you want people tto use this and buy the other modules. In the documentation it says something about a JDBC driver that needs to be installed but isn't included in the package and some obscure file that needs to be created somewhere and contains connection data but to me this is just Greek and doesn't mean anything. Other products like mvDeveloper just work without having to find a driver somewhere and create any files by hand. I bet you can do better than that. Mecki Original-Nachricht Datum: Fri, 2 Sep 2011 17:20:14 + Von: Daniel McGrath dmcgr...@rocketsoftware.com An: U2 Users List u2-users@listserver.u2ug.org Betreff: Re: [U2] DataVu Query [ad] Okay, so once you download DV Query there is a quick start guide that will tell you what you need to do. You need to run CONVERT.SQL on your files so that it has access to them, but you don't need to worry about creating the schemas with VSG or using HS.ADMIN like you would otherwise. Actually, there is a way to just use UPDATE.SQL.PRIVILEGES to get around this (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we recommend you do the CONVERT.SQL way. If you are running older versions of U2 you may need to update XTOOLSUB, which is also a Tech note on TechConnect. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 11:14 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett wphask...@advantos.net wrote: Steve: Really? I was looking at DataVu for UniData and I understood that I did need to SQL'ize all my data. So, if I hosted a number of accounts I'd have to go through the entire process of figuring how to duplicate the accounts for SQL file access, keep them all straight, and fight with all that this entails. Are you sure I misunderstood this? Thanks, Bill Haskett -- -- - Original Message - *From:* slestak...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 9/2/2011 9:47 AM *Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 12:45 PM, John Thompsonjthompson...@gmail.com wrote: For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, lets say Excel... without the user coming to ask me to write some query for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrathdmcgr...@rocketsoftware.com wrote: I'm not entirely sure on what you want here? DataVu (the free Query and paid Report Dashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:36 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is there a comparison chart of DataVu vs. ODBC? I am planning on investigating both for reporting purposes, but, I was just curious if there was anything out there that listed the pros and cons of both in a nice little table. On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: Free as in free beer on the house. Just install and run. There is no need to authorize. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:20 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is this a licensed product? Or does it come with the U2 licenses we have purchased? On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath dmcgr...@rocketsoftware.com wrote: Since DataVu Query recently came up here, I thought I should let you all know we have just released a new version of the free DataVu Query tool (v2.0.1) We have
Re: [U2] DataVu Query [ad]
Hi Mecki You need to set up in the UD.ACCOUNTS. Install the xdemo account from the CD and try connecting to that first. I have installed with UniVerse and I am not as familiar with UniData, you may have to do a CONVERT.SQL, you will need to check the documentation. I would consider actually setting up a separate account with pointers to your live account or even build a mini datawarehouse in a separate account to do reporting from. Make sure that you are select the U2 options and not using the SQL database connectors. There are specific U2 data connections and queries. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, 7 September 2011 9:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataVu Query [ad] David, I bet you are right, but what users want is to be able to install software like that without having to search the documentation for hours. I don't mind if I have to search for and download a JDBC driver from the net to connect to SQL Server, DB2 or Oracle data sources but I expect a Rocket product to work straight away for U2. I get a screen that asks me for the UD server name and even though that name one works for SB client, VSG, UniAdmin and tools like mvDeveloper it won't connect in DataVu. All I found so far is that I need this driver (hell knows where to get it from) and a file called bi.jdbc,drivers (or something like that) that needs to be created somewhere by the administrator. Hell, I am the administrator and I haven't got a clue how to do that! On 06/09/2011 23:22, David Jordan wrote: Mecki You do not need a JDBC driver, it uses uniobjects. There is a video showing how to install and read the documentation. The installation is not intuitive, but it is not hard. I made the mistake first not to read the documentation which takes you through step by step. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: Wednesday, 7 September 2011 1:00 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Well, I can't even connect to the host. A get an error message U2DB1004. I reckon you guys really need to make this a lot easier if you want people tto use this and buy the other modules. In the documentation it says something about a JDBC driver that needs to be installed but isn't included in the package and some obscure file that needs to be created somewhere and contains connection data but to me this is just Greek and doesn't mean anything. Other products like mvDeveloper just work without having to find a driver somewhere and create any files by hand. I bet you can do better than that. Mecki Original-Nachricht Datum: Fri, 2 Sep 2011 17:20:14 + Von: Daniel McGrathdmcgr...@rocketsoftware.com An: U2 Users Listu2-users@listserver.u2ug.org Betreff: Re: [U2] DataVu Query [ad] Okay, so once you download DV Query there is a quick start guide that will tell you what you need to do. You need to run CONVERT.SQL on your files so that it has access to them, but you don't need to worry about creating the schemas with VSG or using HS.ADMIN like you would otherwise. Actually, there is a way to just use UPDATE.SQL.PRIVILEGES to get around this (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we recommend you do the CONVERT.SQL way. If you are running older versions of U2 you may need to update XTOOLSUB, which is also a Tech note on TechConnect. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 11:14 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskettwphask...@advantos.net wrote: Steve: Really? I was looking at DataVu for UniData and I understood that I did need to SQL'ize all my data. So, if I hosted a number of accounts I'd have to go through the entire process of figuring how to duplicate the accounts for SQL file access, keep them all straight, and fight with all that this entails. Are you sure I misunderstood this? Thanks, Bill Haskett -- -- - Original Message - *From:* slestak...@gmail.com *To:* U2 Users Listu2-users@listserver.u2ug.org *Date:* 9/2/2011 9:47 AM *Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 12:45 PM, John Thompsonjthompson...@gmail.com wrote: For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, lets say Excel... without the user coming to ask me to write some query for them... What would be the pros/cons of doing the ODBC way, vs. doing
Re: [U2] DataVu Query [ad]
Hi Mecki You should not need a jdbc driver, this is why I suspect you maybe using the data connector for RDBMs databases instead of U2 data connector which uses uniobjects. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, 7 September 2011 9:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataVu Query [ad] David, I bet you are right, but what users want is to be able to install software like that without having to search the documentation for hours. I don't mind if I have to search for and download a JDBC driver from the net to connect to SQL Server, DB2 or Oracle data sources but I expect a Rocket product to work straight away for U2. I get a screen that asks me for the UD server name and even though that name one works for SB client, VSG, UniAdmin and tools like mvDeveloper it won't connect in DataVu. All I found so far is that I need this driver (hell knows where to get it from) and a file called bi.jdbc,drivers (or something like that) that needs to be created somewhere by the administrator. Hell, I am the administrator and I haven't got a clue how to do that! On 06/09/2011 23:22, David Jordan wrote: Mecki You do not need a JDBC driver, it uses uniobjects. There is a video showing how to install and read the documentation. The installation is not intuitive, but it is not hard. I made the mistake first not to read the documentation which takes you through step by step. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: Wednesday, 7 September 2011 1:00 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Well, I can't even connect to the host. A get an error message U2DB1004. I reckon you guys really need to make this a lot easier if you want people tto use this and buy the other modules. In the documentation it says something about a JDBC driver that needs to be installed but isn't included in the package and some obscure file that needs to be created somewhere and contains connection data but to me this is just Greek and doesn't mean anything. Other products like mvDeveloper just work without having to find a driver somewhere and create any files by hand. I bet you can do better than that. Mecki Original-Nachricht Datum: Fri, 2 Sep 2011 17:20:14 + Von: Daniel McGrathdmcgr...@rocketsoftware.com An: U2 Users Listu2-users@listserver.u2ug.org Betreff: Re: [U2] DataVu Query [ad] Okay, so once you download DV Query there is a quick start guide that will tell you what you need to do. You need to run CONVERT.SQL on your files so that it has access to them, but you don't need to worry about creating the schemas with VSG or using HS.ADMIN like you would otherwise. Actually, there is a way to just use UPDATE.SQL.PRIVILEGES to get around this (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we recommend you do the CONVERT.SQL way. If you are running older versions of U2 you may need to update XTOOLSUB, which is also a Tech note on TechConnect. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 11:14 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskettwphask...@advantos.net wrote: Steve: Really? I was looking at DataVu for UniData and I understood that I did need to SQL'ize all my data. So, if I hosted a number of accounts I'd have to go through the entire process of figuring how to duplicate the accounts for SQL file access, keep them all straight, and fight with all that this entails. Are you sure I misunderstood this? Thanks, Bill Haskett -- -- - Original Message - *From:* slestak...@gmail.com *To:* U2 Users Listu2-users@listserver.u2ug.org *Date:* 9/2/2011 9:47 AM *Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 12:45 PM, John Thompsonjthompson...@gmail.com wrote: For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, lets say Excel... without the user coming to ask me to write some query for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrathdmcgr...@rocketsoftware.com wrote: I'm not entirely sure on what you want here? DataVu (the free Query and paid ReportDashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org
Re: [U2] Stuck getting started with DataVu
Hi all I work with DataVu a bit. The first trap I got caught on was skipping through the documentation and missing steps, double check the steps in installation. A couple of things to check. 1. make sure the entry is correct in the UV.ACCOUNTS file. 2. This does not use ODBC, but it does use SQL. If SQL is not working on your account you need to follow this through first. 3. If linux is involved check if some other steps need to be added. There was some issue with Linux in the beta that I thought was resolved but you may have to install something. In the beta a lot of work was done to ensure that DataVu works with all dictionary types and including SB+ dictionaries. What many are doing is setting up a new account with remote pointers and restricted dictionaries pointing to the data account. You can set that account to be ideal flavour and have different dictionaries to the data account and avoid touching the live account for reporting purposes. You can do what you want to SQLise this account without touching the data account. There is a little perseverance to get DataVu up and working, but in comparison to the work required to get up COGNOS, Chrystal reports and other BI tools to talk to U2, this is an easier path. Remember also that DataVu talks to other RDBMS, which means that you stop the need for pushing data into some SQL Server for reporting purposes and you raise the status of U2 in management eyes reducing the threat of U2 being replaced in your organisation. Another issue to look at. It is easier to transform data to an appropriate format in U2 than trying to manipulate it at DataVu level. Build SQL queries that produce an appropriate array to put into the DataVu Objects, this will save you some frustration going forward. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects question
Uniobjects has the same facility to access TCL through the command method. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Tuesday, 9 August 2011 2:02 PM To: U2 Users List Subject: Re: [U2] uniobjects question [AD] [AD]While it may be impossible with UO, FusionWare's Direct Data Access Server supports a mechanism called EXEC TCL in which you can call any program that can be run from TCL, and pass it inputs, like a PROC or a CGI program. If you miss an input, things will get kind of stuck, but if you know your inputs, it works like a dream. We have customers who have been using it quite happily for a number of years. You can access this functionality from Java, OLE DB and Managed .NET (ADO.NET) clients. We give some very simplistic examples here: http://www.fwic.net/Resources/FusionWareIntegrationBlogs/tabid/116/EntryId/55/Other-Ways-to-Access-Our-MultiValue-SALESORDER-Data.aspx -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, August 08, 2011 4:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uniobjects question Doug, as confirmed by the experience of others, and confirming your own suspicion, we can say with certainty it's not possible to have a functional app where CRT and INPUT are encountered by UO. The only way to use traditional code like that is to skip UO and to use a telnet or SSH client from your language of choice, feeding input to the server, waiting for a response, and parsing the output. That mechanism works fine until something unexpected comes up. Then you need some supporting handlers around your code to recover from the error, avoid keeping the process and license locked, restart a new process, log the event, etc. This is screen scraping, and while there are some fine solutions that do this, they are generally shunned for heavy processing in favor of less volatile solutions. In summary, do you see the two big glowing eyes peering back at you from deep inside of that dark cave? You know better than to go in there, right? :) HTH T From: Doug Chanco I totally agree with your response but what me and the java developer are discussing is if it's even possible (I say nay) I will write a java program to test but I was hoping with the vast sea of knowledge on this group that someone would know, if it was possible or not Yes it should never be done and yes your standards are spot on. This is just a I wonder if this is possible question Dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects question
I have done it Doug, but with the command processor not the subroutine call. I would run the program in the command and receive a string which I would interpret as either a result or a request for information, which I would then respond accordingly. It works but is cumbersome. There is also an issue of timeouts where the connection would drop out after 6 minutes of no response. Creating subroutine calls are a better way to go with no prompts within the program. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Why Pick U2?
I developed a new application in U2 and I sell it. I am not a dinosaur. What has been raised is technical comparisons, but if you are developing software to sell you need to think commercial advantages. For instances, I never sell to IT, I sell to business decision makers, technology means nothing to them, they want results and they want delivery within budget and within time frames. No one asks me what database I run on. You compete first on cost and second on functionality and thirdly they want reliability. This is where U2 shines for a new developer. 1. I never fear that I will not meet cost and time targets, I don't have surprises that delay projects. 2. Cost of Development, I can achieve with 2 programmers in half the time what my competitors require 10+ programmers to do 3. Support: I sell a package and rarely go back to the site for years as it is self-maintaining. Their IT rarely have to do anything with it. 4. Functionality, I can do complex business functionality that my competitors struggle with despite their modern programming languages and tools. 5. I can put a lot of fat into my quote and still undercut my competitors. 6. Code transports through technology changes. If I had written something 15 years ago in c++, VB for windows, I would have had to rewrite it several times to handle the evolution of windows technologies. That is expensive. The advantage of U2 is the KISS principal. Use the right technologies for the right job. For instances front ends, use .Net, Java, etc. U2 Basic is a business programmers language, not a computer science programmers language. It is good for people who are writing business rules as it is quick and simple to write and easy to read and debug. I have written complex business logic that would have been difficult to manage in c#. Sure there are many things that need to be improved in U2, but to think other technologies are perfect is a bit of the grass is greener on the other side. I have worked with many databases and technologies over the years and have seen what looks good to start with often hits brick walls as you start to get serious with the technology and then there are massive costs to jump those brick walls. I am winning with U2 and that's why I use it as do many others on this list. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Why Pick U2 ?
One thing that all the other database lack is that U2 has a sophisticated business rules engine. The SQL bastardise language in other databases is a nightmare compared to unibasic.When everyone is talking APIs, they are mostly talking about the presentation layer. Presentation layer interface to other databases is better than U2, but U2 is better for storing business logic in the database. I am seeing too many applications being developed out their that are breaking the rules of client server where the business logic is in the client. Too many tools use the database as a simple data repository and require business rules to be built into the client. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interesting article
Rob your comments are not wrong. However U2 management want to go where they think the market is. As users we don't tell them anything and then complain that they are not mind readers and are not heading in the direction we want to go. As a user group, we give users a voice to be able to set direction. Of course there are a million one views about the future, but we can build a business case based on the wishes of the majority. I have sat down with Rocket and explained how Microsoft Azure could provide a market opportunity and how U2 could work in this environment and I am working with them to look at its feasibility. Others are looking at REST and a range of other APIs. Rocket is not so much ignoring us rather we as users are not talking to Rocket constructively. What is important is to turn this discussion into something constructive. If Rocket asked you what you want, what would you say. David Jordan VP U2UG ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interesting article
Hi Bill There are some options for alternative licensing. Rocket will not stay in business giving away licenses, but they are also not silly in turning away business because of licensing structure. We as a user group need to put a business case to licensing. There are subscription models we could put up, there are cloud based models. We need to talk to Rocket about the options we need. The user group gives an opportunity to show that these are not the wishes of an individual, but the wishes of a community. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor and Eclipse
Talk to Rocket. I have heard that there have been some discussion to resolve this problem David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Convert to Numeric
Hi Greg I may have misinterpreted your email. However just wanted to make sure you understood that if you want to convert $13,000.00 to numeric you need to do an ICONV. OCONV does the opposite and converts 130 to $13,000.00 Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Friday, 1 July 2011 10:50 AM To: U2 Users List Subject: Re: [U2] Convert to Numeric Guys, I'm getting some wildly unexpected values returned... I have attempted formatting (FMT) and converting (OCONV) and have looked at the data which appears to be correct(no O etc...). The DICT has them set at MD2, and 15R. I notice that I am also getting the following message: In CF.OBJ/_A26S.GET.GLS.INFO at line 212 Non-numeric found when numeric required. Any suggestions how I can force these values numeric? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interesting article (pro mobile web) vs mobile app -relating to previous discussion
It is not an issue of old dogs vs young dogs. It is about the separation of presentation and business logic. The U2 applications are the business logic, the html, java, .Net are the presentation layer. All the young people are caught up on the presentation layer and are cheap. What businesses are starting to struggle with is the development of the backend business logic. What people need to work out is how to sell that they are the backend solution providers and modify their applications to talk to a presentation layer that is done by someone else probably in India. There are many successful U2 applications out there that have the business logic written in u2 Basic and a presentation layer written in java, .Net, html, etc David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Strange Selection Behavior
Hi Steve This may be an issue of the EXECUTE creating another shell to perform the select which the tcl prompt does not require. There has been past discussions of the use of EXECUTE and PERFORM for this reason. However I am not sure that there is an difference for Universe and the PERFORM command is there for functionality. Someone may be able to clarify that. Mind you it should not cause a 22 second issue. Do a print of the cmnd before the execute and capture it in a como. You might see something strange in the way that the command is being constructed. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 11.1.2 list line limit
Hi Jack I would use the OPENSEQ and READSEQ to deal with such files. The problem with ED and READ apart from loading the whole record into memory is that to go to attribute 1M it goes to the start and then counts a million field marks. Then you want to read 1,000,001 it goes back to the beginning and reads 1,000,001 field marks it is extremely slow and unworkable. READSEQ, WRITESEQ leaves a pointer from the last attribute position. You have to process these files sequential but it would read 40MB in nanoseconds, far more efficient. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jig Sent: Monday, 6 June 2011 8:15 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe 11.1.2 list line limit OK sorry Kate, I should have given a little more information. On our system (AIX v5.3) we recently upgraded to 11.1.2 of UV from v10.3, and we deal a lot with lists. Large lists with hundreds of thousands or even millions of lines (elements). These are just lists of keys to records in files. One in particular is a fixed length seven byte key (alphanumeric). However the largest file has 3.5 million records in it. This means that our lists can get to over 3 million lines ( this is about 40MB of a single file in a Unix directory). On version 10.3 when a basic program or the ED editor was used to read one of these lists (with anything over 2 million lines of keys in it) it would just core dump and not be able to read it. The same thing occurred whether one had the list in the SAVEDLISTS file or anywhere else. To get around this problem we wrote software to split these large lists. However that was cumbersome and not always worked to specification. With UV 11.1.2 (and because according to Rocket they did a lot of work to improve memory management) we thought we'd be better off, handling some of these large lists. However it seems we were wrong. A Basic routine cannot read a list that is over 4 million records in it. It just falls over and the process dies. The AE editor is a little more graceful with some information before it also dies trying to open any large list of keys. I know there are ways around this issue, but we expected a lot better performance from the new version. I dont have the exact error at the moment, because I am not at work, but I can add it here if requested. One can always try it themselves to see the error, because it happens every time. I am sure most companies do not work with such large lists, but even so, core dumping instead of a gracious exit is not good enough. This is the first thing we learned when we started out as programmers decades ago. regards jack Kate Stanton wrote: What limit? I do not understand. TIA., Kate On 6 June 2011 19:32, jig iako...@gmail.com wrote: Wondering if anyone is aware of the line limit in a saved list for the latest UV version? Has it improved since we went to 64-bit? -- View this message in context: http://old.nabble.com/Universe-11.1.2-list-line-limit-tp31781147p3178 1147.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 -- 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 -- View this message in context: http://old.nabble.com/Universe-11.1.2-list-line-limit-tp31781147p31782039.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pondering recent thread on compact framework
Microsoft has split their development products into 2 areas presentation and business rules. The presentation people take results given to them by the business application and present it on the phone and web. The business rules developers have little to do with presentation. Many developments in the U2 world are starting to move that way, where the business rules developers are U2 and the presentation developers are another group such as .Net. Hence U2 people are not aware of the phone development. Another issue that would concern organisations is how to handle security and identification of remote users. Creating an application on the phone is simple. How you connect from the phone to the database with encryption, passwords, etc is an area that people fear. Simple web services are easy, but when you then want to know that it is really joe blog that is calling the web service, it becomes another level of complexity. Finally the issue is the cost benefit analysis. Do I write an app that allows executives to access KPIs from my application. Would sending them an email with the KPIs be far cheaper and simpler. At what point is it productivity and at what point is it playing with technology. ___ 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
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
Re: [U2] Uniobjects.Net Compact Framework and Visual Basic
Hi Jeff I suspect that you may not have included all the components to be carried across to the device. They are on your workstation, hence why it runs, but fails on the device. I believe there is a description of the items that need to be included in the sdk in the ibm or rocket directory. You can put the web service on a different machine and talk to the server hence isolating the data. The U2 webservice can encrypt and provide security connection to that server and is fairly easy to set up. With Web services your application runs on any device where .Net limits you to Microsoft. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reliability doesn't raise enough issues to keep the list busy
New sales are mostly packages. A new site implementing a package does not equate to a new site needing U2 programmers. Hence a growth in job advertising is not a measure. Another impact is that new U2 applications have front ends developed with other languages like .Net, java. Etc. Often they are training those people to write U2 code rather than hiring pure U2 people. It is a sign of the times, those that are multiskilled in a number of environments will have greater opportunity to find work. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uv v ud
Hi Bill I ran into a funny like that. The application was compile with an old version of uniobjects .Net and had an issue with the new version of universe. I recompiled with the new version of uniobjects and the issue went away. Other area to look for - I have had issues where a subroutine returned an unsigned variable, make sure all variables are assigned when being returned back. - Check the size of strings being passed back, a program may be passing back a long string as the result of a program bug. It may be a corrupt record. The problem with pick is we look at fld 10 and don't care what is after. You can have a corrupt record with garbage on the end and it will not impact data quality in the application but it will impact on performance. I have found uniobjects to be quite robust, but really only use it to make calls to subroutines, I don't use other functionality. Whilst you can write business logic in the .Net client, there is a question if that does not breach good practice in relation to client server. You should keep your business rules in a central place where you can change it once. You cannot afford to update a 100 desktop applications every time you need to change business logic. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reliability doesn't raise enough issues to keep the list busy
One of the things that U2 has is the KISS principle. What I find like in .Net, is sometimes it overcomplicates a solution. 80% of my code is in UniBasic and 20% in .Net, however I feel like 80% of my time is taken up managing the .Net code compared to 20% managing the greater amount of code in UniBasic. That is something I hear from a number of developers who develop in both environments. I agree we should not do everything in U2, but I wish some of the other environments kept it simple to. One thing I have always liked about U2 is that I always felt confident that I would deliver a project close to time and close to budget, I rarely get surprises. However with .Net, suddenly I hit strange problems relating to versions of OS, security issues, etc that muddy the waters. Hence I spend a lot of time on .Net forums seeking solutions that I just don't need to do with U2. Buggy may have been a bit harsh, but there is an issue of consistency and dependability of development. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reliability doesn't raise enough issues to keep the list busy
Databases have become utility. I don't see many applications today advertising they run on Oracle or Microsoft, many are trying to be generic. People are more interested in buying SAP than worry what database it runs on. Those days of user base and TPC ratings are gone. Users and developers want to know does it run on the environments they want, does it interface with other applications, does it work with cloud, what are the costs, what are the returns it will deliver. They are not asking who uses the database or how many users around the world use it, they are asking who uses the application that they are looking to buy. There is nothing in U2 that stops me interfacing with new technologies. Sure I would like some more native and sometimes simpler interfaces but I have been able to do most things talking to U2. Rocket may not publish figures, but U2 is increasing staff, U2 are introducing new products such as DataVu, these are not indicators of a dying product. Less than 500 people attended U2 universities around the world which means everyone else failed to find out what Rocket is doing. Rocket created the opportunity, but people failed to take advantage of it. Stop focusing on what U2 does not do as all technologies have holes. Focus on what it does do and then work with Rocket to further improve the technology. People do not understand where they are touched by U2. Your baggage being unloaded from the plane is probably using U2. Dialing an emergency number, the operator could be using U2. Doing a banking transaction often has a pick application involved, booking a flight, membership to a union, project management of a building site, dealing with a car distributor, going to the library, managing a nuclear reactor. You name it you are being touched by U2 applications everyday. For me U2 allows me to compete with a small RD staff, small support staff and at a lower cost. I am able to deliver far more for a tenth of the cost of my competitors. If new developers are making decisions based on technology awe instead of business justification, then they will have a short life span. I don't really see why we need to know what the number of users in the market are, it is not that relevant. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Reliability doesn't raise enough issues to keep the list busy
It is the problem with a reliable product there are not enough issues to keep the list busy. If you had one of the competitor products there would be a ton of issues to deal with to keep multiple forums busy. Funny how buggy software can look good, because there are a ton of forums to deal with all the bugs. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
HI Jake A work group license is A$570 David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
Have people who criticised U2 interfaces actually worked with other database applications. Remember the joke What hardware and operating system doe Oracle best run on, a projector and powerpoint. Too much of the competitors' products are gloss and when it comes to writing applications they become a chain and ball. When I look at competitor applications they have pretty interfaces but lack substance. I beat competitors from major companies because I provide functionality at a price that leaves the others for dead. Clients are starting to question the gloss and are looking for substance. As I have said in previous emails, it is not about the technology, it is about how it is sold. We have an Australian U2 GL package that kicked SAP out of a site, it is not impossible. For too long U2 has sold it self, however due to competition, we need to apply more money to marketing and sales people. Marketing budgets of some of the competitors are well over 20%-40% of revenue, few U2 application vendors spend anywhere near that much. Marketing statistics identified that optimists outsold pessimists. If you think U2 is not up to scratch with the competitor, then how are you going to convince the customer. Rethink how you look at U2 compared to other databases and it will change the discussions with senior management. Senior management are on bonuses and they do not get paid for buying brands they get paid for delivering results, you need to demonstrate how U2 improves their bonuses and you are in. Of course there is room for improvement in U2 products and Rocket is working on them, but uniobjects is still one of the most efficient and effective APIs that I have worked with and you can easily add gloss to tired applications with a range of client tools including .Net, java, etc. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Opinions on Cache
Rather my point about the Pick issue is not to say that it is not a problem, it is more the perception of how to sell Pick to senior executives. Business management are not as concerned about technology as they are about results. They may have a concern or a perception about the technology being limiting but they can be convinced otherwise. What I would point out is that it is important that we as a community build the right message that argues the point. Unfortunately I hear too often people being apologetic of the technology rather than pushing its merits. Part of that problem is many people who have grown up with the PICK environment don't understand the limitations of other RDBMs. Many of the new sales of U2 are application driven not technology driven, PICK or U2 is not even mentioned. Many of the sites that are struggling with the PICK issue are sites that have based applications on the technology they have being PICK. The question is not about the technology but a concern if the application is tired. The application could be renewed two ways, replace it or put up a proposal to upgrade and renew the current application. Unfortunately many of these applications have moved into maintenance mode giving it the tired image. What I was trying to do with my comments, is to get people thinking about the strengths of U2. I invite some rigorous debate as it raises questions and generates new ideas people have never thought of. For instance with cloud computing, SQL database applications are designed to be multitenant. In other words I have one set of tables for my applications but I prefix every key with a company identifier. So on a multitenant CRM application where 100 companies are using the applications, the Customer Table would prefix the customer number with a unique identifier for each company using the application and they would all share the same table. With the structure of U2, it would be efficient enough to have a separate account for each company. Technically this might not be an issue to developers but perceptions to a business manager are different. They could perceive an issue of their data sitting alongside other company's data. As an IT manager trying to keep a Pick site, this information could stop a move to another application. What I would put to everyone at the moment is that we have been is a siege mentality over the last decade trying to convince IBM, Informix and management that U2 is a going concern. Now that Rocket has purchased U2 as a growth opportunity, the siege gates have been thrown open and we have the opportunity to attack the competition. As in sport, it is how we think that wins or loses opportunities and I believe that this is the essential issue, we need to change our thinking about Pick. In the last two years I have seen a major change in direction in IT thinking where U2 has some real opportunities. Governments around the world are having to trim budgets and they are not prepared to waste money on brand names. Larger corporations are cost sensitive. I believe U2 is in a strong position to take advantage of that change. Difficulty in finding people is not necessarily a negative. Right at the moment Microsoft SQL has a major issue that those who know TSQL are mostly 40+, I don't see Microsoft sales slowing down because of this. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Opinions on Cache
From my observations, I don't quite agree on Tony's summation of Cache vs U2. Cache has the same burden as U2 in that they came from mumps where U2 came from Pick. The biggest difference between Cache and U2 is marketing where Cache takes on RDBMS and U2 is apologetic for being Pick, but that is not the issue with the technology. Cache is a multi dimensional platform, the same as Pick but in a slightly different way. U2 has SQL just as much as Cache, I have applications written in U2 that have SQL tables and SQL grants and can be accessed with SQL queries. If Cache can sell itself as an SQL database, then so can U2 they are both in the same boat. Whilst I think some of Cache's technology is clever in their object model, people need to consider some issues with Cache. Check that the ATOMic transaction model is what you expect. U2 complies to the standards, when I looked at Cache, I don't believe that they did. Also consider the continuity of the company, what is the future of Intersystems when the founder exits, where Rocket is a more established business that is not so dependent on key managers. I am currently looking at how U2 fits in the cloud environment with products like Microsoft Azure and I think the model of U2 where each table is a separate os file is better for cloud computing than Cache's one system file (similar to the approach of other RDBMs). DataVu provides a significant solution to an area of weakness in the U2 camp related to reporting. DataVu gives U2 the equivalent of SQL Reporting services and more. DataVu provides a competitive position to products like Cognos. This is one technology that I do not believe that Cache can cover off. I think it is great to have Cache in the MV world, it provides competition and will keep Rocket on its toes, both have strengths and weaknesses. However I would not agree in Tony's email that it is a better technology than U2 or that it is a solution to the management concerns who are more familiar with Oracle and SQL Server. I also don't believe that U2 is locked to green screen applications. I am seeing new generations of applications that don't have green screens, they have a range of .Net, java and web interfaces. Honestly the PICK issue does not come up as much as people think it does, nor is it a hindrance. Management are looking for ROI, they want responses to business problems and they want to ensure that Risk management is ticked off. All these can be achieved with U2 as a community we need to learn how to answer those concerns. There are some areas of U2 that need to be refined and as U2 users we need to tell Rocket where to put the priority to ensure that meets our requirements. The U2UG has set up the better and better site and Rocket has the u2as...@rs.com email. Please take advantage of these to refine U2 to meet your expectations. Regards David Jordan U2UG VP ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Opinions on Cache
I am not familiar with UniData and I am aware that UniVerse has had better SQL support than uniData. I have found that UniVerse SQL performs well. The UniVerse query engine is used by both SQL and retrieve, where they pass the query over to an optimizer engine. One thing that has been a bit slow is the ODBC driver which has been updated at release 11.1 . Also the query integrates with EDA, so I can be selecting data off a UniVerse, Oracle and SQL Server at the same time. I would be interested in comparisons in performance of a similar data file with similar indexs, triggers, etc. There is also a consideration issue whether systems are designed for fast retrieval or fast update. It is difficult to assess query performance, we all know how meaningless the old TPS tests were that the RDBMs used to quote all the time. I agree with Dawn some of Caches object model for data is quite innovative and how it propagates to client tools is nifty. With IBM U2 was under resourced, with Rocket U2 has better resources and it is in a much better position to advance quickly with new innovation, it is now time for ideas. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections 2010 - Request For Comment
The user group is for the users. If any user has an idea that we can put into a business plan then we can put it to Rocket and Rocket will respond on the merits of the plan. What is difficult at the moment is what we can do. Rocket advertises the user group in its emails, at the U2 University. Susie regularly advertises the user group in her presentations around the world. Every U2U bag has a U2UG advert paid for by Rocket. The issue of membership is about relevance to users. For a user who is using a ERP solution, they are more interested in belonging to the ERP solution user group than the U2 User group. So who is our audience, ISVs, consultants, programmers, etc. Both George in the UK and Brian in Australasia advertise the user group to their ISVs. However the ISVs rarely advertise to their customer base. We all wish we could get the message out there more, but what we need is ideas more than money. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections 2010 - Request For Comment
First Fft2001 Can we have your name. How do we know that you are not someone from a competitor like Oracle trying to make Rocket look bad. Secondly the focus on money is pointless. We don't need money we need ideas. If anyone has a good idea and it needs some money from Rocket to make it happen, then I am sure that Rocket will consider it. Rocket is not like IBM who were sucking money out of U2 to push DB2, Rocket brought U2 to grow the business and if you have any ideas that will grow the business they will listen. Throwing money at a problem does not solve it. The board have racked their brains trying to come up with ideas to touch base with all users, if anyone has ideas let us know. Thirdly the directors don't have the time to do everything that is required, many hands make light work and we need more involvement of other users. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections 2010 - Request For Comment
Thanks Ron Not knowing raises concerns of what are the motives behind the emails. Will probably means well, but misunderstands what Rocket is doing for the U2UG and some of his comments are unfair to the people involved. David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections 2010 - Request For Comment
Hi Dawn I was raising an issue of etiquette to put names to emails so that everyone knows who they are dealing with and it is transparent that there are no hidden agendas. Not everyone knows who Will is as he has a meaningless email and he signs off with W. George would not know that Will was on the board of U2UG. I was trying to raise a perspective, that not knowing who you are dealing with raises questions about what are the motives. Members particularly new members don't know if Will is working for jBase or Intersystems or other competitors, so being upfront with who you are clears the air for everyone in discussions and minimises misunderstandings. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata sessions stop at any time
Hi Marco Call support of the guys you brought Unidata from, I think there is a patch for your issue. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Antonio Rojas Castro Sent: Sunday, 20 March 2011 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata sessions stop at any time Hello Unidata 7.1.0 on Windows 2008 installed 2 weeks ago. 80 users logged on Unidata sessions stop at any time Event viewer show these messages Error19/03/2011 11:42:17Application Error1000(100) Aplicación con errores udt.exe, versión 7.1.0.3146, marca de hora 0x42c2d61b, módulo con errores unknown, versión 0.0.0.0, marca de tiempo 0x, código de excepción 0x8026, desplazamiento con errores 0x7549a57d, Id. de proceso 0x38bc, hora de inicio de la aplicación 0x01cbe65488e6d5b1. (1100 occurs) Error19/03/2011 12:05:21UniData Telnet1004NingunoTelnet set client binary mode failed.. (13 occurs) Error19/03/2011 11:41:47UniData Telnet1004NingunoTelnet Client/Site licensing inquiry failed.. (42 occurs) How can I fix this ??? Regards, Marco Rojas ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] U2UG Elections 2010 - Request For Comment
to improve membership, but what I can do to help others to prosper new members and spread the message. I hope that I inspire others through passion and belief in the technology we use. Whether it is working on the beta program for DataVu, or sitting down with Microsoft to see how to port UniVerse applications onto Microsoft Azure, or to talk to new developers about the benefits of U2 or seeing how we can get U2 to be included in University courses, all of these play a small role in making U2 stronger. If there are 3,000 people all doing the same thing, think of what we could achieve. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Friendfeed and U2 EDA similarities
The main benefit for EDA is to be able to tell clients that your application runs on Oracle, DB2, SQL Server, etc. At the end of the day the customer may just run U2, but it enables a VAR to meet a criteria. Tender documents might require that products have to run on Oracle that would have denied U2 applications the opportunity. Termenos has sold their pick application on Oracle. As a banking system, customers feel more comfortable with Oracle as a database, so why loose the sale when you can say I run on Oracle. The question is, how much of the Database needs to be put on the external database to satisfy a customer's expectation. Do you just transport information for enquiry/data warehouse data or do you transfer the whole transaction database. One are to be aware is that most pick applications are pessimistic locking and SQL databases prefer optimistic locking for performance. It would usually require U2 to the only application updating the database. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
U2 has probably spoiled us. You should see some of the issues others face upgrading in Oracle, SQL Server, Windows and so on. We have an expectation of seamless upgrades that does not occur in other environments. For people to have software that is 25 years old still running on U2 is pretty good. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
You need to populate that UD.ACCOUNT with a record for that UD.ACCOUNT. You can either manually create it or use UniAdmin to update an already created account. You may also need to fill in the description field. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce McAdoo Sent: Saturday, 20 November 2010 8:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 DataVu Query Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner Brown, Ltd. bmca...@wbltd.commailto:bmca...@wbltd.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniRPC Connection
Bill At one stage in UniVerse, in Service to tick the box to allow the service to interact with the desktop. If it is a Win2008 server there are issues with User access Control. Finally I have had a problem with Win2008 with one of the rpc dlls going missing and had to copy back that dll. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, 11 October 2010 11:19 AM To: U2 Mail List Subject: [U2] UniRPC Connection I have access to multiple UniData servers and connect to these servers via RDP on Windows. I use UniAdmin to administer the UniData dbms. On one particular server I last used UniAdmin about four months ago without any problem. However, now when I try to connect via UniAdmin I get the message No RPC Connection active. Looking on the machine at netstat I see: C:\Documents and Settings\myusernetstat -an Active Connections Proto Local Address Foreign AddressState TCP0.0.0.0:21 0.0.0.0:0 LISTENING TCP0.0.0.0:25 0.0.0.0:0 LISTENING . . TCP0.0.0.0:31438 0.0.0.0:0 LISTENING . TCP192.168.20.141:139 0.0.0.0:0 LISTENING TCP192.168.20.141:1045216.52.233.221:443 ESTABLISHED TCP192.168.20.141:982375.145.23.137:1914 ESTABLISHED TCP192.168.20.141:3389192.168.20.140:56293 ESTABLISHED TCP192.168.20.141:31438 75.145.23.137:2739 TIME_WAIT . As can be seen, the service is in running and my failed attempt to connect has been noticed. I've rebooted the server and still cannot connect. I've tried several variations of login credentials to no avail and am logged in via telnet on port 9823. A look at services shows that the UD RPC services, the UD Dbms, and the UD Telnet service are all running. I can open up a DOS window on my local machine and telnet theiraddress 31438 and connect, so I know the router is properly routing port 31438 to the correct machine. Does anyone know what I'm missing on my Sunday's sojourn in troubleshooting hell? Thanks, -- Bill Haskett * / Advantos Systems, Inc./ * ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
Hi Kevin They do the same thing in IIS. It is a security issue to restrict unauthorized users from accessing greater functionality. I would suspect this is to stop hackers being able to use SQL Queries to access the operating system and carrying out malicious activities. This is probably part of the security enhancements being made to SQL Server, maybe different patch updates between the 2 servers. Regards David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
Hi Kevin It maybe permissions on other folders on that server. I would suspect that OLEDB needs to hold data in a temporary area, that temporary area may not be the same level of permissions on the box that is failing. Calling within linked server may change where that temporary area is located. Have you been able to link from that SQL Server to the other SQL Server? Regards David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
Hi Kevin Are you putting the domain name in the username dn\user for the logon to Unidata? Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
Hi Kevin I suggest you try with the domain and see if that works. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Quick poll - how many use 3-tier or N-tier Architecture
Hi Baker We have 2 tier with the business rules in the database and a VB.Net frontend. We are also installing 3 tier with webservise based on IINet. The backend is UniVerse We use VB.Net as it has better interaction with office, that C# cannot easily do and it is easier for people who have not had C++ or java experience. C# developers can write VB, but VB developers don't easily handle C#, so I double the available developers with VB. We use subroutines in UniVerse as the business rules, and pass the data to datasets in .Net. Due to complexity, we find it quicker and better to keep the business rules in UniVerse Basic. As the business rules are integrated with the database, we believe there is a performance advantage over a middle tier business rule engine, but we have not tested that theory. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dynamic Connect - Mousing
Hi Bill This is a problem with Wintegrate and DC on Vista and Windows 7. I believe Rocket is looking at this, but you should make a support call to Rocket on this. If you use Windows 7, you could run DC through the xp virtual mode. You could try running DC in xp compatible mode in windows 7 and see if that works. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Wednesday, 7 April 2010 8:21 AM To: U2 Users List Subject: [U2] Dynamic Connect - Mousing An important user here (my boss) likes to use the mouse to move around our green screen applications. Although I have tried to discourage this type of mouse use, he asked me to find the answer. He tells me that this worked at one time. It is not clear to me if I changed our applications or if there were pertinent changes in subsequent releases of DC. When he does things like copy and paste say a six-digit part number such as 101234... When he pastes it, some screens will come back with 10?1234. Of course some screen validate keystroke entries such as... Read the first character of the PN and require it to be a 1 or a 3. Fixes would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
