RE: [U2] Capture Dictionary IDs

2009-05-17 Thread Boydell, Stuart
Bill, I'd also try to exclude any extraneous fubar in the dictionary which may have a number in attribute 2 by limiting the search to known dictionary types (ADIS). execute 'SSELECT DICT ':ThisFile:' IF FIELD.NO = ': ThisFieldNbr:' AND IF TYPE = ADIS USING DICT.DICT' capturing cap loop while

Re: [U2] Auto-updating of secondary indices.

2009-05-17 Thread Henry Unger
Do the subroutines do anything that have temporal dependencies? That is, are the values dependent on anything other than @ID and @RECORD, such as an external value coming from somewhere? _ From: Ken Ford [mailto:ken.f...@firstmac.com.au] To: u2-users@listserver.u2ug.org

[U2] Auto-updating of secondary indices.

2009-05-17 Thread Ken Ford
From my reading of the Universe documentation, secondary indices should be automatically updated. I have a case where a file has about 8 secondary indices, some of which are updated automatically, and some seem not to be. A complete rebuild is done on all these indices each night. There does

RE: [U2] Auto-updating of secondary indices.

2009-05-17 Thread Womack, Adrian
Use LIST.INDEX filename and check under the Build column, indexes usually say Not Reqd if they are updated automatically. The DISABLE.INDEX ENABLE.INDEX commands can be used to turn off/on automatic updating of the indexes. But, as Henry mentioned, if the subroutines are accessing data in

Re: [U2] Auto-updating of secondary indices.

2009-05-17 Thread ken . ford
I think I have now grasped it! Thank you all who responded. Obviously, any I-descriptors in a file that refer to other files will not be re-evaluated to automatically update a secondary index when one of those other files is updated, unless the parent file (of the I-descriptors) is itself