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 ".