Editing the DBMS property

StepsTo stop Database Trace by editing the DBMS value in a PowerBuilder script:

  1. 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"