Re: [U2] Saying Goodbye...
Kevin The only thing that I see holding us back is the maturity of our connectivity options It's not often I disagree with you, but here I must.. We don't lack mature interfaces. We have UO.Net; UOJ; web services - now both XML and JSON; WebDE - not to mention third party alternatives. Without even mentioning OleDb, ODBC, JDBC, ADO.Net .. I've been programming Windows since before Microsoft bought VB, most of my work is in Windows or Web and I earn my crust on both U2 and SQL Server. In my limited time I've used VB, Delphi, C#, PHP, ASP, ASP.NET and even java - urgh - all with U2. With that in mind I have to say that UniObjects is the best API I have ever worked with, bar none. It offers a clean, fast interface that other models just can't compete with and for any business logic the U2 subroutine is king. Give me U2 basic and UO or WebDE over the likes of ADO.NET and SQL any day, however you dress it up. There is no reason other than lack of ambition for U2 applications to look old. The technology is there, and has been there for a decade. Let's stop talking it down. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Can this be done with SQL?
George You need the HAVING clause to filter that way (and remember you can use COUNT(*) to get a count): SELECT GENRE, COUNT(*) FROM BOOK_TITLES GROUP BY GENRE; Genre. COUNT ( * ) BIOGRAPHY2 BUSINESS 8 CLASSIC 31 CRIME1 DRAMA 15 FANTASY 68 FICTION 97 HISTORY 9 HUMOUR 17 LANGUAGE 2 01 SELECT GENRE, COUNT(*) FROM BOOK_TITLES GROUP BY GENRE HAVING COUNT(*) 5 SQL+ Genre. COUNT ( * ) BUSINESS 8 CLASSIC 31 DRAMA 15 FANTASY 68 FICTION 97 HISTORY 9 HUMOUR 17 7 records listed. If you want to sort as well, it's easier to use a column alias: 01 SELECT GENRE, COUNT(*) AS BCT FROM BOOK_TITLES GROUP BY GENRE HAVING BCT 5 ORDER BY BCT; Genre. BCT... BUSINESS8 HISTORY 9 DRAMA 15 HUMOUR 17 CLASSIC31 FANTASY68 FICTION97 Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 15 April 2011 14:22 To: U2 Users List Subject: [U2] Can this be done with SQL? I have a DICT item CNT setup as an I desc as (1=1) We use it like: SELECT FILENAME BY FIELD BREAK.ON FIELD TOTAL CNT DET.SUP Which works great for giving counts of FIELD - but you can't sort by it, or select off it. I tried: SELECT FIELD,COUNT(CNT) FROM FILENAME GROUP BY FIELD; Which also does the same, hoping, I could add a WHERE COUNT(CNT) 1 but it won't allow you to add that clause on with out an error: What I want to know is which FIELD's in FILENAME have a TOTALCNT 1 Any ideas? (Either using TCL or SQL) UV 10 Thanks George George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] PDF Files directly from UniData or UniVerse
Doug Check out PrintWizard or my own offering, mvPDF. Since I see Bob has already given the low-down on PrintWizard, here's my 2 pence on mvPDF grin: - fast, as in very - capture and convert print jobs - PCL interpreter - generate merge forms from BASIC or UniQuery - fully featured report generator from Basic or UniQuery - report mining to capture existing reports and redesign them(*) - real-time two-way BASIC API - document mark-up - digital signatures (*) useful if you have a load of reports to restyle and cannot afford to QA the whole generation process as well, e.g. for financial/regulatory reporting. Full details and evals available at the usual place (www.brianleach.co.uk) Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: 12 April 2011 14:40 To: U2 Users List Subject: [U2] PDF Files directly from UniData or UniVerse Here is a question for this group. Has anyone been able to generate PDF files directly from UniData and/or UniVerse without having a manual step involved? In other words, just running a program using the standard PRINTER ON and PRINTER OFF commands, and having the output be a PDF file? Any pointers would be very welcome. Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [AD] Even more editors ..
All Just for completeness - In addition to the two excellent editors (Doug's and Charlie's) already mentioned - you can download my free screen editor (Z) and my free Windows based editor (mvDeveloper) from my website ... Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Databasic conversion
I'd second David's comment. UniVerse in PICK flavour is a closer fit to D3, though some of the issues around casing for files may still bite you (at least UniVerse Basic has always been keyword case insensitive). PROCs and paragraphs should come across fine, remember that paragraphs are PH not H types. Your dictionaries will generally work, but there is no *An equivalent or B correlatives. If you want to call a subroutine from a dictionary you need to use a SUBR() function in an I type. You are better off converting dictionaries to D and I types anyway, they work better with most of the advanced features (e.g. SQL and XML) and there is a conversion program hidden in the APP.PROGS file from what I recall. If you're using flashbasic with % calls, they will need to parsed out and replaced with equivalent functions, and the spooler is quite different. UniVerse supports some of the SP.. commands but frankly you're better off writing your own versions to map to the native SETPTR equivalents. Obviously any device control, terminal and printer settings, anything looking at system files and so forth will be the usual pain to convert. It all depends how vanilla the code is that you will be migrating. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: 07 April 2011 12:03 To: 'U2 Users List' Subject: Re: [U2] Databasic conversion UniVerse PICK flavour account would probably be - out of the box - the path of least resistance. As UniVerse emulates the PICK D3 environment much better than Unidata. Unidata was designed to be a clone of Prime INFORMATION - engineered from the manual up (which including doing this the PI Manual said it could do, but in reality it didn't almost do as published!). Bill H has nicely documented stuff for you already in his post and elsewhere on the Net: http://www.rhinocerus.net/forum/databases-pick/305503-migration-d3-universe- doco.html http://old.nabble.com/RE:-D3-to-U2---how-to-import-a-FileSave-tape-p4361606. html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 7 April 2011 7:14 AM To: 'U2 Users List' Subject: [U2] Databasic conversion Hi I am looking at a little side project to convert an entire system written in databasic on D3 to run on unidata. The guy i work with says it is a couple of hours work - I am not so sure myself. Anyone done this and know what the 'gotchyas' are ? Cheers Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Does anyone have an MV BASIC cheatsheet?
Hi Tony et al There's a simple reason why there aren't new books on this - it's very hard work! Creating any meaningful text on a system that is as wide and flexible as U2 takes many months of effort. In the three books I've written I've only scratched the surface. And given the size of the market, I can promise you - it's for love, not money ... grin. In my case it was partly a response to the fact that I can't offer U2 training in the UK any more - the exclusive agreements over here have blocked off that market - and because I've always enjoyed writing anyway. It's just not a commercial prospect. Incidentally, I *have* started revising my books, starting with the (free) guide to writing your first application, to cover UniData (they are all UniVerse based currently), to include some of the newer features and where to get stuff, and the newest Visual Studio for the client side stuff - now that Universe 11.1 is finally out. No doubt that will take a few months though. As to the books vs blogs question - they both have a place and they both offer different things. I have a shelf full of Microsoft books to build my understanding, but I still use CodeProject for specifics and even MSDN when all else fails. And Rocket *have* started to step up to the plate on this. The new developer zone looks like it is a good springboard. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 25 March 2011 20:14 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Does anyone have an MV BASIC cheatsheet? From: George Gallen Of course there is also the financial gain from the status of being a published author. George, toss that one by anyone in this market who has published a book, and see how far it flies. Jon? Matt? Steve? Harvey? Malcolm? (Most people here are saying who?) These days the blog is the new book (many of us blog books-worth of material each year) but that doesn't seem to be the marketing venue that most people would think either. Brian could comment on all of that too. ___ 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
Guys Can we reign this one in a bit: it's starting to get personal. That's against the spirit of this list. Brian ___ 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
Let's be clear about this - the support that we have asked for has been provided. There is nothing that we are being held back from doing due to lack of support from Rocket. What the group needs is not support from Rocket, we have that, it is the active participation of U2 users willing to put their time where their mouths are and contribute to what the group is doing. If you want to contribute start putting some ideas forward and volunteering time to put them into action. Eloquently put and right on the button. Brian ___ 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
Tony As always, you make some good points. I think maybe we I was wrong to talk about 'marketing' - a better word would have been 'awareness'. That's what we (U2UG) have to get to grips with, and haven't yet. One of the questions I hear all too often - and I'm sure others on the list do as well - is 'who else is using this?'. (and too often from senior managers who haven't heard of the technology and want to close it down). We all know, individually, that this is a thriving platform, powering applications in every business vertical and of every size. But the problem has always been the same - most MV developers feel they part of an isolated community, lone voices crying in the wilderness. We've spoken in the past about the age profile of the community as a cause for concern because we're not reaching younger developers. Not making the platform seem sexy. Frankly, the vendors and vars aren't going to solve these issues, for the reasons that George highlighted. So who will? Where groups like U2UG should be leading, is in making their presence felt and providing an opportunity for building that awareness. An in that I have to return to my main point - it's not the 9 people on board who matter, it's the users of the technology getting in contact with us and making use of us. Maybe the technology is so perfect that we don't need any changes (!) - but even if that were the case, we want/need people to know that there are others out there using this. So how do we go about that? (without spending money..) I've posted about the education agenda, trying to show what the technology can achieve. That's the first step - there is no point welcoming people to a technology they can't see or know where to begin. Then there's the wider context - one of the encouraging signs has been the growth in the number of blogs regarding multivalue. I would like to see the next stage translating into things such as postings on Code Project (which just about every other developer reads) and Tech Republic; kicking off some genuinely useful open source projects (watch this space!); postings to the website; discussions around the new features that have been/are being added to the products. Things that can show that this technology is alive. In today's world every post, every blog, every tweet, every article, every public discussion is a form of marketing. Just getting out there are saying - hey, I implemented SSL on UniVerse (and it worked) - is valuable. You can draw a comparison between our community and the PHP community. Like us, PHP was swimming against the tide and like us, does many things that the rest of the IT world is sometimes (and almost always wrongly) sniffy about. Like multivalue it can easily solve issues in ways that are usually simpler, faster and require less effort than the alternatives. It's never going to be the dominant technology, but it has a strong user base and strong awareness. Oh, and Microsoft is releasing a version for .NET. Of course, there are three key differences: It's open source, so anyone can play. It doesn't carry a lot of legacy. And the people who first used it were enthusiastic and told the world about it. That's what we're missing. Go Forth And Post. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects and java
Doug I would always recommend calling subroutines on the server, unless you have a pressing need not to do so. The biggest gain is for quality - it is much better to write and QA the back end code first, then write the interface code. That way you can work in the sure knowledge of the quality of the expected results, which makes debugging much easier should something go wrong - and you can create test routines for regression testing should things change. It also means any business logic does not get fragmented: good practice always dictates that any business logic should exist only once and in one location, so anything that could be shared between your client and any new or existing server code should be kept neatly packaged on the server - which is what a subroutine is for. I've posted before about having a single, centralized dispatch routine and a standard interface for client-facing subroutines: this adds a tiny overheads but makes it easier to put in logging, recording and playback of the calls. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: 14 March 2011 02:14 To: U2 Users List Subject: Re: [U2] Uniobjects and java thanks,can you give me some of the pros/con's? I have some ideas, (not passing huge amounts of data back and forth for one) but I'd be interested in hearing others, for the moment I think I will be calling subroutines but maybe down the road that may change (if the benefits out weigh a subroutine call) Currently all I think I will be doing initially is just getting data from universe dougc On 3/11/2011 4:09 PM, Symeon Breen wrote: Also think about how your app works - There are two ways of using uniobjects - you can just use it to call a sub and the sub does all the work and returns the data that you need (a quick in and out), or you can do all the file and record manipulation in the java layer. They both have pros and cons, the important concept is how long do you want to hold on to your connection into u2 for. Bearing in mind licencing issues, pooling etc. Rgds Symeon. 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] U2UG Elections 2010 - Request For Comment
Dan Thank you for your open letter. The questions are very pertinent. I'll leave it to the candidates to answer for the future, but if I can speak for past performance as honestly as I can - The board is composed of 9 people who are actively involved in U2 and give of their time freely. That is of course, a constraint in itself, since by definition those of us who care sufficiently to do this are also the busiest - but there is an old Yorkshire saying, if you want something done, ask the busiest person. So we have concentrated on those things we can deliver - educational materials, news, pushing for events like the U2 University, the UniVerse and UniData personal editions, the podcasts from Rocket - and feeding back information on the products either from our own experiences or, where our members communicate, on their behalf. In return, we get a great response from Rocket who give of their time to engage in dialog and to listen to that information. We can't guarantee that they will act on it (!) but we do get a say. That's important. Our failing is that none of us are marketing based: maybe it's the nature of this sector, but we are all techies or consultants of various types. That's just how it has played out - I'd love to see people with a wider selection of roles come forward for election. Plus of course, since we don't charge fees, we don't have any budget to advertise our presence! Because of that, we haven't really succeeded in pushing out the U2 message as we would like. But we have tried to make it easier for those who find U2 to get up and running and to work out just what this technology means and can deliver - hence the starter pack and the new incubator series we are launching. (If you have worked with this technology for many years it's easy to forget just how unfriendly it can seem to a newcomer with no background in our way of working, and that's something we are actively trying to engage with. There's no point saying to the world 'take a look here' if all they can find is a TCL prompt!) We are also here to represent the user community, but that is a two way thing. We have about 3,500 members signed up on the website: and if you are the only U2UG member at your site - tell the others! Get them to join, share, and don't be shy about contacting any of us. You'll find us at U2U events, writing for Spectrum, our own blogs and sites - as well as the U2UG site itself. And of course, we steward the user list on which we are talking now. And vote. Please. It only takes a moment. We can't make you talk to us or join in, but we can try to provide the mechanisms for you to do so. This list, the wiki, forums, news and events. But it's up to you - the community - to join in and make best use of us. As a user group we will only ever be as good as the community behind us. Brian Leach, Outgoing U2UG President. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: 15 March 2011 10:13 To: u2-users@listserver.u2ug.org Subject: [U2] U2UG Elections 2010 - Request For Comment Hi all, I've posted an open letter regarding the U2UG elections to the nominees. I'd love to see more dialogue around these elections as I feel I don't really know what I'm voting for when I place my votes. http://u2tech.wordpress.com/2011/03/15/u2ug-elections-2011/ Along with this, I also wonder how many people on this list are members of the U2UG and how many actually vote? I've never seen any numbers. I know I'm one of two out of the roughly 20 U2 people at my work who know of the U2UG and am the only member. Not the greatest odds. On the positive side, it leaves a lot of room to expand. :) Regards, Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] PROC language documentation
FWFW the proVerb guide is part of the UniVerse documentation set, you can download this from the rocket website if you don't have it to hand.. .. oh, and the free mvDeveloper has syntax highlighting for PROC .. talk about a clash of worlds :) Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon Sent: 15 March 2011 15:57 To: 'U2 Users List' Subject: [U2] PROC language documentation Group, I know I'm dredging up long ago memories but the company I'm working for now still has many PROCs running. I haven't used PROC for 20+ years now and I've forgotten most of what I did know. Never did like that cryptic language. That being said can someone on this list point me to some documentation on the PQN version? Thanks, Gordon Gordon J Glorfield | Software Application Developer | Vertis Communications 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664 | M 443-280-7093 gglorfi...@vertisinc.com | http://www.vertisinc.com Vertis Communications is a results-driven marketing communications company that delivers inventive advertising, direct marketing and interactive solutions to prominent brands across North America. Our deep industry knowledge and extensive range of offerings-including integrated data solutions, digital program management systems, creative services, world-class print and mail production, logistics, out-of-home and business process outsourcing-are used to deliver superior program performance that drives bottom line results for our clients. With 100 strategically positioned locations and more than 5,000 dedicated professionals, we deliver impeccable quality and fast turn-around to any market. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 PE Linux
All I'm told it is on the way - apparently it's been in the queue for getting onto the Rocket website for a couple of weeks now. Just like the other UniVerse 11 stuff :( It exists - really - I was able to get a private download direct from Rocket to test out a specific issue that I needed to sort before implementing on a live system. It appears the problem is not at the Rocket *U2* end but with whatever division runs their website. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2UG Elections Looming
All The International U2 User Group (U2UG) elections for the new board will be launching next week. For those who do not know, the U2UG looks after this email list, as well as providing advice, papers, knowledge base articles, a wiki and running many other projects to benefit the U2 community. The board meet with Rocket every fortnight to represent the concerns of the U2 community and to discuss the direction of the products. Board members give up a lot of their time for free. So we need your support. If you are already a U2UG member, please visit the website over the next few days to make sure that your email address and profile are up to date! Otherwise you won't receive the mails giving your election voice and your chance to vote - and keeping you in touch with the work that the U2UG are undertaking on your behalf. If you are not already a U2UG member, we urge you to join and make full use of us! It's free - just sign up on www.u2ug.org. Thank you Brian ___ 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 ..?
Almost all my frustrations are with Microsoft. Over half the development I did last year was simply handling differences between Win7x64 and previous versions.. which in turn meant upgrading my development platforms (Delphi and .Net) and dealing with THEIR backward incompatibilities, spending stupid amounts on new installation software to rebuild all my setups and discovering that they were also not backward compatible with regard to the plug-in DLLs I needed (and the first one I bought ONLY worked on Win7 and not on XP, as I discovered too late), and then changing my licensing routines and where I install data .. did you know that there is actually now NO place in Windows 7 where you can officially install updatable files that can be shared between users without breaking UAC? All of which has taken months of my time that should have been better spent on improving the products, not hitting my head against whatever walls Microsoft keeps raising. So compared to that, it's nice to have at least one platform (U2) that remains relatively stable! Rant over .. for now. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff Sent: 18 February 2011 18:43 To: U2 Users List Subject: Re: [U2] Frustrated with Rocket / Unidata 7.2 Yes, it appears to me that the issue I experienced was related to updated security in win2008, not in unidata. I've also noticed that every upgrade breaks something. Sometimes you get lucky and things run for 10 years, then one day, BAM! A program stops working after you upgrade the database. It's the nature of the job. Things change. Things break. Things need to be fixed. That is what testing is for. Jeffrey Lettau ERP Systems Manager polkaudio ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] UODOTNET.DLL and 64bit windows.
Jacques, I use UO.Net with Win7x64 all the time, without any problems. Can't speak for 2003, but I have a 2003 x64 box running the old COM version of UO. The only gotcha I'm found with UO on x64 is that if you are using the old COM version of UniObjects with Windows scripting (cscript or wscript) - which incidentally is an excellent way to do all kinds of admin and similar tasks - and you are on Windows 7, you need to use the version of cscript held in SysWow64 not the version in the regular path: otherwise it won't invoke UniObjects but won't give any errors either. Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: 17 February 2011 22:10 To: U2 Users List Subject: Re: [U2] [UV] UODOTNET.DLL and 64bit windows. Hello, I wanted to know if anyone here uses the Uodotnet.dll with 64bit versions of Windows. Particularly windows 2003. If so, which version of the uodotnet.dll do you use ? I am getting an Uodotnet error 81011 saying that the host is unknown. I am able do open a telnet session to the host and I specified the host with the ip address. I am getting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] RPL was Pick History et al
I actually wrote an RPL compiler for UniVerse - I guess that was about 15 years ago. It actually started out quite nice.. it did everything in the RPL81 manual and was a tidy piece of C on SunOS. Then I delved into the 'undocumented' functions .. and by the time I had handled as many of those as I could the poor compiler was completely unrecognizable and unmaintainable. Not soon after, my colleagues banned me from writing C/UNIX. Ever Again. I particularly liked the way you could arbitrarily kill entries from the return stack and jump into another routine bypassing 'n' statements. Using X for multiplication and for the exit command was nice too as was the fact that literals didn't need to be quoted. I do like reverse polish math.. it keeps you on your toes. Though the Microdata chaps missed a trick by not emulating the extended input statement and keytrapping when they did PROC. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: 08 February 2011 17:06 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RPL was Pick History et al In a message dated 2/8/2011 6:02:44 AM Pacific Standard Time, charles_shaf...@ntn-bower.com writes: In the late 80s I worked with Ultimate Pick on a VAX, running software from SMI. That system used RPL as its native programming language. This was the Ultimate PICK that ran on an add-in board. You are the first person I've encountered who ran Pick on top of VMS on the VAX. I am the only person I've met who run it on the MicroVAX. I added that to my article here http://knol.google.com/k/will-johnson/the-ultimate-corp-aka-ultimate-compute r/4hmquk6fx4gu/703#view ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Ultimate UPDATE process migration path ? anyone? anyone ?
Gosh, I *remember* that - and this just a couple of weeks after a PRIME user (current!) got me dusting off my old SIMPLE manual .. I don't know of a direct way to migrate the Ultimate UPDATE but it shouldn't be too hard to turn the update definitions into ENTER scripts - (free from my website grin). Worth a try anyway: sorry I can't be more precise but it's 20 years+ since I looked at UPDATE. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: 03 February 2011 22:40 To: u2-users@listserver.u2ug.org Subject: [U2] Ultimate UPDATE process migration path ? anyone? anyone ? Let's say, you happen to stumble across a site that is using Ultimate's UPDATE processor. Did any other vendor ever have a migration path off this ? Ever? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] 3.99 x 3 = 11
Kate The original A and S types on PICK-like systems were designed purely with integer arithmethic in mind - hence the use of the MDn and MRn conversions to scale and descale. They are not designed for floating point work, so it's no surprise they don't give the answers you expect. And with good reason.. Using non-integer maths is a very bad idea on *any* computer system since floating point operations are intrinsically inaccurate. Incidentally, a lot of SQL based financial apps do the same, even though there are high precision and decimal types available, preferring to store scaling factors alongside their prices to ensure they don't get hit by rounding/truncation errors, so it's not confined to our sector. And as for messing about with complex correlatives - why on EARTH would you want to do that, rather than just fixing the design? You've had 30 years to do so... BUT maybe it would be nice if it could be configurable, say through an entry in uvconfig, to work the same as an I-descriptor. I wouldn't want to see something that fundamental get changed, because it could well mess up other, well-behaved sites, unless it were a configurable option switched off by default. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: 21 January 2011 04:46 To: U2 Users List Subject: [U2] 3.99 x 3 = 11 Does anyone else have a problem with this? We have (for about 30 years) allowed users to use a decimal point when entering quantity. In the dim dark past (was it under Prime or Ultimate? don't remember) we discovered that correlatives ignored anything after a decimal point, so wrote horrible correlatives multiplying the bit before the point by 1, appending to the bit after, taking the first 4 chars of this and adding it, doing arithmetic then dividing result by 1. In the slightly less dim dark past (before 1997, when we introduced our current change control system), we noticed that this problem had been fixed, and removed the complication from correlatives involving quantity. Now, many years and much development later, we extensively use dictionary output rather than programs for reports, forms (eg invoices) and queries. Inaccurate data is an unexpected result. On type S (or A) dictionaries, result of calculation in A or F correlatives is truncated to the decimal point (eg 3.99 x 3 = 11). Minor result is incorrect figures. Major result is under-reporting of totals which are not able to be reconciled to General Ledger (eg value of stock on hand). Rocket's response is that the manual says correlatives only do integer arithmetic. This is not quite true, as integer 3.99 x 3 would be 9. I-type dictionary items handle the data correctly (3.99 x 3 = 11.97). I-types have their own problems, in that fields after 10 are used for internal purposes, so are not able to carry extra information needed for data entry (such as data required, display only, validation rules, data change stamp, etc. I-types also are hard to work with as using a changed dictionary without compiling the dictionary logs the user out, and inadvertent attempt to display data in fields beyond F10 can lock user up, as well as untidily logging out. We are asking Rocket to consider this a bug. What do you think? TIA, Kate Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uv SQL INSERT INTO error?
Hi Shane Not sure exactly what the problem is, but what happens if you rewrite this as: INSERT INTO myTable (val1, val2, val2) SELECT col1, col2, col3 FROM UNNEST table ON testAssoc WHERE col2 = '10-23-10'; I know it *should* be the same, but ... Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shane Ricciardi Sent: 20 December 2010 04:01 To: u2-users@listserver.u2ug.org Subject: [U2] uv SQL INSERT INTO error? Hi. I'm trying to INSERT INTO a table using results from a subquery that happens to reference multivalued columns that belong to an association. I keep getting the following error: UniVerse/SQL: No 'stored' columns were found defining association Does anyone know what the problem is? The @ASSOC_KEY.name dictionary is defined in the subquery's file like so: @ASSOC_KEY.testAssoc 0001 PH 0002 key col1 col2 Although col1 col2 are both i-descriptors. Here's an example of the SQL: INSERT INTO myTable (val1,val2,val3) SELECT col1,col2,col3 FROM table_testAssoc WHERE col2 = '10-23-10'; Thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Val on UniDynArray produces unexpected results
var1.Field(1).StringValue Do you mean that? Or do you mean var1.Field(1).StringValue ? Differences between the P-Code and fully compiled code have been a 'feature' of VB for a long time - the compiled code is generally more accurate/less forgiving and - whilst not relevant here - if you have any sort of multithreading in your code, that can operate differently. If you are concerned, can you send out the P-Code executable? On today's processors, the performance difference is unlikely to hurt. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Halid Sent: 12 November 2010 02:18 To: u2-users@listserver.u2ug.org Subject: [U2] Val on UniDynArray produces unexpected results Hi All, We have come across a very strange bug between UniDynArray and VB6. In our applications we were getting two different results on an if statement between the IDE and the compiled (into Native) exe. In the IDE case the statement was returning True which is correct. In the compiled native exe the exact same statement was returning false which is wrong as the statement should evaluate to true. If we compiled the exe into p-code then the statement evaluates to True as it should. The conditional statement seems to have to be in this exact structure (kind of like a perfect storm of conditions). ((var1.Field(1).StringValue ) Or (False And Val(var1.Field(2).StringValue) 0)) It must compare the same UniDynArray in each part of the if statement and perform a Val on the second UniDynArray. The issue can be demonstrated by the sample code below. We have two Booleans (b1 and b2) that should always evaluate to true. In the VB6 IDE b1 is true and b2 is true as expected. In the Compile Native exe b1 actually evaluates to false. (This is wrong b1 and b2 should always be True). --- Dim var1 As UniDynArray Dim b1 As Boolean Dim b2 As Boolean Set var1 = New UniDynArray var1.Field(1).StringValue = 1 var1.Field(2).StringValue = ' b1 and b2 should always be True ' When compiled into Native Code b1 is false and b2 is true. Why? b1 = ((var1.Field(1).StringValue ) Or (False And Val(var1.Field(2).StringValue) 0)) b2 = ((False And Val(var1.Field(2).StringValue) 0) Or (var1.Field(1).StringValue )) MsgBox b1= b1 and b2= b2 --- I know we can fix the problem quickly by swapping round the conditional blocks or create new variables to hold the string values and then compare them. My concern is that in our very large application what conditional statements could be failing in the executable we send out. Regards Adrian Halid Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P: (08) 9315 7000 F: (08) 9315 7088 E: adrian.ha...@itvision.com.aumailto:adrian.ha...@itvision.com.au W: http://www.itvision.com.auhttp://www.itvision.com.au/ ___ NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use, alteration, disclosure or distribution of this e-mail (including any attachments) by an unintended recipient is prohibited. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then delete both messages. ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Free software licence
Wol/Steve Thanks for the responses. I don't want the GPL as it's too restrictive - it effectively prevents anyone using the software in the context of anything that isn't GPL'ed, and I don't want to restrict that. For example, a plug-in to get SB+ information might need to call an SB+ process - and that would breach the GPL. Also, the LPGL isn't targeted at applications - just components if I read it correctly. I'll dive into the MIT in more detail and see whether it will suit. Thanks Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: 18 October 2010 00:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Free software licence On 17/10/10 12:13, Brian Leach wrote: All I've been planning for a while to release my system scanning tools (mvScan) as free/open software. That way, anyone can download and use it and hopefully people can choose to add to the library of plug-ins that are used to analyse specific entities - an example might be some plug-ins to add SB+ or SBXA tools into the map, neither of which I currently use. In fact, it's one of a number of tools I want to make freely available in the same way. The only stumbling block I'm hitting is trying to choose a licence. With so many 'open source' and 'free software' licences out there, I've just ended up getting more and more confused as I read more about the differences. All I want is a simple licence that will have the usual attribution and indemnity clauses, whilst allowing anyone to modify the software as they please and give it out as they see fit. Strong copyleft or weak, or not copyleft at all. I'm considering the MIT licence for the simple reason that it's short and to the point - but when I see it next to the likes of the CDDL I'm left wondering whether it is enough? What extra protection does the CDDL give? Most of the extra verbiage in the newer licences is due to the Americans getting themselves in a twist over patents - which are illegal in Europe (that doesn't stop the EPO granting them, though). Has anyone any insight to share on this? I'd probably go for either MIT or LGPL in your shoes. MIT gives freedom to the *developer* - any other software guy can take your code, put it in his product, and keep the innovations, bug fixes etc private to himself. LGPL gives freedom to the *code* - while any other software guy can take your code, put it in his product, and keep *his* *product* to himself, any fixes/mods/improvements he makes to your code, he has to share with his customers. I'd also add that MIT/BSD/GPL are well understood licences. The CDDL somewhat less so. The fact you didn't even mention GPL as an option makes me think MIT will be closest to what you want (that, and I think that the CDDL is a GPL-like licence...) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Member Newsletter -- DataVU
Brad It's imminent, but not formally released yet .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: 18 October 2010 15:39 To: 'U2 Users List' Subject: [U2] U2UG Member Newsletter -- DataVU I see no mention of availability or pricing on U2UG and no mention at all on Rocket.com. Does anyone know more? Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Free software licence
All I've been planning for a while to release my system scanning tools (mvScan) as free/open software. That way, anyone can download and use it and hopefully people can choose to add to the library of plug-ins that are used to analyse specific entities - an example might be some plug-ins to add SB+ or SBXA tools into the map, neither of which I currently use. In fact, it's one of a number of tools I want to make freely available in the same way. The only stumbling block I'm hitting is trying to choose a licence. With so many 'open source' and 'free software' licences out there, I've just ended up getting more and more confused as I read more about the differences. All I want is a simple licence that will have the usual attribution and indemnity clauses, whilst allowing anyone to modify the software as they please and give it out as they see fit. I'm considering the MIT licence for the simple reason that it's short and to the point - but when I see it next to the likes of the CDDL I'm left wondering whether it is enough? Has anyone any insight to share on this? Confused Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another undocumented Uniobjects error
Kevin It's the less than useful #define IE_SR_SLAVE_READ_FAIL 39207 /* Failed to read from the slave correctly */ If you have a copy of Universe you can find these in the gcidir/include/api_public.h file. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 22 August 2010 16:29 To: U2 Users List Subject: [U2] Another undocumented Uniobjects error Did some testing today to see if Uniobjects could still read data when the database is paused. Negative. In attempting to connect to Unidata via Uniobjects an error 39207 is returned. This error is of course not documented in the Uniobjects documentation. Is there a comprehensive list of UO error codes... anywhere? An error is an error is an error, I understand that, but I would sure like to understand all the ways this thing can fall down. -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
Re: [U2] Unix to SQLServer
David Three options really 1. BCI with suitable UNIX ODBC driver - EasySoft is/was the recommended choice. One of their guys is on the list, though IIRC they have changed their name. The advantage is that with BCI you are pushing, so you control the content and don't have do deal with the overheads in the odbc client. So long as you do it right (e.g. call sensible stored procedures on the SQL Server side, look at MERGE if using SQL Server 2008) you can get good volumes across. One of my clients uses it heavily for posting trades. 2. OleDB/ODBC etc. client using DTS or SSIS Can be hard work and slow depending on how well or badly defined your database is now. 3. Middle tier Pull out the data using UniObjects and post from a .Net middle tier. That's what my tools [AD] conduit [/AD] does or you can roll your own. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: 13 August 2010 01:24 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Unix to SQLServer In the dying months of our major application, we are looking at sending small amounts of data from UniVerse 10.0.16 HP-UX 11 to an SQLServer database every few minutes from a phantom. I assume ODBC would be the way to go, with middleware from someone. Which middleware do people recommend ? Is there any which doesn't require UniVerse to be stopped to install ? I looked on the Wiki but didn't find anything about this. Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * david.nor...@health.sa.gov.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Windows telnet client with PT200 emulation
Dynamic Connect has pt200. Don't know if it is accurate though - it's not an emulation I use. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Natasha Zagsky Sent: 12 August 2010 19:51 To: u2-users@listserver.u2ug.org Subject: [U2] Windows telnet client with PT200 emulation Can anyone recommend a telnet client for Microsoft Windows XP/Vista/7 with PT200 (Prime Computer) terminal emulation? Natasha zagskyzag...@hotmail.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] Looking for user groups
All The U2UG are assembling a directory of regional user groups (U2, MV, PICK). If you are a member of such a group, or know (up-to-date!) contact details for any of these groups, please drop me an email off-list. Thanks! Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] wierd error
Doug At the risk of stating the obvious, since this is a phantom are you sure it is running in the correct account? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: 22 June 2010 11:51 AM To: U2 Users List Subject: [U2] wierd error I am seeing a lot of the below error ue Jun 15 21:56:54 -8511 stepta Incorrect VOC entry for MO.BP. ue Jun 15 21:56:54 -8511 stepta Incorrect VOC entry for MO.BP in our errlog, the VOC entry looks correct to me: ED VOC MO.BP 3 lines long. : P 0001: Q 0002: EURO.PRG 0003: MO.BP Bottom at line 3. : and in EURO.PRG the voc looks like ED VOC MO.BP 3 lines long. : P 0001: F 0002: MO.BP 0003: D_MO.BP Bottom at line 3. I can list it just fine as well as run any programs in MO.BP Any idea whats going on? dougc. its a unix directory and we are running universe 10.3 on aix 6.1 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2911 - Release Date: 06/01/10 19:25:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Division Issues
Shawn If you are still getting issues and the issue is down to the division itself, you might want to try switching to string maths (HELP BASIC SDIV). It is slower but may give more accurate results in some cases. Remember that fractional numbers are not represented correctly in binary, and thus any floating point maths (whatever platform) are subject to rounding errors. Most financial systems for example scale up/down to integral values when performing calculations to avoid these issues. The fact that one of the numbers is showing as 0.399 suggests that it probably has more digits to follow... Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shawn Hayes Sent: 18 June 2010 9:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] Division Issues Hello, I ran into an issue when dividing 2 numbers. I debugged through the first program and here is the result... TEST1: 27: IF LOAD.VALUE THEN :: S TEST1: 28: ANS = TOP.VALUE/BOTTOM.VALUE ::S ::TOP.VALUE/ NUMBER: 0.3 :: BOTTOM.VALUE/ NUMBER: 0.006554707 :: ANS/ NUMBER: 61.02484472 I created a little test program to divide the same 2 numbers and I came up with this... TEST.DIV: 3: NUM1 = 0.3 :: S TEST.DIV: 4: NUM2 = 0.006554707 :: S TEST.DIV: 5: PRINT NUM1/NUM2 :: S 61.024848098 As you can see 61.024848098 does not equal 61.02484472? I have messed around with the PRESICION statement and I still have not gotten this to work? Can someone advise? Thanks!!! 'We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.' ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Internal Virus Database is out of date. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2911 - Release Date: 06/01/10 19:25:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SQL server to Universe via ODBC problems
Hi 1. The error messages themselves were stripped from the mail - please can you repost them (and not as images, the list server strips all attachments and non-textual entries). 2. You haven't said what version or edition of SQL Server you are running. 3. Whilst your query to analyze memory is interesting, it is of little use without knowing the queries you are executing against the linked server grin... can you provide some details of those? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of ptnaman Sent: 10 June 2010 3:34 PM To: u2-users@listserver.u2ug.org Subject: [U2] SQL server to Universe via ODBC problems This document describes a continuing problem we have been experiencing using a SQL Server linked server connection to an IBM UniVerse data source via ODBC. This issue manifests itself when querying the linked server, and appears to be related to an overall gradual loss of memory. We have tested using both our production server as well as a virtual test environment and see the same results. Universe environment Universe version 10.2.10 Microsoft Windows Server 2003 R2 Service Pack 2 In our production environment we are using the following versions: Microsoft SQL Server Management Studio 9.00.4035.00 Microsoft Analysis Services Client Tools 2005.090.4035.00 Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710) Microsoft MSXML 2.6 3.0 6.0 Microsoft Internet Explorer 7.0.5730.13 Microsoft .NET Framework 2.0.50727.3607 Operating System 5.2.3790 (Windows Server 2003 R2 with 32GB RAM) We use the UniOLEDB Provider for the linked server and we have checked for the latest UniOLEDB drivers. We have tried changing the MemToLeave area by setting the �g option to 3072 - which delays the problem but does not stop it from occurring, it just happens less frequently. In our virtual test environment, we are using the following versions: Microsoft SQL Server Management Studio 9.00.4035.00 Microsoft Analysis Services Client Tools 2005.090.4035.00 Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710) Microsoft MSXML 2.6 3.0 6.0 Microsoft Internet Explorer 8.0.6001.18702 Microsoft .NET Framework 2.0.50727.3607 Operating System 5.2.3790 (Windows Server 2003 R2 with 2GB RAM) In test, we have utilized the following query to monitor memory usage while performing large queries against the linked server: ;WITH VAS_Summary AS ( SELECT Size = VAS_Dump.Size, Reserved = SUM(CASE(CONVERT(INT, VAS_Dump.Base)^0) WHEN 0 THEN 0 ELSE 1 END), Free = SUM(CASE(CONVERT(INT, VAS_Dump.Base)^0) WHEN 0 THEN 1 ELSE 0 END) FROM ( SELECT CONVERT(VARBINARY, SUM(region_size_in_bytes)) [Size], region_allocation_base_address [Base] FROM sys.dm_os_virtual_address_dump WHERE region_allocation_base_address 0x0 GROUP BY region_allocation_base_address UNION SELECT CONVERT(VARBINARY, region_size_in_bytes) [Size], region_allocation_base_address [Base] FROM sys.dm_os_virtual_address_dump WHERE region_allocation_base_address = 0x0 ) AS VAS_Dump GROUP BY Size ) INSERT INTO tbl_chkMemToLeaveSpace SELECT GETDATE(), SUM(CONVERT(BIGINT,Size)*Free)/1024, CAST(MAX(Size) AS BIGINT)/1024 FROM VAS_Summary WHERE Free 0 The results of this monitoring have always shown that we start with approximately 836132KB TotalAvailMem and 122216KB MaxFreeSize. Then, as the queries run, the amount of available and free memory have continually dropped until there is only 2000-3000KB free, and then we see any one of the following error message(s) during any attempted query execution: (In this example � when we received this message, our monitoring showed 43248KB TotalAvailMem and 2728KB MaxFreeSize) OLE DB provider MSDASQL for linked server pauvqa1 returned message [IBM][UVODBC][000]Unable to allocate sufficient memory!. Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider MSDASQL for linked server pauvqa1. After trying to query a second time: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider MSDASQL for linked server pauvqa1 reported an error. The provider reported an unexpected catastrophic failure. Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider
Re: [U2] Langauge Def for Notepad++
Hi Dan Not notepad++, but I have a definition for the excellent TextPad and there's always the free mvDeveloper you can download. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: 28 May 2010 12:30 AM To: U2 Users List Subject: [U2] Langauge Def for Notepad++ Hey all, I seem to recall someone saying that they had a Notepad++ language def that would work for UniData. Does anyone know where I could get this or who it was that created it? Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2900 - Release Date: 05/27/10 19:30:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ and Abnormal termination of UV
Wol In BASIC, *EVERYTHING* is a string (apart from file variables). Therefore any comparison should be valid. To be more precise, no. UniVerse Basic is a run-time typed language (like PHP) not a string language. So it gets the performance and storage benefits of real types, and coerces between types under the cover. If you say For I = 1 To 10, and examine I in the debugger, you will see that it is an integer, not a string. If you later say I=FRED it will be coerced into a string, as will I := FRED or I2 = FRED. In addition to file variables, there are plenty other structures that are not coercible into strings: select list handles (from EXECUTE statement, SELECT. SOMELIST), XML DOM handles and BCI context handles to name but a few. It may seem pedantic, but these distinctions are important when selling the benefits of language like UniVerse Basic. The word 'untyped' offends some sectors of the programming community. 'run-time typed' is generally more acceptable. (and it's funny how many developers sneer at the first mention of these, until you follow up with the PHP analogy.. and suddenly they see the light). Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Question on Dictionary Items
Jim First value (a number of ways but this will work): 002 9 008 F;9R No, this means 'repeat the value in field 9 for the depth of the expression' e.g. if you wanted to multiply each value in a multivalued field with a single valued field to get a multivalued result. Last value: 002 9 008 F;9;P;S;_ Not sure what you're trying to achieve here. It's equivalent to @RECORD9 - SUM(@RECORD9).. Or am I missing something? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of James Patrick Volkman Sent: 24 May 2010 1:58 AM To: u2-users@listserver.u2ug.org Subject: [U2] Question on Dictionary Items Does anyone happen to know why these wouldn't work in Universe? First value (a number of ways but this will work): 002 9 008 F;9R Last value: 002 9 008 F;9;P;S;_ I can use an I-Type but I was hoping to translate off those values. Jim Volkman http://www.linkedin.com/in/jamesvolkman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2892 - Release Date: 05/23/10 19:26:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code 128 Soft Font
So $199 for Windows 7 Pro, plus $100 for the $100 for the software. 'Cmon, are you seriously saying you don't have any old windows boxes lying around your organization? I can't speak for PrintWizard, but mvPDF will run happily on an old Win2000 box. Like PW it's written in Delphi, it is lightning-fast and offers a serious set of tools for document production, ranging from a full Basic API for real-time drawing and rendering (useful if you want to control layouts precisely) through document capture, merge forms with the usual support for barcodes, images and graphics, PCL import with Epson format barcode escapes.. document encryption and digital signing .. direct print output.. oh, and a fully featured banded report designer, page designer, report mining and graphical zone editing to allow you to reformat existing reports without redeveloping them... Which is way overkill if you just want to print barcodes grin And no, there are NO plans to run under Linux (even using Kylix or FreePascal). The printer architecture is just too weak and patchy (said in sorrow, I've been a fan of Linux since Slackware 2.0). You could possibly thoroughly test and warrant with a very limited number of printer models, but only Windows realistically gives you a sense of confidence across all printer manufacturers and types. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XPath queries
Stuart This works for me: $INCLUDE UNIVERSE.INCLUDE XML.H XML = \?xml version=1.0 ?\ XML-1 = 'ABRPayloadSearchResults' XML-1 = 'first /' XML-1 = 'response' XML-1 = 'exceptionSome Exception/exception' XML-1 = '/response' XML-1 = '/ABRPayloadSearchResults' XML = Change(XML,@FM,Char(13):Char(10)) If XDOMOpen(XML,XML.FROM.STRING,hDOM) = XML.ERROR Then Crt Cannot open DOM STOP End GoSub Parse Ok = XDOMClose(hDOM) STOP Parse: * First get my context (ROOT tag) If XDOMLocate(hDOM,'/ABRPayloadSearchResults/response/exception',,hNode) = XML.ERROR Then Crt Cannot get element RETURN End Ok = XDOMGetNodeName(hNode,NodeName) Crt Node Name = :NodeName If XDOMLocateNode(hNode, XDOM.CHILD, XDOM.FIRST.CHILD, XDOM.TEXT.NODE, hTextNode) XML.ERROR Then ok = XDOMGetNodeValue(hTextNode, Value) Crt Value = :Value end Return Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: 20 May 2010 10:33 AM To: U2 Users List Subject: [U2] XPath queries Is it just me being dull-witted or do XPath queries in XDOM not work by name? Linux UV 10.2.7 I have spent quite a few hours trying to get something working and the only way I can get the node is to specify it by position rather than name. For example I have to use this format to successfully query if an 'exception' element exists: XDOMLocate(dh, '/*[1]/*[2]/*[last()]','',xh) instead of specifying exactly what I'm looking for with what I believe should be valid XPath: XDOMLocate(dh, '/ ABRPayloadSearchResults/response/exception','',xh) or even better: XDOMLocate(dh, '//exception','',xh) both of which return -1. Anyone got any clues? Cheers, Stuart Boydell ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2883 - Release Date: 05/19/10 19:26:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code 128 Soft Font
If you have to write a lot of PCL code then a product like print wizards seems a good investment, though. Put it this way - how much does your time cost your employer? If you roll your own it is going to take you a day to mess around with code, look up the printer escape sequences in manuals, get the positioning right (get it wrong the first dozen times), time taken in testing .. when you factor in the cost of your time, it doesn't take 'a lot' of PCL code to justify the cost of a tool. Or are you selling yourself too cheap? [ and BTW mvPDF Lite also does barcodes... and much more besides :) ] Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ and Abnormal termination of UV
Looks like putting a sequential file in a dimensioned array makes it go out and reserve a block of memory the size of the entire file. Doubtful.. I'm guessing under the hood the array will resolve to a series of pointers somewhere down the track, but those pointers will need to be cast to different types depending on what is being stored in the array - a variable, a file pointer, a sequential file pointer etc. So something in that cast will be wrong - it might for example be that whatever structure controls a sequential file originally contained a 32 bit address and now doesn't but the cast is still expecting that, or that it gets copied with an alignment change or something similar. In other words, typical C bug from a pretty unlikely occurrence. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] WORKING WITH PROMPTS
Jim, You don't say, so I'm going to assume UniVerse here. Yes, there are two ways you can do this in BASIC. EXECUTE creates a new workspace, so you need to either change to using PERFORM (which doesn't) or pass the prompt answers into that workspace. Here are the two syntaxes. Given the following test program: PROGRAM testWithPrompts Crt 'Enter something : ': Input Something Crt 'And something else : ': Input SomethingElse Crt 'You entered ':Something: ' ' : SomethingElse Crt That's All Folks STOP 1. Using DATA with Perform: DATA Hello DATA World PERFORM testWithPrompts STOP 2. Redirecting input to the new workspace: Prompts = 'Hello' : @FM :'World' Execute 'testWithPrompts', IN. Prompts STOP Result: RUN test.bp testPrompts Enter something : And something else : You entered Hello World That's All Folks Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of James Patrick Volkman Sent: 13 May 2010 6:13 AM To: u2-users@listserver.u2ug.org Subject: [U2] WORKING WITH PROMPTS I'd like to start off by saying I'm not a programmer. I'm trying to automate the running of a terminal program using the EXECUTE command in BASIC. When the program initiates a prompt comes up. I want to gain control of the prompt and send keys to the terminal. Is there a means in BASIC to gain control of the Prompt the way you would using WinActivate? I use a scripting language that allows you to send keys to the terminal using TERMKEY. Is there a way to do this in BASIC? I don't want to use Sendkeys because of the risk involved. This doesn't work. DATA Y DATA N EXECUTE PROGRAM Jim Volkman San Rafael, CA http://www.linkedin.com/in/jamesvolkman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2868 - Release Date: 05/11/10 19:40:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XML format question
George So to paraphrase, when do you use attributes to hold data and when do you elements.. The problem is, there is no clear answer to this, and everyone who designs XML schema has to grapple with this question. The only simple answer is that if a value could legitimately have an attribute associated with it to qualify it, it should be an element. So in your example, the precision attribute is qualifying the type/content of the Latitude element. But that is really just a design and not a technical choice. The real answer is more pragmatic - it generally depends on what the consumer of that data wants. In parsing terms, attributes and elements are not the same so if the contract calls for an element, use an element; and if it calls for an attribute, use an attribute. It's a question I've asked lots of times and never really had a solid or consistent answer. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 13 May 2010 4:06 PM To: U2 Users List Subject: [U2] XML format question I'm importing some XML, and a question came up with the following: I'm writing a small xml extraction program to setup a dynamic array, what is the difference between putting a field inside the label vs putting the field between the tags of the label? Aren't they both a subset of the label? I always thought that if the field was a single value field, it would be quoted and inside the label, but if it could be a multivaled field, it would go between the field tags, with it's own field/tags. Result precision=addressLatitude39.931085/Latitude Longitude-77.387943/LongitudeAddress1001 N Some Rd/Address CitySomewhere/CityStatePA/StateZip15063-1404/ZipCountryUS/Cou ntry /Result Could this have formatted just as well as: Resultprecisionaddress/precisionLatitude39.931085/Latitude Longitude-77.387943/LongitudeAddress1001 N Some Rd/Address CitySomewhere/CityStatePA/StateZip19063-1404/ZipCountryUS/Cou ntry /Result or Result precision=address Latitude=39.931085 Longitude=-77.387943 Address=1001 N Some Rd City=Somewhere State=PA Zip=19063-1404 Country=US/Result George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2870 - Release Date: 05/12/10 19:26:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] fnuxi problem
Martin The obvious choice would be uvbackup and uvrestore, but failing that you're going to have to do some scripting. How about: Run a find for all the VOC files - that will get you all the account directories. Redirect that to file. Edit it to remove all the /VOC so you're left with the paths. Edit the file (or cat it into a script). You want to run fnuxi against each of those top level account directories for all files and directories contained, but not recursively. From memory a for..done loop should that, something like: for file in account_directory/*; do; fnuxi $file; done Sorry it's been a while since I've had to do this: I use my own packaging tools. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: 13 May 2010 3:48 PM To: u2-users@listserver.u2ug.org Subject: [U2] fnuxi problem Hi all, I am on a UniVerse client site trying to move an application with a vast number of dynamic files, some indexed, from UV 10.1.18 on a Sun Solaris box to UV 10.3.6 on a Red Hat Linux Intel box. The data files were moved with tar and byte order conversion was done using find . -type f -exec fnuxi {} \; This appeared to work but, on testing the application today, it now seems that it skipped quite a few files along the way. Given that fnuxi is supposed to ignore files that don't need conversion, I simply ran the process again. It hung after converting a number of files, looping at 100% cp. In an attempt to make this restartable, I created a shell script with each file as a separate fnuxi command. Again, this works for a while and then hangs. At each hang, I note the failing file, remove everything down to that point from the script and try again. The hangs are so often that this has become unworkable (there are about 400,000 files in the list). Repeating the fnuxi for a failing file sometimes fails again and sometimes works ok. I have also seen it fail with a segmentation fault. Some of the hangs are on the data files, some are on indices. I have even used filepeek to walk through a failing file looking for ideas about why it hangs. So, has anyone experienced the same problem and, far more importantly, has anyone got a fix or an alternative suggestion of how to move this system? Thanks. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2870 - Release Date: 05/12/10 19:26:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Just testing
It's very quiet.. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Printing images
Harold Forgive me if I take this step by step. A JPEG is a compressed image format, one that is understood by Windows and some other platforms. But it's not understood directly by printers. You can convert it to a bitmap (in fact, Windows does this internally when it renders it) which represents an image as a series of bits, with the header defining how those bits make up the image: the size of the image, the number of bits required to represent each color, possible color map etc. But the only reason Windows understands that this is an image, is because it looks at the file extension and because it can read and interpret the header and content. So Windows will display it. Windows will also print it, because it runs printers in graphics mode over a subsystem called GDI (Graphics Device Interface). This effectively defines an API through which Windows can make its font and graphics calls, such as Rectangle, Ellipse, DrawText and image placement. Each printer driver is responsible to translating these calls into whatever underlying instructions make sense to that style and make of printer. In other words, the printer itself does not generally understand the same image formats as Windows. Only the printer driver understands those and converts them into something the printer will understand. Now to add to the confusion, printers generally run in either text mode or graphics mode. Windows runs your printers in graphics mode so any font, for example, is actually rendered as the picture of the font. UniVerse, being text based, runs the printer in text mode so that you need escape sequences like PCL to do primitive font handling and line printing operations - just like a terminal. But unless you want to play with the raster formats in PCL, or roll your own instructions in the graphics language, if you want to print images you need to either: a) print the image under Windows and capture the output from the driver that would normally be streamed to the printer. This is possible but you can't then easily modify it. b) use some translation software that can be driven from UniVerse but actually renders images, fonts etc under Windows (or equivalent). mvPDF and PrintWizard will both do that, as may other software. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: 10 May 2010 8:01 PM To: U2 Users List Subject: [U2] Printing images All: In Universe I am able to use PCL commands to customize printing, fonts, spacing, orientation, etc. I'm sure many of you do this. For example by issuing CHAR(27):'(10U':CHAR(27):'(s1p09v0s6b16602T' in front of text the printing is Arial 9 bold. However, I have been unable to figure out how to print images from within Universe. Something to do with 'bit map', but I can't seem to get it. I have a file containing JPG format images. I can copy a record from this file to a windows directory and easily display the image using windows tools. But, how to get the same binary sent to a printer and print that image? Has anyone been able to do this? Thanks! Harold Harold D. Oaks Sr. Analyst/Programmer Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2864 - Release Date: 05/09/10 19:26:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ERROR IS NOT A UNIDATA DATA FILE
Wally Thanks for this. Good to know. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: 06 May 2010 6:36 PM To: U2 Users List Subject: Re: [U2] ERROR IS NOT A UNIDATA DATA FILE IF you encountered the problem I described below, it could also be corrected in a 'live' file (vs restoring from backup) using the UniData fileview utility. In this case the modulo in the file header of the dat001 file would need to be adjusted to match the current modulo recorded in the file header of the over001 file. If anyone is interested in the details - if mrparkland wants to provide the output of the following commands run on a the problem version of the file, I could provide the repair syntax: From the shell in the account directory where the INVOICES file lives: fileview -p1 INVOICES fileview -o1 INVOICES regards, Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 ..Denver, CO 80237 ..USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Address Sent: Thursday, May 06, 2010 8:48 AM To: U2 Users List Subject: Re: [U2] ERROR IS NOT A UNIDATA DATA FILE We are on 7.2.2. We where able to restore the file from our backup. This file is small. The modulo is 99. Blocksize is 2048. We use FAST to resize our files. --- On Thu, 5/6/10, Wally Terhune wterh...@rocketsoftware.com wrote: From: Wally Terhune wterh...@rocketsoftware.com Subject: Re: [U2] ERROR IS NOT A UNIDATA DATA FILE To: U2 Users List u2-users@listserver.u2ug.org Date: Thursday, May 6, 2010, 10:30 AM The only way that I know that this can happen within the UniData engine is by using CONFIGURE.FILE to set MINIMUM.MODULO lower than the modulo they dynamic file was originally created with - and for the file to merge as records are deleted. This is fixed at 7.2.5 by a change to CONFIGURE.FILE to not allow this setting to occur. So: either upgrade to 7.2.5 or don't use CONFIGURE.FILE to change MINIMUM.MODULO setting to a number smaller than the original modulo - on a file that has the potential for merging. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2856 - Release Date: 05/06/10 07:26:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] -1 and Null values
In UniVerse this is configurable via the $OPTIONS EXTRA.DELIM flag as well as being flavor dependent. But also in UniVerse, there is a specific null value (@NULL) as opposed to an empty string which is logically different. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What a Long Strange Trip This Has Been!
Hi Karen Just because you're entering the Dark Side, doesn't mean you have to unsubscribe - MV has a habit of drawing people back, you know (you'll never escape). And don't forget, many of us use .Net with uv... Congrats Brian ___ 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
Kevin If you are running SQL Server authentication (which was one of your tests) it takes on the permissions of the service user. Is that configured the same on both boxes? Also from researching other postings this is not a U2-specific issue - I've seen the same reported for e.g. DB2 and PostgreSQL. Is there anything in the event viewer about permission or launch failure? Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: 20 April 2010 11:20 PM To: U2 Users List Subject: 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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.801 / Virus Database: 271.1.1/2823 - Release Date: 04/20/10 13:45:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Updating SQL database from Universe 10.3
Yes, I've worked on various systems that do this. Those that run under Windows generally use the built-in BCI (ODBC) interface which is fast and effective - depending of course on what you are calling at the other end! As always the usual rules apply about calling stored procedures being generally much quicker than firing off inserts and updates. For UNIX based sites there are plenty of third party solutions - I have a simple one called conduit for example, and there are plenty others out there. There is cost involved, but there is also cost in purchasing ODBC drivers and driver managers for UNIX if you want to go the BCI route. You pays your money and you takes your choice. The real issues are generally not around connectivity. They are around normalizing the data and cleaning up the crap that accumulates in more forgiving legacy systems, especially if you are going to be loading lots of historic data. That involves not only dealing with poorly managed data - which can happen - but also with data whose meaning has changed over time. That's a whole different subject. And when you say 'legacy' I assume you're talking about the application and not the platform... Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aramaies Sent: 14 April 2010 8:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Updating SQL database from Universe 10.3 Good Day, I need to update SQL database/tables from Universe, and I was wondering if anyone has done this in production mode in real-time mode. I will be updating the files in the legacy platform, and then I need to perform real-time updates on SQL database. Best regards, Ara Baghdasraian /USC ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.801 / Virus Database: 271.1.1/2809 - Release Date: 04/13/10 21:22:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] import data to excel sheet...
Hi Chris I would investigate Tony's product first - that may well save you a bunch of work. I'm generating OpenXML from a number of different places - so if your requirement is for UniVerse only I'd look to Nebula and see if it covers your needs. If you do find afterwards that you still want to look at OpenXML, it's reasonably simple to update and manage but you need to invest some time understanding the structure. Essentially, it's based on something called Open Packaging Convention which is a zipped archive under the hood - though not compatible will all ZIP programs :(. Within that archive, the content is divided into a number of separate 'parts' all of which link together to create a document - so a Word document will have separate parts for the main body, section headers and footers, media elements, embedded pictures etc. Once you have walked through that maze, the spreadsheet markup is simple as far as the data content is concerned: there are some gotchas when reading data (shared strings, for example) but you can generally avoid them all if you are the one generating it. All the content is separated from the styling, and held in a simple sheetData element for the chosen worksheet. Each worksheet is a separate XML doc within the archive. The difficulty is in adding new styles for formatting, simply because the format there is very verbose. Your best bet is to create a template, apply various styles within that template to dummy cells and save it. Then you have all the styling information ready to use and you can simply apply them to your cells by adding a style number attribute. It's worth noting that OpenXML was introduced as the standard format for Office 2007, but there is a free download from Microsoft called the Office Compatibility Pack that lets earlier versions of Office read and write in that format. I'd recommend the free eBook 'OpenXML Explained' by Wouter van Vugt. IIRC it's downloadable via www.openxmldeveloper.org. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] import data to excel sheet...
Chris I'm using OpenXML to create spreadsheets in Excel 2007 format: and writing a series in Spectrum about it. You can create the spreadsheets directly from UniVerse by treating the content as XML (with a number of caveats) or you can call out to something external that will build it using the OpenXML SDK 2.0 or an equivalent toolkit. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 13 April 2010 3:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] import data to excel sheet... I was curious if there is an easy way to add font formatting to the .CSV files I have been creating from UniVerse. Right now we just write to a sequential file and call it name.csv and just use comma's to separate the data. We then use a carriage return CHAR(13) to return to the next line in the spreadsheet. If I wanted to make a word appear as blue or in bold, how are you guys doing this? Thanks. -Chris Date: Mon, 12 Apr 2010 11:47:20 -0700 From: jacque...@yahoo.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] import data to excel sheet... Hi Jaweed, If you already produced a number of files with the CHAR(13) as the end of line separator, you probably still handle them with excel, if you change the file extension from .csv to .txt and when you are in Excel import wizard, specify that the origin of the file is Macintosh.Since the Mac uses CHAR(13) as an EOL separator, the import should work. - Original Message From: Robert Houben robert.hou...@fwic.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, April 12, 2010 12:01:03 PM Subject: Re: [U2] import data to excel sheet... Hi Jaweed, I haven't looked too closely at your code, but I did notice on thing that I would consider the most likely candidate: CHAR(13) is a carriage return, not a line feed. Try using CHAR(10) instead for your LINE.FEED variable. You might have to use CHAR(13):CHAR(10), but I think CHAR(10) should do it. Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed Sent: Monday, April 12, 2010 7:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] import data to excel sheet... Can anyone tell me what is wrong with the following code for importing data from txt file to an excel sheet, when its launch Excel it giving some error message, but when I open the downloaded file from my disc, all the data is in one line with some especial Chars. Any help will be appreciated. 034: ** 035: * OPEN FILES * 036: ** 037: ERRMSG = '' 038: OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE 039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!' 040: END 041: IF ERRMSG THEN 042: GOSUB 91000 043: RETURN 044: END *--: P 045: ** 046: * INITIALIZE * 047: ** 048: PAGE.FEED = CHAR(12) 049: LINE.FEED = CHAR(13) 050: ;* 051: ;* Read the text file to convert 052: ;* 053: READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE 054: ERRMSG = ITEM : TEXT.REC.NAME : DOES NOT EXIST IN : TEXT.FILE.NA ME 055: GOSUB 91000 056: RETURN 057: END 058: ;* 059: ;* Set default values (none are used now) 060: ;* 061: VALUE = DEFAULT 062: LOCATE PROPERTY IN FORMATSTR1 SETTING PTR THEN 063: VALUE = FORMATSTR2,PTR 064: END 065: ;* 066: ;* Remove the first line if it contains a PAGE.FEED *--: P 067: ;* 068: LOOP WHILE TEXT.REC1 = PAGE.FEED DO 069: TEXT.REC = DELETE(TEXT.REC,1) 070: REPEAT 071: IF TEXT.REC1[1,1] = PAGE.FEED THEN 072: TEXT.REC1 = TEXT.REC1[2,LEN(TEXT.REC)] 073: END 074: ;* 075: ;* Find the header for each page 076: ;* 077: SLK.REC = '' 078: SLK.ROWS = 0 079: SLK.HEADER.LINES = 0 080: IF TEXT.REC1[1,10] = RUN D - T: THEN 081: SLK.REC-1 = F;SD;R3 082: SLK.REC-1 = F;SD;R4 083: SLK.REC-1 = C;Y1;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC1[1,30],';',';; '))) 084: SLK.REC-1 = C;Y2;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC2[1,30],';',';; '))) 085: SLK.REC-1 = C;Y3;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC1[31,90],';','; ;'))) 086: SLK.REC-1 = C;Y4;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC2[31,90],';','; ;'))) 087: SLK.ROWS = 4 088: SLK.HEADER.LINES = 2 *--: P 089: END 090: ;* 091: ;* Find the number of lines in the header 092: ;* 093: LINES = DCOUNT(TEXT.REC,@AM) 094: SLK.HEADER.CNT = 0 095: FOR IDX = SLK.HEADER.LINES+1 TO LINES 096: IF INDEX(TEXT.RECIDX,---,1) THEN 097: SLK.HEADER.CNT = IDX 098: EXIT 099: END 100: NEXT IDX 101: ;* 102: ;* Find the column locations 103: ;* 104: COL.LIST = ''
Re: [U2] Quick poll - how many use 3-tier or N-tier Architecture
Hmm, I'm guessing what's behind the question is the need to respond to the usual 'this is a legacy text based system' nonsense. If I'm wrong in that, please forgive the following soapbox! I haven't written text based stuff in years (unless I have no choice), so practically every system I've worked on in the last 10 - 15 years has been client/server or web - whether that's been VB, Delphi, ASP or .Net, using UniObjects, UO.Net, RedBack or equivalents. Point is - these things have been around a long time. For those who bang on about the perceived lack of front end development tools for U2 (and you know who you are!) it's worth pointing out that U2 has an excellent IDE - it's called Visual Studio. No different in that respect to SQL Server.. except the combination of UO.net and UniVerse Basic is often much neater - and for complex operations, quicker - than the equivalent SQL Client/TSQL/SQL CLR combinations grin. If UniVerse Basic looks old-fashioned, just look at the average TSQL procedure: sexy it ain't. And the great advantage of U2 is that you *don't need* traditional n-tier - your Business Logic (BL) tier belongs in the database. In fact, I prefer not to think about U2 as a database. It's much more appropriate to legitimately present U2 as a business engine - one in which BL, DAL and data storage layers are all resident in the same space. Which is a huge saving in efficiency. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SQL Equiv to Save-list?
If you mean UniVerse SQL - for a regular query in the same way as a retrieve statement, you can supply an active select list using the SLIST clause. SELECT BOOK_TITLES WITH GENRE = FICTION SELECT * FROM BOOK_TITLES SLIST 0 But if you're not using it in the same way as a retrieve statement i.e. not as a key filter, or using a different SQL variant you will need to create a temporary table to join or a sub query (which often creates an internal temporary table anyway). Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 08 April 2010 4:03 PM To: U2 Users List Subject: Re: [U2] SQL Equiv to Save-list? So for each listname you would need to create a new temp table, and clear the table prior to saving a list? Thanks for the info... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, April 08, 2010 10:55 AM To: 'U2 Users List' Subject: Re: [U2] SQL Equiv to Save-list? INSERT INTO temptable (customerid) SELECT customerid FROM invoicefile You then have your temp table with customerIDs so can use as such select cust.name , cust.addr , cust.city from customerfile cust inner join temptable temp on temp.customerid = cust.id where cust.st = 'ny' So you can then do -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 08 April 2010 15:09 To: U2 Users List Subject: [U2] SQL Equiv to Save-list? Is there a way in SQL without resorting to subqueries to select a table, then save the resulting field, Then use that list for a future SQL query? ex. select customerid from invoicefile; save the list of customerid for later use later get that list of customerid select cust.name , cust.addr , cust.city, etc from customerfile where cust.id=(list of customerid) and cust.st='ny' Or is this one of those pick ain't it great we can do this features? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.801 / Virus Database: 271.1.1/2796 - Release Date: 04/07/10 19:32:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BDT is anyone using it?
You will never get this kind of response from any of the other developer you mentioned below Er.. because mvDeveloper already had locking in the first place?... grin Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of D Averch Sent: 05 April 2010 2:33 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] BDT is anyone using it? Hi Glenn: I have changed our XLr8Editor today to lock UniBasic code while you edit. You will never get this kind of response from any of the other developer you mentioned below or Rocket Software for a feature you got to have. Are you going to put money where you mouth is and buy XLr8Editor for $49.00? Regards, Doug http://www.u2logic.com/tools.html Date: Sat, 3 Apr 2010 11:27:09 +0200 From: glenn.sal...@nl.flextronics.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] BDT is anyone using it? Hi Doug, The BDT certainly seems like the basis of what could become an excellent tool, however, I am not willing to edit programs without locking in place, and as far as I can tell the BDT does not lock the program for editing, which is asking for trouble. I find a mixture of ED and mvDeveloper provide me with the ammunition I need, although I am also enjoying playing with Accuterm and WED at present. Regards Glenn _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28 326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.800 / Virus Database: 271.1.1/2791 - Release Date: 04/04/10 19:32:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CPU Spikes to 100%
Usually because a client has closed their terminal emulator without disconnecting nicely. The process loops attempting to read from the socket. No remedy but to kill the process. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt Stewart Sent: 25 March 2010 9:46 AM To: 'U2 Users List' Subject: [U2] CPU Spikes to 100% The environment is a virtualized Windows 2003 Server and Universe 10.2.10 On occasion, Ive been notified twice, it may have occurred more often, a Universe process (tl_server.exe) will consume 100% of the CPU. When this happens, support is automatically notified and they need an explanation. As far as the application goes, there is only one background job and all other jobs would execute immediately. I was last notified when it occurred at 2:20am on the 3rd and then again apparently this week. There are some users based in India that could be using the system at the time these occur, but I have not been able to make a connection to a user process yet. Doe's anyone have any ideas why this might be happening or suggestions on how to identify what ever is causing the spike? Is there a Universe log that might be able to give me a clue? Thanks for any suggestions. Curt Stewart TRI-SYS Consulting Integrated Multi-Value Business Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.791 / Virus Database: 271.1.1/2767 - Release Date: 03/24/10 07:33:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2UG news (was Pick Pocket Guide)
All, 1. The good news is that the U2UG board has agreed to push ahead with our incubator project this year. This will combine learning materials and sample applications aimed at bringing the platform in front of genuinely new developers who have not encountered any flavour of multivalue before. The aim will be to make it as easy as possible to get people up and running to the point where they can seriously evaluate the technology, and to showcase the best that it can offer. No doubt we will be seeking volunteers along the road. We will be discussing exactly what we need to include, and how we will be developing these at the next board meeting (in two weeks' time). We already have a number of ideas taking shape, but in the mean time, suggestions are welcomed: just send them to me offlist and I'll keep everyone posted. Once we have a good batch, I'll add a new forum to the website dedicated to discussing and furthering this topic, since it is such an important piece for us as an industry. NOW - since we're going to be giving up a lot of time for this - we want something in return! Listen up! 2. One of the major problems has always been visibility. With the loss of the IBM name, that visibility has taken another dive. The best way to get that visibility and credibility back, is to be able to tell prospective customers and developers just how widespread this technology is. Which means, being able to tell them who is using it. I know we have top companies in every industry sector using U2. Half of them don't even know that there are other people in the same industry using it. And it makes them feel isolated and worried about the platform. We need a way to tell the world 'We Use U2'. So we are going to be launching an initiative for people to tell us that. No more than that - they don't need to tell us anything secret, how they are using it, what they are doing with it, nothing that points to a competitive advantage. Just that they are amongst the thousands of organizations that use it. So watch this space and think about how you can add your organizations names to this list. You might be surprised how many others are out there. Regards Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] visual source safe plugin with basic developer toolkit
Ditto. I've found it the easiest to use with tortoise SVN for the desktop. But then, I don't use Eclipse or BDT. Tip - you also need to version manage other assets such as dictionaries. I've found the easiest way is to build my tables using definition scripts (similar to a create table statement in SQL) and to then version those scripts as part of the source code. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 24 March 2010 10:05 AM To: 'U2 Users List' Subject: Re: [U2] visual source safe plugin with basic developer toolkit I use subversion for both my .net and unibasic code. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of djordan Sent: 24 March 2010 07:39 To: 'U2 Users List' Subject: Re: [U2] visual source safe plugin with basic developer toolkit Has anyone tried the Microsoft visual source safe plugin for eclipse with the basic developer toolkit. I was trying to see if I could use a common source control mechanism for the .Net and unibasic code. http://sourceforge.net/projects/vssplugin/ Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
When Microsoft first released Silverlight - the first books were from Microsoft themselves, the others quickly followed. You have just highlighted the essential difference between books and software.. Software is a single sale: you buy that product from the manufacturer and don't buy a rival product to do the same thing. That's not true with books - to take the Silverlight example, I have half a dozen different books on Silverlight on my shelves, each offering a different perspective and level of detail. Personally I've always found the microsoft press books rushed and full of errors, but I still buy them for the few useful nuggets they will hold, generally before the better written ones come out :) But all these things go hand in hand: We need new blood if we are going to support authors - since the hairy old MV developers won't be the ones buying books even though they can help bring their skills up to date with the new features in the products or up to date techniques. (It's the old 'this technology is easy so I shouldn't have to pay out for what I can work out by myself' argument - even though it's cheaper in the long run to get the advice rather than sacrifice paid time to do it yourself. See also: 'Not invented here syndrome'). But to attract that new blood, we need the publications and educational materials in place to tell them about the technology in the first place. Which is why the incubator project at the U2UG is such an important piece in this discussion. And why I will inevitably keep banging on about it for the next 12 months - you have been warned grin. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
Lloyd Thanks! Yes, I use Lulu because the volumes are so small and since they are US based - as is most of the readership - they can dispatch directly to the client rather than my having to dispatch them from here. The downside is the lead time for production. But 'windbag' or not Tony [grin], don't underestimate the amount of work required to create these - they take literally months of effort and if I were looking on a purely commercial basis they would be a non-starter for that reason. I write the books because I enjoy it, and I because I love this technology. The sales are a bonus. BUT it does lead into another soap box of mine: if you were searching for a book on this technology, what do you search under? The fact that there are no generic names for this market space, other than the 'multivalue' name that only participants understand, is one of my pet hates. Everyone understands the name SQL even though different variants are largely incompatible. Yet we can't even agree on one, single, sensible name for our query language: it's even different between the two U2 products! So if, for example, you wanted a book on the query language, are you looking under: Retrieve, UniQuery, AQL, ACCESS, ENGLISH, INFORM, JQL ... Yes it's fine to have all these trademarked variants - just like TSQL and SQL*PLUS - but the fact that after all these years the vendors still cannot bash their heads together to come up with a single, overarching and generic term just frustrates the h*ll of out me. And the other pieces are no better (BASIC, UniBasic, UniVerse Basic, DATABASIC, DATA/BASIC, PROC or PROVERB ...) I've raised this with the various vendors several times over the years, and it has always falled on deaf ears. But until we can start to just refer to our technology sensibly, it is always going to be an uphill struggle reaching beyond our community boundaries. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lloyd Cottrell Sent: 23 March 2010 3:01 AM To: U2 Users List Subject: Re: [U2] Pick Pocket Guide I would talk to Brian Leach about how he publishes his. If I'm not mistaken they are printed on demand. I have bought a few from him, and they are very good quality. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.791 / Virus Database: 271.1.1/2763 - Release Date: 03/22/10 07:33:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
'twas indeed. It's a timely point, because the new user group board are going to be discussing our projects for the coming year and introductory materials/sample applications and such like are very much in the frame. So nomenclature is something we will need to address if we're not going to confuse people from the very start. From that point of view, it's a pity that mvBase and mvEnterprise exist otherwise we could carry the 'mv' naming further as the standard, but they will be too heavily associated with those products. The Pick name has fallen out of favour, and in any case largely describes the operating system which is viewed very much as a historic platform. So suggestions welcomed. If people want to email me suggestions off-list, then I'll collate them together and put them back to the list for discussion/vote (rather than let it turn into the usual ramblings grin). Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: 23 March 2010 10:22 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick Pocket Guide Maybe instead of waiting for the vendors to agree, we, the community should come up with our own name for the environment. IIRC, multivalue was not thought up by a vendor. Wasn't it our past editor of Spectrum who came up with that name? W.J. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.791 / Virus Database: 271.1.1/2763 - Release Date: 03/22/10 19:44:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide
Tony As always you make some good points. 1/ It's not the term MultiValue I have a problem with - that we should continue to support since it already has a meaning and a presence, and one worth building on. For one thing, MVDBMS is a nice abbreviation! It's the terminology used within that, that is the problem: for example, I want to put some web pages out giving an introduction to the query language. What do I call it? If I use the word 'RetrieVe' that alienates every other variant: if I mention all of them, it just gets silly. Even writing purely for U2, the fact that there are two names - RetrieVe and UniQuery -from the same manufacturer for two variants that to all intents and purposes do the same thing, is confusing for anyone from outside. That's the level where we need some consensus. 2/ Naming IS important, because people search. And it has been one of the battles in getting people to understand the reach of the technolgy, that with the names being totally fragmented any search gives a disproportionately shrunken view of this data model. 3/ Should the U2UG be doing this type of work? - well, how many years have we waited for the vendors to produce introductory materials aimed at encouraging new users other than those migrating from within the existing multivalue pool, or quality samples that really catch the cutting edge of these products? Let me see - forever. So if they are not going to do it, there is a group of people here who can (though whether we will be decide on the outcome of our board meeting tonight when we will be discussing our focus for this year). 4/ Unfortunately the U2UG has to be seen to be focussed on the U2 product line and not on MultiValue in general - otherwise we simply won't get any support and buy-in from Rocket. Bottom line. 5/ But that doesn't mean we can't have materials that point out how the model works, and that point out the areas of advantage over other database models in more general terms. That's a balance we will need to strike, and carefully. You know my personal views.. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Not Consistent Failure
One thought, If they are not supplying a password in UNIX, is this because they all share the same user name? If so, could you be hitting a process-limit on a non-admin user identifier, so it can't create the uv process ? It's been years since I played with AIX, so is there still a maxuprc limit? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Karl Pearson Sent: 23 March 2010 9:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] Not Consistent Failure When ever I see someone post something that can't be replicated because it's inconsistent, I wonder what the answer is going to be. So, here goes: I have a client that has started experiencing a login anomaly. First, the use telnet, and second, they don't have passwords at the Unix level. They are on AIX 5.2.0.0 with Universe 10.2.12 The things I've seen are: - the session doesn't make it into UV for their password prompt but drops straight to Unix. - I've checked permissions at various locations and at various levels. - I've commented out various parts of both /etc/profile and /u1/ACCT/.profile with no consistent noticeable change. - I've checked UV.LOGIN and ACCT LOGIN as well and nothing has changed in either place, and they are performing minimal tasks. - I've added a sleep just before exec /u1/uv/bin/uv plus changed uv to uvsh to see if that mattered. It didn't change the failures. - Failures are either on the 2nd login, 4th login, 3rd and 4th, 6th and 7th, 2nd and 3rd and 5th or whenever the pattern can't be matched... In other words, there's no rhyme or reason that can be applied to this failure. This is a real head-scratcher for me and I'm hoping someone has seen this or has something to offer. TIA --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- Children seldom misquote you. In fact, they usually repeat word for word what you shouldn't have said. --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.791 / Virus Database: 271.1.1/2765 - Release Date: 03/23/10 07:33:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using JDBC on Unidata 7.1 on HPUX
I roll my own, but a TOJSON option to match the TOXML would be a good addition to the query language. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: 22 March 2010 3:40 PM To: U2 Users List Subject: Re: [U2] Using JDBC on Unidata 7.1 on HPUX Is there any built-in way in UniBasic to convert U2 records to JSON strings? Or do you roll your own? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.791 / Virus Database: 271.1.1/2761 - Release Date: 03/22/10 07:33:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I'm looking for PICK
Guys We're getting dangerously close here to a personal attack. That's not the reason for this list. Points made, now please reign it in. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] PRINTER memory segment removed
Hi Jeff It means that a previous process had terminating leaving its shared memory segment behind, and the new one has the required permission to remove it and create a new one. Which normally isn't a direct cause for concern. It's if it can't remove the segment that you need to take action and remove it manually. Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: 19 March 2010 3:59 PM To: U2-Users@listserver.u2ug.org Subject: [U2] PRINTER memory segment removed AIX 5.3 and Universe 10.2.4 I have a cron job that runs a UVBasic program each morning. This morning it got a PRINTER memory segment removed message when dropping into Universe. I know I've seen this before but I can't remember what I did about it. Can someone provide a reminder? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.791 / Virus Database: 271.1.1/2754 - Release Date: 03/18/10 19:33:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Interesting interview with Susie
All Here is an interesting interview with Susie about how things are now with U2 and Rocket. It's given by Elkie Holland of Prospectus: http://www.prospectus.co.uk/t/SusieSiegesmundMarch10.htm Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Barcode Software for UniVerse?
Tony You're missing the point - Zebras a fast thermal (damn expensive) printers dedicated to barcode labelling. You won't get the same speed out of a regular printer... :) Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 26 February 2010 3:32 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Barcode Software for UniVerse? This is very nice n all but I'm Soo glad I use PrintWizard. PRINT 'barcode pointsize=20 src=1234567890 style=code128' Code example in context here: nospamNebula-RnD.com/products/PW/demo2.htm More insight here: remove.pleaseNebula-RnD.com/blog/tech/2008/03/pwtips01.html [lots of excellent, functional, excessive code snipped] (Nebula RD does not sell PrintWizard or get any related commissions.) T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2710 - Release Date: 02/25/10 19:57:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Keep a running total in a listing
Hi Henry Yes Universe supports the @1 approach but it's a) undocumented, b) non-obvious and c) could always change some day - okay not likely but it's not an 'official' feature or that's what I was told.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: 24 February 2010 6:09 PM To: 'U2 Users List' Subject: Re: [U2] Keep a running total in a listing Such things were so simple in PI/open: SORT VOC @ID FMT 32L SIZE EVAL @1+SIZE;@ COL.HDG Running COL.SPCS ID.SUP Length @ID. (in Bytes) Running... # 3 3 $INCLUDE 5 8 % 4 12 4 16 ACCOUNTS 45 61 BASIC.HELP 49110 CREATE.WIDGET.FILE 1,184 1,294 DELETE.WIDGETS 755 2,049 DEVICES43 2,092 DEVLIST43 2,135 EDFS.HELP 47 2,182 EDITOPTIONS47 2,229 ENTER.WIDGETS 616 2,845 GUI.HELP 45 2,890 LIST.WIDGETS 1,070 3,960 MAP35 3,995 MODIFY.WIDGETS 578 4,573 PARTFILES 47 4,620 Perhaps someone knows of a similar trick for UniVerse. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, February 24, 2010 9:50 AM To: 'U2 Users List' Subject: Re: [U2] Keep a running total in a listing George ED DICT BOOK_TITLES RUNNING_TOTAL This is a Type I Descriptor last compiled on 23/07/09 at 16:35. 20 lines long. : p 0001: I 0002: SUBR('RT','RUNNING_TOTAL',UNITS) 0003: MD0 0004: Run 0005: 10R 0006: S ED BLP RT 19 lines long. : p 0001: SUBROUTINE RT(ANS, WHICH, VALUE) 0002: COMMON /RT/ RT.NAMES,RT.VALUES 0003: 0004: IF @NI = 1 THEN 0005: RT.NAMES = '' 0006: RT.VALUES = '' 0007: END 0008: LOCATE WHICH IN RT.NAMES SETTING POS THEN 0009: TOTAL = RT.VALUESPOS 0010: END ELSE 0011: TOTAL = 0 0012: RT.NAMES-1 = WHICH 0013: POS = DCOUNT(RT.NAMES,@FM) 0014: END 0015: 0016: TOTAL += VALUE 0017: RT.VALUESPOS = TOTAL 0018: ANS = TOTAL 0019: RETURN LIST BOOK_TITLES RUNNING_TOTAL UNITS 04:37:46pm 23 Jul 2009 PAGE1 Key.. Run... Units 10 2222 11 23 1 12 30 7 13 35 5 14 41 6 15 46 5 16 47 1 17 49 2 18 52 3 Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 23 February 2010 3:07 PM To: U2 Users List Subject: [U2] Keep a running total in a listing How would you produce a running total column on a report? I've done this once before, and can not remember how I set it up. This is running UV 10 Ex. LIST SOMEFILE F1 @IDF1 1 2 2 5 3 8 4 11 What I want to do is: LIST SOMEFILE F1 TOTAL(F1) @IDF1 TOTAL 1 2 2 2 5 7 3 815 4 11 26 Thanks George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2705 - Release Date: 02/23/10 19:34:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2705 - Release Date: 02/24/10 07:34:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobject.Net Plus ASP.Net web service performance (was Re: Error connecting to Universe using Web Service Developer Tool)
Absolutely not - that's way too long. Either your application is doing some lengthy startups, something is seriously wrong with your DNS lookups or authentication of something similar is hitting it. You don't say what platform you are on, but I've seen slow connections where there are large active directory trees through which to iterate group memberships .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jason Lin Sent: 20 February 2010 10:13 AM To: U2 Users List Subject: [U2] Uniobject.Net Plus ASP.Net web service performance (was Re: Error connecting to Universe using Web Service Developer Tool) My first attempt using Uniobject.Net in a ASP.net web service is a bit disappointing. The issue I have is the performance of OpenSession command. It takes about 4 seconds to execute Uniobject's OpenSession command. I verified OpenSession's slow performance in a C# program by doing open and closing unisession multiple times in a loop without doing any database query. Does anyone know if 4 seconds is the typical time it takes for Uniobject to execute OpenSession command? Thanks Jason ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2699 - Release Date: 02/21/10 07:34:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniObjects 'Exec'
David The Command object does have a Response property which is like the THIS in your example. But that would have to be logged in some way. Also, if you're running UniVerse, it may create an entry in the errlog .. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: 19 February 2010 2:49 PM To: 'U2 Users List' Subject: [U2] UniObjects 'Exec' We are using a product and just found out that one of the reasons we're having some difficulties on an installation was that one of my dictionaries was not defined at a new site. This caused a 'Exec' of a SELECT to fail, but here's the kicker -- in BASIC, we could have 'seen' the error with CAPTURING and RETURNING -- but I'm told the interface to UniObjects does not return this diagnostic information on the 'Exec'... So in BASIC, I would have EXECUTE 'SELECT FILENAME WITH DICTITEM = A' CAPTURING THIS RETURNING THAT And I could 'query' what is in THIS and THAT to decide if there is a problem if the DICTITEM didn't exist for some reason. I'm told that the product we're using cannot do this same thing -- there is no way to 'know' the message 'select criteria DICTITEM is not a field' was returned from the 'Exec' as we could have seen in the BASIC EXECUTE. Is there no way to get back this same REALLY valuable feedback in UniObjects? How do you code for this issue in UO? This would not be big deal if we had source code or a 'log' of what was happening -- we just had a screen that didn't come up, and with dozens of fields, it's not obvious what the issue was -- until we found it! But the failure of the 'SELECT' command causes the 4GL based on UO to just 'die' I don't want to be stung another time with this, and am never afraid to ask for thoughts or ideas!! If there is a way to handle this, I want to find it and get the idea into their head so I never have a 'lost day' trying to hunt down this kind of issue... TIA!! David Wolverton ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2694 - Release Date: 02/18/10 19:34:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is there something wrong with the new wiki?
Hi Gregor It works for me when logged in.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: 16 February 2010 1:23 AM To: 'U2 Users List' Subject: [U2] Is there something wrong with the new wiki? Hello, I am just trying to access the new wiki on the u2ug.org website, and am having trouble seeing anything. First, without logging in I clicked on the New Wiki link which just re-displayed the home page. After logging in, all I see is what looks to be the toolbar, with links and icons for Home, Wiki Home, Bookmarks, History and the Jump to select field. Does anyone else have this view, or does it work for others? Gregor ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2689 - Release Date: 02/15/10 07:35:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2UG Elections Reminder
Calling all U2UG Members! This is a reminder that the elections for the 2010 U2UG Board will close on Feb 10th. So if you have not cast your vote yet, please sign in to www.u2ug.org and visit the elections page (under Membership menu). Thanks! Brian On behalf of the U2UG Board. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections
Hi Symeon I notice you have two separate logins to the website, and one of them has not been activated. I've now activated that, so you should be able to see the elections page. If not, drop me an email offlist and I'll sort it. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 04 February 2010 8:15 PM To: lbc7...@gmail.com; 'U2 Users List' Subject: Re: [U2] U2UG Elections I have the same i cannot see a link on the home page, I am logged in - u2ug.org ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lloyd Cottrell Sent: 04 February 2010 18:02 To: U2 Users List Subject: Re: [U2] U2UG Elections nvr mind, I logged out and back in and found it. On Thu, Feb 4, 2010 at 10:28 AM, Lloyd Cottrell lbc7...@gmail.com wrote: I might be blind, but can you give a link to do the voting? On Wed, Feb 3, 2010 at 2:02 AM, Brian Leach br...@brianleach.co.uk wrote: Calling all U2UG Members This is a reminder that voting has opened for the election of the new U2UG Board for 2010 - 2011. The board is composed of busy individuals who have volunteered their time to represent you, the U2 community. This year, following the transition to Rocket, the user groups plans to be even more active than ever. In order to secure a strong mandate, we need as many members as possible to vote. Please take a few moments to visit the elections page on the website and cast your vote. We have a strong slate of candidates once again, and they deserve your support. Voting will close on 10 Feb 2010. You can cast your vote more than once, however only the last vote cast will count. Votes can be cast through the website or by sending an email to: electi...@mvopen.org quoting your U2UG login name. The election page can be found under the Membership menu once you have logged into the site. Thank you. Brian On behalf of the U2 User Group Board. PS: If you are a member of the U2UG but have not received a previous email about voting, please check the email address in your member profile and make sure that it does not require verification. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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 No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2667 - Release Date: 02/04/10 07:35:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections
Dave No. The u2ug is a redirect from the old u2ug site, the one we first set up when we started the group off. Mvopen.org is the real address for this server, but both should take you to the same place. We tried to switch the u2ug address a little while back, but it stuffed up these lists (which are hosted yet somewhere else) so we've been wary of trying that again .. It is on the agenda for the new board to sort out though :) Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor Sent: 04 February 2010 10:29 PM To: U2 Users List Subject: Re: [U2] U2UG Elections It almost sounds like the same url is connected to a different opening page between the US and the UK. 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: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thursday, February 04, 2010 1:51 PM Subject: Re: [U2] U2UG Elections U2ug.org, but changed the url to mvopen.org and it is no different. Under Membership i have 4 options Register, Join email List, UUG charter, U2UG Newsletter - it is kind of like i have not logged in but at the top of the left column it says you are logged in as Symeon Breen. ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Robinson Sent: 04 February 2010 21:36 To: U2 Users List Subject: Re: [U2] U2UG Elections Are you logging into mvopen.org? Cheers, Don Robinson From: Symeon Breen syme...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, February 4, 2010 4:24:07 PM Subject: Re: [U2] U2UG Elections Sorry it is deffo not there ! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: 04 February 2010 20:20 To: U2 Users List Subject: Re: [U2] U2UG Elections I voted yesterday - after you Log in, under Membership (left side) you'll see a link for 'U2UG Elections', click it, then go to bottom of page. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, February 04, 2010 1:15 PM To: lbc7...@gmail.com; 'U2 Users List' Subject: Re: [U2] U2UG Elections I have the same i cannot see a link on the home page, I am logged in - u2ug.org ? -Original Message- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2667 - Release Date: 02/04/10 07:35:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Resize Question
Hi Andrew Because UniVerse dictionaries contain not only solid column definitions, but also synonyms and virtual fields, you have to choose which of these will be exposed for ODBC or similar relational protocols. A typical dictionary for a mature system might have a thousand entries which makes navigating these in something like MS query or the .NET data set designer very difficult! So for this you need to do two things: First, create a phrase named @SELECT. This is a dictionary entry in the format: Key: @SELECT 1: PH 2: list of fields SPACE delimited. You can test this out by doing a SELECT * from file at TCL, which uses the same phrase. Then, you need to update the file information cache used by ODBC (prevents it having to scan every dictionary on connect). For this, run the HS.UPDATE.FILEINFO command after making your changes. However, you might also want to step back and consider whether ODBC is really your best choice. To use ODBC effectively you need to understand about dynamic normalizing and the differences between the UniVerse data model and the relational model expected by ODBC. Depending on what you wish to do, ODBC may tie you up in knots and you may be better off looking at one of the native protocols (the UniObjects family) or web services instead. Also, I don't know why you chose to copy your VOC across. That will contain pointers to all the files from the original system, which you don't have on yours, hence the large number of errors you are seeing. If you are brave, you can try a CLEAN.ACCOUNT command, but take a backup first! [AD] You might want to consider my latest book, 'IBM UniVerse Client Developer' (written when this was still an IBM product) which covers the various protocols in depth. You can find details on my website, www.brianleach.co.uk. [/AD] Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E. Tegenkamp Sent: 02 February 2010 4:17 PM To: 'U2 Users List' Subject: Re: [U2] Resize Question Thank you very much! That has helped a lot and I can now see the data in the UV command line :) If possible, I am now hoping to be able to expose this imported data to ODBC so I can work with it in PHP, etc. But I am again finding problems I cannot find an answer for in the help docs or searching the list archive. First, I created a PICK account using the U2UG guide mentioned. I then used HS.ADMIN option 3 to Activate access to files in an account which went well and showed it as an activated account. I copied over the TEMP and VOC (D_VOC, D_VOCLIB, VOC, VOCLIB, etc) files from the live UniVerse server to my account as well as my test table ZIP (ZIP and D_ZIP). I fnuxi'd and SET.INDEX'd them and could see the data on the command line using SELECT COUNT(*) FROM ZIP and the like. However, when I went to ODBC I could only see 3 tables. AE_DOC, HELP_FILE, and HS_FILE_ACCESS (ODBC reported no rows in HS_FILE_ACCESS). I ran HS.ADMIN option 3 again on the account and for most things it said: Could not open file FILENAME. STATUS() = -2 FILENAME was not written into File Information Cache. For the file I copied over, ZIP, it said: ZIP's dictionary has no @ phrase or @SELECT phrase. ZIP was written into File Information Cache but may not behave as desired. This is a little confusing as I thought D_ZIP was the dictionary file and SELECT works on the command line. After this, I checked ODBC and saw the 3 above and one more table called UVMD. I am not sure what this was so I got it but it appears to be a system table of some sort. Thanks again for any tips on how to properly setup/expose this file/table to ODBC! Andrew -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, February 01, 2010 11:55 AM To: 'U2 Users List' Subject: Re: [U2] Resize Question Okay, a few things here... First the index issue. When UniVerse creates an index on a file, it puts the absolute pathname to the index into the file header. You will need to remove this using the SET.INDEX command thus: SET.INDEX filename TO NULL Next, the file size: The D_ZIP is the dictionary file. If you haven't fnuxi'd this, the modulus in the file header will be in the wrong byte order, so the reported modulus (16777216) is garbage. You will need to fnuxi D_ZIP as well. Incidentally - Download the free daily admin guide from the U2UG website (under the Learner Pack) for more details: here is a top level view - The modulus is one of the two components of sizing a file, and refers to the number of groups (pages) in the file. As it says, in personal edition there is a limit to this value. This number is independent of the actual data stored since a) it is the space reserved, so part may be empty, and b) you can make the size of each group (page) - also known
[U2] U2UG Elections
Calling all U2UG Members This is a reminder that voting has opened for the election of the new U2UG Board for 2010 - 2011. The board is composed of busy individuals who have volunteered their time to represent you, the U2 community. This year, following the transition to Rocket, the user groups plans to be even more active than ever. In order to secure a strong mandate, we need as many members as possible to vote. Please take a few moments to visit the elections page on the website and cast your vote. We have a strong slate of candidates once again, and they deserve your support. Voting will close on 10 Feb 2010. You can cast your vote more than once, however only the last vote cast will count. Votes can be cast through the website or by sending an email to: electi...@mvopen.org quoting your U2UG login name. The election page can be found under the Membership menu once you have logged into the site. Thank you. Brian On behalf of the U2 User Group Board. PS: If you are a member of the U2UG but have not received a previous email about voting, please check the email address in your member profile and make sure that it does not require verification. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Changing lower case keywords to UPPER CASE
Marco, I have a precompiler to do this. Contact me offline and I'll send you a copy. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Manyevere Sent: 27 January 2010 4:18 PM To: U2 Users List Subject: [U2] Changing lower case keywords to UPPER CASE I need to change all keywords in some UV BASIC programs to upper case. Global search and replace wont do because I should not change the keywords if they appear inside quotted strings or comments. Some of the programs are really looong. Does anyone have a better idea how to do this? Kind regards, Marco. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2660 - Release Date: 01/31/10 19:35:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Resize Question
Okay, a few things here... First the index issue. When UniVerse creates an index on a file, it puts the absolute pathname to the index into the file header. You will need to remove this using the SET.INDEX command thus: SET.INDEX filename TO NULL Next, the file size: The D_ZIP is the dictionary file. If you haven't fnuxi'd this, the modulus in the file header will be in the wrong byte order, so the reported modulus (16777216) is garbage. You will need to fnuxi D_ZIP as well. Incidentally - Download the free daily admin guide from the U2UG website (under the Learner Pack) for more details: here is a top level view - The modulus is one of the two components of sizing a file, and refers to the number of groups (pages) in the file. As it says, in personal edition there is a limit to this value. This number is independent of the actual data stored since a) it is the space reserved, so part may be empty, and b) you can make the size of each group (page) - also known as the separation - larger to store the data, it just makes the file less performant (and affects things like locking). To change the modulus and separation, look at the RESIZE command (HELP RESIZE). Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E. Tegenkamp Sent: 01 February 2010 4:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] Resize Question I'd like to preface this by saying I am a UniVerse newbie. Ideally, I am trying to import some data into a personal edition UniVerse database but I am having some trouble. One example is a ZIP code lookup called ZIP. First, I copied the files in from a UNIX system to a Windows install of Personal Edition. Not ideal but not sure if it's a deal-breaker as yet so I'm moving on... Then, I did fnuxi VOC and fnuxi ZIP. VOC was fine but on ZIP I got a warning the secondary indices are defined in a unix location and if necessary, use SET.INDEX to update file header to correct locations. I am not sure how to use SET.INDEX so I have not done anything with that. Now I go to UniVerse and get Your VOC is out of date. Update to current release (Y/N)? If I select Yes, I get an error about TEMP being in my VOC file but unable to create it. I believe this is because I do not have all the data copied over from the live UniVerse server, so I select No and get Unable to open the operating system file OC.O/LOGON.TESTER where TESTER is the account name logging on. That gives me a prompt so I can do ANALYZE.FILE ZIP and I see the file type is 18, modulo is 4507 and separation is 1. There are 44,098 records. Then I try a SELECT ST FROM ZIP to get the states and I get an error saying File D_ZIP has modulo 16777216 which is 10007. Please resize it to modulo = 10007 in order to use it in Personal Edition. I have tried running RESIZE of various file types, modulo, and separation, but I still get the error on D_ZIP every time. I have no idea how to get D_ZIP down to = 10007 or if it is even possible, or if the records being 44k+ means I cannot view it in personal edition or what exactly is going 44k+ on with this. Can anyone help me past this or tell me why I can't get past it? Thanks for any tips for a newbie, Andrew ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2660 - Release Date: 01/31/10 19:35:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse RetreiVe how do I query a file for all of its column's values?
Print *** Item Missing End Print Print NExt If Count(Options,PRINTER) Then Printer Off Printer Close ENd STOP *--- * GetField *--- GetField: DRec = FieldList(FieldNo) First = UpCase(trimF(DRec)[1,1]) Begin Case Case First = D If DRec2 = 0 Then D = @ID End Else D = @RecordDRec2 End C = DRec3 Case First = A Or First = S If DRec2 = 0 Then D = @ID End Else D = @RecordDRec2 End If DRec8 Then D = OConvS(D,DRec8) End C = DRec7 Case First = I D = IType(DRec) C = DRec7 End Case If C then D = OConvS(D,C) End Return *--- * GetRec *--- GetRec: * First do any non-associated fields For J = 1 To NoNonAssocs FieldNo = NonAssocJ GoSub GetField Print FieldNamesFieldNo L#15::: If IsNull(D) Then Print NULL End Else Print D1,1 For K = 2 To DCount(D,@vm) Print Space(16):D1,K Next End Next * Now try to fit any associations across ThisAssoc = '' Depth = 0 For A = 1 To NoAssocs Dc = DCount(AssocsASSOC.LIST,A,@SVM) For J = 1 to Dc FieldNo = AssocsASSOC.LIST,A, J GoSub GetField If IsNull(D) Then D = NULL End ThisAssocJ = D If DCount(D,@VM) Depth Then Depth = DCount(D,@VM) End Next * Column headers SoFar = 0 For J = 1 to Dc Width = AssocsASSOC.WIDTH, A, J FieldNo = AssocsASSOC.LIST, A, J If Width + SoFar = PageWidth Then Print SoFar = 0 End Print FieldNamesFieldNo (L#:Width) : : SoFar += (Width + 1) Next Print * Now the data For K = 1 to Depth SoFar = 0 For J = 1 to Dc Width = AssocsASSOC.WIDTH, A, J FieldNo = AssocsASSOC.LIST, A, J If Width + SoFar = PageWidth Then Print SoFar = 0 End Print ThisAssocJ, K (L#:Width) : : SoFar += (Width + 1) Next Print Next Next If Not(NoPage) then Crt Press any key to Continue :; C = KeyIn() C = Upcase(C) If C = Q Then STOP If C = N Then NoPage = @True End Return *--- * UpdateAssoc *--- UpdateAssoc: If AssocName = '' then NonAssoc-1 = NoFields End Else Locate AssocName In AssocsASSOC.NAME By AL Setting Pos Else Ins AssocName Before AssocsASSOC.NAME,Pos Ins Before AssocsASSOC.LIST,Pos Ins Before AssocsASSOC.WIDTH, Pos End AssocsASSOC.LIST,Pos,-1 = NoFields If Not(Width) then Width = 10 AssocsASSOC.WIDTH,Pos,-1 = Width End Return *--- * Usage *--- Usage: Crt LIST.FIELDS Crt === Crt Crt List all/designated fields for selected records. Crt Crt Syntax: Crt Crt LIST.FIELDS filename {*|[id id..]} options Crt Crt Options: Crt Crt /DATA Show Data fields only (no I Descriptors) Crt /SPARSE Do not show synonyms Crt /PRINTER Send to printer Crt /NOPAGE Disable paging Crt RETURN Return -| END OF LIST.FIELDS |-- -| stdTCL |-- SUBROUTINE stdTCL( FileName, FL, ItemList, Options ) *-- * Name: stdTCL * Description : Get TCL Arguments * Author : Brian Leach * Date: * Project : * Module : GENERAL
Re: [U2] Still using wIntegrate to copy files?
Ah, the halcyon days, waiting for a 30kb ZMODEM transfer down a 2400 baud modem - that was pedal to the metal computing ;) Just load the current beta for Visual Studio 2010 ! It is SO SLOW that it will take you right back to those 2400 days. It can easily take 10 - 30 seconds to catch up when I'm typing C# - and my typing is pretty bad grin. And as for the SilverLight design surface .. get a good book, you'll have plenty of time to read it. Just hope they sort it out before the official release. Oh, and that's on a fast PC, plenty of RAM, Windows 7. Strange how the constant striving for innovation always seems to lead to ever longer development ... Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Listserv Archives
Hi Kate If you use the previous menu [logged in] - U2 Email List that links to the Gmane view of the user list where you can search the archives easily. The other page links to IndexFocus as an alternative, but it looks like that may not be operating. Best Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Katie Morgan Sent: 11 January 2010 9:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] Listserv Archives I'm trying to search the archives for U2-users, but am having no luck. I'm following the link to the archives from the U2UG website (u2ug.org [logged in]-Join Email List-Message Archives), and get a search page, but when I try to execute a search, I'm getting webpage cannot be found error. Is anybody else able to get search results? Katie Morgan Datatel Programmer/Analyst Linfield College Integrated Technology Services 900 SE Baker St McMinnville, OR 97128-6894 kmor...@linfield.edu 503.883.2714 (if you can't reverse the logic, reverse the rest of the world.) -maryc on the Datatel Users Community Forums ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.725 / Virus Database: 270.14.134/2614 - Release Date: 01/11/10 13:29:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse haning after putting password in (win2003)
Hi David Couple of things to check - there is a login semaphore which might not be getting released. - sometimes iterating through active directory credentials can take forever if there is a deep hierarchy, especially if the credentials are being retrieved over a wan. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: 08 January 2010 9:24 PM To: U2 Users List Subject: Re: [U2] UniVerse haning after putting password in (win2003) Has anyone experienced a situation where UniVerse hangs after you enter user name and password has been entered. We had this problem with uniObjects and then I tested the telnet and this is the situation I discovered. When we do a reboot the problem seems to clearaway. This is running on a windows server Regards David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.725 / Virus Database: 270.14.131/2608 - Release Date: 01/08/10 19:35:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniRPC returning 39125
Hi David Are you going in as the same user you would use to telnet? If not, does the user have permission on that account directory? Are you using an absolute pathname for the account, and if not, does it work if you do? Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: 06 January 2010 5:13 PM To: 'U2 Users List' Subject: [U2] UniRPC returning 39125 I have a connection throwing 39125 when I try to RPC That means 'bad account' - yet the account connect data looks perfect to me... Anyone else seen 39125 during RPC? Any guidance? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.725 / Virus Database: 270.14.126/2601 - Release Date: 01/05/10 19:35:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Last chance to nominate
To all U2UG Members: Do you know anyone with the enthusiasm and commitment to join the U2UG board? Can you give up a small amount of your time to help drive the user group forward? Do you have opinions on the future of these platforms that should be heard? If so, this is your last chance to nominate for the U2 User Group Board for 2010. You can nominate yourself or another U2 User Group member. Nominations close on 10 January, and we want to hear from you! Please send nominations to: electi...@mvopen.org Candidates must be signed up members of the U2UG. This means that they must be registered on the U2UG website for a period of 6 months prior to the elections. If you do not want to stand for office, you can still let us know what you want the User Group to achieve in the next year. Send your suggestions to: i...@brianleach.co.uk or contact your local U2UG board member. Thanks! U2UG Board. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Any Ideas
Dave To do it nicely, use UniObjects from VBScript (VBScript is built into every copy of Windows through the CSCRIPT and WSCRIPT interpreters). Very useful for all kinds of admin and similar operations, and more flexible than using a regular batch file. I wrote a simple primer on this a few years ago, you can download that from: http://109.104.64.69/kb/docs/kb3.pdf Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave R Sent: 18 December 2009 1:25 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Any Ideas I am looking for a command in Windows that will launch a UniVerse Basic Command. Dave R. eFax (815)4259364 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.716 / Virus Database: 270.14.111/2570 - Release Date: 12/17/09 08:30:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] A readnext within a VOC?
George Here's a very simple but very utility: PROGRAM SRUN * --- * @@Name: SRUN * @@Description : Run a command against each element of a select list * @@Version : 1.0 * --- * Brief Description * - * @@INFO { * Syntax SRUN Command {} params * where {} substitutes each select list entry in turn. * eg SELECT VOC WITH F1 LIKE F... AND WITH F2 UNLIKE .../... * SRUN RESIZE {} * * * * } * --- * Warnings * * * --- * Modification History * * --- * Keywords * * @@KEY UTILS,SRUN * -- * To Do List * -- * * -- $OPTIONS PICK Open 'SAVEDLISTS' To Sl Else Print 'Cannot Open Saved Lists File' Stop End ProgramName = SRUN TCL = @Sentence Locate ProgramName In Convert( ,@FM, TCL ) Setting Pos Then RestOfLine = TCL[ ,Pos+1, Len(TCL)] End Else RestOfLine = '' End If RestOfLine = '' Then GoSub Usage STOP End Ix = Index(RestOfLine,{},1) If Not(Ix) Then Crt 'no include specification' STOP end ReadList List Else Crt 'No items Selected' STOP End Loop Remove Id from List Setting DVAR Command = Change(RestOfLine,{},Id) Crt Command Execute Convert(;,@FM,Command) While DVAR Do Repeat STOP *--- * Usage *--- Usage: Crt 'SRUN - Run a Command against a select list' Crt 'Syntax - SELECT ' Crt 'SRUN Command {} ...' Crt '{} substitutes the select list element' Crt Crt 'Example:' Crt ' SELECT VOC WITH F1 LIKE F...' Crt ' SRUN LIST {} ' Crt Crt 'Multiple commands can be specified semicolon delimited' Crt Return -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 10 December 2009 7:03 PM To: U2 Users List Subject: [U2] A readnext within a VOC? I'd like to setup a VOC to select a list, then run a program for each entry in the list (like below...) PA GET-LIST LISTNAME LOOP READNEXT ID ELSE EXIT DATA ID RUN LIB PROGRAMNAME REPEAT I Thought there was a way to do this...but just can't remember how. In the meantime, I pass the list to another program (on another channel) which reads each item and EXECUTEs the PROGRAMNAME George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.709 / Virus Database: 270.14.102/2556 - Release Date: 12/10/09 07:36:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2UG Elections
All Just a reminder to all U2UG members, that we are seeking nominations for the next board. We are looking for a new Vice President and three Members at Large. You can nominate either yourself or another U2UG member for these positions. With the sale of U2 to Rocket, we have a wealth of new opportunities and need enthusiastic board members to help push our current projects through, and to come up with new ideas. Please send your nominations to: electi...@u2ug.org Thank you Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] BCI Connectivity
Hi Bill You don't need CONNECT privileges to use BCI, unless you are making a BCI connection back into UniVerse. The BCI demo program supplied with UniVerse does that, which is why it asks for the privileges. If you are accessing e.g. SQL Server, it's down to the role of the user you specify in the connection. If you do need to connect back into UniVerse, the SQL catalog is normally owned by either root or uvsql, depending on who you nominated when UniVerse was first installed. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: 09 December 2009 11:59 PM To: U2 Users List Subject: Re: [U2] [UV] BCI Connectivity I found a VMark article... written by Brian Leach... for UniData indicating... Send an eMail to Vmark for UniVerse info. Is the referenced companion article for UniVerse available. I am struggling with setting up BCI on our HP-Ux machine. I have the IBM 10.3 BASIC SQL Client Interface Guide but some of the configuration is unClear to me. When I try to connect, I get the following error... # cd /usr/ibm/uv/sql/catalog # /usr/ibm/uv/bin/uv UniVerse Command Language 10.1 (c) Copyright IBM Corporation 2003. All rights reserved. catalog logged on: Wed Dec 9 18:49:15 2009 GRANT CONNECT TO brutzy SQL+ UniVerse/SQL: root does not have DBA privilege. Also, the settings in LOGTO UV uv are unClear. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.709 / Virus Database: 270.14.101/2555 - Release Date: 12/09/09 19:41:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects and login paragraph
Jerry Anything that can't be interactive. If that were not the case, and you started e.g. a menu system from your LOGIN paragraph, it would try to run that whenever you logged in through UniObjects and you would be stuffed. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 10 December 2009 4:38 PM To: 'U2 Users List' Subject: [U2] Uniobjects and login paragraph Did I see that someone said Uniobjects bypasses the login paragraph? What else bypasses the login paragraph? Is this on both 'nix and Windows? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.709 / Virus Database: 270.14.101/2555 - Release Date: 12/09/09 19:41:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mapping files.
Jerry That's only on UniVerse.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 30 November 2009 4:18 PM To: 'U2 Users List' Subject: Re: [U2] Mapping files. You also have to have Allownfs set to 1 in your configuration and permissions set on the other server so you can use the file. Jerry Banker ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2UG Website
All I've been informed by my hosting provider that they are moving my server (hosting the U2UG site) to a new data centre. This necessitates a change of IP address, and also means the U2UG site will be down whilst they make the move. Just hope that address isn't reused for some dodgy site before Google picks up the change :( It will be happening some time next week but they won't give a specific date. Thanks for your patience. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Haydon Bishop is out of the office.
And from which, my dear Watson, one may reasonably surmise that the famous Mr Bishop might in fact have been IN the office at some time.. grin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Haydon Bishop Sent: 21 November 2009 4:02 AM To: u2-users@listserver.u2ug.org Subject: [U2] Haydon Bishop is out of the office. I will be out of the office starting 20/11/2009 and will not return until 23/11/2009. I will respond to your message when I return. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.709 / Virus Database: 270.14.76/2519 - Release Date: 11/22/09 07:38:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Wiki
Bill The wiki is open to all to restructure. I haven't (deliberately) given it a category structure: that's up to the contributors. Wiki's are anarchic and anyone is free to change them (within the normal bounds of decency). That's how they work :) To add your page to the wiki, simply edit the page from which you want it linked, and add a link in the form of [[Your Page Title]]. There is a test page where you can play if you want to try it out first. Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: 27 October 2009 22:09 To: U2 Mail List Subject: [U2] Wiki I've been trying to add something to the U2 wiki but am unable to get the document located in the correct category within the wiki. I've read the instructions but they're of little help. Editing other pages don't help either. Looking up the wiki markups on the internet doesn't help much. When looking at the wiki structure I see it seems to be out of structure, which means others are having similar problems. It was easy to add a page but nearly impossible to properly insert it into the category structure of the wiki. Any help would be appreciated. Thanks, Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Call Stack
Hi Karen The equivalent on UniVerse is System(9001) It's nicely undocumented, but here are Charles Stevenson's comments: Value 1 of each attribute is the depth in the return stack Non-negative numbers mean that those programs are all part of the return stack. Negative numbers below simply mean those subroutines were called and returned from in the past. I don't think @LEVEL has anything to do with it, contrary to the patchlist text Value 2 is the program Value 3 is the hex address The object address you see when you VLIST a program For the negative depths, n/a. Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bessel, Karen Sent: 26 October 2009 16:48 To: U2 Users List Subject: [U2] UV Call Stack I had a trigger question last week, and I received some help from the list (thanks!), and I have another question. A member of the list sent me a program that he uses for triggers, and it's really nifty, except it uses a U2 function - SYSTEM(49) - that doesn't seem to have an equivalent in UV. ARGGG. The most important part of this trigger is to get the call stack and write it out so that I know what program is writing this garbage out. Something like this: Procedure is: KEB; pc = 5C; source line = 20 Called from: PRE.KEB; pc = 6; source line = 13 PRE.KEB was the main-line program - called KEB @ line 13. Broke out of KEB at line 20. I need programs and source code line#s. If RAID can show it to me, it's got to be accessible somehow, right? Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3780 Email: karen.bes...@tylertech.com Web: http://www.tylertech.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] Connection Pooling Statement
George Thanks, seems I was misquoted or the price has fallen (it was a while ago). At around 1700 GBP (with underlying licence) that's more reasonable. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land Sent: 25 September 2009 10:38 To: U2 Users List Subject: Re: [U2] Connection Pooling Statement On 25/09/2009 09:51, Brian Leach br...@brianleach.co.uk wrote: My beef is quite simply with the price of pooled connections. With the cost of the underlying licence, you are talking around 3,000 GBP plus AMC per connection, which means 10 shares costs around twice the amount you can buy SQL Server Enterprise for and get unlimited connections. That is simply untenable. Hi Brian, Current price is actually 1,207 GBP with 181 GBP pa from year 2 onwards George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Connection Pooling Statement
Hi Charles The text regarding connection pooling was inserted into the licence agreement when RedBack was first added, and originally that was the target of the change in the licence agreement: any multiplexing or connection concentrating was banned unless you had webshares. This of course meant that if you had any other stateless solution you could *only* use RedBack, whilst people *already had* home grown solutions using UniObjects that were suddenly in breach, where they had not been before. Also, connection pooling was only added to UO.net and UOJ much later, so there was a period when a change to the licence agreement - in other words, a change to the agreement you had originally signed up to - meant that you could not run your existing software legally even though it was perfectly legal when you wrote it, and there was no technical or commercial solution in place as an alternative (I like RedBack but it doesn't suit all applications). However, it was only 'advertised' to the distributors are part of their handbook, and so many end users didn't know about this (do you generally re-read the licence agreement every time you upgrade?). Hence there was a lot of confusion around. My beef is quite simply with the price of pooled connections. With the cost of the underlying licence, you are talking around 3,000 GBP plus AMC per connection, which means 10 shares costs around twice the amount you can buy SQL Server Enterprise for and get unlimited connections. That is simply untenable. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: 24 September 2009 23:40 To: U2 Users List Subject: Re: [U2] Connection Pooling Statement I'm missing something. We ran Redback without connection pooling. Is that an exception because it's a U2 product or were we in violation? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reading the Global Catalog
Bill There is a very cludgy routine below to get it for UniVerse. However, on some revisions of UniVerse there was a bug that prevented the catalog path being written to the catdir object, so your luck may vary. Brian --- cut here --- PROGRAM GetCatdirPath $OPTIONS PICK Get(Arg.) ProgName Else Crt Program Name ::; input ProgName if ProgName = then GoSub Usage STOP End End OpenSeq GLOBAL.CATDIR, ProgName To FL Else Crt Cant open it STOP End Status FStat From FL Else Crt Cannot status :ProgName CloseSeq FL STOP End ObjectLength = FStat6 ReadBlk Object From FL, ObjectLength Else Crt Cannot read :ProgName CloseSeq FL STOP End CloseSeq FL L = ObjectLength Loop While Object[L,1] = Char(0) Do L -= 1 Repeat Path = Loop While Object[L,1] Char(0) Do Path = Object[L,1]: Path L -= 1 Repeat Crt Path STOP *--- * Usage *--- Usage: Crt GetCatdirPath Crt = Crt Crt Get original path name from Global catalog entry. Crt Crt Syntax: Crt Crt GetCatdirPath *MyProg Crt Return --- end cut --- -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: 23 September 2009 19:11 To: U2 Users List Subject: [U2] Reading the Global Catalog Is there a way to programatically... [1] read the global catalog? [2] determine the original path (file folder) of a cataloged (compiled) SubRoutine? In other words, is it possible to do something like... read R.Catalog from F.Catalog, MY.SUB.NAME else R.Catalog = '' My.Sub.Path = R.Catalog2 Suggestions would be appreciated. --Bill Brutzman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://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] Worst Case/Best Case
What we really need in the U2 world is constant innovation, a new, modern development platform, or several, the ability to use and interface to the Windows world with all it's wonderful tool sets. We just need some visionary injection into our world... Now I'm confused. What part of 'interface to the Windows world' can't you do with UniVerse? It has UO.net - which is cleaner and faster than any other DB interface I've used - ADO.net, OleDB, ODBC, Web Services, nacent support for Entity Framework (though what will happen to the ADO.NET provider following the sale is up in the air) .. The only thing it really lacks is a good native mode PHP provider. Calling Basic subroutines from any of these is no harder than calling SQL stored procedures. Of course, SQL Server has an excellent development tool - it's called Visual Studio. So does UniVerse - it's called Visual Studio. You don't get as many wizards when using UniVerse, but then if you're doing any real development against SQL Server you will ignore the wizards anyway.. Oh, and back tracking a little, UniVerse does support referential integrity if you define your files as SQL tables. It has the same CASCADE option found on other RDBMS. Just 'cos people don't use it, don't mean it ain't there. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] GOOD NEWS From Susie
George I'm totally with you on this. The products have been through several hands, and this is the first time since the days of VMARK and UniData they haven't been merged/sold to database vendors with competing products. That has to be a good thing. The deal is done and we don't have any choice but to make the very most of it. Let's not talk this down before we have given these guys every opportunity. Now we can panic, or we can take this as a positive and introduce Rocket to a community that wants the products to succeed, is prepared to support them and pay for them, and turn them into the platforms we need for our businesses to prosperin future. If they are sensible, they will listen and we can get positive momentum from this move. We've all been through this before with the previous owners, and we and the products have survived. The engineers have done good things with the product, within the strictures imposed by IBM. Now, just maybe, there is a chance to employ some imagination. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land Sent: 17 September 2009 09:45 To: U2 Users List Subject: Re: [U2] GOOD NEWS From Susie My understanding of the logic of this is that the U2 people are so excited about it because it will allow them to invest in product development in a meaningful way. To describe Rocket as a rest home for no longer wanted technology is very harsh, what they are is an OEM specialist. A big part of the problem of IBM and U2 was that U2 is OEM, people acquire it because it is embedded in an application they have bought. IBM don't really do OEM and an issue has been a lack of understanding of how the OEM sales model works. U2 has remained largely outside the IBM structure everywhere except here in the UK. Here there are IBM employees reporting into the mainstream IBM structure who work on U2. As the UK Distributor we work with mainstream IBM people in a U2 context and it is hard, few of the structures, processes and mechanisms match what we do. Meanwhile there is development happening because it is right for IBM, so we got EDA allowing us to store data in DB2. Great but useless, we know and the U2 developers know that SQL Server is where it needs to be but they had to do DB2. Then you get things like UniData 7.2, a release that would probably have been UniData 8 but wasn't because to go to a new release number takes so much hassle in IBM that it would have taken beyond forever to get out. Alongside this you have education which has to go through the IBM education people meaning hardly any training happens because it is too expensive. Organising an event is really hard because people from several countries need to get involved, U2U in the UK last year was a nightmare for that reason. So personally I can understand precisely why Susie and her team wanted this and why they feel that Rocket is the right owner. Rocket do OEM, they provide software that goes into DB2, Tivoli and Rational amongst others. They sell through ISVs, they are used to their products being rebranded and bundled into others, that's largely why none of us have heard of them. Branding is the big issue going forwards, we've lost the IBM brand and that is a big loss. But from a product development and technical perspective the software is going into an environment that is much more suited to it. That is the major positive out of all this, the RD that is now likely to happen directed at what customers need and not what IBM want. As for buying a business to kill, what does happen is people buy them to run them as cash cows but there is no indication that will happen here. Rocket are active developers of their products and there is every sign that they intend to actively develop U2. George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 being sold!
Les, Master of understatement.. I'll be there. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Les Hewkin Sent: 16 September 2009 09:47 To: U2 Users List Subject: Re: [U2] U2 being sold! This news should make the U2 Universities interesting.. I will be in the bar in Liverpool if anyone want to buy me a drink...:-) Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ODBC Connection Error
Hi John Unfortunately that error just means an RPC connection error, which doesn't give much to go on.. Any context you can provide for this? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Castilletti Sent: 14 September 2009 16:26 To: u2-users@listserver.u2ug.org Subject: [U2] ODBC Connection Error Can someone shed some light on what may be wrong with my attempt at connecting to A Universe File from MS Query using ODBC. The error is: Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func:SQLPrepare(DML); State: IM985; universe code; 81002; Msg: [IBM][SQL Client][RPC] error code - 81002. Thanks in Advance John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users