LOG COMMENT

Scope

SQL Syntax

  LOG COMMENT {'String'
               :HostVariable
               :ProcedureParameter
               :ProcedureLocalVariable
               ?                       }

Parameters

String

specifies the comment as a constant character string (up to 3996 bytes)

HostVariable

specifies the comment to be logged as a host variable. No indicator may be specified. The data type of the host variable must be CHAR or VARCHAR. If the value is null, an error is returned and no comment is logged.

ProcedureParameter or ProcedureLocalVariable

specifies the comment to be logged as a procedure parameter or local variable. If the value is null, an error is returned and no comment is logged. The data type must be CHAR or VARCHAR.

?

specifies the comment to be logged as a dynamic parameter. The data type is assumed to be VARCHAR(3996). If the value is null, an error is returned and no comment is logged.

Description

• The maximum length of a comment is 3996 bytes.

• A comment can use the DBEnvironment language or the native language.

• An error is returned if LOG COMMENT is used and audit logging is not enabled with the COMMENT audit element or the COMMENT PARTITION is NONE.

Authorization

Example

   LOG COMMENT 'Select From Table PurchDB.Parts';
   SELECT PartNo FROM PurchDB.Parts WHERE PartNo='1234';