PI49017: DB2 ADMIN TOOL - GEN GET IBM0421S ONCODE=520 THE SUBSCRIPTRANGE CONDITION WAS RAISED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using the GEN/DDL line command against a db, DB2 ADMIN
  TOOL failed on a view that contained the REPLACE function that
  used DBCS string with Shift Out/Shift In control characters
  equivalent to for example '0E40400F'x in the search string
  to replace Double-byte blank.
  ADB2PA: could not convert characters from CCSID(937) to
          CCSID(37)
  CHARS_CONVERTED_COUNT=9313 SQL_STMT_CAPS.SQL_STMT_LENGTH=9325;
  IBM0421S  ONCODE=520  The SUBSCRIPTRANGE condition was raised.
            From entry point FUNCTION_REF at statement 14996 at
            compile unit offset +00001660 at entry offset
            +00001660 at address 27B77628.
  ERROR condition was raised
  Traceback of user routines:
   Entry          Statement  CU offset   Entry offset  Address
    FUNCTION_REF   14996      +00001660   +00001660     27B77628
    EXPRESSION_ELEMENT
                   12616      +00000356   +00000356     27B7F096
    EXPRESSION     12372      +000000F0   +000000F0     27B7FE78
    SELECT_ELEMENT 10223      +000002F4   +000002F4     27B8CB0C
    SELECT_LIST    10124      +00000162   +00000162     27B8D19A
    SELECT_CLAUSE  10080      +00000344   +00000344     27B8D654
    SUBSELECT      9948       +00000298   +00000298     27B8DA00
    FULLSELECT     9867       +00000520   +00000520     27B8E490
    VIEW_STMT      8466       +00000A3A   +00000A3A     27B93002
    CREATE_STMT    5313       +0000193C   +0000193C     27BA243C
    SQL_STATEMENT  3126       +00000D8A   +00000D8A     27BA7422
    PARSE          2901       +00000122   +00000122     27BA832A
    ADB2PA         2269       +000020C2   +000020C2     27AE41BA
    PARSE_SQL_STMT 82         +000001AE   +000001AE     27CF8E26
    EDIT_DDL_STMT  333        +00000548   +00000548     27CF94D8
    CREATE_VIEW    13020      +00001214   +00001214     27CBAD5C
    ADB2REG        1290       +00000D0A   +00000D0A     27C993F2
    GENERATE       3115       +0000118E   +0000118E     2799C576
    REU0023        1934       +00000F72   +00000F72     27990D12
    GENERATE       1887       +00000084   +00000084     27AABD94
    GEN_VIEWS      7656       +00002340   +00002340     27AA0A10
    ADB2REP        2102       +000010B0   +000010B0     27A584D0
    ADB2GEN        3169       +00003E92   +00003E92     2790B2F2
  

Local fix

• Use the hex notation instead of the DBCS charactes in SQL.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the GEN/DDL command             *
  *                 to generate a VIEW which contains a          *
  *                 columns defined with 'FOR MIXED              *
  *                 DATA'.                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When performing the GEN/DDL             *
  *                      command on a VIEW that                  *
  *                      contains columns defined with           *
  *                      'FOR MIXED DATA', the                   *
  *                      following error may occur:              *
  *                                                              *
  *                      ADB2PA: could not convert               *
  *                      characters from CCSID(XXX) to           *
  *                              CCSID(37)                       *
  *                      CHARS_CONVERTED_COUNT                   *
  *                      =9313 SQL_STMT_CAPS.                    *
  *                      SQL_STMT_LENGTH=9325;                   *
  *                      IBM0421S  ONCODE=520  The               *
  *                      SUBSCRIPTRANGE condition                *
  *                      was raised.                             *
  *                        From entry point FUNCTION_REF         *
  *                           at statement 14996 at              *
  *                           compile unit offset >offset<       *
  *                           at entry offset >offset< at        *
  *                           address >address<.                 *
  *                      ERROR condition was raised...           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When performing the GEN/DDL command on a VIEW,
  DB2 Admin may not be able to generate the VIEW containing
  columns defined with 'FOR MIXED DATA'.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI34939 UI34940 UI34941

Modules/Macros

•    ADB2PA   ADB2PA5
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI34939

     UP16/02/04 P F602

• RB10 PSY UI34940

     UP16/02/04 P F602

• RB20 PSY UI34941

     UP16/02/04 P F602

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.