Who's On?

	Membership:
	Latest: Brenda Carpenter
	Past 24 Hours: 0
	Prev. 24 Hours: 1
	Overall: 5223

	People Online:
	Visitors: 48
	Members: 0
	Total: 48

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

No Key Change Index

7 Replies

0 Subscribed to this topic

28 Subscribed to this forum

Sort:

Author

Messages

Angela Collins

Basic Member

Posts: 20

5/2/2011 10:21 PM

I need a custom index on APVENMAST by Tax ID and Tax ID Type. When I created it originally, I didn't set it up as a key change index. It failed. I change the yes to a no, did a blddbdict, and no changes were picked up. I tried deleting the index and starting all over. I just do not seem to get the index fixed. Is there a trick to this in 9.0.1.7?

Ragu Raghavan

Veteran Member

Posts: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

5/2/2011 11:07 PM

Doesn't a blddbdict need to be followed by a dbreorg for the changes to become effeective?

John Henley

Posts: 3365

New Poster

Engaged Reader

Avid Reader

5/2/2011 11:21 PM

What do you mean by "no changes were picked up"? =

John Henley

Posts: 3365

New Poster

Engaged Reader

Avid Reader

5/2/2011 11:51 PM

You should also recompile any programs that use your index. =

Angela Collins

Basic Member

Posts: 20

5/3/2011 9:46 PM

When I change the value from Yes to No and do a blddbdict, there are no changes.

John Henley

Posts: 3365

New Poster

Engaged Reader

Avid Reader

5/3/2011 10:21 PM

No changes where? In the database?=

CindyW

Veteran Member

Posts: 169

5/4/2011 1:03 PM

I'm assuming he means that there was no + dictionary file created. We've run into this a few times now with indexes...and often, depending upon what it is that is being changed, we have to "force" a + file. In other words....make a different, obvious change, do the blddbdict/reorg, then remove that change, and add your custom change, and then do the blddbdict/reorg again. That will pick it up.

John Henley

Posts: 3365

New Poster

Engaged Reader

Avid Reader

5/4/2011 1:18 PM

In the case of a key change, I don't believe there is any change made to the database; key change is supported by all databases now supported by LSF9, so there really is nothing that gets implemented in the database, therefore no + dictionary and/or dbreorg required. The key change logic is implemented by the Lawson database layer; just make sure you recompile any affected programs, and that should be all that is needed.