AcuODBC User's Guide
Version 6.0

3.7 File Aliases

A file alias provides a way to map data files, ".xfd" files, and SQL tables. File aliases are useful when

A DSN can support a maximum of 64 aliases.

This section describes the fields on the File Alias tab and also provides an example.

Table Name

Enter the name of one of the tables in the data source that your ODBC-enabled application opens, as shown in the Microsoft Access example below.

Table names must be unique. You cannot add an alias to the list if you use a duplicate table name.


Enter the name of the ".xfd" file to be used with the table specified in the Table Name field. Enter only the file name, with neither the path leading to the file nor the extension. AcuODBC takes the path from the XFD Directory field on the General tab.

Data File

Enter the full path (including filename) where the file containing the data for the specified table is located. The data file does not need to be in the same directory as the ".xfd" file.

Write Permission

This is available only for read/write versions of AcuODBC. Indicate write permissions for the specified tables. You can specify "DSN Default," "Read Only," or "Read/Write". "DSN Default" tells AcuODBC to use the permission established in the Read Only field on the Advanced tab. Selecting "Read Only" or "Read/Write" overrides the setting on the Advanced tab.

Note: Field- or column-level write protection can be further defined by adding the READ-ONLY and HIDDEN directives to the file descriptor (FD) of your COBOL program. Refer to section 6.3.9, "READ-ONLY Directive," and section 6.3.6, "HIDDEN Directive," for instructions.

To add the file alias to the DSN definition, click Add. The alias is added to the list box in the lower part of the tab, with a check box to the far left of the row. The check in the box indicates that AcuODBC will include that entry when performing operations. Clear the check box if you do not want AcuODBC to include this alias. Select the check box again when you want to include the alias. AcuODBC keeps the alias information in memory so that you need only to select or clear a check box to indicate whether a particular file alias should be used by AcuODBC.

Acucorp, Inc.
Voice: (800) 262-6585 (U.S.A. and Canada)
Voice: (858) 689-4500
Fax: (858) 689-4550

Please share your comments on this manual
or on any Acucorp documentation with the
Acucorp Communications Department.
1988-2003 Acucorp, Inc.
All rights reserved.