Controls the tracing of software-generated SQL commands.
SET SQLTRACE ON|OFF
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.
> 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.