SET SQLTRACE

SET SQLTRACE

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

SET SQLTRACE

SET SQLTRACE

Controls the tracing of software-generated SQL commands.

Syntax

SET SQLTRACE ON|OFF

Comments

The SQLTRACE option is set OFF by default.

When SQLTRACE is switched ON, all SQL statements generated are displayed at the terminal. SQL statements are generated during command or program parsing, interactive or interpretive execution, and compiling, if a command statement refers to an EntitySet or relationship identified as being managed by an SQL database server.

Example

> set sqltrace on
> list all Customers format CC LastName
select cc, lastname from customers

When the software parses, executes, or compiles the statement list all Customers format CC LastName with SQL tracing set on, select cc, lastname from customers appears at the terminal.

See Also

COMPILE

PARSE

SET COMPILEMODE

SET EXECUTEMODE

UNCOMPILE

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish