IBM Support

PN51941: SQLCODE = -104,ERROR: ILLEGAL SYMBOL 'MON ' VALID SYMBOLS ARE )

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Using ==> Decimal point = Comma to have European Date, leads to
    MSGDSNT408T SQLCODE = -104,error: ILLEGAL SYMBOL 'MON  ' VALID
    SYMBOLS ARE ) during INIT of Sytem Tables.
    Problem was detected, using Table: DLRTCIFI (.SDRLDEFS)
    SQL INSERT INTO &SYSPREFIX.CICS_FIELD
      (CLASS,DICT_ENTRY_ID,OUTPUT_LENGTH,OUTPUT_OFFSET)
      VALUES(3,'DFHCICS T005',  8,  0);             -- START
    ...
    

Local fix

  • SQL INSERT INTO &SYSPREFIX.CICS_FIELD
       (CLASS,DICT_ENTRY_ID,OUTPUT_LENGTH,OUTPUT_OFFSET)
       VALUES(3, 'DFHCICS T005',  8,  0);             -- START
                |
     ===========| insert a blank after the Comma
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All EPDM 1.1.0 users using the comma (,)     *
    *                 as the decimal point indicator in DB2.       *
    ****************************************************************
    * PROBLEM DESCRIPTION: Message 'DSNT408T SQLCODE = -104,.. '.  *
    *                      displayed, when comma is used as        *
    *                      decimal point in DB2.                   *
    *                      EPDM definitions members contain comma  *
    *                      as separator without using a blank      *
    *                      after and are interpreted as decimal    *
    *                      comma by DB2.                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Message DSNT408T SQLCODE = -104,ERROR: ILLEGAL SYMBOL...
    during installation of EPDM when comma is used as decimal
    point in DB2.
    

Problem conclusion

  • Several EPDM definitions and queries are corrected (blank
    added after comma). Execs handling decimal comma are
    changed.
    100Y
    110Y
    113Y
    130Y
    131Y
    132Y
    140Y
    141Y
    142Y
    DRLEAEDT
    DRLENRRD
    DRLENR61
    DRLERACF
    DRLERDEF
    DRLERDIR
    DRLEREPD
    DRLERSAV
    DRLERSRC
    DRLQER05
    DRLQIA01
    DRLQIA04
    DRLQIA06
    DRLQIT01
    DRLQIT02
    DRLQIT03
    DRLQIY01
    DRLQIY05
    DRLQIY06
    DRLQIY07
    DRLQMA01
    DRLQMA02
    DRLQMA03
    DRLQMA04
    DRLQMA08
    DRLQMA09
    DRLQMA10
    DRLQMA11
    DRLQMA12
    DRLQMA14
    DRLQMA15
    DRLQMA16
    DRLQMP30
    DRLQMP64
    DRLQMP65
    DRLQMP66
    DRLQMV05
    DRLQMV06
    DRLQMV07
    DRLQMV74
    DRLQOP01
    DRLQOP02
    DRLQOP03
    DRLQOP08
    DRLQOP09
    DRLQOP11
    DRLQOP12
    DRLQOP13
    DRLTCIFI
    DRLTDWEK
    DRLTINOB
    DRLTMAET
    DRLTMPAP
    DRLTMPAS
    DRLTMPLP
    DRLTMPPD
    DRLTMPPG
    DRLTMPST
    DRLTMPSW
    DRLTMPWO
    DRLTMPXP
    DRLTMPXS
    DRLTMVLP
    DRLTMVWT
    DRLTRAEV
    DRLTVACT
    DRLWD2UT
    

Temporary fix

  • Aparfixes for apar PN51941 are now available.
    

Comments

APAR Information

  • APAR number

    PN51941

  • Reported component name

    EPDM 1.1

  • Reported component ID

    569510100

  • Reported release

    100

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    1994-01-28

  • Closed date

    1994-04-12

  • Last modified date

    1994-07-15

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

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

    UN60269 UN60270 UN60271 UN60273 UN60274 UN60275 UN60276 UN60277
    UN60278

Modules/Macros

  • DRLEAEDT DRLENRRD DRLENR61 DRLERACF DRLERDEF
    DRLERDIR DRLEREPD DRLERSAV DRLERSRC DRLQER05 DRLQIA01 DRLQIA04
    DRLQIA06 DRLQIT01 DRLQIT02 DRLQIT03 DRLQIY01 DRLQIY05 DRLQIY06
    DRLQIY07 DRLQMA01 DRLQMA02 DRLQMA03 DRLQMA04 DRLQMA08 DRLQMA09
    DRLQMA10 DRLQMA11 DRLQMA12 DRLQMA14 DRLQMA15 DRLQMA16 DRLQMP30
    DRLQMP64 DRLQMP65 DRLQMP66 DRLQMV05 DRLQMV06 DRLQMV07 DRLQMV74
    DRLQOP01 DRLQOP02 DRLQOP03 DRLQOP08 DRLQOP09 DRLQOP11 DRLQOP12
    DRLQOP13 DRLTCIFI DRLTDWEK DRLTINOB DRLTMAET DRLTMPAP DRLTMPAS
    DRLTMPLP DRLTMPPD DRLTMPPG DRLTMPST DRLTMPSW DRLTMPWO DRLTMPXP
    DRLTMPXS DRLTMVLP DRLTMVWT DRLTRAEV DRLTVACT DRLWD2UT
    

Fix information

  • Fixed component name

    EPDM 1.1

  • Fixed component ID

    569510100

Applicable component levels

  • R100 PSY UN60269

       UP94/04/15 P F404

  • R110 PSY UN60270

       UP94/04/15 P F404

  • R113 PSY UN60271

       UP94/04/15 P F404

  • R130 PSY UN60273

       UP94/04/15 P F404

  • R131 PSY UN60274

       UP94/04/15 P F404

  • R132 PSY UN60275

       UP94/04/15 P F404

  • R140 PSY UN60276

       UP94/04/15 P F404

  • R141 PSY UN60277

       UP94/04/15 P F404

  • R142 PSY UN60278

       UP94/04/15 P F404

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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS2DUM","label":"IBM Z Decision Support"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"100","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEQQC","label":"IBM Z Decision Support for Capacity Planning"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"100","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
15 July 1994