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.

Syntax 
sa_statement_text( txt )
Arguments

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

Remarks

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

Permissions

None

Side effects

None

See also
Example

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''' );
stmt_text
1 SELECT *
2 FROM car
3 WHERE name = 'Audi'
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0