# DB2 “Error in converting column name from JString to CString”

**URL:** <https://techcommunity.softwareag.com/t/db2-error-in-converting-column-name-from-jstring-to-cstring/208237>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-Basics-on-Linux-Unix-Windows, Adabas-on-Windows-UNIX, Adabas-on-Linux\
**Created:** [May 13, 2020, 1:45pm UTC](https://techcommunity.softwareag.com/t/db2-error-in-converting-column-name-from-jstring-to-cstring/208237 "2020-05-13T13:45:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![BorHris](https://avatars.discourse-cdn.com/v4/letter/b/f0a364/32.png) [@BorHris](https://techcommunity.softwareag.com/u/BorHris)\
**Post date:** [May 13, 2020, 1:45pm UTC](https://techcommunity.softwareag.com/t/db2-error-in-converting-column-name-from-jstring-to-cstring/208237/1 "2020-05-13T13:45:24Z")

</div>

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

```auto
db2 set passthru CACDSJ
db2 select * from "ANAG"."[TABLENAME]"
```

The query is executed without any problem

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [May 14, 2020, 1:08am UTC](https://techcommunity.softwareag.com/t/db2-error-in-converting-column-name-from-jstring-to-cstring/208237/2 "2020-05-14T01:08:59Z")

</div>

This appears to be a message from the IBM product(s) you are using. Perhaps a ticket to IBM or a posting on an IBM forum would be more helpful.

Another option would be to use Software AG’s Adabas SQL Gateway product to provide you with a JDBC connection to Adabas.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:44pm UTC](https://techcommunity.softwareag.com/t/db2-error-in-converting-column-name-from-jstring-to-cstring/208237/3 "2021-04-02T15:44:40Z")

</div>