IBM Support

JR35752: SQL0901N ERROR WITH REASON "NEGATIVE OUTPUT DATA LENGTH" REPORTED WHEN QUERY MICROSOFT SQL SERVER NICKNAME

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When you SELECT from Microsoft SQL Server nickname's
    char/varchar column, if remote table contains some multibyte
    encoded string, and those string's character-length exceeds
    certain value, SELECT statement will fail with following
    error message:
    SQL0901N  The SQL statement failed because of a non-severe
    system error.
    Subsequent SQL statements can be processed.  (Reason "Negative
    output data length".)  SQLSTATE=58004
    
    You can reproduce it by the following steps.
    1) Insert some multibyte encoded string into remote SQL Server
    table's char/varchar column, by SQL Server Management Studio.
        CREATE TABLE [dbname].[schemaname].[tablename](ID int,
    MESSAGE char(10));
        INSERT INTO [dbname].[schemaname].[tablename] VALUES(1,
    '?????');
    
    2) Create nickname for remote table at Federation Server. Then
    select from the nickname with char/varchar column
        CREATE NICKNAME nickname FOR servername.username.tablename;
        SELECT * FROM nickname;
    
    The reason of this error is that, when SQL Server Wrapper
    retrieves data length of character type column , ODBC driver
    returns SQL_NO_TOTAL indicator, whose value is -4, in following
     two  scenarios:
    1) the local data buffer is inadequate for remote data.
    2) The driver cannot determine the number of bytes of long data
    that still available to return in an output buffer.
    (http://msdn.microsoft.com/en-us/library/ms713532(VS.85).aspx)
    SQL Server incorrectly treats this indicator as a length value.
    

Local fix

Problem summary

  • Users affected:
       Users of the MS SQL Server 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

    JR35752

  • Reported component name

    MSSQL WRAPPER

  • Reported component ID

    5724N9705

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-23

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

    JR35753 JR35754

Fix information

  • Fixed component name

    MSSQL WRAPPER

  • Fixed component ID

    5724N9705

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:
19 September 2010