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.

book

Article ID: 17431

calendar_today

Updated On:

Products

CA Compress Data Compression for MVS CA Compress Data Compression for Fujitsu CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server 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 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 Datacom/AD

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: