Fixes are available
APAR status
Closed as program error.
Error description
When we create a nickname on remote table whose table name length is greater than 28, it can be executed successfully. But when you try to query from this nickname, you will get below error msg: SQL1822N Unexpected error code "103" received from data source "<server name>". Associated text and tokens are "The identifier that starts with '"<remote_table_name>". SQLSTATE=560BD
Local fix
alter server <servername> options(db2_table_quote_char ' ')
Problem summary
Users affected: Users of the Sybase wrapper in InfoSphere Federation Server Problem description and summary: See error description.
Problem conclusion
Problem was first fixed in Version 9.5 FixPak 6 (s100805 ). This fix should be applied on Federation Server.
Temporary fix
Comments
APAR Information
APAR number
JR32526
Reported component name
SYBASE WRAPPER
Reported component ID
5724N9711
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-03-27
Closed date
2010-09-19
Last modified date
2010-09-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
SYBASE WRAPPER
Fixed component ID
5724N9711
Applicable component levels
R950 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
24 May 2022