SQL3324N Error when creating nickname using Federation Server ODBC wrapper for remote Oracle Rdb table

Troubleshooting

Problem

When creating nickname using ODBC wrapper via 'Oracle ODBC driver for Rdb' for remote Oracle Rdb table will receive type not recognized errors like following: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL3324N Column "" has a type of "CHAR" which is not recognized.

Symptom

db2 create nickname ASSETS for LMSRDB.LMSTrade32.ASSETS

DB21034E The command was processed as an SQL statement because it was
not avalid Command Line Processor command. During SQL processing it
returned:SQL3324N Column "TABLE_TYPE" has a type of "CHAR" which is not
recognized.

[{"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Sources and Wrappers - ODBC","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5;9.7;10.1;10.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
InfoSphere Federation Server

Software version:
9.5, 9.7, 10.1, 10.5

Operating system(s):
Windows

Document number:
503489

Modified date:
25 April 2025

UID

swg21657424

IBM Support

Tips