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.

Article Id: 17431
Status: Published
Updated On: 21-03-2018 07:13
Legacy Id: TEC618479
Products:
CA CIS , CA Common Services for z/OS , CA 90s Services , CA Database Management Solutions for DB2 for z/OS , CA Common Product Services Component , CA Common Services , CA Datacom/AD , CA ecoMeter Server Component FOC , CA Easytrieve Report Generator for Common Services , CA Infocai Maintenance , CA IPC , Unicenter CA-JCLCheck Common Component , CA Mainframe VM Product Manager , CA Chorus Software Manager , CA On Demand Portal , CA Service Desk Manager - Unified Self Service , CA PAM Client for Linux for zSeries , CA Mainframe Connector for Linux on System z , CA Graphical Management Interface , CA Web Administrator for Top Secret , CA CA- Xpertware , CA Compress Data Compression for MVS , CA Compress Data Compression for Fujitsu , CA Datacom , CA Disk Backup and Restore - MVS , CA DISK BACKUP AND RESTORE- ADD-ON OPTIO , CA DISK BACKUP AND RESTORE , CA Ideal , CA CIS , CA Common Services for z/OS , CA 90s Services , CA Database Management Solutions for DB2 for z/OS , CA Common Product Services Component , CA Common Services , CA Datacom/AD , CA ecoMeter Server Component FOC , CA Easytrieve Report Generator for Common Services , CA Infocai Maintenance , CA IPC , Unicenter CA-JCLCheck Common Component , CA Mainframe VM Product Manager , CA Chorus Software Manager , CA On Demand Portal , CA Service Desk Manager - Unified Self Service , CA PAM Client for Linux for zSeries , CA Mainframe Connector for Linux on System z , CA Graphical Management Interface , CA Web Administrator for Top Secret , CA CA- Xpertware
Issue/Introduction:

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.

Environment:

Release: DATABB00200-14-Datacom/AD
Component: