Re: Accessing a file member in SQL

[rob@xxxxxxxxx]

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