Re: Accessing a file member in SQL

["David Turnidge" <daveturnidge@xxxxxxxxx>]

Thank you all for your answers. It appears that OVRDBF is what is working
best.

Dave

On Tue, Apr 22, 2008 at 8:42 AM, <rob@xxxxxxxxx> wrote:

> Dave,
>
> ALIAS is one way.
> OVRDBF to the particular member is another.
> Converting the file from multiple members to a single member is what I'd
> recommend.  Multiple members forbid the use of Constraints.
> You could also SPENDMONEY and get a product from IBM that supports
> multiple members.  I forget if it is SMP or DB2 multi system.  In that
> scenario members are called partitions.  We don't have it so I can't
> comment further.  I bet you'd have to modify your tables anyway.  For
> example if you segment members by year and don't include the year as a
> column in the table because it's already in the member name, you're going
> to have to change.  Now, if the year is based off of a date stored in the
> table you're probably ok.
>
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> "David Turnidge" <daveturnidge@xxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 04/22/2008 09:29 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
> cc
>
> Subject
> Accessing a file member in SQL
>
>
>
>
>
>
>  We've been looking around (unsuccessfully) for a way to access a file
> member
> in an SQL SELECT statement. Can anyone direct me to an example?
>
> I just got given an example using ALIAS. Is this the way to go?
>
> Dave
> --
>  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.
>
>
> --
> 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.