IBM Support

JR32506: SQL1822N ERROR REPORTED WHEN TRYING TO CREATE NICKNAME FOR REMOT E TABLE WHOSE TABLE OR INDEX NAME CONTAINED QUOTES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Below is the error message reported and scenario example:
    Remote data source  has table defined as below:
    create table "'in squotes'"(c1 integer, c2 char(15));
    
    
    
    
    
    When we try to use federated to create nickname on this table,
    we get below error message
    
    
    
    create nickname mynick for DATASTORE2.NEWTON."'in squotes'"
    
    
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL1822N  Unexpected error code "-104" received from data
    source "DATASTORE2".
    Associated text and tokens are " SQL0104N  An unexpected token
    "in squotes''"
    was foun".  SQLSTATE=560BD
    

Local fix

Problem summary

  • Users affected:
       Users of the DRDA wrapper in the DB2 for LUW Homogeneous
    Federation Feature or InfoSphere Federation Server
    Problem description and summary:
       See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9.1 FixPak 8 (s090823). This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32506

  • 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-25

  • Closed date

    2009-10-07

  • Last modified date

    2009-10-07

  • 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

  • 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:
07 October 2009