RE: SQL VIEW over multi-member file

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

When doing a select on a multi-member logical, SQL wants to copy all the
members' records into a temporary table.  That really sucks when there's 15
million records in each of 12 members...... Vern's ALIAS suggestion is
probably the way to go.  It's hard to maintain the alias definitions unless
the members are somewhat static.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



> -----Original Message-----
> From: vhamberg@attbi.com [mailto:vhamberg@attbi.com]
> Sent: Wednesday, September 18, 2002 5:47 PM
> To: midrange-l@midrange.com
> Subject: Re: SQL VIEW over multi-member file
>
>
> Short answer - no. SQL knows nothing about multiple
> members. You can, however, create a logical based on
> multiple members. If you don't include a key field,
> it'll read them in order of the member names you list on
> the CRTLF command. You could use ORDER BY on the result
> in a SELECT.
>
> But there's no way to select a member's records out of
> that mess.
>
> You can create ALIASes in SQL, to work with individual
> members.
>
> Regards
>
> Vern
> > This message is in MIME format. Since your mail reader does
> not understand
> > this format, some or all of this message may not be legible.
> > --
> > [ Picked text/plain from multipart/alternative ]
> > I need to know if I can create a SQL VIEW over a table that contains
> > multiple members and override to any member at run time?
> >
> > Thank you,
> > Matt Tyler
> > Mattt@wincofoods.com <mailto:Mattt@wincofoods.com>
> >
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> _______________________________________________
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>