Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    3

    Unanswered: Underscore in database name

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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...

  3. #3
    Join Date
    Sep 2004
    Posts
    3
    You're right. I just tried it with a shorter name with an underscore and it worked fine.

    Thanks
    Justin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •