Uppercase and Lowercase

All DMSII data set, data item, and set names are uppercase. These names are also stored in uppercase in the DATASETS and DMS_ITEMS client control tables. Their equivalent relational database table, column, and index names are stored in lowercase in the DATATABLES and DATAITEMS client control tables.

  • All DMSII data set names are stored in the DATASETS client control table in uppercase, just as they appear in the DMSII database. The equivalent relational database table name is converted to lowercase and is stored in the DATATABLES client control table. Thus, a data set named CREDIT in the DMSII database is named credit in the relational database.
  • All DMSII data item names are stored in the DMS_ITEMS client control table in uppercase, just as they appear in the DMSII database. The equivalent relational database data item name is converted to lowercase and is stored in the DATAITEMS client control table. Thus, a data item named LIMIT in the DMSII database is named limit in the relational database.

    Note: You must type these names in the correct case. If you are using the relational database table name as a character string value in a SQL statement (for example, 'tablename'), you must use lowercase.