Syntax error when creating user mapping in DB2 (Data Federation)

[puer_apuliae]

- Federation Server (DB2)
- Solaris 10 Fed Server

db2 "create user mapping for USER123 server SRV1 options
(remote_authid ‘AAA_USER’, remote_password ‘PWD’)"

CLP response:

# ./db2 "create user mapping for USER123 server SRV1 options
(remote_authid .AAA_USER., remote_password .PWD’.)"
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 "create user mapping for USER123 server
SRV"
was found following "BEGIN-OF-STATEMENT". Expected tokens may
include:
"<space>". SQLSTATE=42601

-----

It's obviously a syntax error (SQLSTATE=42601) but I cannot figure
out where the problem may be. The
syntax looks correct to me...

Thanks
Orlando

[Michael Rudolph]

pu**********@live.com wrote:

db2 "create user mapping for USER123 server SRV1 options
(remote_authid ‘AAA_USER’, remote_password ‘PWD’)"

[...]

Thanks
Orlando

Hi Orlando,

db2 "CREATE USER MAPPING FOR USER123 SERVER SRV1 OPTIONS (ADD
REMOTE_AUTHID 'AAA_USER', ADD REMOTE_PASSWORD 'PWD')"

Note that the apostrophe around AAA_USER is different (‘value’ vs
'value'), and that you are missing the "ADD" keyword. Ok, according to
[1] the ADD keyword is optional.

Michael

[1]
http://publib.boulder.ibm.com/infoce...c/r0002172.htm