IBM Support

JR44108: SQL0180N IS REPORTED WHEN CREATE MSSQL NICKNAME

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • db2 => create wrapper mssql_wrap library 'libdb2mssql3.so'
    db2 => create server mssql2008_serv type mssqlserver version
    2008 wrapper mssql_wrap options(node '*', dbname '*')
    db2 => create user mapping for user server mssql2008_serv
    options(remote_authid '*', remote_password '*')
    db2 => set passthru mssql2008_serv
    db2 => create table test3 (c1 date, c2 char)
    db2 => insert into test3 values ('2012-01-01','a')
    db2 => insert into test3 values ('2012-01-02','b')
    db2 => insert into test3 values ('2012-01-03','c')
    db2 => insert into test3 values ('2012-01-04','d')
    db2 => set passthru reset
    
    From SQL Server Management Studio, run
    EXEC sp_createstats
    
    After that, create nickname will fail:
    db2 => create nickname mssql_test3 for mssql2008_serv.*.test3
    DB21034E  The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command.  During SQL processing it
    returned:
    SQL0180N  The syntax of the string representation of a datetime
    value is
    incorrect.  SQLSTATE=22007
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Before DB2 V95 fix pack 11, Federated SQL SERVER 2008 wraper *
    * can not create nickname when sp_createstats is enabled.      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If SQL Servers enabled single-column statistics for eligible *
    * columns with sp_createstats, DB2 failed to create nickename  *
    * for remote tables.                                           *
    *                                                              *
    * From SQL Server Management Studio, run                       *
    * EXEC sp_createstats                                          *
    *                                                              *
    * After that, create nickname will fail:                       *
    * db2 => create nickname <nickname> for                        *
    * <mssql2008_serv>.<username>.<remote_table>                   *
    * DB21034E  The command was processed as an SQL statement      *
    * because it was not a                                         *
    * valid Command Line Processor command.  During SQL processing *
    * it returned:                                                 *
    * SQL0180N  The syntax of the string representation of a       *
    * datetime value is                                            *
    * incorrect.  SQLSTATE=22007                                   *
    *                                                              *
    * This issus can only be found on ODBC 6.0 driver.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version V95 fix pack 11.                      *
    ****************************************************************
    

Problem conclusion

  • This problem is fixed on V95 fix pack 11.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR44108

  • Reported component name

    FEDERATION SERV

  • Reported component ID

    5724N9700

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-09-14

  • Closed date

    2013-04-11

  • Last modified date

    2013-04-11

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

    JR44107

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

    IC88678

Fix information

  • Fixed component name

    FEDERATION SERV

  • Fixed component ID

    5724N9700

Applicable component levels

  • R950 PSN

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021