|
> -----Original Message----- > From: Vern Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx] > Sent: Thursday, August 19, 2004 5:04 PM > To: Midrange Systems Technical Discussion > Subject: Re: IBM DDS to DDL and native file structure to > RDBMS table direction > > > Dave > > Do you have a link to the presentation? Maybe on the iSereis DB2 site? > > One of the statements seems a little weird--"from the current > native flat > file, keyed-sequence file structure created by DDS to RDBMS > tables created > by DDL". Why this seems strange is, the RDBMS tables created > with DDL are > exactly the same as the files created by DDS. An SQL table is > a physical > file, after all. Some attributes differ - an SQL table can > have only one > member, where a PF can have as many as allowed. Vern just a small correction. With v5r3 the iSeries now supports SQL partitioned tables. How may you ask? By using multi-member files! What's cool is that the partitioning is behind the scenes, using an SQL interface it looks like one big file. The native I/O interface continues to deal with the multi-member file as it always has. Charles
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.