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.

Related Topics