Re: Accessing a file member in SQL

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.