Catalog DB Problem in 7.2

[Al Murry]

Production is running in 6.1 with a db name
of AUTO.

Trying to upgrade to 7.2 and I cannot catalog this DB.
It will not take the identifier.

"" An unexpected token "AUTO" was found following "DB" "

Changing the prod name would require a "LOT" of code change.

any ideas?

[Jan M. Nelken]

Al Murry wrote:

Production is running in 6.1 with a db name
of AUTO.

Trying to upgrade to 7.2 and I cannot catalog this DB.
It will not take the identifier.

"" An unexpected token "AUTO" was found following "DB" "

Changing the prod name would require a "LOT" of code change.

any ideas?

As per DB2 Documentation:

There are no specifically reserved words in DB2 Version 8. Keywords can
be used as ordinary identifiers, except in a context where they could
also be interpreted as SQL keywords. In such cases, the word must be
specified as a delimited identifier.

So you *still* may need to have a "LOT" of code changes - this will work:

DB2 CATALOG DB PROD AS \"AUTO\"

but then - at least from CLP - you would need to issue:

DB2 CONNECT TO \"AUTO\"

As for your application code - I am not sure what would be required to
change.
Jan M. Nelken