EXPORT TABLE

EXPORT TABLE — Specifies that a table is for export only.

Synopsis

EXPORT TABLE table-name

Description

At runtime, any records written to an export-only table are queued to the export connector, as described in Chapter 13, Exporting Live Data. If export is enabled, this data is then passed through the connector to the export client that manages the export process.

The EXPORT TABLE statement lets you specify which tables in the schema are export-only tables. These tables become write-only. That is, they can be used in INSERT statements, but not SELECT, UPDATE, or DELETE statements.

If export is not enabled at runtime, writing to export-only tables has no effect.