Previous Topic Next topic Print topic


XDB_ index-name_ location-name

Restriction: This topic applies to Windows environments only.

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:

Windows:
XDB_eric.orderidx_location1=m:\anypath
UNIX:
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;
Previous Topic Next topic Print topic