AW: Tables and PFs

the table can have one and only one member.

Not quite true! It is possible to generate partitioned tables and a
partition is nothing else than a member.
(Even though IBM recommends only to use partitioned tables only for really
large tables, i.e. the maximum number of rows (4.2 Billion) or the maximum
space 1.7 tera byte will be reached soon)

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Jeff Crosby
Gesendet: Wednesday, 13. January 2010 13:57
An: Midrange Systems Technical Discussion
Betreff: Re: Tables and PFs

How tables get created is important for all the reasons you point out, but

I

don't think we should start calling SQL created PF's tables and DDS

created

PF's files, do you ?

I don't mean to be pedantic (always wanted to use that word <g>), but there
are enough differences that maybe we should.

Another difference between a DDL created table and a DDS created PF is that
the table can have one and only one member. That's been discussed here
before, but I don't think it was mentioned in this thread.