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

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Yeah, Charles, is that not a strange one. Presentation is still 
single-member, for SQL standards purposes, but implementation uses multiple 
members.

I still wish the developers of SQL had gone the route of IFS, where a *FILE 
is treated as a directory, a container, and the member is the real table.

Later
Vern

At 07:58 AM 8/20/2004, you wrote:
> > -----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.