DB2 7.1
Fixpack 10
W2K SP4

How do you put an underscore in the database name? When I restore a database from CLP using the following command:

restore database TESTDATABASE from d:\backup\ taken at 20050111190052 to d:\ into TEST_DATABASE

I get the following error:

SQL0104N An unexpected token "TEST_DATABASE" was found following "INTO"
Expected tokens may include: "<database-alias>". SQLSTATE=42601

I know that underscore is a valid character since our live database has an underscore in it. I just don't know how it was setup that way.

Thanks
Justin

This isn't the actual command you're issuing, is it? As far as I know the length of the database name (or alias) is limited to 8 characters...

You're right. I just tried it with a shorter name with an underscore and it worked fine.

Thanks
Justin