We are setting up the federation in order to browse data from ADABAS using DB2 federation. We have a Classic Data Architect connection set up and a remote server in DB2 federation configured using JDBC. The problem is that when we try to create a nickname using this command:
CREATE NICKNAME “JADABAS”.“[TABLENAME]” FOR “CACDSJ”.“ANAG”.“[TABLENAME]”; we are getting this error:
The DB2-server is a windows.
If we perform a select using the command
db2 set passthru CACDSJ
db2 select * from "ANAG"."[TABLENAME]"
The query is executed without any problem