DMSQL - Enable or disable SQL statements

Use this command to enable the users with the TS System Administrator and TS Administrator roles in Management Console to specify SQL statements when configuring table-level operations.

If enabled, these users can specify SQL statements that control which target tables CDC Replication refreshes or truncated (cleared) on the target. If you have already specified SQL statements in Management Console and this command is used to disable SQL statements afterwards, SQL statements will not be executed.

This command can only be run from the QSECOFR user profile.

Note: The use of SQL statements may constitute a security concern in your working environment. Therefore, you should exercise caution when issuing this command to enable the specification of SQL statements in Management Console.

Applies To—Target

Parameters

Table 1. Supported keywords
Keyword	Description	Choices	Notes
ENBSQL	SQL statements status	NO, YES	Optional

SQL statements status (ENBSQL)

Indicates whether or not the specification of SQL statements in Management Console is enabled or disabled.

*NO: Specifies that SQL statements cannot be entered in Management Console.; This is the default setting.
*YES: Specifies that SQL statements can be entered in Management Console.