By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,358 Members | 2,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,358 IT Pros & Developers. It's quick & easy.

unable to create server for remote data source

P: 3
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.
Jun 14 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.