XDB_ index-name_ location-name

XDB_index-name_location-name is an optional environment variable that is used in conjunction with the VCAT NAME option of the SQL CREATE INDEX command. To physically locate each index on a specific storage device (drive and path), specify a path in the [Server] topic of the xdb.ini file for each index/location combination, and subsequently create the index using the VCAT NAME option.

The format for this environment variable is:

XDB_index-name_location-name=drive-and-path

If a qualifier is required, enter a two-part name for the index-name, such as:

XDB_eric.orderidx_location1=m:\anypath

XDB_eric.orderidx_location1=/anypath

For example, to create and store an index called customerindex on d:\indexes\customer (Windows) or /indexes/customer (UNIX) and another index called ordersindex on e:\indexes\orders (Windows) or /indexes/orders (UNIX) (both for tables in the TUTORIAL location), you would make two entries in the xdb.ini file, and issue two SQL CREATE INDEX commands as follows:

1. In the [Server] topic of the xdb.ini file, enter the following:
   Windows:

   XDB_customerindex_tutorial=d:\indexes\customer XDB_ordersindex_tutorial=e:\indexes\orders/indexes/orders

   UNIX:

   XDB_customerindex_tutorial=/indexes/customer XDB_ordersindex_tutorial=/indexes/orders

2. Using the USING VCAT Index Options under the Create/Alter Table function in SQL Wizard (Windows) or Interactive SQL or Batch SQL (UNIX), issue the following commands:

   CREATE INDEX customerindex ON customer(c_no) 
       USING VCAT NAME; 
   CREATE INDEX ordersindex ON orders(o_no) 
       USING VCAT NAME;