Havving played with XML (and not very deeply) I got the impression that one can "join" FILEs to give you effective sub-sub-sub style nesting .
However, seeing as my testing was limited to exporting a "nearly-flat" file into MS's Infopath, I didnt' try digging very deeply. Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: 27 April 2004 23:08 To: 'Ronald Bourret' Cc: [EMAIL PROTECTED] Subject: RE: XML and U2 You are correct that the built-in XML <--> U2 utilities go to sub-values and I think it makes sense to ignore the text values information at this point. Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -----Original Message----- From: Ronald Bourret [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 4:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML and U2 Thanks. That clarifies things and I'll modify the entry for UniVerse to account for this. You do raise a new question when you say: "The database comes pre-loaded with functions on multi-values and multi-valued sub-values and users write similar functions to lower levels if needed." Does this mean that you can have sub-sub-values, sub-sub-sub-values, and so on, ad infinitum? If so, do the XML tools handle this, adding more sub-elements as needed? The XML <=> DB mapping languages for UniData and UniVerse don't seem to handle this, except that the documentation for UniData seems to allow one level beneath sub-values, saying something about adding another sub-element in the case of text marks. (I dutifully ignored this, having spent too much time on the entries already :) -- Ron "Dawn M. Wolthuis" wrote: > > Hi Rob -- > It is the rare table, indeed, that is created with a sql CREATE TABLE > statement in a U2 database. U2 has SQL as a second language. It is not > really an RDBMS, but uses a data model very similar to the one used by XML > (a tree or di-graph structure). > > With the CREATE-FILE command a file gets created and then when a dictionary > is populated, it is descriptive of the data (so not quite the same as an > RDBMS that way) and can include sub-fields. > > The database comes pre-loaded with functions on multi-values and > multi-valued sub-values and users write similar functions to lower levels if > needed. Let me know if that doesn't quite answer the question. Thanks. > --dawn > > Dawn M. Wolthuis > Tincat Group, Inc. > www.tincat-group.com > > Take and give some delight today. > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Jerry Banker > Sent: Tuesday, April 27, 2004 11:30 AM > To: U2-Users > Subject: Fw: XML and U2 > > I finally got an answer back from Ron Bourret and he has added the U2 > products to his XML enabled list of databases. Anybody want to answer his > question? I could do it but I'm kind of busy right now. > Jerry > ----- Original Message ----- > From: "Ronald Bourret" <[EMAIL PROTECTED]> > To: "Jerry Banker" <[EMAIL PROTECTED]> > Sent: Monday, April 26, 2004 6:32 PM > Subject: Re: XML and U2 > > This is to let you know that I've finally added UniVerse and UniData to > the list. You can see the entries at: > > http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#unidata > http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#universe > > Comments / corrections welcome. > > (One question I had was whether UniVerse supports multi-subvalued > columns as well as multi-valued columns. There are a number of > references to subvalues in the documents, but the UniVerse CREATE TABLE > command does not seem to support them...) > > Thanks for you patience, > > -- Ron > > > Jerry Banker wrote: > > > > Ronald Bourret, > > Looking over your list of XML enabled databases I was impressed > > however I noticed that you included IBM's DB2 product but excluded > > IBM's most XML like databases referred to as their U2 product line > > (uniVerse and Unidata). Both U2 products are post-relational and use a > > nested file architecture very much similar to XML design and do have > > XML transformation tools (uniVerse more so than Unidata at the latest > > revision). XML documents can be output through their query language > > and imported into the database through simple commands. Another > > advantage is that the database can be accessed through it's native > > query language or with SQL. You should look into these products if you > > have not already. > > http://www-3.ibm.com/software/data/u2/ > > > > Jerry Banker > > Member U2UG > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users **************************************************************************** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. **************************************************************************** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
