>From jbase you can run a normal retrive/UniQuery query against the Oracle, SQL Server, etc database or you can do the normal SQL. From the RDBMS side you can only do SQL.
An interesting concept is the ability to call a Basic Program as a stored procedure from an RDBMS Query. Ie When doing a query against SQL Server the stored procedure is a BASIC program. This sounds possible with the next release of SQL Server combined with jbase. 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 Dawn M. Wolthuis Sent: Thursday, 15 April 2004 10:04 PM To: 'U2 Users Discussion List' Subject: RE: Jbase handles multivalue on RDBMS Do you know if there is a flavor of the type-it-in multivalue query language (e.g. UniQuery) that can be executed against data stored in Oracle, DB2, SQL Server, etc? I know that DataBASIC can be with jBASE and ONGroup, for example. --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 djordan Sent: Thursday, April 15, 2004 12:27 AM To: 'U2 Users Discussion List' Subject: Jbase handles multivalue on RDBMS Hi Steve Just to correct you, jbase does not require you to move to 1NF files to run on an RDBMS. Jbase will port multi dimensional data across to an RDBMS and automatically handle the conversion to multiple tables invisible to the application. The issue is in the quality of the dictionary, like lengths and data types that RDBMS do not handle breaking the rules. Jbase does handle a lot of these issues and I would assume IBM will incorporate that in U2. Also in such an environment you would not move all your files over to an RDBMS, it would make sense to leave work files and control files in Universe which are usualy the worst offenders. If you wish to make your application portable in a future environment like this, look at SQLising your files including multivalues and starting cleaning your data as this will be your biggest issue, not multivalues. Just another point, jbase does the same for Cache, which is another multi-dimensional database, although not PICK. Regards David Jordan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Mayo Sent: Thursday, 15 April 2004 4:01 AM To: U2 Users Discussion List Subject: RE: The future of U2 The way that jBase handles the problem is by requiring the database be flattened out (i.e., no multivalues) and strict data typing. This is of course the standard with 1NF databases. Unfortunately for most of us, it means a complete redesign of the existing mv database structure. Over the past several years, all new systems that I have developed have used 1NF. Still most of the data still uses multivalues and would take years to convert. :-) Steve -- 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users