SQL Application Development in CA IDMS › SQL Application Development › Testing and Debugging the Application

Testing and Debugging the Application

Testing SQL Access

You can use the CA IDMS Command Facility to test SQL statements online and to verify conditions of the database. When you successfully test a statement, you can save it in the dictionary.

Note: For more information about using the Command Facility, see the CA IDMS Common Facilities Guide.

Debugging Embedded SQL

Besides using CA IDMS debugging tools for the host language program, you can debug embedded SQL by:

• Displaying values in fields of SQL Communication Areas (SQLCAs), where the DBMS returns information about the executing program and about SQL statement execution

  Note: For more information about displaying SQLCA fields, see SQL Status Checking and Error Handling.

• Requesting a trace of all SQL commands issued from a batch application

  Note: For more information about the SQL trace facility, see SQL Trace Facility.

• Issuing GET DIAGNOSTICS SQL statements to request diagnostic information from the DBMS about the last executed SQL statement

  Note: For more information about the GET DIAGNOSTICS statement, see the CA IDMS SQL Reference Guide.