IBM Support

JR35369: ODBC wrapper: creating nickname on remote table with index fails SQL0901N

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL0901N error will happen when using Federation ODBC wrapper
    with some ODBC driver, like DB2 or XKOTO gridscale ODBC driver,
    and the remote table has index defined.
    
    Here are the reproduce steps,
    (1) create table T1 in DB2 and then create at least one index on
    it.
    SET PASSTHRU <servername>;
    DROP TABLE T1;
    CREATE TABLE T1 (C1 int);
    CREATE UNIQUE INDEX <index_name> on T1(C1);
    SET PASSTHRU RESET;
    (2) create nickname for table T1
    db2 => CREATE NICKNAME "NICK1" FOR
    <server_name>.<schema_name>."T1";
    DB21034E  The command was processed as an SQL statement because
    it was not a valid Command Line Processor command.  During SQL
     processing it returned:
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason
    "convert_codepage ".) SQLSTATE=58004
    

Local fix

Problem summary

  • Users affected:
       Users of the ODBC 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

    JR35369

  • Reported component name

    ODBC WRAPPER

  • Reported component ID

    5724N9707

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-01-13

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

    JR35381 JR35382

Fix information

  • Fixed component name

    ODBC WRAPPER

  • Fixed component ID

    5724N9707

Applicable component levels

  • R950 PSN

       UP

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

Document Information

Modified date:
19 September 2010