PK30025: DCLGEN, SPUFI, DSNTEP2, AND DSNTEP4 CHANGES FOR CCSIDS 1026 AND 1155

A fix is available

 

APAR status

  • Closed as new function.

Error description

  • Enhance shallow parsing in DSNTEP2, DSNTEP4, SPUFI, and DCLGEN
    to recognize code point x'FC' as the double quote character
    when the current application encoding scheme is CCSIDs 1026 or
    1155.

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of SPUFI, DCLGEN, DSNTEP2, and *
    * DSNTEP4 in DB2 UDB for z/OS Version 8 are *
    * affected by this change. *
    ****************************************************************
    * PROBLEM DESCRIPTION: SPUFI, DCLGEN, DSNTEP2, and DSNTEP4 do *
    * not correctly handle the double quote *
    * (") character when the application *
    * encoding scheme is 1026 (Turkish) or *
    * 1155 (Turkish with the Euro symbol). *
    ****************************************************************
    * RECOMMENDATION: *
    ****************************************************************
    In virtually every EBCDIC code page the double quote character
    resides at code point x'7F' but in CCSIDs 1026 (Turkish) and
    1155 (Turkish with the Euro symbol) it's at x'FC'. Currently,
    SPUFI, DCLGEN, DSNTEP2, and DSNTEP4 interpret only x'7F' as the
    double quote character, so undesired results can occur when
    these applications process input encoded in CCSID 1026 or 1155.
    * SPUFI, DSNTEP2, and DSNTEP4 have shallow parsers for finding
    the SQL terminator character (typically the semicolon) of the
    current statement in the SQL input stream. These parsers are
    sensitive to single and double quote characters so as to avoid
    tripping over the SQL terminator character in delimited
    strings within the SQL statement. Under CCSIDs 1026 and 1155,
    SQL statements are currently misinterpreted if the SQL termi-
    nator character appears in a token delimited by x'FC'.
    * DCLGEN performs shallow parsing on specified table names for
    use of single and double quote characters as SQL delimiters.
    Under CCSIDs 1026 and 1155, table names delimited by code
    point x'FC' can be misinterpreted.
    .
    This APAR modifies SPUFI, DSNTEP2, and DSNTEP4 to automatically
    detect whether to use code point x'FC' or code point
    x'7F' as the double quote character when the application
    encoding scheme is 1026 or 1155. For CCSIDs 1026 and 1155 only,
    the first undelimited occurrence of x'7F' or x'FC' is interpret-
    ed as the double quote character, signalling the start of a
    delimited token: Shallow parsing then scans the input for a
    matching x'7F' or x'FC' that signals the end of the delimited
    token. For all other CCSIDs, these applications continue to
    use only code point x'7F' as the double quote character.
    .
    DCLGEN is modified to use x'FC' as the double quote character
    when the loaded DSNHDECP specifies 1026 or 1155 as the SBCS
    EBCDIC CCSID (SCCSID). DCLGEN continues to use code point x'7F'
    as the double quote character for all other CCSIDs.

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PK30025

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-08-16

  • Closed date

    2006-12-06

  • Last modified date

    2007-01-03

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

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

    UK20347

Modules/Macros
DSN@CP68 DSN@EP2L DSN@EP4L DSNDSEY DSNDSIB DSNECP24
DSNECP68 DSNESM21 DSNTEP2 DSNTEP2L DSNTEP4 DSNTEP4L
Publications Referenced
SC18742603        

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK20347

       UP06/12/22 P F612

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

810

Reference #:

PK30025

Modified date:

2007-01-03

Translate my page

Machine Translation

Content navigation