Missing Table Keys

Hello,

I have an environment in which ALL keys are missing from the business data tables. I was wondering if anyone knew of a quick and easy way to replace all the keys in the tables?

Thank you,

Which OS & Database?

On the 400, the keys & indexes are stored via Logical Files. If you recreate your indexes, they will magically appear.

Physical File (PF) where the data is
Logical File (LF) keys and indexes for the PF.

HTH

db

[DB SYSTEM SETTINGS]
EnablePrimaryKey=1
(in the client jde.ini file)

Then you can run UBE R9698712 to create all Primary Keys (XJDE0002 version
will let you select data source or environment)

or you can use R98404 to recreate all indexes.

If you use R98404 take a look at oti-00-0123

This is exactly what I was looking for. Thank you much.