unable to create server for remote data source

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • adititiwari
    New Member
    • May 2010
    • 3

    unable to create server for remote data source

    Hi,

    I issued a command:

    create server p400 type db2/400 version 5.3.0 wrapper DRDA authorization "qseibm" password "ibm***" options (node 'S657686B', dbname 'S657686B')

    for an already cataloged remote data source.
    I could successfully connect to the data source through my AIX server but once I run this command i got the following error:

    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 "SERVER" was found following "". Expected
    tokens may include: "VIEW ALIAS TABLE SCHEMA UNIQUE ENCODED". SQLSTATE=42601

    same create server command I had used before to create a server and it worked fine.
Working...