0

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 SQL statement or command failed because of a database system error. (Reason "Error in converting column name from JString to CString".). SQLCODE=-901, SQLSTATE= , DRIVER=3.68.61

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

Matioski
  • 117
  • 1
  • 2
  • 11
  • If you failed to create the nickname, I expect you still have permissions/privileges issues. Edit your question to include what messages appear in db2diag when you run create nickname. – mao May 11 '18 at 12:58
  • Also, in your 'CREATE SERVER' you can (temporarily only) try the 'JDBC LOG' 'Y' option and examine what messages the wrapper creates in the DIAGPATH of your Db2-instance. – mao May 11 '18 at 13:34
  • I have already done that but there is nothing about that error – Matioski May 30 '18 at 12:35
  • If you enabled the jdbc logging on the create-server , and then dropped (if exist) and recreate the nickname, and still the jdbc wrapper shows no entries in its logfile for 'create nickname' then you should open a trouble-ticket with IBM – mao May 30 '18 at 15:29

0 Answers0