RE: IBM DDS to DDL and native file structure to RDBMS table direc tion

Later
Vern

> -----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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.