2.217 SUPPRESSALTERMESSAGES | NOSUPPRESSALTERMESSAGES

Valid for

Extract

Description

Use SUPPRESSALTERMESSAGES to instruct Extract to display the first ALTER message it encounters for a table, but suppress that table's subsequent ALTER messages. Secondary partition ALTER messages resulting from the initial ALTER operation will also be suppressed.

When SUPPRESSALTERMESSAGES is set, only one ALTER will be seen in the Extract report and EMS for a base table, even if numerous ALTER operations are performed on that table during the run of the Extract process.

No ALTER messages will be seen for a table that has been excluded for the Extract.

Default

NOSUPPRESSALTERMESSAGES

Syntax

SUPPRESSALTERMESSAGES | NOSUPPRESSALTERMESSAGES