Re: Adding a member to an index

Hi, Sharon:

Reading this again, I wonder if perhaps you are talking about SQL indexes? :-o

(That is a little trickier, since standard SQL does not have "members" ... that is an IBM i5/OS DB2/400 extension .. )

If that is what you are talking about, I think you can do something like this (in DB2 SQL) ...

Suppose you have a multi-member physical file called Sales, with one member for each month ... January, February, March, etc.

You can create an alias for each member, so that you can access each member as if it is a "table" in SQL:

create alias SalesMarch for Sales ( March )

Once you do that, I believe you can just do normal a "create index" for "SalesMarch" just like you would for any other table ...

Let me know if that works for you ...

Thanks,

Mark S. Waterbury

Sharon wrote:

Hello, I am trying to figure out how to handle adding a member to an index on a file. Did some testing, added a member to the main file, and the index does not automatically pull it in like a LF would.
When I dropped the index and recreated it, you cannot see if it is there when you do a WRKF command, and the total records listed went down from it's previous amount.

What is the proper way to handle this? Any help would be appreciated.

Sharon

_________________________________________________________________
Hotmail® is up to 70% faster. Now good news travels really fast.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_70faster_032009