Case sensitivity in model names

Model names are treated similar to database objects in SQL statements.

Therefore, the following rules apply:

  • A model name is converted to upper case.
  • A model name in double quotes is not converted.
  • Model name literals in a where clause, for example, in the LIST_MODEL() procedure, are not converted.

The following table shows examples for the case sensitivity in model names and table names.

Table 1. Case sensitivity in model names and table names
Command Result
CREATE TABLE foo (x integer) Creates a table FOO
CALL IDAX.KMEANS('model=foo ... ') Creates a model FOO
CREATE TABLE "foo" (x integer) Creates a table foo
CALL IDAX.KMEANS('model="foo" ... ') Creates a model foo
SELECT * FROM SYSCAT.TABLES WHERE TABNAME = 'foo'; Returns the table information only if the table name is foo

Literals in a WHERE clause are not converted.
CALL IDAX.LIST_MODELS('where=modelname=''foo'' '); Lists the model only if the model name is foo