LargeStatementSupport

The LargeStatementSupport parameter specifies whether the High-speed Apply Engine can process SQL statements or logical log input records that are longer than 262,144 bytes (256 KB).

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[StartUp]

Abbreviation

None

Required?

No

Valid values

Yes, No

Default value

No

Related topic

StartUp-parameters

Usage

Specify one of the following values for the LargeStatementSupport parameter:

  • No directs High-speed Apply Engine to issue error message BMCAPT0046 if either an SQL statement or a logical log record in the input file is longer than 256 KB bytes. No is the default value.
  • Yes directs High-speed Apply Engine to extend the limit on an input statement of record to 1,048,576 bytes (1 MB).

If you are processing logical log input that includes data from large volume columns (such as XML or LOB columns), consider specifying Yes for this parameter to accommodate the larger amount of data. If processing in your environment requires that you process an SQL statement or a logical log record that is longer than 1 MB, contact BMC Customer Support for assistance.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*