An error might occur when you are running an SQL procedure query against a DB2 table in the z/OS operating environment


An error might occur when you run an SQL procedure query to read a DB2 table and the query contains the PUT function. The errors that result are similar to one of the following:

ERROR: Error during in-database processing. ERROR: General error ERROR: Error during in-database processing. ERROR: TKTSPrepare failed.

The first error occurs when the required DB2 SASTKTS plan has not been created. The second error occurs if the SASTKTS package has been incorrectly added to the SAS93 or SAS94 DB2 plan.

To eliminate the errors, fix your DB2 bind statements to include code to create the SASTKTS plan and to not include the SASTKTS package in your SAS93 or SAS94 plan.