Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

sa_statement_text system procedure

Formats a SELECT statement so that individual items appear on separate lines. This is useful when viewing long statements from the request log, in which all newline characters are removed.

sa_statement_text( txt )

• txt  Use this LONG VARCHAR parameter to specify a SELECT statement.

The txt that is entered must be a string (in single quotes) or a string expression.

None

None

• sa_get_request_times system procedure
• sa_get_request_profile system procedure

The following call formats a SELECT statement so that individual items appear on separate lines.

CALL sa_statement_text( 'SELECT * FROM car WHERE name=''Audi''' );