DIS TABLE "lowercase.name"; receive error E DC601014 TABLE IS NOTIN DICTIONARY

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

When attempting to display a table name with lowercase characters, it cannot be found. 

E DC601014  TABLE IS NOT IN DICTIONARY              

For example: 

DIS TABLE "BSQL1.apk_pkc_TBL";                                                  
*+ Status = 1        SQLSTATE = 01600        Messages follow:                   
*+ DB004205 T9126 C1M6018: ERRORS detected in processing request                
*+ E DC601014  TABLE IS NOT IN DICTIONARY                               WORD  3 

Environment

Release : 19.0

Component : CA ADS

Cause

The quotes around the Schema and Table Name prevented the names from being converted to uppercase.

Resolution

Remove the quotes from the Table and Schema from the UPDATE statement so that it will be converted to uppercase:

For example: 

UPDATE "BSQL1"."apk_pkc_TBL" 

We will not convert these names to uppercase when quoted.

 

Additional Information

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-idms-reference/19-0/sql-reference/identifiers/expansion-of-table-name.html