Troubleshooting
Problem
Query nicknames in version 9 fails after migrating from 8.2 with SQL0901N error "column number out of range" returned when querying data using ODBC nickname
Symptom
Queries that returned results in version 8.2 fails when executed in version 9.
[{"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"},{"code":"PF033","label":"Windows"}],"Version":"9.1;9.5;9.7","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.1, 9.5, 9.7
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
392811
Modified date:
25 April 2025
UID
swg21394066
Manage My Notification Subscriptions