IBM Support

JR32655: SQL0901N REPORTED WHEN QUERYING FROM NICKNAME WITH HEAD EXPRESSION LIKE COALESCE(CHAR,TIME) USING MSSQLSERVER WRAPPER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • When you create a nickname on remote table which has a column
    defined as DATETIME/SMALLDATETIME, and then alter the
    corresponding nickname column type to time, it will reported
    error like blow:
    select COALESCE(chti,ti)  from t7
    1
    --------
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason "MSSQL:
    unknown time
    format".)  SQLSTATE=58004
    
    Below is steps to reproduce this error:
    set passthru DATASTORE2;
    drop table t7;
    create table t7 (chti char(30) not null,ti  DATETIME not null);
    insert into t7 values ('01:11:11', '03:33:33');
    set passthru reset;
    create nickname t7 for DATASTORE2.j15user1.t7;
    alter nickname t7  alter column ti local type time;
    select COALESCE(chti,ti)  from t7
    

Local fix

Problem summary

  • Users affected:
       Users of the MSSQL wrapper in InfoSphere Federation Server
    Problem description and summary:
       See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9.5, FixPak 4 (s090429). This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32655

  • Reported component name

    MSSQL WRAPPER

  • Reported component ID

    5724N9705

  • Reported release

    950

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-09

  • Closed date

    2009-06-16

  • Last modified date

    2009-06-16

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

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

Fix information

Applicable component levels

  • R950 PSN

       UP

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

Document Information

Modified date:
16 June 2009