ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 199855

calendar_today

Updated On:

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 

Cause

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

Environment

Release : 19.0

Component : CA ADS

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