Annotation Table/Indicator

[russokr]

Is there a utility that will set the annotation indicator on a bill index, after old annotations are deleted out of ARSANN?  The annotation indicator on the bill index is either ON or OFF, it does not indicate if multiple annotations exist for a bill.  Our annotaion table is over 12 million rows, & we want to delete annotations > than 2 years, but if a bill has more than 1 annotation associated, a
current and an old annotaion, we need to be able to determine if the annotaion indicator needs to be flipped OFF for the old annotaion that was deleted, or if there is still a current annotation associated with the bill, & the annotation indicator should remain ON.

[Justin Derrick]

12 million rows doesn't sound like a problem.  There are systems out there with individual tables of over 100 million rows of document indexes out there.

If you're seeing performance problems, make sure you're on a recent version of CMOD -- newer versions have new indexes on the ARSANN table that make searching for annotations for a specific document very fast.  Alternately, check to see that the table and its indexes don't need a 'reorg'.

To the best of my knowledge, there's no pre-built utility out there to do what you're asking.

-JD.

[Alessandro Perucchi]

Hello.

As Justin said,out of the box, there are nothing to do what you want.

But it is possible to do it, if you really want to do it.
It means going inside the Annotation table and with the help of some scripts do what you want.
You will be on your own. Since it's not supported officially by IBM.
But if you do it correctly it might work quite well.
You will need to check, of course, with each new version of CMOD, if what you did is still supported or not.

One advice, would be, is to ask IBM for an improvement. There is a thread in this website to ask for such improvement, then there are some voting, and the most wanted requests will be considered by the developpers team.
It won't be done now, but in a future version of CMOD. (Hopefully not so distant...)

Cheers,
Alessandro