PH47453: DECFLOAT DATATYPE SUPPORT FOR PLI, C WITH DCLGEN

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DECFLOAT datatype support for PLI, C with DCLGEN
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS and Db2 13 for z/OS                      *
  * users of DCLGEN(DECLARATIONS GENERATOR)                      *
  * for PL/I and C programs using the DECFLOAT                   *
  * data type.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DCLGEN does not support the SQL data                         *
  * type DECFLOAT for the C and PL/I                             *
  * language. An error message                                   *
  * "DCLGEN DOES NOT SUPPORT THE SQL DATA                        *
  * TYPE DECFLOAT(sqltype 997)" is issued                        *
  * and the variable declaration generated                       *
  * for the DECFLOAT field is missing the                        *
  * variable data type.                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DCLGEN does not support the SQL data type DECFLOAT for the C
  and PL/I language. As a result, the variable declaration
  generated for the DECFLOAT column is missing the variable
  data type, as shown in the following PL/I example:
    DCL 1 DCLTESTDCLGEN,
         5 C1       BIN FIXED(31),
         5 C2       BIN FIXED(15),
         5 C3       ,
         5 C4       ;
    where the corresponding Db2 table was created as follows
    (C3 and C4 with data type DECFLOAT):
    CREATE TABLE TESTDCLGEN(C1 INT,
                            C2 SMALLINT,
                            C3 DECFLOAT(16)
                            C4 DECFLOAT(34));
  

Problem conclusion

Temporary fix

Comments

• DCLGEN is enhanced to support the SQL data type DECFLOAT
  for the PL/I and C language. For the same table
  described in the Problem Summary section, the DCLGEN
  PL/I variable declarations will show the correct
  variable data type, as shown below:
    DCL 1 DCLTESTDCLGEN,
         5 C1       BIN FIXED(31),
         5 C2       BIN FIXED(15),
         5 C3       DEC FLOAT(16),
         5 C4       DEC FLOAT(34);
  

APAR Information

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

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

  UI81838 UI81839

Modules/Macros

• DSNECP62 DSNECP60 DSNECP63
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI81838

     UP22/08/16 P F208

• RD10 PSY UI81839

     UP22/08/16 P F208

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.