CA Datacom/AD 14 0 sites should also apply PTF RO72082 if Datacom SQL 14 0 PTFs RO69039 and RO70910 have been applied. These are needed if SQL DROP Table feature to be used.

Document ID : KB000017431
Last Modified Date : 14/02/2018
Show Technical Document Details

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.