IBM Support

JR32226: OVERFLOW ERROR ISN'T REPORTED AS EXPECTED WHEN CONVERTING LOCAL LARGE TYPE VALUE TO REMOTE SMALL TYPE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Here is an example, the convertion happens when you pass a
    BIGINT value to stored procedure parameter which has a INT
    remote type.
    SET PASSTHRU SERV
    DB20000I The SQL command completed successfully.
    
    CREATE TABLE T1 (c1 CHAR, c2 INT)
    DB20000I The SQL command completed successfully.
    
    CREATE PROCEDURE PROC(@in1 CHAR, @in2 INT)
    AS
    BEGIN
    UPDATE T1 SET c2=@in2 WHERE c1=@in1
    END
    DB20000I The SQL command completed successfully.
    
    SET PASSTHRU RESET
    DB20000I The SQL command completed successfully.
    
    CREATE NICKNAME N1 for SERV.USER.T1
    DB20000I The SQL command completed successfully.
    
    CREATE PROCEDURE fstp SOURCE USER.PROC FOR SERVER SERV
    DB20000I The SQL command completed successfully.
    
    INSERT INTO N1(c1) VALUES('I')
    DB20000I The SQL command completed successfully.
    
    CALL fstp('I', 17179869184)
    
    Return Status = 0
    
    ( Here, value 17179869184 (0x4 0000 0000) have overflown for
    INT type, but expected error message "SQL0413N Overflow
    occurred during numeric data type conversion. SQLSTATE=22003"
    hasn't been reported.)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * No specific                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Overflow error isn't reported as expectation when converting *
    * local large type valu to remote small type.                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 'Federaion Server' V95fp4                         *
    ****************************************************************
    

Problem conclusion

  • Fixed in release v95fp4 090114.
    With this fix , when invalid conversion happens, following
    error message will be generated,
    "SQL0413N Overflow occurred during numeric data type
    conversion.
    SQLSTATE=22003"
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32226

  • Reported component name

    TERADATA WRAPPE

  • Reported component ID

    5724N9709

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-03

  • Closed date

    2009-06-15

  • Last modified date

    2009-06-15

  • 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

    TERADATA WRAPPE

  • Fixed component ID

    5724N9709

Applicable component levels

  • R950 PSN

       UP

  • R950 PSY

       UP

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

Document Information

Modified date:
15 June 2009