IC87063: DB2 RETURNS -901 FOR TARGET TYPE IS NOT TYPED WHEN COMPILING MERGE STATEMENT

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 may throw -901 error message "target type is not typed"
    while compiling a MERGE statement whose source table is a single
    row value box involving untyped parameter marker.
    
    This creates FODC directory for APPerror  and the call stack
    looks
    
    sqlnn_cmpl
    sqlnp_main
    sqlnp_parser
    sqlnp_smactn
    sqlnq_sem_merge
    sqlnq_udi
    sqlnq_iu_convSourcePid
    sqlnq_conv_source_pid_w_ta[
    sqlnq_pid::fix_parmm_for_a
    sqlnq_pid::fix_untyped
    
    This happens when MERGE statement has UPDATE or INSERT action,
    and target table doesn't include the target column name
    specified by UPDATE or INSERT. In other word, the MERGE
    statement has syntax error and this APAR will address this issue
    and throw the correct error message to the users.
    

Local fix

  • Correct target column name.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users running  merge statement.                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to fix the issue. or use check the column     *
    * name and correct the syntax to avoid the issue.              *
    ****************************************************************
    

Problem conclusion

  • APAR will first fixed in V9.7 fixpack 8.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC87063

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-08

  • Closed date

    2013-04-01

  • Last modified date

    2013-04-01

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

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

    IC89708

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC87063

Modified date:

2013-04-01

Translate my page

Machine Translation

Content navigation