Previous Topic: Error Appears After Starting JBossNext Topic: Errors While Configuring the Web Application Module

Troubleshooting Articles › Error Dropping the TSF Database

Error Dropping the TSF Database

Symptom:

When I try to run the TSDB102 member in custom_hlq.CETJJCL, the job fails with RC=0020. The failing step is DBSQLPR, in which each SQL command fails with the following error:

SQLCODE = -20, SQLSTATE=42601    
MESSAGE = BAD SYNTAX: <DROP TABLE TSF.tablename  QUERYNO
WHEN THE ERROR OCCURRED, THE SYNTAX BELOW HAD BEEN PARSED:
  DROP TABLE TSF.tablename   QUERYN                      

Solution:

Apply the current CA Datacom/AD maintenance.

For an immediate work-around, follow these steps:

  1. Make a temporary copy of CETJDATA(DB400308).
  2. Edit the copy to remove QUERYNO and the number following it. 
  3. Verify that each line ends with a semicolon.
  4. Use this copy as the SYSIN data set in the DBSQLPR step of TSDB102.