The testcat script uses the AMD2 transaction to create temporary tables and execute each CSP. At least one row is returned for each CSP, and the testcat script then drops the temporary tables.
Run the testcat script as input to your TRS. This isql example shows how to run the testcat script with a TRS named “new_TRS”:
isql -Snew_TRS -Usa -P < testcat
go
This script automatically tests each of the CSPs.