For some strange reason, the DICT of each Part File needed to contain copies of the I-Types from the Distributed File's DICT in order for CREATE.INDEX to work correctly.
Next question... To avoid having to copy DICT items to all the Part Files each time a change is made, I updated the VOC pointer of each Part File to look at the DICT for the Distributed File. This seemed to work fine for the CREATE.INDEX, and each INDEX.000 record within each of the I_files (one for each Part File) has correct index information for the records within it's part file. >From a Distributed File perspective, does anyone see a problem with changing the DICT pointers for each Part File to look at the DICT of the Distributed File? Each Part File belongs to only this one Distributed File. If not, then how about the Indices themselves when combined with Distributed Files? Would each Part File not using it's own DICT cause a problem? Thanks! [EMAIL PROTECTED] group.com To: U2 Users Discussion List <[EMAIL PROTECTED]> Sent by: cc: u2-users-bounces@ Subject: Secondary Indices on Distributed Files oliver.com 02/09/2004 12:08 PM Please respond to U2 Users Discussion List I've got a Distributed File that I'm trying to create indices on. Four of the fields are D-Types, and CREATE.INDEX runs fine for them. Three fields though, are I-Types (that are compiled and working), where CREATE.INDEX gives the following error: I-descriptor must be compiled before execution. I-descriptor must be compiled before execution. I-descriptor must be compiled before execution. Program "*UVPRINTMSG": pc = 34, Variable previously undefined. Zero length string used. [000000] All seven fields are working just fine as indices on the original file that was a Static Hashed file. I'm setting up the Distributed File to get around the 2GB limit issues. Does anyone know of any limitations putting secondary indices onto distributed files? Thanks! Gary Canedy ----------------------------------------------------------- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ----------------------------------------------------------- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users