If you select the Hints option from the FMS Controls overlay for Sybase, Oracle, or ODBC in File System Groups File Maintenance, the Table Naming Scheme Hints overlay appears as shown in Figure 2-20-A below.
Figure 2-20-A. Table Naming Scheme Hints Overlay
The Hints overlay contains this option by each naming scheme example:
· Select defaults the associated naming scheme into the FMS Controls overlay.
There are other macros available for use in a table naming scheme besides the examples displayed on the screen. A complete list of macros is provided below:
· $host host name
· $engine APPX engine version
· $endian 'intel' or 'risc'
· $root $APPXPATH
· $uid 3-character APPX User ID
· $user OS User ID
· $pid OS Process ID
· $appl File's application ID
· $ver File's application Version
· $db File's Database ID
· $scope Process nesting level
· $file 8-character file name
· $type "Data", "Struct", "Portdata", etc.
· $anything-else An environment variable
For example, the normal location for an APPX data file would be:
$root/$db/$ap/$type/$file
If you wanted to invert the database/application hierarchy, it would be:
$root/$ap/$db/$type/$file