FORMATXML

Valid for

Extract

Description

Use the FORMATXML parameter to output data in XML format, instead of the default Oracle GoldenGate canonical format. A FORMATXML statement affects all extract files or trails that are defined after it.

Note:

Do not use FORMATXML if the data will be processed by the Replicat process. Replicat expects the default canonical format. Do not use FORMATXML if FORMATASCII or FORMATSQL is being used.

Default

None

Syntax

FORMATXML [option] [, ...]

option is one of the following.

INLINEPROPERTIES | NOINLINEPROPERTIES: Controls whether properties are included within the XML tag or written separately. INLINEPROPERTIES is the default.
ONERECPERTRANS: Causes Extract to create one FORMATXML transaction per record if the SOURCEISFILE parameter is present. The default is to create one FORMATXML transaction per file.
TRANS | NOTRANS: Controls whether transaction boundaries and commit timestamps should be included in the XML output. TRANS is the default.

Example

FORMATXML NOINLINEPROPERTIES, NOTRANS