IBM Support

JR32527: SQLSTATE SQL1822N '103' REPORT USING SYBASE WRAPPER TO QUERY FROM NICKNAME DEFINED WITH REMOTE TABLE LENGTH GREATER THAN 28

Subscribe

You can track all active APARs for this component.

 

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.1 FixPak 9 (s100326 ). This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32527

  • Reported component name

    SYBASE WRAPPER

  • Reported component ID

    5724N9711

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-27

  • Closed date

    2010-04-14

  • Last modified date

    2010-04-14

  • APAR is sysrouted FROM one or more of the following:

    JR32526

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    SYBASE WRAPPER

  • Fixed component ID

    5724N9711

Applicable component levels

  • R910 PSN

       UP

  • R911 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPQ","label":"Data Sources and Wrappers - Sybase"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
14 April 2010