PH05953: NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users who are                            *
  * developing JavaScript applications                           *
  * in Node.js runtime environment.                              *
  IMPORTANT NOTE:  This APAR introduces a change in the default
  behavior for the ODBC/CLI driver when fetching a DECIMAL or
  NUMERIC column of scale 0 into SQL_C_CHAR.  Following the
  application of this APAR, a trailing decimal point is no longer
  returned in the resulting character string in order to maintain
  cross-platform consistency.  Therefore, LDAP users or any
  application that might have a dependency on this trailing
  decimal point must also apply APAR PH11103 to override the
  default behavior through the PATCH2 configuration keyword in the
  initialization file.  Otherwise, unexpected error/abend may
  occur.
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When developing Node.js                                      *
  * applications in the z/OS UNIX Systems                        *
  * Services environment, applications                           *
  * can not access Db2 data using the                            *
  * ibm_db package in the NPM repository.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR provides the necessary ODBC driver support to enable
  JavaScript web applications running on Node.js to establish
  connectivity to Db2 using the ibm_db NPM package in the z/OS
  UNIX System Services environment.
  

Problem conclusion

Temporary fix

Comments

• ODBC code has been changed to support the ibm_db package
  on z/OS:
  1. Add #define for SQL_SUCCEEDED
  2. Add wide (suffix-W) API SQLGetDiagRecW to support
     UNICODE UCS-2 string arguments
  3. Recognize SQL_C_SBIGINT as a valid C symbolic data type
  4. Remove extra decimal when fetching from a DECIMAL or
     NUMERIC column of scale 0 into SQL_C_CHAR
  5. Add IEEE floating-point support.  A new initialization
     keyword FLOAT=IEEE has been introduced to enable
     applications to send/receive floating-point data in
     IEEE format.
  6. Provide an internal mechanism to guarantee serialized
     access when processing asynchronous ODBC transactions
     on a shared Db2 connection in Node.js.  A new
     initialization keyword value has been introduced which
     allows a multithreaded and multicontext ODBC application
     to activate this internal mechanism.  The new keyword
     value is not externalized as the feature being provided
     should only be used under the direction of the ODBC
     development team.
  

APAR Information

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

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

  UI60551

Modules/Macros

• DSNAOG17 DSNCLI   DSNAOG19 DSNAOC1L DSNAOCLI DSNAOG1L DSNAOC22
  DSNAOC1Q DSNAOC1R DSNAOC02 DSNAOTRC DSNAOC03 DSNAOG1Q DSNAOG22
  DSNAOC1U DSNAOG1R DSNAOC05 DSNAOC27 DSNAOC06 DSNAOC28 DSNAOG02
  DSNAOG03 DSNAOC08 DSNAOG1U DSN@LIQR DSNAOG05 DSNAOG27 DSNAOG06
  DSNAOG28 DSNAOG08 DSNWAPI  DSNAOC0A DSNAOC0E DSNAOG0A DSNAOSDK
  DSNAOG0E DSNAOC0J DSNAOG0J DSNAOC0P DSNAOC0R DSNAOG0P DSNAOC16
  DSNAOC0U DSNAOG0R DSNAOC17 DSNAOC19 DSNAOG0U DSNAOG16
  

Fix information

• Fixed component name

  DB2 ODBC/JDBC/S

• Fixed component ID

  5740XYR02

Applicable component levels

• RC17 PSY UI60551

     UP19/01/22 P F901

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.