RE: DBA Question

Tom,

This isn't completely true at v5r3.

You can create a partitioned tabled using SQL that results in a multi-member PF 
object on the iSeries.  Granted, you can't use the ADDPFM command on the 
resulting PF, but it does contain multiple members.

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Tom Liotta
> Sent: Monday, June 20, 2005 9:07 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: RE: DBA Question
> 
> 
> Jack:
> 
> I didn't see a lot of responses that seemed to get at the 
> heart of your question. Maybe I misunderstood.
> 
> One example of a 'physical' difference between a DDS logical 
> file and a SQL view is that DDS LFs can have multiple 
> members; the sub-type for SQL views will reject any attempt 
> to add more members.
> 
> Is this the kind of info you were looking for?
> 
> Tom Liotta
> 
> midrange-l-request@xxxxxxxxxxxx wrote:
> 
> >  11. DBA Question (Jack Derham)
> >
> >Got into a discussion this afternoon about what the real 
> differences are
> >between logical files, views and indexes. The discussion got 
> a little heated
> >at times so I would ask that some of you well versed members 
> to please help
> >out less fortunate uninformed members about the real 
> physical and logical
> >attributes of these object types.
> 
> -- 
> Tom Liotta
> The PowerTech Group, Inc.
> 19426 68th Avenue South
> Kent, WA 98032
> Phone  253-872-7788 x313
> Fax    253-872-7904
> http://www.powertech.com
> 
> 
> 
> __________________________________________________________________
> Switch to Netscape Internet Service.
> As low as $9.95 a month -- Sign up today at 
> http://isp.netscape.com/register
> 
> Netscape. Just the Net You Need.
> 
> New! Netscape Toolbar for Internet Explorer
> Search from anywhere on the Web and block those annoying pop-ups.
> Download now at http://channels.netscape.com/ns/search/install.jsp
> -- 
> 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.
> 
>