There are a variety of ways that this can be achieved. 1. the records are stored in the relational database as a raw string including value marks etc. This is meaningless data to DB2 users. 2. The data is converted into two dimensional databases, requiring data typing, length definitions, etc. Dirty data will be an issue that can be covered a number of ways. The data will still look multi dimensional to the application.
The index data and dictionary will likely stay in universe. For performance the record locking will probably remain in Universe, meaning there can be no updating from the DB2 side or there will be corruption. RDBMS cannot handle row locking as efficiently as PICK. Regards David Jordan Managing Consultant [EMAIL PROTECTED] Dacono Holdings Pty Ltd Business & Technology Consulting PO Box 909 Lane Cove NSW 2066 Australia Ph 61 2 9418 8329 Fax 61 2 9427 2371 www.dacono.com.au -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon Glorfield Sent: Thursday, 15 April 2004 6:45 AM To: 'U2 Users Discussion List' Subject: RE: The future of U2 I don't really care what the backend DB engine is as long as I can use my favorite set of tools to develop applications. But if a change to DB2 or whatever is going to force me to severly change the way I operate, then I'd see that as a bad thing. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- 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