MySQL DDL Queries on API Gateway runtime

book

Article ID: 124980

calendar_today

Updated On:

Products

STARTER PACK-7 CA Rapid App Security CA API Gateway

Issue/Introduction



There was a specification inquiry from customers planning to use MySQL as an external DB.
Does API Gateway issue the following DDL without operation of Policy Manager etc on runtime?
 
* DDL (Data Definition Language):
ALTER TABLE
TRUNCATE TABLE
OPTIMIZE TABLE
REPAIR TABLE
RESTORE TABLE

Environment

API GATEWAY 9.4

Resolution

The answer is  ‘No’ as there is no such documentation or relevant information.