Description:
After CA Datacom SQL 14.0 PTFs RO69039 (CARS1406) and RO70910 (CARS1407) were applied, a Datacom/AD 14.0 site was unable to use SQL to DROP a Table.
In the case encountered, an ENF 14.1 customer received the following errors when attempting to run job CASQL04 in order to DROP tables as instructed by the ++HOLD action in ENF 14.1 PTF RO54507:
AUTHID=CAS9ENFS INPUT STATEMENT: DROP TABLE CAS9ENFS.CICSTERM; ___________SQL ERROR SUMMARY START___________ SQLCODE = -999, SQLSTATE=56S19 MESSAGE = INTERNAL ERROR (DDServ LINE 0341): STMT NOT ALLOWED IN AD MUF ____________SQL ERROR SUMMARY END____________
Solution:
Apply PTF RO72082 to re-allow the use of the DROP function then rerun the failing DROP job.