IBM Support

JR27933: ARRAY INPUT WITH EXPRESSION FAILED WITH -312 ERROR AGAINST Z/DB2 V9

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In V9, DB2 for z/OS started to enforce the restriction that a
    host variable array cannot be used in an expression for
    multi-row insert.  An INSERT statement with host variable arrays
    (such as the one shown below) that used to work on V8 would no
    longer work on V9.
    
    This error occurs when actions are tried from v9 LUW client or
    when directly from USS on Z/OS v9.  This APAR is intended to fix
    the LUW side.  See APAR PK55261 for Z/OS side.
    
    
    INSERT INTO PS_RS_DF_WRKR_AVA
    
    (EMPLID ,
    DATE_ENTERED ,
    SEQ_NBR ,
     START_DTTM,
     END_DTTM)
     VALUES (:1 , :2 , :3 ,
     TIMESTAMP(CAST(:4 as DATE), CAST(:5 as TIME)) ,
    TIMESTAMP(CAST(:6 as DATE), CAST(:7 as TIME)))
    
    LOCAL FIX:
    Please fix in next release
    

Local fix

  • None. Please fix in next release.
    

Problem summary

  • ARRAY INPUT WITH EXPRESSION FAILED WITH -312 ERROR AGAINST Z/DB2
    V9
    

Problem conclusion

  • First fixed in v9.5 FP1
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR27933

  • Reported component name

    DB2 CEE WINDOWS

  • Reported component ID

    5765F3001

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-11-30

  • Closed date

    2008-04-30

  • Last modified date

    2010-12-11

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

    JR27836

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

Fix information

  • Fixed component name

    DB2 CEE WINDOWS

  • Fixed component ID

    5765F3001

Applicable component levels

  • R950 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950"}]

Document Information

Modified date:
07 October 2021