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 can successfully connect to the data source through my AIX server but once I run this command i get 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.

Did you enable federation support in your DBM config? And which version of DB2 are you using on which platform?

If it really worked before on the same database, you may have some sort of typo (e.g. a non-printable character) in your statement.

Hi Knut,
Thanks for the support
I have already modified the dbm config file to make it federated and I'm using db2 9.1 on AIX 5.3.

How can i look for those "typo" ?

ADITI TIWARI

always put this command in a file. we had this problem before, because it needs quotes and " quotes..
execute with db2 -tvf ...