PQ90860: SQLCODE104 OR SQLCODE117 RECEIVED WHEN COMMA IS DEFINED AS DECIMAL POINT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Data Archive Expert ( DAE ) R110 encounters an unexpected
  SQL error when processing a request and using comma as a
  decimal point.
  .
  When attempting to change COMMIT level from 1000 to 100 on
  panel AHXV11 'Data Archive Expert Settings' and DECIMAL=COMMA ,
  message MSGAHXSETTS and SQLCODE104 are received.
  Message: AHXSETTS: INSERT INTO  SESSION.TMPUSERPROPS
       SQLCODE:  -104
       SQLSTATE: 42601
       SQL ERROR TOKENS: ,2.) ,
       SQL PROCEDURE DETECTING ERROR: DSNHPARS
       SQL DIAGNOSTIC INFORMATION: 0,0,0,-1,323,0
  .
  When attempting to ' Save archive specification ' and
  DECIMAL=COMMA , SQLCODE117 and MSGAHXUNITT were returned.
  Message: AHXUNITT: INSERT INTO SESSION.TMPTBSOURCES
       SQLCODE:  -117
       SQLSTATE: 42802
       SQL ERROR TOKENS:
       SQL PROCEDURE DETECTING ERROR: DSNXOIN
       SQL DIAGNOSTIC INFORMATION: -111,0,0,-1,0,0
  .
  Problem only occurs on system where comma is defined as a
  decimal.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Data Archive Expert             *
  *                 release 110, who use "COMMA" as              *
  *                 "Decimal Point", are affected.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE104 OR SQLCODE117 is received    *
  *                      when COMMA is defined as the DECIMAL    *
  *                      POINT.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the ZPARM, PERIOD, is set to 'COMMA', and therefore,
  COMMA is defined as the DECIMAL POINT, SQLCODE errors
  occur (-104 or -117).
  

Problem conclusion

• The reported problem of "COMMA defined as the DECIMAL POINT" is
  fixed  (i.e. after apply the fix, COMMA can be used as the
  DECIMAL POINT if the ZPARM, PERIOD, is set to 'COMMA').
  

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:

  UQ94039

Modules/Macros

• AHXATLCM AHXCRDB  AHXDEFPR AHXGTABS AHXIDXCL
  AHXJ00   AHXONMAP AHXPRIM  AHXRETDF AHXSCTAB AHXSDEF  AHXSETTS
  AHXTOOL  AHXUNITT AHXV110  AHX8DFPR
  

Fix information

• Fixed component name

  DB2 DATA ARCHIV

• Fixed component ID

  5655I9500

Applicable component levels

• R110 PSY UQ94039

     UP04/11/04 P F411

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.