[U2] Universe and ADO connections
Anyone out there have a list of the various ADO connectors for Universe? I'm looking for pros and cons of the various offerings. We had been using the data provider from IBM and now have Rocket's version. As we have experienced some issues,I need to know what is available as options to possibly migrate our current web applications over to. New management and customer complaints about the web applications are a bad combination. Thanks in advance. Mike Randall ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe and ADO connections
Tony, As we already have working models, the concern would be things like use of connection (session) pooling licenses, the ability to return datasets directly from Universe (we use SQLDirect) and overall performance. We haven't totally split the tiers but are headed down that path so we'd be close. I would be interested in discussing this further. Mike Randall IT Director Taylored Services www.tayloredservices.com 732-248-7900 x131 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, January 23, 2013 4:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe and ADO connections [AD] Mike, in response to your question: mv.NET has an ADO.NET-compliant provider called Adapter Objects. It exposes the MV environment as tables, rows, columns, and stored procedures for all CRUD, rather than files, items, attributes, and BASIC programs, respectively. So the ADO.NET developer gets what she/he needs without being a Pick expert. The queries to U2 are pseudo-SQL, rather than being something like SQL-92 compliant. The idea here is that the MV developer(s) collaborate with the .NET developer(s) to craft queries with Where, and OrderBy clauses, where we would normally use WITH and BY. For anything more complex the best approach is to expose a BASIC subroutine as a stored proc, and accept parameters. mv.NET includes Adapter Objects to help keep non-Pick people happy, but also included is Core Objects, which is more of a Pick-like interface. This is a super-set of UO.NET. mv.NET uses UO.NET as a basic lower-level transport and wraps round it a more powerful set of functionality. If you already abstract your UI from the middle-tier and the data (Business Access Layer=BAL, Data Access Layer=DAL...) then replacing existing code should not be a challenge. mv.NET also includes Solution Objects, which generates strongly typed classes - completely abstracting you away from database queries. This will be familiar to those who know NHibernate, CSLA, the .NET Entity Framework, and other ORM tools. You generate collection classes like Customers which encapsulate instances of Customer, and those might have methods like .Save or .UpdateSalesRep. So the mechanics of data access are eliminated and the classes are usable by anyone independent of their experience with RDBMS or Pick. There are also built-in facilities for session pooling, Web Services, Silverlight, and other common requirements. Please feel free to contact me for more information, including mentoring and other services to help with the conversion. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms From: Mike Randall Anyone out there have a list of the various ADO connectors for Universe? I'm looking for pros and cons of the various offerings. We had been using the data provider from IBM and now have Rocket's version. As we have experienced some issues,I need to know what is available as options to possibly migrate our current web applications over to. New management and customer complaints about the web applications are a bad combination. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [AD] Webinar: U2 RESTful Web Services
Thanks again, I will view them shortly. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, February 28, 2012 10:36 AM To: U2 Users List Subject: Re: [U2] [AD] Webinar: U2 RESTful Web Services As promised, the webinar recording: http://www.rocketsoftware.com/u2/resources/media-casts/webinars/restful Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Randall Sent: Wednesday, February 22, 2012 3:21 PM To: 'U2 Users List' Subject: Re: [U2] [AD] Webinar: U2 RESTful Web Services Thank you sir... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, February 22, 2012 4:36 PM To: U2 Users List Subject: Re: [U2] [AD] Webinar: U2 RESTful Web Services Hi Mike, All our webinars are announced ahead of time to those on our mailing lists. As Doug has already pointed out, our webinars are recorded and will be posted on our website. I will send you a link once it is posted. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Randall Sent: Wednesday, February 22, 2012 1:38 PM To: 'U2 Users List' Subject: Re: [U2] [AD] Webinar: U2 RESTful Web Services Daniel, This one seemed pretty interesting. Unfortunately you didn't provide much lead time for those of us who would have been interested.Maybe a recording of the webinar or another session? Thanks, Mike R. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, February 21, 2012 2:44 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] [AD] Webinar: U2 RESTful Web Services For anyone who hasn't heard and interested, we will be running a webinar on our new free tool and on REST/RESTful in general. Take a Load Off with U2 RESTful Web Services Webinar Explore the world of Web services and discover how you can integrate different applications running on different platforms, using different languages. Learn the differences between SOAP and RESTful Web Services and how to choose which style to use. Find out more about how you, like many name brand Web sites, can use U2 RESTful Web Services to easily super-charge your Web applications! Rocket Software's Nik Kesic, Lead Technical Support for Rocket U2, will present this webinar. Register for a session now by clicking a date and time below: Session A: Tuesday, February 21, 2012 4:00 PM - 5:00 PM MST (https://www1.gotomeeting.com/register/774151120) Session B: Wednesday, February 22, 2012 9:00 AM - 10:00 AM MST (https://www1.gotomeeting.com/register/827368200) Dan McGrath U2 Product Manager | Rocket Software PS: I added [AD] as I'm not sure how the group feels about webinar postings and decided to err on the conservative side. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [AD] Webinar: U2 RESTful Web Services
Daniel, This one seemed pretty interesting. Unfortunately you didn't provide much lead time for those of us who would have been interested.Maybe a recording of the webinar or another session? Thanks, Mike R. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, February 21, 2012 2:44 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] [AD] Webinar: U2 RESTful Web Services For anyone who hasn't heard and interested, we will be running a webinar on our new free tool and on REST/RESTful in general. Take a Load Off with U2 RESTful Web Services Webinar Explore the world of Web services and discover how you can integrate different applications running on different platforms, using different languages. Learn the differences between SOAP and RESTful Web Services and how to choose which style to use. Find out more about how you, like many name brand Web sites, can use U2 RESTful Web Services to easily super-charge your Web applications! Rocket Software's Nik Kesic, Lead Technical Support for Rocket U2, will present this webinar. Register for a session now by clicking a date and time below: Session A: Tuesday, February 21, 2012 4:00 PM - 5:00 PM MST (https://www1.gotomeeting.com/register/774151120) Session B: Wednesday, February 22, 2012 9:00 AM - 10:00 AM MST (https://www1.gotomeeting.com/register/827368200) Dan McGrath U2 Product Manager | Rocket Software PS: I added [AD] as I'm not sure how the group feels about webinar postings and decided to err on the conservative side. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [AD] Webinar: U2 RESTful Web Services
Thank you sir... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, February 22, 2012 4:36 PM To: U2 Users List Subject: Re: [U2] [AD] Webinar: U2 RESTful Web Services Hi Mike, All our webinars are announced ahead of time to those on our mailing lists. As Doug has already pointed out, our webinars are recorded and will be posted on our website. I will send you a link once it is posted. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Randall Sent: Wednesday, February 22, 2012 1:38 PM To: 'U2 Users List' Subject: Re: [U2] [AD] Webinar: U2 RESTful Web Services Daniel, This one seemed pretty interesting. Unfortunately you didn't provide much lead time for those of us who would have been interested.Maybe a recording of the webinar or another session? Thanks, Mike R. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, February 21, 2012 2:44 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] [AD] Webinar: U2 RESTful Web Services For anyone who hasn't heard and interested, we will be running a webinar on our new free tool and on REST/RESTful in general. Take a Load Off with U2 RESTful Web Services Webinar Explore the world of Web services and discover how you can integrate different applications running on different platforms, using different languages. Learn the differences between SOAP and RESTful Web Services and how to choose which style to use. Find out more about how you, like many name brand Web sites, can use U2 RESTful Web Services to easily super-charge your Web applications! Rocket Software's Nik Kesic, Lead Technical Support for Rocket U2, will present this webinar. Register for a session now by clicking a date and time below: Session A: Tuesday, February 21, 2012 4:00 PM - 5:00 PM MST (https://www1.gotomeeting.com/register/774151120) Session B: Wednesday, February 22, 2012 9:00 AM - 10:00 AM MST (https://www1.gotomeeting.com/register/827368200) Dan McGrath U2 Product Manager | Rocket Software PS: I added [AD] as I'm not sure how the group feels about webinar postings and decided to err on the conservative side. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selecting a List
CHANGE works in UV too. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Wednesday, June 08, 2011 12:07 PM To: U2 Users List Subject: Re: [U2] Selecting a List I'm assuming this is in a basic program and you want to use CHANGE instead of CONVERT. In Unidata, anyway. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, June 08, 2011 9:00 AM To: U2 Users List Subject: Re: [U2] Selecting a List On 08/06/11 16:47, Greg Coelho wrote: Hi All, Again, I need a little help. The following PROCEDURE LINE works just fine. In this case I'm just inserting the variable V.CALENDAR.YEAR to complete my file suite and I am going after 2 alphanumeric records ('P2021422' 'P2083158'). PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = 'P2021422' 'P2083158' The problem arises when I attempt to select from a LIST (below) PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = : VL.JS.LIST.VAR1 Of course the system does not like the Value Marker so I need to get rid of it... VL.JS.LIST.VAR1 = ':CONVERT (@VM,' ',VL.JS.LIST.VAR1):' The hope here is to replace @VM with ' ' and then place the ' at each end... but CONVERT will only switch one for one - one @VM for a single single quote (') which results in a quote mismatch. Any suggestions? Yes. I think you need the ?REPLACE? function. There is a function that replaces one string with another. It might be EREPLACE instead. Anyways. Read the BASIC manual - it is there. 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] serial #
Try config from TCL. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Saturday, May 07, 2011 1:30 PM To: u2-users@listserver.u2ug.org Subject: [U2] serial # Someone asked me the other day how they could determine their uv serial number. I didn't know, and can't find it when I RTFM on uvlictool. Anyone know? ___ 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] Saying Goodbye...
Doug, I think you make an excellent point about too many in the U2 space that fail to show what the technology can do and obsolete themselves and the product in the process. In today's world of smart phones, tablets and the web, green screen apps just don't cut it.These 'saying goodbye' letters should be a call to arms for all U2 developers. Change or get eaten.Embrace .Net and web... Mike Randall -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: Tuesday, April 26, 2011 10:53 AM To: U2 Users List Subject: Re: [U2] Saying Goodbye... The problem is two parts. First, we programmers have failed to show management that we have the skill set to Innovate or Die. Secondly, we have managers that are happy they are employed and don't know or care what U2 can do. Maybe this is because they don't know or perhaps we have not done anything to show them what can be done. Presentation is everything. Show the managers and owners what U2 software can do using browser based technology or Microsoft's .NET. When every I visit a client or prospective client I tell them and show them what innovations we are doing or will be doing. This is so when a sales person from Oracle or SAP come to their office and try to sell them, I have already closed that door. I bring my XLr8Editor on a thumb drive to every client to show them, I am not editing program via a DOS line by line editor. U2logic tools are state of the art with innovations like continuous compile that make me more efficient and my code less buggy. Can AE/ED editor say that? Of course not. Regards, Doug www.u2logic.com/tools.html Free trials available ___ 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] too many values in sort
Aging standards aside, I'd REALLY be questioning the design of a function that uses multi-values approaching that number of items.I would think it can't be very efficient... Mike R. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 25, 2010 12:52 PM To: U2 Users List Subject: Re: [U2] too many values in sort Of course, why would anyone need a BASIC program larger than 32K? I believe it's called progress. Non-configurable size limits are just __NOT__ acceptable in today's computing environment. The attendant work-arounds are just plain ugly, and inexcusable. The greatest aspect of PICK is the narrow gulf between the logical and the physical; database structure is logical, query syntax is logical, in fact, the entire machine is a logical machine. Twenty year old physical limitation should have been resolved at least ten years ago. :-( Bill Kevin King said the following on 10/25/2010 8:27 AM: Agreed on all points. Will check this on my customer's system. On Mon, Oct 25, 2010 at 9:11 AM, Dave Davisdda...@harriscomputer.comwrote: That's some shopping list. I haven't seen anything anywhere that lets you adjust this limit. Besides breaking the record up into separate tables, you may need to make a temp file that normalizes this for you, by doing something like stringing the value or row number into the key. I've never had anything approaching 10240 values in a multivalue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 10:54 AM To: U2 Users List Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -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] too many values in sort
If I were stuck with such a limitation, my approach might be to try an replace that function with an 'outside the application' index or something. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 4:22 PM To: U2 Users List Subject: Re: [U2] too many values in sort Mike, I agree with you. This is unfortunately a vendor application and they're storing quick retrieval lists of products. The customer can build these lists (via Excel import) as big as they want. ___ 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] mv.NET and U2.NET
I wondered when IBM.Net data provider would be added to the thread.We've been using it quite reliably for a couple of years.Total access to U2, true .Net capabilities. And It's free. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land Sent: Wednesday, August 04, 2010 3:29 AM To: U2 Users List Subject: Re: [U2] mv.NET and U2.NET At the risk of sounding like I'm disparaging a competing offering, here is my understanding of U2.NET. Corrections are welcome: 1) U2.NET is essentially an old version of mv.NET (a fork). A license to the source was purchased by IBM from BlueFinity. It's essentially v3.2.x (?) frozen in time. Not quite, U2.NET has it's origins in mv.NET but has since been developed on by IBM/Rocket. I understand that Initially the work focussed on making it more performant and on improving the installability of it. It is now a fully fledged Rocket product with a development path of it's own. 2) It has not progressed in sync with mv.NET to support new features like Solution Objects (code generation of strongly-typed business classes) or the new extended support for Silverlight. No license was purchased by IBM/Rocket for ongoing enhancements or fixes from BlueFinity. Again, not quite. Bluefinity don't develop U2.NET it is a Rocket product with a development path and development team of it's own. It won't develop in sync with mv.NET or with anything else, it is an independent product with it's own development path. 3) Where the same mv.NET software can be used across almost all Pick/MV platforms, U2.NET hase been restricted to operating only with U2. I really don't get this. Land Rover make aftermarket products for Land Rovers, they don't make them for Jeeps. U2 represents the overwhelming majority of the mv market, it would be perverse of them to even consider making their tools work with anything other than U2. What you will get with a Rocket product is something that is designed for and written for U2. As UniVerse and UniData move forwards so the tools move forwards with them, and vice versa. 4) I originally thought and hoped that it would be provided free to the U2 client base. I really wanted to use U2.NET as an alternative to UO.NET and mv.NET for sites where it was better suited. But to my surprise this severely and intentionally limited product (in current features and its future) is being sold to U2 sites at a price comparable to mv.NET itself. If you want free then you should be looking at IBM.NET (soon to be renamed), with is an ADO.NET provider with add ins for Visual Studio, including support for SSIS and SSRS, LINQ, Silverlight and support for U2 Automatic Data Encryption. With it, you can access your U2 Data with SQL commands (like select, insert), U2 style access too (U2 Subroutines, unnest, DynArray Class, CALL LIST and SQLExecDirect), or through XML (TOXML, GETXMLSUB, XmlAdapter) and with Object Data access (LINQ to Entity, EDM Model). George Land APT Solutions Ltd U2 UK Distributor ___ 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] Command logging in Universe 10.2.1
I think the renamed COMO is a better avenue because the commnand stack can be easily manipulated via the dot commands.There is .D (delete stack line) and .C (change line) to alter the contents.The stack logs are probably a solution for novice users but not for the savvy tech who wants to hide their tracks. Just a couple of ideas... Mike R. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum Sent: Wednesday, October 28, 2009 11:26 AM To: U2 Users List Subject: Re: [U2] Command logging in Universe 10.2.1 Brian, Just be aware that the Command Stacks are only written to SAVEDLISTS if field 2 of the STACKWRITE record in the VOC is set to ON. If it is set to OFF then no command stack is written. Cheers, Andy - Original Message From: bpar...@nemianlife.lu bpar...@nemianlife.lu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, 28 October, 2009 13:49:57 Subject: Re: [U2] Command logging in Universe 10.2.1 Many thanks to everyone who had some input to my question regarding command logging and particular thanks to Mike Randall who pointed out the command stacks that are written to SAVELISTS. I was under the impression that this only happened when issuing a SAVELIST command but apparently there is one for every session. This is sure to make the auditors happy. Cheers, Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Command logging in Universe 10.2.1
One thing to consider is the command stacks that are written to savedlists which has the command line activity. Not gospel as they can be manipulated but something.If it were me, I'd lock down command line access and/or the commands themselves. In past lives, I've had wrappers around system commands that did whatever logging was necessary.For example ED ran our special version which took the command line options and logged them and verified that the particular user was 'authorized' to use ED or access the file they entered. Another method might be to COMO everything and change the name of the COMO command to something only your administrator knows so no one could 'COMO OFF'. Of course you'd need to lock down VOC changes and access to the UV account and certain system tables. A few ideas Mike R. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpar...@nemianlife.lu Sent: Friday, October 23, 2009 4:52 AM To: u2-users@listserver.u2ug.org Subject: [U2] Command logging in Universe 10.2.1 Hi all, We are using Universe 10.2.1 to run a Life Insurance application and we use the UV command line to carry out various database administration tasks. All other access is via the application, where all transactions are recorded to an audit trail. We have the auditors in at the moment and they are very interested in having a compulsory tracing of the command line sessions logged as if a COMO ON was issued as the first command however I don't know of any way to make this mandatory, i.e. not allow COMO OFF. Does any one know any better. Many thanks for any help. Brian Parker Systems Manager Nemian Life and Pensions SA ___ 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] .Net Data Provider
Anyone have any idea what happens to the .Net Data Provider for U2 in the Rocket Universe? The product was labeled as a DB2 data provider on the IBM site with U2 being part of the functionality. No mention of it anywhere on the Rocket site. Thanks, Mike Randall ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] GOOD NEWS From Susie
Hard to view this as a positive no matter what spin is put on it. Smacks of being a part of Mercedes and then belonging to Joe's garage... Marketing of U2 (if there is such a thing) just took a serious blow to the gut. Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Results Sent: Tuesday, September 15, 2009 4:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] GOOD NEWS From Susie All, I just got off the phone with Susie Seigesmund. She has assured me that her entire team has been invited to stay together, Rocket didn't just buy the software or the customer list or the channel, they are buying into the people who supported us all along. More news as I have it. Also, watch U2UG.org, as we will be updating teh front page several times in the next few days. - Charles Barouch ___ 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] U2.NET question
One thing I've noticed is that the names for the various products are very convoluted. They have U2.Net, Mv.Net, Uniobjects.Net, yada yada yada. The free tool is the .Net Data Provider. I'm using that to link U2 to the .Net apps. Mike Randall, MCP -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Thursday, March 19, 2009 2:50 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2.NET question Hi, all. Is U2.NET included with (in this case) UniVerse like UniObjects.NET is, or is it a separate priced product like U2 Web DE (aka Redback)? Thanks. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] User count not correct
From the UV account, go to DOS and cd to bin, then 'uvlictool clean_lic -a'. That will reset them. Uvlictool by itself will show you what UV thinks is currently active. Mike Randall, MCP -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of bpa...@serta.com Sent: Wednesday, March 04, 2009 3:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] User count not correct No. There are no complicated users or processes. They're all straight UV Telnet sessions. Another reboot of the server resolved the issue, but now I'm curious if anyone knows where the current count of users is stored - and if there's any way to clean it up without having to go through a reboot. Thank you!!! Brian -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Drew William Henderson Sent: Wednesday, March 04, 2009 12:44 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] User count not correct Do you have anyone using ODBC on the database? I don't recall if it shows up in a LISTU. Drew -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of bpa...@serta.com Sent: Wednesday, March 04, 2009 1:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] User count not correct Good day everyone! I have a customer running U2 on W2K. They are licensed for 29 users. They cannot log in because it is acting like it's at the limit. If I do a LISTU, it shows 15 users logged in. If I run the USERS command (or CRT SYSTEM(35)), it says there are 29 users logged in. This occurred after a reboot. How do I clean this up? Thanks! Brian Paige _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Serta International Corporate Headquarters has moved to 2600 Forbs Avenue, Hoffman Estates, IL 60192 Phone 847-645-0200Fax: 847-645-0205 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. 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 strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Serta International Corporate Headquarters has moved to 2600 Forbs Avenue, Hoffman Estates, IL 60192 Phone 847-645-0200Fax: 847-645-0205 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. 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 strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT - Pick mentioned in letter to the editor... [not-secure]
I hate to say it but it's our own fault. Many of us have been around a while and now have positions of influence as far as the software systems. If you are still writing green screen apps in this day and age then you deserve what you get. While we have a Universe backend, there will never be another character based screen written in my shop. U2 supports every modern interface out there. If you are too [...] to use them, you deserve your fate. Harsh, but true Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Tuesday, July 08, 2008 6:38 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OT - Pick mentioned in letter to the editor... [not-secure] Well, just don't let anyone tell you that SQL is new The first version of SQL was developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. from http://en.wikipedia.org/wiki/SQL -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bessel, Karen Sent: Tuesday, July 08, 2008 14:45 To: u2-users@listserver.u2ug.org Subject: RE: [U2] OT - Pick mentioned in letter to the editor... [not-secure] Nope. I don't do any data warehousing, business intelligence, or database development in my current position. I guess I should have been more specific. I would love to have a job doing one or all of those things in a current, marketable technology like Oracle or SQL Server. I've uprooted my family twice in the last three years for job changes and I don't want to do it any more. Karen Bessel Software Developer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG Sent: Tuesday, July 08, 2008 3:56 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OT - Pick mentioned in letter to the editor... [not-secure] Karen, Aren't you already doing those jobs on U2? Jerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bessel, Karen Sent: Tuesday, July 08, 2008 3:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OT - Pick mentioned in letter to the editor... [not-secure] LOL I agree. He should speak for himself. I'd trade my legacy software developer job for a data warehousing/business intelligence/database developer job tomorrow. Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3777 Email: [EMAIL PROTECTED] Web: http://www.tylertech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Tuesday, July 08, 2008 2:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OT - Pick mentioned in letter to the editor... [not-secure] Interesting, it's a shame that what he says isn't really true. George On 08/07/2008 19:59, Hennessey, Mark F. [EMAIL PROTECTED] wrote: This appeared in the letters to the editor section of the July 1 Software Development Times HIS PICK FOR AN OS IS CLEAR I read your article about virtualization (Virtualization 3.0, May 15, page 25, or http://tinyurl.com/5j4dnc) with some amusement. I am an old Pick database programmer, and Pick has done virtualization since the 1970s. The Pick OS will load and run on just about any platform, including Microsoft's. It uses built-in tools to create one of the easiest-to-use and most versatile 3D relational database models on the market. Yet, it never merits mention in any of the mainstream media periodicals. Just about every buzzword and acronym you guys punch out every month, Pick has been doing since bell-bottoms and afro hairdos were in style. All the techno-weenies out there owe a great deal of what's happening in their careers to this venerable OS, yet I'll bet less than 5% have ever heard of it. Had Dick Pick not passed away in the mid-1990s, things might have been different today. But wherever you find a Pickie out there, they'll tell you that they wouldn't trade their legacy system for all the whiz-bang buzzword-laden toys in the world. So how about a nod to the good old days once in awhile? Gary Lass Wilsonville, Ore. Mark Hennessey State of Connecticut Department of Social Services Information Technology Services Child Support Systems Voice: 860-424-5261 Fax: 860-424-4813 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately on +44 (01952) 214000 or at [EMAIL PROTECTED] . Please delete and destroy any copies in any format of this email you may have received in error
RE: [U2] Getting daily data from SAP from Universe
SAP is using a SQL database. What I've done to automate some of the data sharing is from the Universe side, I have triggers on certain tables that execute SQL statements against our SQL Server databases to do what I need. Inserts, Updates, etc. all work like a charm. I haven't tried it the other way but I gather it would work with OLEDB or even ODBC if I was desperate. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Tuesday, July 08, 2008 6:30 PM To: U2Users Subject: [U2] Getting daily data from SAP from Universe Hi all ideally my client would like Universe to interogate SAP, extract data and upload its own database without having to involve the SAP army ie rather not have one side provide a flat file and the other side deconstruct it The only thing i can think of at the moment is use excel as an intermediary such that... run an excel query on sap to load a spreadsheet upload this data into universe via uniobjects Any ideas appreciated jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to tell if running a subroutine though RedBack
One of the previous recommendations seems to fit the bill, use @logname or @who to determine if it's your Redback user and adjust the code accordingly. All Redback requests will have the ID of user ID used to set it up. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Farmer Sent: Wednesday, June 25, 2008 9:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How to tell if running a subroutine though RedBack Thanks for the advice, but that is a UniVerse command and this is UniData - Sorry I did not say that in the first place. Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian Sent: Wednesday, June 25, 2008 7:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] How to tell if running a subroutine though RedBack Check the content of the @AUTHORIZATION system variable. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Farmer Sent: Thursday, 26 June 2008 2:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] How to tell if running a subroutine though RedBack I have a need to call a standard subroutine from a RedBack application call. The subroutine is meant to be used in an interactive mode and can prompt the user if there is an error in the data. If the data is coming from RedBack, I want to suppress the prompting and write the error to a log file. Is there any environment variable I can look at to tell if I am executing under the RedBack API call? Thanks Doug DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse Triggers
Brian, An excellent article. One that should be required reading by every systems architect that works in the U2 environment. I'm stunned that many don't realize the power in triggers, especially those of you supporting systems with no source! Again, great article. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Thursday, May 08, 2008 8:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse Triggers Mike If you check the recent issues (pdfs on their site) I wrote an article on triggers for Spectrum you might find useful. Brian -Original Message- From: Mike Randall[EMAIL PROTECTED] Sent: 08/05/08 03:58:08 To: u2-users@listserver.u2ug.orgu2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse Triggers Interesting, I actually saw the trigger reference under SQL and made the incorrect assumption that it was referring to actual SQL commands rather than calling BASIC subroutines. Thanks for correction. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 07, 2008 8:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Triggers It's a UniVerse SQL command (yes, even if the file is not an SQL table). CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON tablename FOR EACH ROW CALLING ' program ' ; Details are in chapter 5 of the UniVerse SQL Reference. [Message truncated. Tap Edit-Mark for Download to get remaining portion.] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse Triggers
On UV triggers, I've used them often on UD and now have a great application for them on UV. I searched the VOC and found no commands with the word 'trigger' in them. I was expecting the CREATE.TRIGGER of Unidata.What's the syntax for setting them up in UV? Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Friday, April 25, 2008 11:02 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] UniVerse Triggers Hello, We have received reports that UV triggers have shown some instability. Does anyone have anything to share on this? We have been using them for a couple of years with no issues but were hoping for more details from other users, if available. Thanks much, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse Triggers
Interesting, I actually saw the trigger reference under SQL and made the incorrect assumption that it was referring to actual SQL commands rather than calling BASIC subroutines. Thanks for correction. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Wednesday, May 07, 2008 8:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Triggers It's a UniVerse SQL command (yes, even if the file is not an SQL table). CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON tablename FOR EACH ROW CALLING ' program ' ; Details are in chapter 5 of the UniVerse SQL Reference. [AD] Also, I will be conducting a webinar through Spectrum University on the topic of UniVerse Triggers starting next Thursday. The course is three one-hour sessions on three consecutive Thursdays. For more information, please see http://www.intl-spectrum.com/tabid/159/univ/15/default.aspx [/AD] Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 7, 2008, at 4:28 PM, Mike Randall wrote: On UV triggers, I've used them often on UD and now have a great application for them on UV. I searched the VOC and found no commands with the word 'trigger' in them. I was expecting the CREATE.TRIGGER of Unidata.What's the syntax for setting them up in UV? Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Friday, April 25, 2008 11:02 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] UniVerse Triggers Hello, We have received reports that UV triggers have shown some instability. Does anyone have anything to share on this? We have been using them for a couple of years with no issues but were hoping for more details from other users, if available. Thanks much, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Pooled UO.Net Connections [not-secure]
I too would be interested in seeing them compared as I am considering implementing them. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: Friday, March 07, 2008 1:42 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Pooled UO.Net Connections [not-secure] I'd be interested in seeing the stats, and how they were collected. In your free time, of course! Mark Hennessey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Friday, March 07, 2008 11:47 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Pooled UO.Net Connections Hi Brian , I am using it in some ASP.NET environs and it is highly performant compared to opening and closing a connection each time - I have some good stats on live web sites using WAS that I can send on to you/the list if anyone is interested. Symeon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 07 March 2008 15:09 To: u2-users@listserver.u2ug.org Subject: [U2] Pooled UO.Net Connections All Being too poor to afford to purchase pooled connection licences just for testing, I'm interested in hearing from anyone using these with UO.NET in anger in terms of performance and stability. Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] mv.net versus Web DE
Jim, I'm in NJ and would love to know about some of the local user groups. For all the Visual Studio haters out there, I've been using it for the past 5 years or so after a gazillion years in U2. I'll go back to U2 stuff kicking and screaming. Visual Studio is FANTASTIC!!. Yes, I said it. Mike Randall, MCP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Canale, Jr. Sent: Friday, November 30, 2007 6:30 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] mv.net versus Web DE Tony Gravagno wrote: If you don't want to pay for Visual Studio [Ad - kind of] There may be another way for people on Long Island to get the brand new Visual Studio 2008 Professional for free. Next week (Dec. 6th), the LI.NET Developers Group will be hosting a meeting and at that meeting Microsoft will be giving away some copies of VS2008 Pro. If you live on Long Island and are interested in attending (you must register for the meeting), please shoot me an email off-list. I also know of a few other .NET developer groups where they will be doing the same thing (NYC, NJ) so you may want to check into that if you belong to any of those groups. [/ad] Best regards, Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Straw Poll - what GUI do you/would you use?
.Net has become my environment of choice. The Visual Studio IDE is fantastic and the character based U2 stuff that I've used since the 80's seems archaic and I'm not going back. Microsoft has tools, integration and support that's hard to match. I've become very proficient in both C# and VB.Net and totally agree with you that they are pretty equal as far as application development. VB.Net is easier (readable) but C# is the current 'sexy' language (more object oriented) and more in demand. One thing I've noticed is that no matter what the platform, the key to success seems to be in the ability to efficiently architect your solutions. In the .Net world, that is n-tiered with reusable class libraries. That's the where the talked about improvements in development speed and quality are achieved. Regarding the original post: 1) I think there are only 2 real mainstream options today, Java based or .Net based. My choice would be based on my current resources and environments. If my environment and people resources lean towards Unix and the 'C' world, I'd explore the Java based technologies. If it's Windows and dialects of Basic, then .Net is probably a better fit If you are coming from the MV world, the leap to .Net and VB.Net is far easier IMO. 2) The pain or joy from gui-izing a character app depends on the level of separation of the source app's presentation from the business layer. I've done several and the most successful are those with some type of existing screen handler where the business logic is already somewhat isolated. Your old-school MV app with the screen logic intermixed with the business logic is far more difficult as you really end up redesigning the entire function. There lies the beauty and power of an n-tier architecture. With each layer defined as separate, callable libraries, you end with an environment that is nimble in regards to changing technologies. Pure gold for software houses and end-user application life cycle and longevity. Mike Randall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Friday, January 12, 2007 12:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Straw Poll - what GUI do you/would you use? Hi I've been writing (and using) GUI and web applications for UniVerse for over 15 years, and I've used most of the standard technologies. Over the years ... Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: 12 January 2007 15:58 To: u2-users@listserver.u2ug.org Subject: [U2] Straw Poll - what GUI do you/would you use? Perhaps this question should've gone to the community list but I didn't want to miss the technical readers, nor their technical input. I'm conducting a straw poll about the 'preferred' graphical user interface. Please, no vendors or software providers. [We like you, we just want to hear from those who actually are in the trenches with your tools. Thanks. ;-) ] Would you mind responding to any of the following 3 questions: 1) In a perfect world, assuming UniVerse or UniData has the requisite hooks/services, what development environment would you use to put a graphical user interface on a character based application? Be concise if responding on-list. Rants are welcome to my direct email. 2) What was your *best* experience GUI-izing a character application? What language/tool? How long did it take? Was business logic already separated from presentation layer? 3) What was your *nightmare* experience GUI-izing a character application? What language/tool? How long did it take? Was project abandoned/completed? Was business logic already separated from presentation layer? Please forgive any repetition with previous threads, some of which I've read. Thanks exceedingly for any response. If you don't 'name names' this will be of no use, yet we are hoping this will not degrade into a trashing spree. We are grateful to all those providers/vendors who are contributing to the synergy of our market, wherever their toolset is along the continuum of perfection. There are likely factors, beyond the toolset itself, that contributed to the *nightmares* - please give credit where due. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Replication Between Unidata and MySQL
First thing that comes to mind is an update trigger on the Unidata side that captures every write attempt. The trigger could compare the before and after versions of the record and execute a call to a SQL update process that you come up with. The trigger could normalize your data (or whatever you needed done) and could be added with no impact to your application. Mike From: Kevin King [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] Replication Between Unidata and MySQL Date: Fri, 28 Jul 2006 14:30:56 -0700 I have been assigned a unique project and have been given some pretty stringent requirements. Basically the project involves a subset replication of a Unidata database into MySQL. As certain records change in Unidata (6.0) that record is to be flushed to a separate server running MySQL. Off-hours batch updates are not an option at this point, inconsistency between systems is intended to be momentary at best. I can handle the conversion and flattening of the data; that's certainly no deal breaker but keeping the MySQL server updated on a near-realtime basis has me a bit freaked out. Has anyone handled this kind of thing? Is there a connector to MySQL that can be addressed from within Unidata? I could certainly do something with ODBC I would figure but with Unidata running on AIX I'm not sure how exactly I'd move the data to the MySQL server (running on a Win box) directly. Other options off the top of my head include * ...using a http server to update the MySQL instance and using the callHttp interface or... * ...writing a TCP listener to do the updating of the MySQL instance and using Unidata sockets to move the data. However, these will necessitate a bit of code that I'd prefer to avoid. What would you do? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Tracking file writes
A trigger would be an ideal method as it's non-intrusive to your existing code. There are some caveats though. Basically you'd create a UNIBASIC program that could have any logic you want. In your case, probably something that writes to an audit file. You then attach this program to your file via a CREATE.TRIGGER command most likely defining it as an UPDATE trigger (there are some rules and parameters that you can get from the docs). Since your goal is to identify processes, the caveat would be how to identify the process. The trigger is based strictly on the file and doesn't really care what process initiated it. Depending on your platform and how your system is put together, @VERB or @SENTENCE might give you what you need or you might have to come up with something different. HTH Mike Randall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Koca Sent: Wednesday, July 12, 2006 1:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - Tracking file writes I need to track all processes that write to a specific file. At one time I remember that you could set some type of trigger to do this. If someone could provided me the information on how to do this, or direct me to the documentation that covers this I would appreciate it. Jim Koca --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 Web Product
It's part of the 'new' Redback. Version 4.3 has been renamed. Haven't seen it yet though. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 9:47 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 Web Product Apologies, but never heard of it. What is it? Karl quote who=Cooper, Rudy Hello List, I was curious if anyone was using IBM's U2 Web DE 4.3 product ? If so I wanted to know what you thought about the product. I know I could read about it on IBM's page, but I want to get someone's opinion who is using it. Thx, Rudy Rudy Cooper Technical Project Lead Sage Publications Information Technology Development (805) 410-7724 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] .net - universe 10.1.14
Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshire GU14 7PA, UK Tel: 01252 379489 Mob: 07973 451156 www.explore.co.uk __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Java Web Client
The U2Logic AJAX approach seems especially interesting. I haven't downloaded their tools and put them through the paces but I've seen it work. Personally, I've fallen head over heels in love with .Net and the Micro$oft integration and power but the rapid response and connectivity of AJAX type tools coupled with the price is definitely worth exploring IMO. There's still Uniobjects out there too at that magic price point of $0. Good Luck in your search. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Friday, June 02, 2006 7:56 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Universe Java Web Client We here need a new religion for GUI apps. Right now we are green-screen with mostly Dynamic Connect and a little wIntegrate. Because our back-end is HP-Ux, and .Net apps are not supported on a Unix drive, a Microsoft solution is not viable. We would not want an intermediary Microsoft server (which could fail) between PC clients and host. Thus, Java. While Swing is tempting, Swing is rich without reach. We do not want to have to someday re-write Swing apps to be browser compatible for remote access. While I am encouraged by DE, RedBack, SB+, Adobe-Flex, and an abundance of third-party tools, for us these products are pricey. The pack seems to be narrowing to u2Logic and JSF. The comments from people on this list have been a big help and are much appreciated. Regards, --Bill Because we host UniVerse -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wendy Smoak Sent: Friday, June 02, 2006 1:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Java Web Client On 6/2/06, Brutzman, Bill [EMAIL PROTECTED] wrote: This answer helps a lot. Thanks. Okay, okay, so we're still curious what you want to do with Universe, JSF, and AJAX. :) One of the things on my really long list of things to do is a web front end for the 'demo' app that ships with UniData. And then to re-do it with different combinations of webapp frameworks and middleware. Lately I've been playing with Sun Java Studio Creator, which is an IDE for creating JSF apps. Hooking a JSF component up to a web service is trivial with Creator. I haven't come back around to see how far IBM has come with 'native' web services for UniData, though. I wasn't all that impressed with the plain old XML handling last time I looked. All in my spare time, of course... -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] interface into Unidata [ad]
Unidata does indeed support triggers.You can define update and delete routines that are run automatically by the database itself. The trigger would provide you with an API to add additional processing whenever the trigger enabled file is written to. That API hook is a UniBasic routine that has access to the data about to be written and provides you with the opportunity to add any logic you like to it. That could be running another application, writing the data to another file, creating an XML file, running a webservice, etc., etc. whatever the system is capable of. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Thursday, June 01, 2006 6:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] interface into Unidata [ad] Brad Davis wrote: Tony - We're trying to capture updates to the Unidata tables, as they occur on the system. Is this what we're talking about? It sounds like you're talking about database triggers. I don't know off-hand if Unidata supports triggers but if it does then the answer is yes. (I can ask on my side and get an answer on that but I'm sure someone will chime in here.) One of your normal processes will update a unidata file, the trigger sends an event to some remote process which then puts the data into some other application. The other application must have an Application Program Interface (API) which is a plug that we can hook into for importing and exporting data. I personally specialize in understanding these plugs, and connecting products like this with MV apps. This same sort of thing can be done by storing data to a localhost OS file and then spawning another program to process that data, but this may not be possible if your other application isn't on the localhost. Part of the service we provide is getting to understand your topology so that we can recommend effective ways to do these things. If mv.NET isn't the right tool for the job, like if you need a completely Linux solution, I won't try to sell mv.NET. HTH Tony TG@ no.spam.pleaseNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Java
Redback makes the entire U2 structure available to both .Net and Java. The real beauty of the product is that it's strictly an interface which allows you to fully utilize and work natively in the environment of your choice *if* that's what you want. You also have the flexibility to do as much or as little of your business logic in U2 as you see fit. Use Redback and pick your favorite IDE. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Monday, May 29, 2006 11:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Java I was wondering what IDE if that folks are using to develop Universe/Java ? From time to time I mess around with Java, and I would like to use something that will be able to expose all the properties/methods of the UniObjects. I was using Visual Cafi and I remember that it did not do this. I think that program is non-existent. So, I need something else and Im looking for suggestions. So, all of you Java guys and gals what do you use to develop in Universe/Java ? Anthony -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.7.4/351 - Release Date: 5/29/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Redback 4.3?
I got an email today announcing U2 Web Development Environment 4.3. Beyond a new name, does anyone have any specifics on what's new in there? There seems to be mention of a new IDE and scheduler enhancements. Thanks, Mike --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connection within UniVerse and Oracle
Depending on what you are trying to do, ODBC (slow and awkward IMO) or a VB/VB.Net program that can easily access both databases would be a very easy way to go about it. You would need uniobjects or Redback to connect to Universe. Again, depending on your goals, there are some tools out there like the stuff from ON Corp. HTH Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, February 27, 2006 11:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] connection within UniVerse and Oracle I am trying to establish a connection between UniVerse 10.1 ( aix unix ) and Oracle (Window 2003), has anyone done this before? I was told to either use socket connection or ODBC. It seems that it is not that easy to use socket connection talking to Oracle, so I am thinking of using ODBC? Any ideas. Thanks. Regards Frederick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Telnet on Windows 2003 Server
Craig, Thank you. That cleared up the problem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Craig Sent: Wednesday, February 01, 2006 6:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Telnet on Windows 2003 Server It's a file permission issue. You need to allow non-admin users permission to write to the UV directory. Do not share this directory. Ross -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Wednesday, February 01, 2006 3:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] Telnet on Windows 2003 Server On a fresh install of UV on Windows 2003 server, only admin users can telnet in. Any ideas? TIA Mike --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Telnet on Windows 2003 Server
On a fresh install of UV on Windows 2003 server, only admin users can telnet in. Any ideas? TIA Mike --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uvo.net UvBasic .Net
Sounds like exactly what you can do now with Redback. The product gives you total flexibility on how much logic is U2 and how much is in .Net.You can have all your business logic as U2 methods, all in .Net using U2 as simply a datastore, or anything in between. Mike Randall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Thursday, April 28, 2005 8:01 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uvo.net UvBasic .Net The concept of having Basic.Net assembly language is one I am interested in too. One could write the business rules in PICK Basic in a class and use VB or C# to develop the GUIs. Best of Both Worlds. I don't believe it is too complex; one of the open source PICK developers may be able to adapt their compilers to the .Net framework to achieve this. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uvo.net UvBasic .Net
I whole heartedly agree. The green screen is the crusher for our environment. As far as .Net and Visual Studio go, I don't think it takes even that much effort as having Pick Basic as .Net assemblies to modernize or help perception, although that would be terrific. What would be great is simply the ability to use U2 components in the .Net environment as easily as you can those of other databases. The biggest headache/difference is that of data awareness. The current Visual Studio and much more so in VS 2005 allow you to establish tables/procedures as predefined datasources that can be linked to controls. If we did that, our U2 environments could be used by the dotnet world same as any other database.That puts us on an equal or closer footing with the SQL guys. Then the other features of U2 (flexible dictionaries, variable lengths, etc.) are enhancements to be pitched as selling points. Seems like a couple of vendors started down that road (most notably RD's PDP). Maybe it one day it happens. Mike However my perception is to make PICK more acceptable to younger people and look more mainstream. U2 is hung more for the green screen than for anything else, it is perceived as archaic even though that is far from the fact. If a Blue Chip company was looking at U2, and the basic code was a .Net assembly and we could create tables, etc from the Microsoft Visual Studio it could be the difference between a sale win or loss. It could minimise management wanting to throw U2 out of sites for something more modern as the even older RDBMS. It is the perceptions, not the technicalities that have dropped U2 from mainstream. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MvInternet
Trying my best to be impartial and simple, I think there are 3 categories of web connectivity products for U2. 1. You have what I call the web for pick programmers products. These are tools that allow you to do the majority of the work in BASIC with the product's IDE and they generate the web stuff for you. (Mvinternet/Web Wizard) Pros: You don't need to know much about web technologies to get something up and running. Cons: Integration and functionality limitations because of code generation. Scalability 2. Connectivity products. These make U2 accessible to web technologies. No IDE involved and you work in the web technology of choice. (Redback and PDP .net) Pros: Unlimited flexibility and control. Cons: Price? Web technology expertise required 3. Roll you own. These are the cgi scripts using Perl/PHP etc. Pros: Low cost Cons: Limited functionality HTH If anyone has any ideas they would share, please contact me at [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Locks, releases and STATU() (oh my)
Think LIST.READU is what you are looking for. LIST.LOCKS only displays the 64 semaphore locks which I don't think are too common anymore. Trick with LIST.READU was equating the file number to the proper data file if you were doing it programmatically. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Thursday, April 14, 2005 10:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Locks, releases and STATU() (oh my) Hello wizards, I've read what I can find on the subject, but I'm not finding what I need. As usual, anyone who knows where the info is, I would not be the least bit offended if you just point. Or if you know off-hand ... (Presently grappling with Unidata): When I hit a lock with a: READU this FROM that,ID LOCKED locked clause ELSE whatever LIST.LOCKS from TCL has always been worse than useless for me. For example at this exact moment I'm holding locks on 3 sessions, yet if I run LIST.LOCKS on a 4th session it displays ABSOLUTELY NOTHING. I don't see much on offer in the LOCKED clause, although the online help suggests that STATUS() will return the user number of the lock it ran into. Can't understand its output... I have a very short program that displays STATUS(), opens the file and displays STATUS() then does a READU against an item I purposefully have locked on another session and I display STATUS() a third time. What do you suppose its giving me, and what can I do with it? 1 STATUS = 0 -- beginning of program 2 STATUS = 1 -- after the open 3 STATUS = 197613 -- this is what it gives me after the READU against a locked item What I want to do is determine who/what has the lock, tell the user, I also want to be able to carry on under my own conditions when ud 46 flag is set which will by default allow edits to items I've locked against my own session. Which is too loose -- I want to check to make sure I'm in the exact right condition to do that and I'm not sure how I can (by seeing what is holding the lock) but ... does anyone know how to get ANY information out of a lock? Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Form Feed Options
Try the 'EJECT' option of the SETPTR command. It's supposed to do exactly what you are looking for. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Tuesday, March 29, 2005 10:02 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Form Feed Options Is there an easy way to configure the UniVerse spooler such that as each print job finishes, a page eject is issued. Thus far, I have been unable to determine what the form feed options are in the UniVerse spooler. Options like FF No Delay are not clear right now. The JetDirect to the Printronix P300 greenbar line-printer works, except for this feature. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Redback Startup
I think Brian's comments were excellent and very accurate. Redback itself is relatively easy to use. I think he hit it right on the head with it's the myriad of other technologies that can make it seem daunting. Coming from a U2/Pick background, the major hurdles in my learning curve were clearly the web technologies. You need knowledge of html/javascript/vbscript/ASP to put out commercial grade browser based product. Now you have .Net or the Java world worlds as the latest technology options to use with Redback. Redback is a piece of cake if you know the web side. As you get into UOJ, the exact same learning curve applies. I think your level of productivity would be about the same with Redback. In fact, I'd say the curve you go through with UOJ is the same as that of Redback with .Net. Very similar stuff IMO. As you get to issues like scaling up or apps that support a larger number of users, Redback will shine and it works with all the web the technologies (ASP/ASP.Net/Java/JSP). Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 18, 2005 12:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Redback Startup The problem here is that IBM is behind a tool that happens to be the most difficult one of the breed to work with imho ! And possible the most expensive as well. Of course it may be the best at certain things. But those of us who want to get out business on the web don't necessarily want to spend three weeks in training and another nine months figuring out how to use it. Mostly we just want to start using it. So to my mind, that's a real problem. As a programmer, using ASP without Redback at all, I'm at least able to start getting interaction from U2 to and from the web and can learn as I go. And so far it hasn't cost me anything. Will Johnson Fast Forward --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata acount on unix
It's been a while but I believe it was makeudt? Too much Windows lately for me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Thursday, February 17, 2005 9:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata acount on unix This is such a fundamental question ...sorry I'm such a numbskull -- I never do this. How does one make a directory on unix into a unidata account? On windoze I just make the directory and then go to it and type 'newacct'. What does the trick on unix? Thanks a million! Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] GE and LE question
All depends on what MX.VALS is set to. If it's not a number then your results can be valid. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Friday, February 11, 2005 10:25 AM To: U2-Users (E-mail) Subject: [U2] GE and LE question We have several programs that have been writing non-numeric when numeric required errors to the system log. The user inputs the value for each program. INPUT SEL BEGIN CASE CASE SEL GE 1 AND LE MX.VALS ; * passes this line VAL1 = RECORDSEL ; * line that gets the error. I've found out what is causing the error. The users have been inputting a number plus X. While testing my fix, I entered 2Q that also past the GE and LE test but errored at the VAL1 line. Brenda --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe to Web interface
Seems that a lot of you guys are trying to reinvent the wheel. There are several products on the market that have solved everything I've seen mentioned in this thread and then some. Most notably Redback and Raining Data's Pick Data Provider. I can understand if you have absolutely zero budget but these products aren't THAT expensive. Mike R. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV/Redback] How can my UV code determine the redback user name?
Adrian, No one connects. Remember, this is the stateless web here. Redback merely has anonymous processes that handles incoming requests for U2 data. There is no identity.If you want to identify incoming requesters, that will have to be part of your application. For an intranet application for example, your 1st screen would be a login screen where you prompt for user name and password. Your application would have to validate and store it. That name can be retrieved by your UV code. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian Sent: Friday, January 28, 2005 3:49 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV/Redback] How can my UV code determine the redback user name? Another question from a Redback newbie. There's a file WWUSERS that contains a list of redback user names (eg. RBADMIN). I can create new users in this file and assign them a password. Using the RBOScope examples supplied, I can connect using one of these user names password. I've created a new UV subroutine that is called via the POSTWRITE method on one of the objects. What I'd like to do is access the username so I can add it to any audit records I may write. I've noticed that @LOGNAME @ACCOUNT are both blank but @AUTHORIZATION contains redback. Is there a variable (or a getProperty method) that I can use to determine the user who connected? AdrianW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV/Redback] How can my UV code determine the redback user name?
George, There you are getting into server authentication. Redback will run with Apache. I guess it is dependent on what web technology you are using with it (Java, JSP, CGI) as to how that info can be made available to U2. I focused on the Microsoft technologies (IIS, ASP, ASP.Net) because of a perceived shorter learning curve coming from a Pick background with VB/VB Script versus Java. With IIS, you can set a server for windows authentication where you get the windows user id dialog box. Although I haven't gone that route, I'm sure you can find a way to access it to use in your code. So I would say the answer to your question is yes. Instead, I write my own login/security routines which is tied to the application for things like specific program access, printer defaults, email addresses, etc. In your case, I imagine the htaccess/htpassword files could be used as a validation source in ASP but the piping to read it and get it back to U2 would have to be figured out. If it works now and you can get it via your cgi script, it most likely work the same if you continued to use Apache. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Friday, January 28, 2005 9:39 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV/Redback] How can my UV code determine the redback user name? Mike, Right now, I have an .htaccess/.htpassword file combo for apache web server when you hit the site, the webserver gives you a login box. This information is available to a .cgi program from the webserver. Can the ASP server supply the Redback routine this information as well? and/or does the ASP server have that username/password ability? George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Does the Redback account have to be PICK flavour?
The accounts that you enable for Redback do not have to be Pick flavor. I have customers where the accounts are everything but Pick flavor. When you say 'the' Redback account, that's somewhat confusing. You have the user accounts that you create/enable and there is the rbdefn account that gets created when you install the product. That one is created as Pick flavor.That is not the one you use to Redback enable your data accounts. That account has the Redback internal routines for the product and will not have any effect on what you build. The process is that you Redback enable accounts that you want to make available to your web apps. Those accounts will have pointers to WWPROGS AND WWLIB from the rbdefn account. I tend to create new U2 accounts with VOC pointer for only the files I plan on using with my web apps. You then create modules in that account for your programs, RBOs, etc. Hope this helps, Mike Randall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian Sent: Thursday, January 27, 2005 8:02 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Does the Redback account have to be PICK flavour? We've just started experimenting with Redback and according to the documentation the Redback account needs to be Pick flavour. Is this correct? or can another flavour be used? All our user and development accounts are PI/Open flavour. Assuming the redback account has to be Pick then is it safe to call routines that were compiled in the PI/Open account? One problem I can see is if any of the routines EXECUTE statements that won't work in Pick (eg. The COPY FROM ... statement - not that I'd consider calling that particular statement from within a routine called from Redback). Any hints and tips for making Redback work with non-pick flavour accounts/programs would be gratefully received. AdrianW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Run phantom as another user
Why not GRANT the other user access to whatever it is? And if you are using Redback, why do you need SQL anyway? ADO? Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 1:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user I think I have this problem as well. I have a SQL command which works when I run it, but when my RedBack phantom run's it it fails with : Error text is [Ardent][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Co nnection not open Anyone know how to run a Unidata subroutine as someone else? I cannot find the article in u2ug. Thanks Graham Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: 25 January 2005 15:47 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UV] Run phantom as another user I am looking at this AUTHORIZE statement in Unidata. I am not able to compile a program using it and cannot find anything in the manuals about it. Is this a Universe sql only extension to Basic? -Original Message- From: David Jordan [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 10:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user In a BASIC program you can use the AUTHORIZE statement to set a different security credential. (See the U2UG newsletter on the U2UG web site for the article of security) You set the statement to AUTHORIZE username Then compile the program as that user. Anyone running that program will run under that usernames credentials. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Tuesday, 25 January 2005 1:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Run phantom as another user Is there a way to run a phantom process as another user using the PHANTOM command? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Run phantom as another user
Still curious about BCI. Not up on BCI but if you have Redback that means you are using a web interface. That means you can easily access Oracle and U2 at the same time. Not sure of your app but I'd have an ASP or ASP.NET program that opened U2 and Oracle for all the 2=way data exchanging I wanted. Using ADO, the commands to access both databases would be almost identical. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 4:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user Sorry, should have said I am using BCI Connect SQL to extract data from an Oracle database into Unidata. Works as me, but not when executed from a RedBack phantom which has been started by someone else. Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: 25 January 2005 18:24 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user Why not GRANT the other user access to whatever it is? And if you are using Redback, why do you need SQL anyway? ADO? Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 1:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user I think I have this problem as well. I have a SQL command which works when I run it, but when my RedBack phantom run's it it fails with : Error text is [Ardent][SQL Client][ODBC][Microsoft][ODBC Driver Manager] Co nnection not open Anyone know how to run a Unidata subroutine as someone else? I cannot find the article in u2ug. Thanks Graham Graham Forbes Trading Systems BT Consulting Systems Integration -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney Sent: 25 January 2005 15:47 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UV] Run phantom as another user I am looking at this AUTHORIZE statement in Unidata. I am not able to compile a program using it and cannot find anything in the manuals about it. Is this a Universe sql only extension to Basic? -Original Message- From: David Jordan [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 10:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Run phantom as another user In a BASIC program you can use the AUTHORIZE statement to set a different security credential. (See the U2UG newsletter on the U2UG web site for the article of security) You set the statement to AUTHORIZE username Then compile the program as that user. Anyone running that program will run under that usernames credentials. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Tuesday, 25 January 2005 1:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Run phantom as another user Is there a way to run a phantom process as another user using the PHANTOM command? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.bt.com/consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Wintegrate ML-SEND
Can it send html formatted messages as well as standard text messages? If so, what's required for them? TIA, Mike Randall --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do I get the Universe Version number from the server
Take a look at the VOC entry RELLEVEL. It's an 'X' type entry that contains the version info. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of peter watson Sent: Wednesday, October 20, 2004 6:38 AM To: [EMAIL PROTECTED] Subject: [U2] How do I get the Universe Version number from the server How do I get the Universe Version number from the server The information in this electronic mail message is Confidential and may be legally privileged. It is intended solely for the addressees. Access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. The sender's employer is not liable for any loss or damage arising in any way from this message or its attachments. -VRG3a- --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] GUI File Upload Using Wintegrate
Frank, Sounds like the standard Wintegrate import that's on the run menu does what you describe. They also have the WIN.IMPORT subroutine if you wanted to create your own interface. Fairly straight forward task. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bright, Frank Sent: Thursday, August 26, 2004 10:21 AM To: U2-Users Group (E-mail) Subject: [U2] GUI File Upload Using Wintegrate To All: I want to import files into a Unidata directory. We use WIntergrate. Is there a script that will allow us to choose the files using a Windows like lookup? The same way you are prompted in Windows to save a file or to lookup a file, to use the same type of interface within a WIntegrate script. Also, are there repositories on examples of Unibasic coding that is available to the public. Thanks in advance! Frank [EMAIL PROTECTED] ___ Frank M. Bright [EMAIL PROTECTED] Administrative Computing University of the Arts (A15) http://www.uarts.edu 320 S. Broad St. 215-717-6081(w) Philadelphia, PA 19102 215-717-6087(f) Colleague 17.0.14 AIX 5.2.0.2 Unidata 6.03 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Wintegrate
Site licensing is the one advantage I've seen. Wintegrate does all the other stuff and seems to have a very easy to use interface for calling their routines. I've used both and tend to favor Wintegrate cost issues aside. Both are good products. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Wednesday, August 11, 2004 10:19 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Wintegrate Mark: I concur with Ross. AccuTerm offers _very_ reasonable site licensing; I think it's something like $995 unlimited users. In fact, so much so I'd wonder why anyone would use wIntegrate at a large site. However, wIntegrate has: 1) Query Builder 2) Cuts and pastes way faster and AccuTerm has: 1) Significantly better terminal emulation (width beyond 132) 2) Multiple open sessions within the same instance 3) Much nicer cut-n-paste capabilities (cut paste @15,10 - 72,20) 4) Friendlier interface with user (at least for me) 5) The best darned site license price available. This is, however, a quick overview excluding programming capabilities, but I believe AccuTerm has tremendous scriting capabilities. To check out some of the nifty functionality available check out: http://www.asent.com/technical.html Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ross Ferris Sent: Wednesday, August 11, 2004 6:48 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Wintegrate Does it HAVE to be Wintegrate ? AccuTerm offer very reasonable site licences Ross Ferris Stamina Software Visage an Evolution in Software Development From: [EMAIL PROTECTED] on behalf of Mark Johnson Sent: Wed 11/08/2004 05:48 To: [EMAIL PROTECTED] Subject: [U2] Wintegrate Being U2 and Wintegrate are intimately related, anyone have any hints on any dealers/VAR's that can offer a reasonable discount on 20 licenses. $4,000 is a huge amount of money to pay for this as an emulator and from what I've gathered, there's no site licenses. Wintegrate 98 is acceptable. 5.0 has server based thin clients which is unnecessary. The main attraction for Wintegrate is its virtually invisible ability to send emails using the local client. A side by side comparison of it and Accuterm illustrates Wintegrates ease at many of the MV-PC functionality. This email thing is huge. I've tried sendmail and BLAT which are fine but WIN.MLSEND beats them all. Please keep the replies as Wintegrate. Thanks. Mark Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Adding D-Descriptors
The records can have varying numbers of fields. From your comment about flaky data, my guess would be that you are using fields that are being written to someplace else other than what you added. Dictionaries have no impact on what Basic programs do. Fields may be written to a particular file and there doesn't have to be any dictionary present or the dict says the fields hold something totally different. The dictionary is only used for reporting and selection functions. As such, looking at the dictionary is not a reliable or even valid way of determining field usage. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, August 05, 2004 10:22 AM To: '[EMAIL PROTECTED]' Subject: [U2] Adding D-Descriptors At the bottom of a data dictionary having a few dozen D-Fields, I added a few more D-Fields. Inside a UniBasic application, end-users are able to read and write data to these fields. Sometimes though, when listing results, some flaky data shows up. I am writing to inquire...is there now a requirement to normalize all records such that there are blanks specified in the newly defined fields...for all records ? In other words, is it not ok to have a mix of records...some with 71 fields...others with 75 fields? --Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Adding D-Descriptors
Double-edged sword IMO, I'm sure you've ran into that system you're investigating and discover that there are no dictionaries or the mappings are incorrect. As I get more and more involved in the SQL databases, that reliable definition of record layouts comes up as a key advantage.The U2/Pick world's greatest strength is their flexibility. The U2/Pick world's greatest weakness is their flexibility. I guess it all depends on who's at the controls... Mike Randall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Thursday, August 05, 2004 12:09 PM To: U2 Group Subject: RE: [U2] Adding D-Descriptors I think I'd call it more of a difference in philosophy than a feature or flaw. A basic tenent of the SQLian religion is that any operation which affects the database is performed through a single interface, that being SQL. Pickians on the other hand want to use anything that is efficient for a particular application to perform database operation so we've got your direct read/writes as well as SQL so we can pick/choose/combine at will. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Copying data between two Universe servers
Wintegrate has a nice feature called 'Bridge Copy', that allows you to log into multiple systems and transfer data between them at the file level. There is also UV/Net. It allows file access across machines. Separate product from IBM. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, July 28, 2004 5:10 AM To: [EMAIL PROTECTED] Subject: [U2] Copying data between two Universe servers I am looking for the best way to copy data between two Windows 2000 servers running Universe 10.0.10 over a VPN. I was looking at putting the data in a type 1 file and using a ftp copy command running on the scheduler. I don't want all the data being entered on one server I don't know if there is a better way using q-pointers and copying or any other method I haven't thought of yet. Many thanks --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate Query Builder
Create a user version of the file with just the items you want them to see. VOC: FilenameForUsers 1: F 2: Original File name 3: D_CopyofDictforUsers Could use CREATE.FILE DICT CopyofDictforUsers Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Michaelsen Sent: Friday, July 23, 2004 2:58 PM To: [EMAIL PROTECTED] Subject: [U2] wIntegrate Query Builder Is there a way to limit dictionary items from appearing in query builder. We are wondering if we can let the end users run with query builder but not give them access to all the dictionary items. kevin --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Mvquery Users
I beg to differ there. We use Redback and move HUGE amounts from the server with amazing response time. Our reporting tool of choice is Crystal Reports.We use Redback to retrieve data from U2 and then link it Crystal. Fast and powerful with outstanding presentation. And we do it with .Net too. Mike R. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schmidt, Steve Sent: Wednesday, June 02, 2004 7:25 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Mvquery Users Dave, I can assure you it is not only MVQuery that this occurs in, I run [EMAIL PROTECTED] and use a Redback Application to build query's. Large data extraction is a simply awful response. I also find myself with a crashed browser session and a process that is still writing to the file. We are moving to data warehouse solution which will bypass the Redback Application altogether. Steven Schmidt Database Manager [EMAIL PROTECTED] 301-941-0216 The Endocrine Society 8401 Connecticut Avenue Suite 900 Chevy Chase, MD 20815-5817 -Original Message- From: Dave S [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 02, 2004 6:23 PM To: [EMAIL PROTECTED] Subject: [U2] Mvquery Users I would like to know if there are any mvquery users sharing the same concerns that we have. When we run a query on a large data file the task manager on my Windows 2000 Professional Desktop indicates that mvquery is not responding. Mvquery seems to be the only application that I run that this happens to, why is that ? In fact, if the task manager indicated that Microsoft Outlook was not responding, I would normally kill the process. Sometimes the mvquery process completes, more often than that we end up killing it. But the process has been running for several minutes now and I am probably going to kill the process. Does anyone have an idea what the problem is ? - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/