How to resolve Reserved Word conflicts?

Question :

The script generates a separate report file called reserved words.rpt. How to resolve Reserved Word conflicts?

Environment/Conditions/Configuration :

TDBMS 15.00.04.02

Answer :

To fix reserved words found in tables, either rename the word or enclose the offending name in double quotes ("word" ).

Additional Information :

dbql_out.rpt: These tables will be dropped in the upgrade. If you wish to retain the data move the data to a new database and rename table or you may just delete data in the tables.

The following query can be ran on the 15.10 environment to show which NEW reserved words are added to 15.10

SELECT * FROM TABLE (SYSLIB.SQLRestrictedWords_TBF()) AS t1 WHERE release_introduced > '15.00' AND category = 'R' ;