To stop Database Trace in a PowerBuilder application script, you must delete the word trace from the DBMS property. You can do this by:
Editing the value of the DBMS property of the Transaction object
Reading the DBMS value from an external text file
You must reconnect for the change to take effect.
To stop Database Trace by editing the DBMS value
in a PowerBuilder script:
Delete the word trace from the DBMS connection property in your application script.
For example, here is the DBMS connection property in a PowerBuilder script that enables the Database Trace. (This syntax assumes you are using the default Transaction object SQLCA, but you can also define your own Transaction object.)
SQLCA.DBMS = "trace SYC"
Here is how the same DBMS connection property should look after you edit it to stop tracing:
SQLCA.DBMS = "SYC"
As an alternative to editing the DBMS property in your PowerBuilder application script, you can use the PowerScript ProfileString function to read the DBMS value from a specified section of an external text file, such as an application-specific initialization file.
This assumes that the DBMS value read from your initialization file does not include the word trace, as shown in the preceding example in “Editing the DBMS property.”
