Entity-to-Path Assignments

Entity-to-path assignments are used to provide an additional or alternative name or path for entities.

Entity-to-path assignments are used:

  • To direct individual entities to an additional path, beside the one specified by the DBMS Path property
  • To give the target DBMS table a different name than the name of the modeled entity. This is especially useful when the DBMS or operating system does not support table names that are as long as modeled entity names.
  • For a record-level DBMS, to specify the name of the directory that contains the DBMS tables.

Syntax

The exact syntax for entity-to-path assignments depends on the target connector:

  • When the target path leads to the connector for a record-level DBMS, use the following syntax:

    Entity.ApplicationModel {=} $Path:{DirectoryPath}Filename*

  • When the target path leads to the connector for a field-level DBMS, use the following syntax:

    Entity.ApplicationModel {=} $Path:Table.*

  • When the target path leads to a network connector, use the following syntax:

    Entity.ApplicationModel {=} $Path:Entity.*

You cannot use an entity-to-path assignment for a network connector to change the name of the table in the destination DBMS. To do that, use an assignment on the server machine, where:

  • Entity—name of the modeled entity.
  • Model—entity's model name, if defined.
  • $Path—default path (for example, $SYB), an installation path (for example, $INS_SYB), or a user-defined path (for example, $NETPATH). If the path is user-defined, it must be defined before the current assignment.
  • For a record-level DBMS, DirectoryPath is the name of the directory that contains the DBMS files. If no directory is specified, the current working directory is assumed.
  • Table is the name of the table (or file) in the target DBMS.
  • .* represents the default (or extensions) for the table used by the target DBMS.