If you select the Hints option from the File Attributes overlays for Sybase, Oracle, and ODBC, the Table Naming Hints overlay appears as shown in Figure 3-7-A below:
Figure 3-7-A. Table Naming Hints Overlay
The Hints overlay contains this option by each naming scheme example:
· Select defaults the associated naming scheme into the File Attributes 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