PM78907: CLASSIC STORED PROCEDURE UNEXPECTEDLY RETURNS TRUNCATED INPUT OR OUTPUT VALUES

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When stored procedures are called while using the Classic
    CLI/ODBC driver, the return values of output or input/output
    parameters may get truncated.  This will particularly be an
    issue when using InfoSphere DataStage z/OS File Stage because it
    uses the Classic system stored procedure and the Classic
    CLI/ODBC driver underneath.
    .
    Additionally when binding host variables and passing zero length
    strings, the Classic CLI/ODBC currently returns a 'feature not
    implemented' error.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Classic Federation                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: The return values of output or          *
    *                      input/output parameters of a Classic    *
    *                      system stored procedure may be          *
    *                      truncated unexpectedly.                 *
    *                      This problem was reported when          *
    *                      InfoSphere DataStage z/OS File Stage    *
    *                      was used to access the Classic          *
    *                      CLI/ODBC driver to call a Classic       *
    *                      system stored procedure.                *
    *                      When a CREATE TABLE was processed, the  *
    *                      stored procedue returned a truncated    *
    *                      DD name, confirmed by the following     *
    *                      trace entry in the server log:          *
    *                      2012-12-05-11.48.46.186950 RC(03),      *
    *                      SpcRC(ffffffff),                        *
    *                      Data(00000000,00000000) Node(220),      *
    *                      Task(9136984) QP, func , line 654 in    *
    *                      CAC.V101.RUP3.B120507.C(AAQCQPIN)       *
    *                      'CREATE TABLE                           *
    *                      SYSDST.DSTTBL123456789101 DBTYPE        *
    *                      SEQUENTIAL DD "SYS0"' ' (RAWDATA        *
    *                      SOURCE DEFINITION DATAMAP OFFSET 0      *
    *                      LENGTH 35 DATATYPE C ' 'USE AS          *
    *                      VARCHAR(35)) '                          *
    *                      .                                       *
    *                      Where the DD above should have been     *
    *                      an 8-char DD name.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    See problem description.
    

Problem conclusion

  • Code has been updated to address the truncation issue.
    A change has also been introduced to allow zero-length strings
    to be passed when binding host variables.
    To obtain the complete fix, in addition to the PTF, please
    download the most current Classic ODBC/CLI driver.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM78907

  • Reported component name

    CLASSIC FED & E

  • Reported component ID

    5697I8200

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-10

  • Closed date

    2012-12-14

  • Last modified date

    2013-01-02

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

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

Modules/Macros

  • CECCCHDL CECCENDE CECCENGN CECCFAHD CECCGET
    CECCHNDL CECCPUT  CECCSQER CECCSQL  CECOCONV
    

Fix information

  • Fixed component name

    CLASSIC FED & E

  • Fixed component ID

    5697I8200

Applicable component levels

  • RA10 PSY UK90370

       UP12/12/19 P F212

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Classic Federation Server for z/OS
General issues

Software version:

A10

Reference #:

PM78907

Modified date:

2013-01-02

Translate my page

Machine Translation

Content navigation