DDL not converted to upper case executing RC/Migrator analysis
search cancel

DDL not converted to upper case executing RC/Migrator analysis

book

Article ID: 255740

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS

Issue/Introduction

Why is RC/Migrator for Db2 for z/OS (RCM) analysis not converting DDL to upper case.


For example:

CREATE TABLE "Table_creator.Table_name"
... 

The DDL remains case sensitive and the table creator and table name are not converted to upper case.

Resolution

It is the double quotation marks "   "  that are preventing the translation of the lowercase schema and object names to uppercase.
Without the double quotes, then the lowercase will be converted to uppercase as expected.