Navigator User Guide

10.5.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Extraction Map Names

An extraction map name has a specific format that varies by source type.

The following general format is initially used:

xnninstance.mapname

After you extract changes using an extraction map, the table name is appended to the extraction map name:

xnninstance.mapname_tablename

The variables in the extraction map name are:

x: A character that indicates whether the extraction map was generated or user-defined. Valid values are:

d
. Default extraction map that PowerExchange generated.

u
. User-defined extraction map.
nn: A one- or two-character value that defines the source type. Valid values are:

1
for DB2 for z/OS.

2
for IMS.

3
for DB2 for i5/OS.

4
for Adabas.

6
for VSAM.

7
for CA Datacom/DB.

8
for Oracle.

10
for Microsoft SQL Server.

B
for DB2 for Linux, UNIX, and Windows.

D
for IDMS log-based.

e
for MySQL.

f
for PostgreSQL.
instance: The instance name that was specified or generated when the registration group was created. The instance value varies by source type.
mapname: One of the following values:

For a default extraction map, the user-defined name that was specified for the capture registration.

For a user-defined extraction map, the
Map Name
value that was specified when the extraction map was manually created.
tablename: The table name of the relational source table, or the source data map name.

In extraction maps, the xnninstance variable string is called the schema. When you open an extraction group, PowerExchange Navigator displays the extraction maps in the group as schema.mapname. When you extract changes using an extraction map, the full extraction map name of schema.mapname_tablename is used.

For example, when you run a database row test, PowerExchange Navigator generates the following SQL statement to extract the changes:

SELECT * FROM schema.mapname_tablename

In the database row test, all columns are selected by default. However, you can edit the SQL statement to select specific columns in either of the following ways:

In the

Database Row Test

dialog box, manually edit the SQL statement in the

SQL Statement

box to select specific columns.

In the

Extract Definition

window, select specific columns and run a database row test.

PowerExchange generates an SQL statement in the

Database Row Test

dialog box that selects the specified columns.

You can override the schema name and map name by using the