AcuODBC User's Guide
Version 6.0

6.5 How AcuODBC Locates XFD Files

XFD files contain the data dictionary used to map the SQL from your Windows application to the appropriate I/O requests.

The following sections describe the rules followed by AcuODBC to locate the data dictionary files. There are some general rules and the some rules specific to remote file access.

General Rules

Data dictionary files must be located in the directory specified in the XFD Directory field on the General tab of the AcuODBC Configuration property sheet. The AcuODBC driver looks for an XFD file with the same base name as the table. In this instance, the driver does not differentiate between uppercase and lowercase letters nor between hyphens and underscores.

The name of each file corresponds to the name used in the SELECT clause of the COBOL program, followed by the "XFD" extension. See section 6.2.5, "Naming the XFD File," for more information.

To locate an XFD file, AcuODBC needs the DSN and table names. If the data source is part of a master DSN, AcuODBC uses the XFD directory specified for the master DSN. If you have defined an alias on the File Alias tab of the AcuODBC Configuration property sheet, the XFD file is accessed through the name of the alias, not the original name of the file. See section 3.8, "Multicompany Support," and section 3.7, "File Aliases," for more information.

If the AcuODBC driver cannot find the XFD file in any of these places, it looks for WHEN condition tables.

Finally, if the driver does not find the XFD files in any of these places, you receive an error message indicating that the table was not found. In addition, should you have duplicate table names, the driver finds the XFD file, but the table it refers to is undefined; that is, you cannot know which of the duplicate tables it defines.

Remote File Access

Using a remote file server, you can locate data dictionary files on the remote server, but this is not necessary. This is a feature you can use at your convenience.

Note: If you using AcuODBC Server, files located on the same server where processing occurs are consider local. This section pertains to remote files and local processing, where you are running AcuServer(TM).

When you create a DSN and then decide to locate XFD files on the remote server, you must complete the XFD Directory field on the General tab of the AcuODBC Configuration property sheet with the name of the remote directory containing the XFD files. When you type the name of the remote directory, keep in mind that on UNIX, pathnames are case sensitive.

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.