IBM Support

SI66177 - OSP-DB-OTHER-INCORROUT MERGE ON VIEW WITH INSTEAD OF TRIGGER

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT MERGE ON VIEW WITH INSTEAD OF TRIGGER


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R2M0    SI64019   00/00    0000
PRE  5770SS1  V7R2M0    SI63641   00/00    0000
PRE  5770SS1  V7R2M0    SI63642   00/00    0000
PRE  5770SS1  V7R2M0    SI62150   00/00    0000
PRE  5770SS1  V7R2M0    SI60046   00/00    0000
CO   5770SS1  V7R2M0    SI65781   00/00    0000
CO   5770SS1  V7R2M0    SI65783   00/00    0000
CO   5770SS1  V7R2M0    SI65782   00/00    0000
CO   5770SS1  V7R2M0    SI63693   00/00    0000
CO   5770SS1  V7R2M0    SI58796   00/00    0000
CO   5770SS1  V7R2M0    SI58742   00/00    0000
CO   5770SS1  V7R2M0    SI58027   00/00    0000
CO   5770SS1  V7R2M0    SI57835   00/00    0000
CO   5770SS1  V7R2M0    SI54400   00/00    0000
DIST 5770ST1  V7R2M0    SI57912   NONE     0000



NOTICE:
-------
Application of this PTF may disable or render ineffective programs that
use system memory addresses not generated by the IBM translator,
including programs that circumvent control technology designed to limit
interactive capacity to purchased levels.  This PTF may be a prerequisite
for future PTFs.  By applying this PTF you authorize and agree to the
foregoing.

This PTF is subject to the terms of the license agreement which
accompanied, or was contained in, the Program for which you are obtaining
the PTF.  You are not authorized to install or use the PTF except as part
of a Program for which you have a valid Proof of Entitlement.

SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
REGARDING THE PTF.

The applicable license agreement may have been provided to you in printed
form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
CL command.





APAR Error Description / Circumvention

-----------------------------------------------
Using the MERGE statement for an inherently read-only or
non-deletable view was previously allowed if the operation in
the MERGE (insert, update, delete) matched the operation of an
INSTEAD OF trigger for the view. This should not be allowed. The
MERGE processing cannot always recognize when a change requires
the trigger to be fired.

CORRECTION FOR APAR SE68329 :
-----------------------------
Internal processing has been changed to issue an SQL0150 when
MERGE is operating on a view defined this way. This restriction
is listed in the SQL Reference for the MERGE statement.

