Re: [U2] What ETL?
We use a small in-house C#/Uniobject tool which: Extracts data from U2 using DBTOXML function. Uses SQLXMLBulkLoad object to put that into a SQL "operational data store". We run classic ETL process on that and build star schemas etc I like it because ... it's simple, quick and relatively efficient, takes advantage of U2 to clean the data before it gets to XML. Takes advantage of XML schema and transformations to get the data into SQL. Stuart -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Debster Sent: Wednesday, 29 July 2009 2:50 PM To: U2 Users List Subject: [U2] What ETL? Just takin' a survey What ETL tool do you use - Why do you like it? Ease of use "Anyone can hold the helm when the sea is calm". -Syrus Publilius ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using PHP
To start, I'll echo Ross. PHP is great for sessions and all manners of web-type programming. Unlike Java - an otherwise excellent language which tends to require some complex-ish web server setup - PHP is much more lightweight and plugs into just about any web server quickly and efficiently. The language is purportedly derived from Perl but syntactically I find it closer to the original ANSI C++ with just a touch of Java-isms to keep it friendly. It's easy (dare I say "fun"?) to learn, easy to read, easy to deploy, and can be very maintainable (though of course individual mileage in this department varies per individual - as with all languages). There are all sorts of frameworks and infrastructures available for PHP but one doesn't have to use anything more than an editor to get started. The documentation is well written (I find it much more understandable than most) and there are plenty of books available with code samples to get one moving in the right direction. PHP can install with lots of different modules from SQL connectors to crypto libraries, ZIP and PDF creators and extractors, and a blindingly large array of other features as well. And if that's not enough there's a whole boatload of other user-contributed libraries available via PEAR. Generally speaking, (well written) PHP code performs very well, it's a reasonably mature language with a good object model (as of PHP5) but where it really shines is in passing data to and through a web server and managing sessions. I've also used it for *nix shell scripting for administration types of things and even had the pleasure of writing a NAGIOS plugin with it. Come to think of it, I've used it for all sorts of ad-hoc data analysis on my Windows box as well when awk was just a little too ... awkward? (pun intended, of course) I've heard PHP is the #2 language in the world behind C++, but I don't know definitively that's entirely reliable. That said, it does seem like it's gaining momentum because it's so flexible and pervasive. The fact that it can be used beyond the web and on nearly every platform imaginable without additional hardware or software, well, that has to account for something. The only downside to PHP in terms of U2 is that IBM has so far refused to create any kind of native connector. The UO connector "works" but it requires something of a walk on the wild side to mitigate some weirdness in the dynamic array extraction methods. Yeah, there's that TechConnect article which describes rolling your own, but even I'm not THAT geeky. Finally, FREE is always a good price, especially when you get so much with PHP. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ad] XLr8Editor Sale[/ad]
Do you have any provision in svn for sb plus objects? -Original Message- From: Doug Sent: Wednesday, July 29, 2009 8:15 PM To: 'U2 Users List' Subject: [U2] [ad] XLr8Editor Sale[/ad] We want all of you who have not tried our XLr8Editor for Universe or Unidata to use it for free for 90 days. We have added some amazing features in the last couple of months such as source code control, templates, and searching (similar to ESEARCH). Download instructions are at www.u2logic.com/downloads.html. What are you waiting for? You have nothing to loose. Operators are standing by! Tougue planted firmly in my cheek, Doug www.u2logic.com "The premier developer of Eclipse plug-ins for Universe and Unidata" ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [ad] XLr8Editor Sale[/ad]
We want all of you who have not tried our XLr8Editor for Universe or Unidata to use it for free for 90 days. We have added some amazing features in the last couple of months such as source code control, templates, and searching (similar to ESEARCH). Download instructions are at www.u2logic.com/downloads.html. What are you waiting for? You have nothing to loose. Operators are standing by! Tougue planted firmly in my cheek, Doug www.u2logic.com "The premier developer of Eclipse plug-ins for Universe and Unidata" ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] the XML/DB Tool
> From: Coelho, Gregory > I am on UniData (7.1 and 7.2) attempting to create a set of > nested relationships in a XML file. In an attempt to learn > how to use the XML/DB Tool I've read through IBM's > UniData:UniBasic Extensions - but am now more confused that > at the onset. Can anyone direct me to a knowledge source for help? I'll piggy-back on Greg's request. I don't know if this is at all what Greg is trying to do but I'll take a chance and see if anything I'm doing can help with what he's doing. I've recently obtained a large and completex dataset which is composed of hundreds of megabytes of XML, defined by a set of XSD documents. Transforming the XSD into strongly-typed .NET classes is easy. Reading the XML into strongly-typed objects is easy. The next step is mapping these objects to MV files. Having done this sort of thing a number of times before, I'm firmly of the opinion that one should not, for example, import XML data for Customers and push that data directly to a CUSTOMERS file. Rather, I believe the data should be stored in one or more files, like CUSTOMERS.XML.PRIMARY, CUSTOMERS.XML.ADDRESSES, CUSTOMERS.XML.CODES, etc, and from there business rules should be run to properly integrate this data with the live application files. This ETL layer helps to ensure that live data isn't corrupted by a data dump, and it also helps to allow for changes in both the XML and the application without having to link the two directly. It's an MVC pattern which works well in a wide variety of applications. I have been brainstorming for quite a while now to find the best way to link middle-tier code to the back-end as defined above. I do not like the idea of hardcoding XML handling into the MV environment, so unless strongly compelled, personally I tend to avoid the U2 XML tools entirely. But I'm open for suggestions. Right now I use C# partial classes to represent the XSD schema, and am planning to create new partial classes to augment these with SaveToDBMS functionality, looping on class objects to run rules and process the data into MV files. I'd like to automate the generation of the files that are updated (like CUSTOMERS.XML.ADDRESSES above) or write a code generator that will use schema or code (via reflection) to create code to do this same function for any set of XML/XSD. Assuming I've explained the above properly - has anyone done this? Anyone interested in the outcome? Any suggestions? Is this a case where the U2 XML capabilities may present some value? I'll be happy to clarify where required. Thanks! Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula R&D sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What ETL?
Bill You forgot ODS vs true Data Warehouse ;-) "Brutzman, Bill" Sent by: u2-users-boun...@listserver.u2ug.org 07/29/2009 10:06 AM Please respond to U2 Users List To "U2 Users List" cc Subject Re: [U2] What ETL? Here we are using ODBC and UniBasic. Extract, transform, and load (ETL) in database usage and especially in data warehousing involves: Extracting data from outside sources Transforming it to fit operational needs (which can include quality levels) Loading it into the end target (database or data warehouse)... (defn from Wikipedia) "AnyOne can go to BlockBuster and rent the Perfect Storm" -Billus Brutzmanicus -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Debster Sent: Wednesday, July 29, 2009 12:50 AM To: U2 Users List Subject: [U2] What ETL? Just takin' a survey What ETL tool do you use - Why do you like it? Ease of use "Anyone can hold the helm when the sea is calm". -Syrus Publilius ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- This communication (including any attachments) is intended only for use by the addressee(s) named herein and may contain legally privileged or confidential information. If you are not the intended recipient or an authorized representative of the intended recipient on this communication, you are hereby notified that any dissemination or distribution of this communication (or attachments) is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and permanently delete the communication and any attachments from your system. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using PHP
I have three reasons to use PHP as a "CGI Bridge" - Sessions, Cookies, and Query Parsing. These are things PHP is good at. In the past I would have added that it ran on a host of platforms, like UniVerse, but I'm having issues on AIX these days. I've also PHP in the past as a command-line tool to generate pages with the Smarty template engine, invoking it from UniVerse (see: http://www.rossmorrissey.com/uv/beyonded.htm slide 30...). Thanks, Ross. On Wed, Jul 29, 2009 at 6:54 AM, Brutzman, Bill wrote: > > While it makes sense to me to consider using PHP as middleWare to do SQL > things... > > What are the advantages of using PHP with U2 rather than UniObjects > for Java or .Net? > > Insights would be appreciated. > > --Bill > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Locked License Seat {unclassified}
Thanks Dan, I will give it a go and see what pops up. Andy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Thursday, 30 July 2009 6:13 a.m. To: U2 Users List Subject: Re: [U2] [UV] Locked License Seat {unclassified} Microsoft has a tool called procexp.exe that shows a process and all its children processes attached to it. Using this tool you can kill the parent and the child processes. This should free up what you need to. Just be careful, it is a very powerful tool. Good luck, Dan Goble ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Locked License Seat {unclassified}
Thanks for the help Dan. I did have a few rouge cmd.exe processes but cleaning them up didn't tidy up this license problem :( I will bear this wee trick in mind though, as I have had other problems that this could have solved. :) Andy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel Perttula Sent: Thursday, 30 July 2009 1:47 a.m. To: 'U2 Users List' Subject: Re: [U2] [UV] Locked License Seat {unclassified} Do you have any rogue "cmd.exe" processes running on the server? One of the most common causes we've seen for stuck licenses is that the uv session launched a DOS /c command line process that was somehow problematic. Killing the uv process was not enough, the cmd.exe process it launched had to be zapped as well, only then would the uvlictool free up the license. Dan The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using PHP
I use it purely as a test layer - my web sites use web services that connect using uniobjects they run u2 subs to return xml data that they aprse etc. All that is in aso.net. I have some pho code that calls the udt subs directly and captures the output and then displayes the resulting xml together with any output, - it gives me the ability to test the backend outside of the .net layer, and also put crt's in the backend code so i can debug, trace etc the backend code. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: 29 July 2009 14:54 To: U2 Users List Subject: [U2] Using PHP While it makes sense to me to consider using PHP as middleWare to do SQL things... What are the advantages of using PHP with U2 rather than UniObjects for Java or .Net? Insights would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Locked License Seat {unclassified}
Microsoft has a tool called procexp.exe that shows a process and all its children processes attached to it. Using this tool you can kill the parent and the child processes. This should free up what you need to. Just be careful, it is a very powerful tool. Good luck, Dan Goble ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] the XML/DB Tool
Not sure what your end objective is, but I have found that using the Web Services Developer Tool to be a better choice if you are planning to deploy a soap server, or even just to create the xml and wsdl files. There is a manual for this tool at: http://publibfp.boulder.ibm.com/epubs/pdf/22922020.pdf. I also suggest you take a look at the appropriate sections of the following: http://publibfp.boulder.ibm.com/epubs/pdf/22922360.pdf I have not found a manual for the XML/DB Mapping tool. Also, be sure you have the latest version of 1.3.3 for the Mapping Tool or 1.2.2 for Web Services Developer. If not, you should get them from the client cd. The best thing I have found is to use some examples that you can find searching around the IBM web sites. Take a look at: http://www-01.ibm.com/support/docview.wss?uid=swg21252788 http://www.ibm.com/developerworks/db2/library/techarticle/dm-0508kesic/ http://www.ibm.com/developerworks/data/library/techarticle/dm-0601dreyfuss/ Hope this helps. If you have any specific questions, post again. -- Carl Dula Voice: 973-227-8440 X111 Pulsar Systems, Inc.Fax: 973-227-8440 271 Route 46 West, Suite H209 email:c...@pulsarsystems.com Fairfield, NJ 07004-2474http://www.pulsarsystems.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV]recurring database, indexing and deadlatch errors
Yes, or try to find a file type with hashing algorithm that will guarantee that they cannot hash to the same group. Brian > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of > Manu Fernandes > Sent: 29 July 2009 16:17 > To: U2 Users List > Subject: Re: [U2] [UV]recurring database, indexing and > deadlatch errors > > I suppose you think about a DEFINE.DF based on the key structure ! > That can be a solution... > > Manu > > > > -Message d'origine- > > De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] De la part de Brian Leach Envoyé : > > mercredi 29 juillet 2009 16:35 À : > u2-users@listserver.u2ug.org Objet > > : Re: [U2] [UV]recurring database, indexing and deadlatch errors > > > > Hi Manu > > > > It is a good question... > > > > What do the record keys look like, and how many records are there? > > > > Brian > > > > > -Original Message- > > > From: u2-users-boun...@listserver.u2ug.org > > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu > > > Fernandes > > > Sent: 29 July 2009 13:54 > > > To: U2 Users List > > > Subject: [U2] [UV]recurring database, indexing and > deadlatch errors > > > > > > > > > Hello U2 group, > > > > > > Probably a good question. > > > > > > We define a < recurring > file. > > > Attribute<1> refer to a record in the same file (pointer > to a parent > > > record). > > > We have a I-Type SUBR which return the "root" key/item of > a current > > > item (read the parent until parent = @NULL ) > > > > > > Then we create a index with this I-type to retrieve > easily the items > > > childs of a "root-id". > > > > > > All work fine ... > > > except when the root-item is stored on the same FileGroup of the > > > child-item. > > > (at TCL, *RECORD file root-id* return the same value then *RECORD > > > file > > > child-id*) > > > > > > If this occurs, at the write step (save a child record) into the > > > SUBR called by indices processing, we get a "Self > deadlatch error" > > > and return to TCL. > > > This occurs because we are in a "write" which is a internal > > > "transaction with isolation level 0" and we try to read a record > > > already in the isolation. > > > > > > Do you have any idea to solve it ? > > > Thanks by advance. > > > Manu > > > ___ > > > 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] [UV] Locked License Seat {unclassified}
Sorry. I just noticed this was a windows server and I gave you *nix syntax. I didn't scroll down far enough. Jeff Powell wrote: Try kill -15 2160 kill 2160 15 and kill 2160 9 with no effect. ___ 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] Wintegrate/MS Access
Has anyone used the host subroutines in Wintegrate to interface with Access? I can open the db, run a query and get the recordset, but cannot get to each field in the record. We are on Unidata 6.1 and Wintegrate 6. Thank you. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV]recurring database, indexing and deadlatch errors
I suppose you think about a DEFINE.DF based on the key structure ! That can be a solution... Manu > -Message d'origine- > De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] De la part de Brian Leach > Envoyé : mercredi 29 juillet 2009 16:35 > À : u2-users@listserver.u2ug.org > Objet : Re: [U2] [UV]recurring database, indexing and deadlatch errors > > Hi Manu > > It is a good question... > > What do the record keys look like, and how many records are there? > > Brian > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of > > Manu Fernandes > > Sent: 29 July 2009 13:54 > > To: U2 Users List > > Subject: [U2] [UV]recurring database, indexing and deadlatch errors > > > > > > Hello U2 group, > > > > Probably a good question. > > > > We define a < recurring > file. > > Attribute<1> refer to a record in the same file (pointer to > > a parent record). > > We have a I-Type SUBR which return the "root" key/item of a > > current item (read the parent until parent = @NULL ) > > > > Then we create a index with this I-type to retrieve easily > > the items childs of a "root-id". > > > > All work fine ... > > except when the root-item is stored on the same FileGroup of > > the child-item. > > (at TCL, *RECORD file root-id* return the same value then *RECORD file > > child-id*) > > > > If this occurs, at the write step (save a child record) into > > the SUBR called by indices processing, we get a "Self > > deadlatch error" and return to TCL. > > This occurs because we are in a "write" which is a internal > > "transaction with isolation level 0" and we try to read a > > record already in the isolation. > > > > Do you have any idea to solve it ? > > Thanks by advance. > > Manu > > ___ > > 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] [UV]recurring database, indexing and deadlatch errors
Hi Brian, Thanks for your interest. Keys are alpha chars like this Code Parent RP0907166311 11/5 RE0907162560 1108 RE0907162561 113305 RE0907162562 113502 RE0907162563 113502 RE0907162564 119BPL WP0907133832 RE0907162564 RE090721XRE0907162564 WP0907093668 RE0907162562 WP0907204811 RE0907162562 WP0907113771 RE0907162560 Actually we have 12'000 records but each day it's growing. Yes, if we RESIZE the file when the problem occurs, it solve ... until next time. Manu > -Message d'origine- > De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] De la part de Brian Leach > Envoyé : mercredi 29 juillet 2009 16:35 > À : u2-users@listserver.u2ug.org > Objet : Re: [U2] [UV]recurring database, indexing and deadlatch errors > > Hi Manu > > It is a good question... > > What do the record keys look like, and how many records are there? > > Brian > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of > > Manu Fernandes > > Sent: 29 July 2009 13:54 > > To: U2 Users List > > Subject: [U2] [UV]recurring database, indexing and deadlatch errors > > > > > > Hello U2 group, > > > > Probably a good question. > > > > We define a < recurring > file. > > Attribute<1> refer to a record in the same file (pointer to > > a parent record). > > We have a I-Type SUBR which return the "root" key/item of a > > current item (read the parent until parent = @NULL ) > > > > Then we create a index with this I-type to retrieve easily > > the items childs of a "root-id". > > > > All work fine ... > > except when the root-item is stored on the same FileGroup of > > the child-item. > > (at TCL, *RECORD file root-id* return the same value then *RECORD file > > child-id*) > > > > If this occurs, at the write step (save a child record) into > > the SUBR called by indices processing, we get a "Self > > deadlatch error" and return to TCL. > > This occurs because we are in a "write" which is a internal > > "transaction with isolation level 0" and we try to read a > > record already in the isolation. > > > > Do you have any idea to solve it ? > > Thanks by advance. > > Manu > > ___ > > 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] What ETL?
DataStage would be an option. I am not using it, but it would be the cadillac solution. At the low, but excellent, end of the spectrum, I would put Cedarville DOWNLOAD, which can also extact to xml, for example IIRC. Depending on your goal, something like Informer or MITS might fit the bill too. I have a ton more information regarding ETL with UniData in my head, but much of my information is now dated (we are now using Cache' rather than UniData), so I'll just leave it at that. --dawn On Wed, Jul 29, 2009 at 9:18 AM, Brian Leach wrote: > Debster - > > Horses for courses. It's like saying 'what do you use for your applications' > - there's a wealth of scenarios out there and tools for each of them .. > > At the top end, Aptitude from Microgen. Not cheap, but a fully featured > suite for transforming data: very powerful, graphical and loved by financial > analysts. Probably too heavy for most mv uses, and you need a serious > consulting budget for that as well. But for sheer firepower it's one of the > best. > > At the bottom end, BCI out of UniVerse. The advantage of BCI is that you > have total programmatic control over the data you ship out, especially where > it isn't easy to get it from enquiry type statements. > > Inbetween, Conduit [ad] or the data transformation tools in SQL Server if > you want to pull data in from UniVerse over e.g. ODBC. > > And I'm waiting for someone to say DataStage... (I don't use it so I can't > recommend it). > > Regards > > Brian > >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Debster >> Sent: 29 July 2009 05:50 >> To: U2 Users List >> Subject: [U2] What ETL? >> >> Just takin' a survey >> >> What ETL tool do you use - >> >> Why do you like it? >> >> Ease of use >> >> >> >> >> "Anyone can hold the helm when the sea is calm". >> -Syrus Publilius >> >> >> >> >> >> >> >> >> ___ >> 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 > -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] the XML/DB Tool
All, I am on UniData (7.1 and 7.2) attempting to create a set of nested relationships in a XML file. In an attempt to learn how to use the XML/DB Tool I've read through IBM's UniData:UniBasic Extensions - but am now more confused that at the onset. Can anyone direct me to a knowledge source for help? Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV]recurring database, indexing and deadlatch errors
Hi Manu It is a good question... What do the record keys look like, and how many records are there? Brian > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of > Manu Fernandes > Sent: 29 July 2009 13:54 > To: U2 Users List > Subject: [U2] [UV]recurring database, indexing and deadlatch errors > > > Hello U2 group, > > Probably a good question. > > We define a < recurring > file. > Attribute<1> refer to a record in the same file (pointer to > a parent record). > We have a I-Type SUBR which return the "root" key/item of a > current item (read the parent until parent = @NULL ) > > Then we create a index with this I-type to retrieve easily > the items childs of a "root-id". > > All work fine ... > except when the root-item is stored on the same FileGroup of > the child-item. > (at TCL, *RECORD file root-id* return the same value then *RECORD file > child-id*) > > If this occurs, at the write step (save a child record) into > the SUBR called by indices processing, we get a "Self > deadlatch error" and return to TCL. > This occurs because we are in a "write" which is a internal > "transaction with isolation level 0" and we try to read a > record already in the isolation. > > Do you have any idea to solve it ? > Thanks by advance. > Manu > ___ > 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] What ETL?
DataStage. Works well for us. Our vendor exposes a somewhat normalized SQL account. We interact with that, not directly to UD. It's graphical if you want. Programmatic if you need. Since we're a U2 shop, we like that it's based on a flavor of UV. Have been using it for a number of years with no real issues to send data directly to Oracle, SQL Server and DB2. Brad > > And I'm waiting for someone to say DataStage... (I don't use it so I can't > recommend it). > > Regards > > Brian U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What ETL?
Debster - Horses for courses. It's like saying 'what do you use for your applications' - there's a wealth of scenarios out there and tools for each of them .. At the top end, Aptitude from Microgen. Not cheap, but a fully featured suite for transforming data: very powerful, graphical and loved by financial analysts. Probably too heavy for most mv uses, and you need a serious consulting budget for that as well. But for sheer firepower it's one of the best. At the bottom end, BCI out of UniVerse. The advantage of BCI is that you have total programmatic control over the data you ship out, especially where it isn't easy to get it from enquiry type statements. Inbetween, Conduit [ad] or the data transformation tools in SQL Server if you want to pull data in from UniVerse over e.g. ODBC. And I'm waiting for someone to say DataStage... (I don't use it so I can't recommend it). Regards Brian > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Debster > Sent: 29 July 2009 05:50 > To: U2 Users List > Subject: [U2] What ETL? > > Just takin' a survey > > What ETL tool do you use - > > Why do you like it? > > Ease of use > > > > > "Anyone can hold the helm when the sea is calm". > -Syrus Publilius > > > > > > > > > ___ > 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] What ETL?
Here we are using ODBC and UniBasic. Extract, transform, and load (ETL) in database usage and especially in data warehousing involves: Extracting data from outside sources Transforming it to fit operational needs (which can include quality levels) Loading it into the end target (database or data warehouse)... (defn from Wikipedia) "AnyOne can go to BlockBuster and rent the Perfect Storm" -Billus Brutzmanicus -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Debster Sent: Wednesday, July 29, 2009 12:50 AM To: U2 Users List Subject: [U2] What ETL? Just takin' a survey What ETL tool do you use - Why do you like it? Ease of use "Anyone can hold the helm when the sea is calm". -Syrus Publilius ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Using PHP
While it makes sense to me to consider using PHP as middleWare to do SQL things... What are the advantages of using PHP with U2 rather than UniObjects for Java or .Net? Insights would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Locked License Seat {unclassified}
Do you have any rogue "cmd.exe" processes running on the server? One of the most common causes we've seen for stuck licenses is that the uv session launched a DOS /c command line process that was somehow problematic. Killing the uv process was not enough, the cmd.exe process it launched had to be zapped as well, only then would the uvlictool free up the license. Dan > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of MACK ANDREW, MR > Sent: Tuesday, July 28, 2009 10:33 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] [UV] Locked License Seat {unclassified} > > Hi all, > > I have a small problem with a license seat (42) that is being consumed > by a PID (2160) according to uvlictool, but that is not showing up in > PORT.STATUS or the Windows tasklist. > > I have tried uvlictool clean_lic -a and both kill 2160 15 and kill 2160 > 9 with no effect. UniVerse has been restarted several times since it > started to show up and that hasn't shifted it. ANALYZE.SHM advises that > there is no printer segment attached to the PID so it just seems that it > is a tied up license issue. > > I cannot find any info on anything besides uvictool that would allow me > to examine or clear the license, so before I escalate this to IBM, does > anyone have any ideas? > > UniVerse 10.1.18 on Windows 2003 Server R2 > > Thanks for you help. > > Andy > > The information contained in this Internet Email message is intended > for the addressee only and may contain privileged information, but not > necessarily the official views or opinions of the New Zealand Defence > Force. > If you are not the intended recipient you must not use, disclose, copy or > distribute this message or the information in it. > > If you have received this message in error, please Email or telephone > the sender immediately. > ___ > 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] [UV]recurring database, indexing and deadlatch errors
Hello U2 group, Probably a good question. We define a < recurring > file. Attribute<1> refer to a record in the same file (pointer to a parent record). We have a I-Type SUBR which return the "root" key/item of a current item (read the parent until parent = @NULL ) Then we create a index with this I-type to retrieve easily the items childs of a "root-id". All work fine ... except when the root-item is stored on the same FileGroup of the child-item. (at TCL, *RECORD file root-id* return the same value then *RECORD file child-id*) If this occurs, at the write step (save a child record) into the SUBR called by indices processing, we get a "Self deadlatch error" and return to TCL. This occurs because we are in a "write" which is a internal "transaction with isolation level 0" and we try to read a record already in the isolation. Do you have any idea to solve it ? Thanks by advance. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Locked License Seat {unclassified}
Try kill -15 2160 kill 2160 15 and kill 2160 9 with no effect. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What ETL?
Hi, E.T.L. which one ? A in-house SB+/BASIC dev composed with 2 parts : - SB+ interfaces to define mapping & extract options (Extract, Transform E.T. ) -- tablename --- link to filename(s) (same file into multi-account or multi-file with the same structure) --- human name of the table (for metadata providing to request tool) --- long description of the table (for metadata providing to request tool) -- columnname --- linked to Itype or SB+ expression to extract data --- sql-datatype --- human name of the column (for metadata providing to request tool) --- long descrition of the column (for metadata providing to request tool) --- specify the column indexing properties into dw -- options --- process before extract (to prepare temp file if necessary) --- select clauses to filter data --- process after read record (to transform the datas by BASIC if necessary) --- dw refresh rhythm incremental real time (based on trigger update trap) incremental time stamp (based on a time stamp, if exist into record) partial, based on select criteria complete - BASIC subr to extract data from files via E.T. and build SQL stmt to update data warehouse (Load L.) We run under Universe, Unidata, D3. We run in front of data warehouse running under MS-Sql, Orable, DB2, mySQL, Unidata, Universe(sql-schema), or direct access - Datawarehouse can be on the same server or separate. We have routines to interfaces data from outside U2 (xls, mdb, other-sql db, ...) and merge it into DW. The really big advantage is : - we work directly into the native structure of U2 (mv'ed, sv'ed, record_on_fixed_key, "special storage organisation") - we use BASIC power to extract, transform data - the deployment consist to deploy one account with subr and one file with ETL defn per application - we build SQL stmt via template which can be "dedicated" by sql-db specificity Manu > -Message d'origine- > De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] De la part de Debster > Envoyé : mercredi 29 juillet 2009 06:50 > À : u2-users@listserver.u2ug.org > Objet : [U2] What ETL? > > Just takin' a survey > > What ETL tool do you use - > > Why do you like it? > > Ease of use > > > > > "Anyone can hold the helm when the sea is calm". > -Syrus Publilius > > > > > > > > > ___ > 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