Generate SQL will now produce SQL table names for VIEW and MQT definitions
With IBM® i 7.5, the QSYS2.GENERATE_SQL and QSYS2.GENERATE_SQL_OBJECTS procedures will generate the SQL table names for view and MQT definitions. Previously, the GENERATE_SQL and GENERATE_SQL_OBJECTS procedures 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 an example, the previous output generated the file names like this:
FROM CUST_LIB.CUSTO00001, CUST_LIB.CUSTO00002The new output could be like this
instead:
FROM CUST_LIB.CUSTOMER_ID, CUST_LIB.CUSTOMER_ADDRESS