CIRCUMVENTION FOR APAR SE68329 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI65871      OSP-DB INTERNAL MAINTENANCE
   SI65847      OSP-DB INTERNAL MAINTENANCE
   SI65811      OSP-DB INTERNAL MAINTENANCE
   SI65780      OSP-DB INTERNAL MAINTENANCE
   SI65717      OSP-DB INTERNAL MAINTENANCE
   SI65359      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4302 MSGCPF4302 F/QQQ
   SI65287      OSP-DB Teraspace memory leak when multiple derived tables in
   SI65079      SQL-RUN-PERFM CRTSQLCI/CRTSQLCPPI PERFORMANCE
   SI64717      OSP-DB-OTHER-T/QSQINS-MSGSQL0203 INSERT STATEMENT FAILS WITH
   SI64451      OSP-DB-OTHER-MSGSQL0326 JOBS SEEING SQL0326 IN APPLICATION J
   SI64409      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 MCH1210 F/QSQRCH
   SI64355      OSP-DB-OTHER-F/QSQRCHK-MSGMCH1210 WHEN RECURSIVE COMMON TABL
   SI64355      OSP-DB-F/QSQRCHK-MSGMCH1210 when returning a SQL0390 process
   SI64304      OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGSQL0205 MSGSQL0205 F/Q
   SI64193      OSP-DB INTERNAL MAINTENANCE
   SI64193      OSP-DB-OTHER-T/QSINS-MSGSQL0203 INSERT STATEMENT FAILS WITH
   SI64051      OSP-DB INTERNAL MAINTENANCE
   SI64051      OSP-DB Internal Maintenance
   SI63898      OSP-DB-OTHER-F/QSQPLIST-T/QSQPLIST-MSGMCH3601 RUNSQLSTM
   SI63874      OSP-DB Correct FULL OUTER JOIN implementation
   SI63835      OSP-DB INTERNAL MAINTENANCE
   SI63763      OS-DB-OTHER Fix handling of partition table range boundary v
   SI63696      OSP-DB INTERNAL MAINTENANCE
   SI63635      OSP-DB INTERNAL MAINTENANCE
   SI63497      OSP-DB Addition of LTRIM / RTRIM Function Support
   SI63377      OSP-DB Internal Maintenance
   SI63230      OSP-DB Do not issue SQL7901 for create package
   SI63137      OSP-DB-OTHER-RC2-MSGSQL0101 SQL COMPLEX SQL0101 RC2
   SI62774      OSP-DB INTERNAL MAINTENANCE
   SI62653      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0204 REMOTE THREE PAR
   SI62629      OSP-DB INTERNAL MAINTENANCE
   SI62588      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0205 COLUMN NAME NOT
   SI62582      OSP-DB INTERNAL MAINTENANCE
   SI62526      OSP-DB-OTHER-F/QQDAPROC-T/QQDAPROC-MSGMCH3602 ON SOME CRTSQL
   SI62526      OSP-DB INFRASTRUCTURE
   SI62508      OSP-DB INTERNAL MAINTENANCE
   SI62299      OSP-DB INTERNAL MAINTENANCE
   SI62154      OSP-DB INFRASTRUCTURE
   SI61997      OSP-DB Internal Maintenance
   SI61896      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0204 SQL0204 F/QSQRUN
   SI61880      OSP-DB INTERNAL MAINTENANCE
   SI61321      OSP-DB SQL0171 when using VARGRAPHIC type with INSTR() or LO
   SI61195      OSP-DB-OTHER-T/QSQSCHEM-MSGCPD0018 RUNSQLSTM PROBLEM WITH CL
   SI60800      OSP-DB-OTHER-T/QSQPMAIN-MSGCPF9999 FROM CRTSRCPF/CHGSRCPF/AD
   SI60800      SQL-CMPL-CURR ALLOW COMPILEOPT('OPTION(*EVENTF)') ON SQL PRE
   SI60800      OSP-DB INTERNAL MAINTENANCE
   SI60793      OSP-DB-F/QSQINS-MSGMCH3402 DLTF on table with row and column
   SI60592      OSP-DB INFRASTRUCTURE
   SI60558      OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 SQL INSERT FAILS WITH MSG
   SI60423      OSP-DB-OTHER BETTER SQL IDENTIFIER NAMES
   SI60322      OSP-DB-MSGMSG0601 T/QQQFVMT Proc/MAP using lateral correlati
   SI60310      OSP-DB Internal Maintenance
   SI60263      OSP-DB-OTHER-INCORROUT QDT is not rebuilt when SELECT * and
   SI60187      OSP-DB-OTHER-MSGSQL0053 RUNSQLSTM PROBLEM WITH UNICODE CCSID
   SI60142      OSP-DB-INCORROUT INLINED SQL FUNCTION
   SI60141      OSP-DB-MSGMCH3601-QSQPROC RUNSQL of compound dynamic stateme
   SI60052      OSP-DB INTERNAL MAINTENANCE
   SI60039      SQL-CMPL-CURR-T/QSQPRUN-MSGSQL8016 SQL PRECOMPILE
   SI59967      OSP-PERFM SQL INSERT SLOW AFTER A FAILED ALTER TABLE
   SI59737      OSP-DB Internal Maintenance
   SI59608      OSP-DB INFRASTRUCTURE
   SI59449      OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-RC21-MSGCPD4374 UPDATING X
   SI59414      OSP-DB INFRASTRUCTURE
   SI59348      OSP-DB INTERNAL MAINTENANCE
   SI59311      OSP-DB-OTHER-MSGSQL0900 AFTER CRTSQLCI to REMOTE RDB
   SI59123      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-RC2-MSGSQL0101 SQL RPG OBJE
   SI59063      OSP-DB INFRASTRUCTURE
   SI58991      OSP-DB INTERNAL MAINTENANCE
   SI58975      OSP-DB OFFSET clause changes for internal processing
   SI58951      OSP-DB INTERNAL MAINTENANCE
   SI58909      OSP-DB Internal Maintenance
   SI58909      OSP-DB Internal Maintenance
   SI58907      OSP-DB INFRASTRUCTURE
   SI58804      OSP-DB-OTHER-F/QSQPLIST-T/QSQPLIST-MSGMCH3402 ALTER TABLE FR
   SI58740      OSP-DB INFRASTRUCTURE
   SI58101      OSP-DB INTERNAL MAINTENANCE
   SI58101      OSP-DB-OTHER-PERFM EXTRA CONNECTION DONE WITH 3-PART NAMING
   SI58062      OSP-DB-INCORROUT SQL ROUTINE CONDITION HANDLER NOT ACTIVATED
   SI58026      OSP-DB Internal Maintenance
   SI57930      OSP-DB-MSGSQL0206 when column not defined at precompile time
   SI57911      OSP-DB INTERNAL MAINTENANCE
   SI52755      SQL-CMPL-CURR CRTSQLRPGI FAILS WHEN COMPILING LARGE SOURCE F
   SI57897      OSP-DB-MSGSQL0150 Unable to use XMLTABLE and a view in a tem
   SI57834      OSP-DB-OTHER-F/QLIDLOBJ-T/QSQDDDL1-MSGCPC2191 QGENOBJNAM DAT
   SI57749      OSP-DB-OTHER-MSGSQL0104 RUNSQLSTM PROBLEM WITH TRIMMED RECOR
   SI57567      OSP-DB-OTHER-MSGSQL0104 RUNSQLSTM PROBLEM WITH TRIMMED RECOR
   SI57533      OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN1-MSGCPD4324 MSGCPD4324 F/QQQ
   SI57533      OSP-DB-OTHER-F/QQQVFMT-T/QSQRCHK-MSGCPF4278 SQL STORED PROCE
   SI56946      OSP-DB Internal Maintenance
   SI56940      OSP-DB Internal Maintenance
   SI56794      OSP-DB Update SYSTRIGGERS to correct REMARKS column
   SI56757      OSP-DB CPYFRMIMPF CAN RUN SLOW IF OVRDBF IS USED.
   SI56720      OSP-DB Internal Maintenance
   SI56633      OSP-DB-PERFM SQL ROUTINE GRAPHIC/VARGRAPHIC PERFORMANCE
   SI56593      SQL-CMPL-INCORROUT TRIGGER EVENT PREDICATE OF A MULTIPLE EVE
   SI56348      OSP-DB Formatting for SQL routine text lost using RUNSQLSTM
   SI56323      OSP-DB INTERNAL MAINTENANCE
   SI56253      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-RC2-MSGSQL0101 SQL MERGE ST
   SI56253      OSP-DB INTERNAL MAINTENANCE
   SI56136      OSP-DB Extend QSQPRCED() to include some QAQQINI options
   SI56125      OSP-DB INTERNAL MAINTENANCE
   SI55931      SQL-CMPL-INCORROUT DEBUGGER ARRAY TYPE VARIABLES
   SI55612      OSP-DB Internal Maintenance
   SI55601      OSP-DB Internal Maintenance
   SI55601      OSP-DB-F/QSQRCHK-MSGMCH0601 when there are a large number of
   SI55601      OSP-DB CREATE TABLE with range partition starting value grea
   SI55601      OSP-DB-OTHER-T/QSQRUN4X/42011-MSGSQL0204 SQL0204 ISSUED WHEN
   SI55601      OSP-DB-OTHER-INCORROUT NO MSGSQL0206 AT COMPILE WHEN SQL_GVA
   SI55588      OSP-DB-OTHER-F/QDBCRTFI-T/QSQCRTT-MSGCPF3204
   SI55495      OSP-F/QSQDDL1-T/QSQDDL1-MSGMCH1210 RUNSQLSTM FAILS WITH MCH1
   SI55455      OSP-DB-OTHER-F/QSQPARSP-T/QSQPARSP-MSGMCH0601 DBGVIEW *SOURC
   SI55430      SQL-CMPL-CURR-INCORROUT CORRECT DATE/TIME/TIMESTAMP HOST VAR
   SI55290      OSP-DB-MSGMCH3601-T/QSQRCHK using array variables
   SI55283      OSP-DB Internal Maintenance
   SI55222      OSP-DB Internal Maintenance
   SI54999      OSP-DB INTERNAL MAINTENANCE
   SI54868      OSP-DB-OTHER-UNPRED UPDATING A TABLE WITH BOTH A NULLABLE FI
   SI54866      SQL-CMPL DEBUGGER SUPPORT FOR SQL VARIABLES WITHIN SQL ROUTI
   SI54746      OSP-DB Internal Maintenance
   SI54683      OSP-DB INTERNAL MAINTENANCE
   SI54606      OSP-DB Internal Maintenance
   SI54555      OSP-DB INTERNAL MAINTENANCE
   SI54520      QRY-QRYRUN-THREADS-MSGCPD4302 IN DEFINE RESULT FIELDS CPD430
   SI54070      OSP-DB Internal Maintenance
   SI53986      OSP-DB RUNSQL sends duplicate messages to joblog
   SI53912      OSP-DB ADD LOCK TABLE SUPPORT MULTIPLE MEMBER FILES
   SI53690      OSP-DB-MSGCPD4324 QQQVSEL Global variable and NOT IN predica
   SI53646      OSP-DB RUNSQL not writing error to joblog with *LIST option
   SI53618      OSP-DB-MSGSQL5001 when using a global variable in a DISTINCT
   SI53547      OSP-DB-MSGSQL0901 invoking function LPAD with parameter 1 va
   SI53502      OSP-DB INTERNAL MAINTENANCE
   SI53481      OSP-DB INTERNAL MAINTENANCE
   SI53428      OSP-DB-MSGSQL0901 ALTER TABLE ALTER PARTITION on a table wit
   SI53428      OSP-DB-MSGSQL0312 INCORRECT ERROR MESSAGE
   SI53428      OSP-DB-MSGSQL0901 ALTER TABLE ALTER PARTITION on a table wit
   SI53425      OSP-DB INTERNAL MAINTENANCE
   SI53405      OSP-DB Add option for listing to RUNSQL command
   SI53293      OSP-DB-MSGSQL9001 SQL PRECOMPILE FAILS WITH SQL0122 WHEN USI
   SI53214      SQL-CMPL-MSGSQL7032 SQL ROUTINE FAILS TO CREATE
   SI53146      OSP-DB Serviceability Enhancement for SQL
   SI53071      OSP-DB Internal maintenance
   SI52897      OSP-DB-OTHER-UNPRED A CREATE OF A MATERIALIZED QUERY TABLE M
   SI52831      OSP-DB CREATE TABLE with range partition starting value less
   SI52818      OSP-DB Internal Maintenance
   SI52789      SQL-CMPL-MSGSQL7032 SQL ROUTINE FAILS TO CREATE
   SI52745      OSP-DB-OTHER-INCORROUT THE COLUMN NAME OF A GLOBAL VAR WITH
   SI52745      OSP-F/QSQRCHK-T/QSQRCHK-MSGMCH0601 A CALL TO A STORED PROCED
   SI52745      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 CRTSQLCBLI FAILS
   SI52685      OSP-DB UNABLE TO USE GENERATE SQL WITH PARTITIONED TABLE IF
   SI52604      OSP-DB-MSGSQL0338 with implied parentheses in join order
   SI52458      OSP-DB Internal maintainence
   SI52344      OSP-DB INTERNAL MAINTENANCE
   SI52271      OSP-DB INTERNAL MAINTENANCE
   SI52193      OSP-DB Column name for global variable with long AS name
   SI52016      OSP-DB-MSGSQL0156 TRUNCATE sends wrong message for an index
   SI51984      OSP-DB INTERNAL MAINTENANCE
   SI51927      OSP-DB INTERNAL MAINTENANCE
   SI51755      OSP-DB Internal Maintenance
   SI51682      OSP-DB INTERNAL MAINTENANCE
   SI51529      OSP-DB Incremental Enhancement
   SI51461      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 CRTSQLCBLI FAILS
   SI51282      OSP-DB Internal Maintenance
   SI51241      OSP-DB Internal Maintenance

Summary Information

System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program............... 5770SS1
APAR Fixed.......................... View details for APAR SE68329
Superseded by:...................... View fix details for PTF SI68941
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C8249720


System i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information.

Document information

More support for: i family

Software version: V7R2M0

Operating system(s): OS/400

Reference #: SI66177

Modified date: 21 December 2017