adding a condition to a table (dbdef)

Did you run the blddbdict / dbreorg process to implement the change to the database? You could also use rngdbdump or database tools to confirm.

Brian, I have run blddbdict/dbreorg multiple times. I can run a rngdbdump, but it doesn't have a condition option. The condition looks like its there but when I go to use it, it says it's not. You can see that it is there in the screen shot from MS Add-ins query wizard. Thanks, Karen

I'm not aware of any other requirements to add the condition successfully, but I haven't worked with adding conditions. Maybe someone else can give input. The Condition Report may help to tell if it's added or not. cndrpt productline [filename] List existing rules for conditions in the specified file.

Brian, Thanks for the info on that report. It shows all 3 conditions; the 2 original ones and the new one. They are all defined the same. Thanks, Karen

I decided to use a work around by adding a new index. It's doing the same thing with the index. The index is in dbdef and in the physical database (Oracle). I can see it in the MS Add-ins query wizard, but when I try to use it, it tells me it's not there. I made table changes to several other tables within the last month with no problems. And we have not taken any LSF patches in a long time. I have done a verifyora11. Is there any other utility that checks for dictionary issues? Thanks, Karen

I’m not sure why, but an IOS Cache refresh resolved the issue. I would understand it, if I couldn’t see them. But, since I could see them you would have thought I could use them. But, after the IOS Cache refresh, I was able to use both the condition and the index.

I guess it would be similar to updating bookmarks, but the runtime and users can't see the changes until you refresh. That's good to know. Thanks for the update.