HP 3000 Manuals HP 3000 Manuals
LOG COMMENT
The LOG COMMENT statement permits the entry of comments into the
ALLBASE/SQL DBELog file. These comments can be extracted using the Audit
Tool, SQLAudit.
Scope
ISQL or Application Programs
SQL Syntax
{'String' }
{:HostVariable }
LOG COMMENT {:ProcedureParameter }
{:ProcedureLocalVariable}
{? }
Parameters
String is in the form of a character string constant, up
to 3996 bytes.
HostVariable is in the form of a host variable. No indicator
may be specified. The data type of the host
variable must be CHAR or VARCHAR.
ProcedureParameter or is in the form of procedure parameter or local
ProcedureLocalVariable variable. If the value is null, an error is
returned and no comment is logged. The data type
must be CHAR or VARCHAR.
? is in the form of a dynamic parameter. The data
type is assumed to be CHAR(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 selected, or the
COMMENT PARTITION is NONE.
Authorization
Any user can issue this statement from within a database session.
Example
LOG COMMENT 'Select From Table PurchDB.Parts';
SELECT PartNumber FROM PurchDB.Parts WHERE PartNumber = '1123-P-01';