XDBIDX_ location-name

XDBIDX_location-name is an optional environment variable that is used in conjunction with the VCAT PATH option of the SQL CREATE INDEX command. To physically locate all indexes for a location on a specific storage device (drive and path), specify an index path in the xdb.ini file for each location, and subsequently create indexes using the VCAT PATH option.

The format for this environment variable is:

XDBIDX_location-name=drive-and-path

For example, to create and store all indexes for the TUTORIAL location in the path d:\indexes\tutorial (Windows) or /indexes/tutorial (UNIX), you would:

1. Make the following entry in the XDB Server machine's configuration file:

   XDBIDX_tutorial=d:\indexes\tutorial/indexes/tutorial

2. Using the USING VCAT PATH Index Option under the Create/Alter Table function in SQLWizard (Windows) or Interactive or Batch SQL (UNIX), issue the following command:

   CREATE INDEX customerindex ON customer(c_no) 
       USING VCAT PATH;