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.

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.