When creating a transport map, you can define a map that uses tables in the local database. The tables accessed in these maps must be predefined using the Local Database window. For more information, see Using a local database.
The Transaction Server's support of Local Database tables is restricted to disk based tables. Local Database tables created in memory are not supported by transport maps and the Transaction action.
To specify a local database, follow these steps:
- From the Transport Map window, click the
Transport drop-down.
A list of default local database transports appears.
- Select the database transport you want to
use.
The bottom of the Transport Map window changes to accommodate the local database transport.
The table actions available for a Local
DB table are the same as the actions for any of
the supported commercial database products such as DB2,
Oracle, and SQL Server. Notice that there is no schema
(database user) when adding a local database.
The above screen shows an example transport map with a Select
operation. It is possible to use a Where clause
and Order By statements.