ddlCreateTokenMapping() - create a mapping from SQL-Compatabible names to TB-Compatible names

ddlCreateTokenMapping() - create a mapping from SQL-Compatabible names to TB-Compatible names ddlCreateTokenMapping() - create a mapping from SQL-Compatabible names to TB-Compatible names

ddlCreateTokenMapping() is used to create a mapping from SQL-Compatible names (referred to as external names) to TB-Compatible names (referred to as internal names).

Prototype:

   void ddlCreateTokenMapping(
      CONTROL *ctl,
      char *OptnStr,
      char *ArgList);          /* command argument list */

Permitted values in OptnStr:

/S - make external schema-names, table-names and column-names case sensitive;

Form of ArgList:

<MapInfoTableName> <SchemaNameSQL> <TableNameSQL> <ColumnNameSQL> <TableNameTb> <ColumnNameTb> ...

<MapInfoTableName> is the name of the table that contains the mapping info;
<SchemaNameSQL> is the name of the field in <MapInfoTableName> that contains the external schema name;
<TableNameSQL> is the name of the field in <MapInfoTableName> that contains the external table name;
<ColumnNameSQL> is the name of the field in <MapInfoTableName> that contains the external table name;
<TableNameTB> is the name of the field in <MapInfoTableName> that contains the internal table name;
<ColumnNameTB> is the name of the field in <MapInfoTableName> that contains the internal table name;

At the present time, this is, in fact:

      ETL#_MappedColumns ETL#_SchemaName ETL#_TableName ETL#_ColumnName ETL#_IndexTableName ETL#_IndexColumnName