[U2] Unidata Error

2010-12-22 Thread Paul Parkinson
Hi, Does anyone know what causes the error can't get to U_tosbcs. This has happened a couple of times for me now and each time I have had to re-install Unidata. Unidata for Windows version 7.2.5 installed on Windows 2003 server -- Kind Regards Paul Parkinson Ideal Business Services Ltd.

[U2] Migration

2010-12-22 Thread Shawn Hayes
Are there products out there to take a fully relational database and migrate it into a non-first-normal form database?   We have products out there that migrate from MV databases to fully relational databases...  How about the other way around  'We act as though comfort and luxury were the

Re: [U2] Migration

2010-12-22 Thread Kevin King
I would think the migration would be application specific. That said, it certainly wouldn't be a difficult thing to write. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Migration

2010-12-22 Thread Shawn Hayes
Why would it need to be application specific?  I was just thinking that architecturally (sometimes) there are advantages to using a non first normal form databases.  If you can read the schema of a fully relational database, couldn't you easily enough re-create the files embedding child

Re: [U2] Migration

2010-12-22 Thread Mecki Foerthmann
Even though you are right that there can be distinct advantages MV vs. Relational. But you surely wouldn't want a Product Category file that holds all the product information in multi-valued fields. Or Order and invoice data as multivalued fields in the customer file. There is obviously a little

Re: [U2] Migration

2010-12-22 Thread Shawn Hayes
I realize there is a bit more to MV database design then just parent-child relationships.  The lack of constraints is both a curse and a blessing in the MV world.  However, I don't accept that you wouldn't want a product category file that holds all the product information in MV fields or

Re: [U2] Migration

2010-12-22 Thread Dan Fitzgerald
Yeah, if you can design data objects that you can get in one read, Mazeltov! Date: Wed, 22 Dec 2010 13:04:32 -0800 From: go_mnviki...@yahoo.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] Migration I realize there is a bit more to MV database design then just parent-child

Re: [U2] Migration

2010-12-22 Thread Kevin King
Getting everything you want in one read is practical in limited circumstances. Getting what you want in one REQUEST, however... that's much more valuable. We use JSON formatted strings to pass structured data into and out of Unidata using subroutines to collect everything we need. This allows a

Re: [U2] Migration

2010-12-22 Thread Shawn Hayes
I was just thinking out loud...   First of all, I am not talking about an Easy Button. I am talking about a migration path from a fully normalized relational database (hope that is a more accurate term) to take advantage of MV database functionality. Using U2 as a Data warehouse, serving data

[U2] Daniel Jorgenson/GUS/SICK is out of the office.

2010-12-22 Thread Daniel Jorgenson
I will be out of the office starting 12/22/2010 and will not return until 12/30/2010. I will respond to your message when I return. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Migration

2010-12-22 Thread Kevin King
Shawn, while I applaud the concept of finding a way to plug a MV database in where a SQL database might otherwise be ensconced, one problem with the attempt is that while the storage itself is a different animal, more so is the access. Most of these types of apps that rely on a SQL database do so

Re: [U2] Migration

2010-12-22 Thread Shawn Hayes
I will have to think more about this...  I appreciate you sharing your experience and time!!!  'We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.' - Original Message From: Kevin

Re: [U2] Migration

2010-12-22 Thread Wols Lists
On 22/12/10 19:49, Shawn Hayes wrote: Why would it need to be application specific? I was just thinking that architecturally (sometimes) there are advantages to using a non first normal form databases. If you can read the schema of a fully relational database, couldn't you easily enough

[U2] Need help with MV assoc/I-desc

2010-12-22 Thread Jeffrey Butera
I need insight from the U2 faithful. This is Unidata 7, if that affects the answer... I have a file which has 2 associated fields, such as: XEM.PERSON = 1737292:@VM:1818182:@VM:9187311 XEM.VALUE = 23:@VM:14:@VM:99 What I'd like is a field which sorts by XEM.VALUE for the associated person

Re: [U2] Migration

2010-12-22 Thread Ross Ferris
I assume you aren't talking about just ANY old BOM, but one with 10 or 15 levels of nesting, right ;-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Mecki