Physical Database DDL Statements › Naming Conventions › Using Lowercase Letters in Identifiers

Using Lowercase Letters in Identifiers

Some physical DDL statements contain references to SQL entities. For example, you can specify the name of an SQL schema on a SEGMENT statement. If the schema name is case sensitive, enclose it in double quotes:

for sql schema "Devschm"

If you code other physical DDL entities in lower case letters, CA IDMS/DB automatically converts them to upper case.