Thanks Wally, but if the dictionary it's not a direct reference to a specific atb number it WON'T be used. For example, if 1019 is a group extraction, then any *other* name using the exact same atb and group extract will be ignored. This is a big problem especially for multipart keys.
For example, let's say a key is LOCATION*INVOICE.NUMBER and there is a field definition for each part - LOC (G0*1) and INVNO (G1*1). If someone added a field defn LOCN (G0*1) - just to change a heading let's say, and this field started be propagated though out the application, any sort using LOCN will ignore the index LOC - although LOC and LOCN are the EXACT SAME THING! Currently the only option is to change all reports/selects/etc to use LOC (ouch) or add an additional index on LOCN (bad idea). Unidata needs to be smartened up so that applications can use the benefits of the database (multiple references to the same thing resulting in the same thing) without performance penalties caused by not using an existing index, or by having to update multiple indexes for the same thing. Or by having to reengineer an existing app. My .02 cents. Laura -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Thursday, January 07, 2010 5:55 PM To: U2 Users List Subject: Re: [U2] create.index and numeric dict names Certainly no problem creating a synonym dict item that is not numeric (TEN_NINETEEN?). If it is a D type - all dict items used in a SELECT/LIST WITH that references the same attribute number will use the index. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, January 07, 2010 3:29 PM To: 'U2 Users List' Subject: [U2] create.index and numeric dict names A funny on unidata 7.1 on linux - For a particular reason (don't ask why) i wanted to create an index on an attribute in a file, the dict name for this attribute is actually a number (1019) - but the command comes back :CREATE.INDEX TEMP 1019 ---------------------^ syntax error It does not like numeric dict names - anyone know if there is an option to get around this at all ?? Thanks Symeon. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users