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

Obtain the fix for this APAR.

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 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.