What is the procedure for adding a new index to an existing table? I have a table I created, but can't figure out how to add a new index! Thanks for any help...

Hello dwestrick

In the session Maintain Tables, there is a button <Indexes>. Using that, you can create your new index.

I realize I can "enter" an index there, but what do I do to make it take effect? Do I need to convert to data dictionary again, or what? I keep getting errors when trying to access a table I've tried to add a new index to.....

In ERP/B50 the indexes are found in the Table Definitions session, under the "Special" pull down menu.

We must have crossed in posting..
You must convert your change to runtime. If it is the first time creating the table you use create runtime. You then have to exit Baan and come back. You should see your change in General Table Maintenance then.

Hello dwestrick

Yes, of course, you would have to issue a 'Convert to Runtime DD' from the Application drop-down. After that completes, EXIT the BSHELL and restart the BSHELL. Only then you should be able to use the new index.

When you do the 'Convert to Runtime DD', ensure that you have checked 'Reconfigure Table' flag, because that is what 'establishes' the new index.

I keep getting errors when trying to access a table I've tried to add a new index to.....

What kind of errors? This may help the others to solve you problem.


Mark

The first error I actually get right now is when trying to reconfigure the table (in Convert to Runtime DD) - drop original table error 113, and it doesn't complete....

Error 113 means table is locked. You mentioned that it is an existing table. People can't be accessing that table when you convert. Depending on what table - if it has references to others etc, everyone should be off the system when you run your convert to run time. This includes any locks you placed earlier in your processes, so you should exit and come back in to run the convert on a clean shell, with everyone out.

Well, I finally managed to get this task accomplished! I think my problem was that I was trying to convert to runtime dd and reconfigure the table from within Maintain Table Definitions... As soon as I got out of that session and tried it, it worked like a charm!

Thanks everyone for your help! :)