4GL_USEDIR_LEVEL

Restriction: This topic applies only when a Database Connectors license has been installed via the Micro Focus License Management System.

This variable provides a method of mapping filenames (with directory information) to table names. 4GL_USEDIR_LEVEL lets you use files of the same name, which would normally go into separate directories, as separate names in a single database. This variable determines how many levels of directory information to use as part of the table name.

If set to the default value of 0, all directory information is removed from the filename before it is used as a table name
When set to negative values, nothing is done differently
When set to a positive value, the number determines how much directory information to keep

For example, given the file /home/data1/gl/master.dat, the following values result in the given table name:

4GL-USEDIR-LEVEL	Final resolved name
0	master.dat
1	glmaster.dat
2	data1glmaster.dat
3 or larger	homedata1glmaster.dat

This variable has an upper limit of 127 characters and is currently available with the Database Connectors for Microsoft SQL Server interface. Any special instructions are included in the section describing support.

The 4GL_DB_MAP configuration variable enables you to set one map at a time. 4GL_USEDIR_LEVEL interacts with 4GL_DB_MAP as follows.

4GL_DB_MAP is tested first, to determine which database to search for the table
Then 4GL_USEDIR_LEVEL is used to change the final name of the table