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