Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130

    Unanswered: Error in creating server in Federated DB

    Hi,
    We were trying to create server in Federated DB for the data source on z/os and receive the systax error. Is there anything missing here?

    CREATE SERVER TDB2
    TYPE DB2/ZOS
    VERSION 9
    WRAPPER DRDA
    AUTHORIZATION "isrc1"
    PASSWORD "*****"
    OPTIONS (DBNAME 'MHTDB2') ;

    Error as follows:
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0104N An unexpected token "TDB2" was found following "". Expected
    tokens may include: "TABLESPACE". SQLSTATE=42601

    SQL0104N An unexpected token "TDB2" was found following "". Expected tokens may include: "TABLESPACE ".

  2. #2
    Join Date
    Dec 2011
    Posts
    30
    you can change the name of server then try

Posting Permissions

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