IBM Support

InfoSphere Federation Server ODBC wrapper issue: SQL1822N returned with error code 'HY000' when selecting nickname for Classic Federation Server source

Troubleshooting


Problem

When selecting nickname defined for remote Classic Federation Server table on MVS, SQL1822N returned. Exact error message: SQL1822N Unexpected error code "HY000" received from data source "CF_SERVER". Associated text and tokens are " SQLTables - Please look up SQLCODE: SQLCODE. SQL-Error". SQLSTATE=560BD

[{"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Sources and Wrappers - ODBC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.1;9.5;9.7","Edition":"Developer Edition;All Editions","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.

Document Information

Modified date:
25 April 2025

UID

swg21377860