Using this variable, set the case of the indexed file filenames in your destination directory. On Windows by default, the filenames are recognized in either upper, lower, or mixed case. On UNIX/Linux using the default setting enables you to access files regardless of whether they are named in upper case or lower case letters. You may need to use this variable to indicate the correct case.
If you set FILE_CASE to Upper, you can access only files that are named in upper case letters. In the reverse, if you set FILE_CASE to Lower, you can access only files that are named in lower case letters.
The following table shows the files you would find depending on the FILE_CASE:
The name of the file is stored in the system catalog at the time it is loaded using either xdbcutil or addfile. On UNIX/Linux this will be equivalent to the file name being loaded in lower case. Should you wish to access a file in mixed case, you must load the original filename in the appropriate case. You can do this with the xdbcutil program.
For a UNIX/Linux example if you wish to load an .xfd file titled myxfd that will result in an SQL table named “newtable” and reference a COBOL data file named MyDaTaFile, you would use this command:
xdbcutil -a myxfd#newtable#MyDaTaFile
In your AcuXDBC configuration file, you would need to ensure that you have the entry:
On UNIX/Linux AcuXDBC would then leave the case of the filename unchanged when it attempts to open the file.