
Generate Data Definition Language (QSQGNDDL) API will now produce SQL table names for VIEW and MQT definitions
In IBM® i 7.4 PTF SI77910, the Generate Data Definition Language (QSQGNDDL) API will generate the SQL table names for view and MQT definitions. Previously, the Generate Data Definition Language (QSQGNDDL) API would always generate the system file name. With this change, the SQL table name will be generated even if the original create statement used the system name.
For example, the previous output generated the file names like
this:
FROM CUST_LIB.CUSTO00001,
CUST_LIB.CUSTO00002
The new output could be like this
now:
FROM CUST_LIB.CUSTOMER_ID,
CUST_LIB.CUSTOMER_ADDRESS
