IBM Support

SI50702 - Integrity Problem

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

Integrity Problem


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI48642   00/00    0000
PRE  5770SS1  710  SI48829   00/00    0000
PRE  5770SS1  710  SI48846   00/00    0000
PRE  5770SS1  710  SI48853   00/00    0000
PRE  5770SS1  710  SI48874   00/00    0000
PRE  5770SS1  710  SI48128   00/00    0000
PRE  5770SS1  710  SI48152   00/00    0000
PRE  5770SS1  710  SI48274   00/00    0000
PRE  5770SS1  710  SI48090   00/00    0000
PRE  5770SS1  710  SI46490   00/00    0000
PRE  5770SS1  710  SI46574   00/00    0000
PRE  5770SS1  710  SI42954   00/00    0000
PRE  5770999  710  MF52752   00/00    0000
PRE  5770SS1  710  SI38089   00/00    0000
CO   5770SS1  710  SI50048   00/00    0000
CO   5770SS1  710  SI50045   00/00    0000
CO   5770SS1  710  SI50046   00/00    0000
CO   5770SS1  710  SI50047   00/00    0000
CO   5770SS1  710  SI49848   00/00    0000
CO   5770SS1  710  SI49106   00/00    0000
CO   5770SS1  710  SI49105   00/00    0000
CO   5770SS1  710  SI48826   00/00    0000
CO   5770SS1  710  SI48080   00/00    0000
CO   5770SS1  710  SI48144   00/00    0000
CO   5770SS1  710  SI46365   00/00    0000
CO   5770SS1  710  SI42927   00/00    0000
CO   5770SS1  710  SI41416   00/00    0000
DIST 5770ST1  710  SI49109   NONE     0000
DIST 5770SS1  710  SI43720   00/00    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

-----------------------------------------------
Integrity Problem.

CORRECTION FOR APAR SE56408 :
-----------------------------
Integrity Problem.

CIRCUMVENTION FOR APAR SE56408 :
--------------------------------
Integrity Problem.


Activation Instructions


None.




Special Instructions


None.


Default Instructions

THIS IS A DELAYED PTF TO BE APPLIED AT IPL TIME.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI50592      OSP-DB-OTHER-INCORROUT DBCS SQL HEX(REPLACE('FIELDNAME' X'DB
   SI50441      OSP-DB No parameter marker replacement for special Guardium
   SI50241      OSP-DB-OTHER-MSGMCH3601 A MSGMCH3601 MAY OCCUR WHEN USING TH
   SI50044      OSP-DB Support for Debug of Scalar UDFs with Data Studio
   SI50011      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0122 WHEN RUNNING A G
   SI49846      OSP-DB ALLOW EXPLICIT USE OF RDB ALIAS WITH 3-PART SQL STATE
   SI49744      OSP-DB-OTHER-F/QSQRPARS-MSGMCH3601 MSGMCH3601 F/QSQRPARS ON
   SI49638      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH3203 MSGMCH3203 F/QSQ
   SI49514      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0204 SQL STATEMENT FA
   SI49112      OSP-DB Add support for multiple event triggers
   SI49112      OSP-DB-OTHER-MSGSQL0104 WHEN TRYING TO CREATE A TRIGGER USIN
   SI49112      OSP-DB-MSGMCH3601 QSQRCHK for MERGE statement
   SI49112      OSP-DB Add option to specify system name for create table, v
   SI48882      OSP-DB INTERNAL MAINTENANCE
   SI48854      OSP-DB Disallow SELECT statement for RUNSQL command
   SI48804      OSP-DB Null results returned for multiple grouping sets quer
   SI48309      OSP-DB Named parameters and defaults for procedures
   SI48269      OSP-DB-MSGSQL0204 create variable referencing function with
   SI48164      OSP-DB INTERNAL MAINTENANCE
   SI48142      OSP-DB INTERNAL MAINTENANCE
   SI47739      OSP-DB support CREATE TABLE AS with a remote query
   SI47435      OSP-DB In *SYS naming, allow '.' for qualifying objects
   SI47244      OSP-DB-OTHER-SRCB6005121 WORD 1 SRCB6005121 WORD 3 SRC004000
   SI46912      OSP-DB-MSGSQL0129 Delete statement incorrectly indicates max
   SI46631      OSP-DB Add support for the XMLTABLE function
   SI46554      OSP-DB-OTHER-T/QSQRPARSX/60620-MSGMCH1210 EDITING RGPLE SOUR
   SI46386      OSP-DB Too many rows deleted using RRN in row expression
   SI46369      F/QSQXCUTE-MSGSQL0104-RIDS/CLEANUP SETTING AN SQL VARIABLE T
   SI46347      OSP-DB SUPPORT WRAPPED FUNCTIONS AND PROCEDURES
   SI46228      OSP-INCORROUT FETCH FIRST N ROW NOT RECOGNIZED
   SI46228      OSP-DB-OTHER-UNPRED DSPPGM, PRTSQLINF AND I SERIES NAV RETRI
   SI45871      OSP-DB Support UNIT SSD for DECLARE GLOBAL TEMPORARY TABLE
   SI45644      OSP-F/QSQDDL1-T/QSQDDL1-MSGMCH1210 CREATE OR REPLACE VIEW FA
   SI45405      OSP-DB CCSID not set for parameters defined as NCHAR type
   SI45338      OSP-DB-OTHER-MSGSQL7906 RUNSQLSTM WITH TGTRLS(*V5R4M0) FAILS
   SI45048      OSP-DB-MSGSQL0084 prompting CONNECT TO in interactive sql
   SI44779      OSP-DB-OTHER-UNPRED ALLOCATE(0) ON AN ALTER TABLE DOES NOT R
   SI44779      OSP-DB-OTHER-UNPRED AN ALTER TABLE USING BEFORE COLUMN SYNTA
   SI44576      OSP-DB-OTHER-INCORROUT A QUERY WITH AT LEAST 2 TABLES MAY RE
   SI44441      OSP-DB-OTHER-MSGSQL5001 SQL RESERVED WORD COLLECT CANNOT BE
   SI43721      OSP-DB Loop when prompting SQL statement ALTER TABLE t1 ADD
   SI43315      OSP-DB-OTHER-F/DBPMTRAP-T/QSQRPARS-MSGMCH3203 EDITING SQLRPG
   SI43315      OSP-DB-OTHER-LOOP RPG PGM WITH SQL COMPILE STARTS LOOPING NO
   SI43315      OSP-DB-MSGSQL0199 For sql create view with common table expr
   SI43315      OSP-DB SQL function RID disallows column named RID
   SI43315      OSP-DB SQL query support for CONNECT BY
   SI42953      OSP-DB-OTHER-MSGSQL0204 CALL OF A FUNCTION IS FAILING WITH M
   SI42953      OSP-DB SPECIFY PROGRAM NAME ON CREATE TRIGGER
   SI42180      OSP-DB-OTHER-MSGSQL0120 SQL STATE 42903 WHEN USING OLAP RANK
   SI42092      OSP-DB-OTHER-F/QSQXCUTEX/27892-T/SAME-MSGSQL5001 MSGSQL5001
   SI42092      OSP-DB-OTHER-MSGSQL0203 OSP-DB-OTHER-MSGSQL0203
   SI42092      OSP-DB-MSGSQL0199 when use label DEFAULT in routine body
   SI41834      OSP-DB-OTHER-INCORROUT UNICODE CONSTANTS THAT END IN CHARACT
   SI41803      OSP-DB-MSGSQL0113 when TABLESPACE clause should be ignored
   SI41803      OSP-DB-MSGSQL0113 CREATE PROCEDURE in RUNSQLSTM with delimit
   SI41616      OSP-DB Global variable qualified with system naming restrict
   SI41487      SMU-DBPARL-F/QSQRPARS-T/QSQRPARS-MSGMCH1210 DELETING LINES I
   SI41415      OSP-DB-INCORROUT VISUAL EXPLAIN OF MERGE FAILS
   SI41341      OSP-DB-MSGSQL0802 Update statement with qualified global var
   SI41171      OSP-DB Parameter marker data types for simple SQL CASE expre
   SI41055      OSP-DB Enable expressions in SQL CALL statement
   SI41055      OSP-DB Tolerate the NOT LOGGED clause for CREATE TABLE state
   SI40525      F/QSQILVL3-MSGMCH1210-MOD/QSQILVL3 SQL6101 AND MCH1210 F/QSQ
   SI40325      OSP-DB Wrong string returned for XMLELEMENT on IGC system
   SI40216      OSP-DB-MSGCPD4324 MERGE statement with many host variables
   SI40109      OSP-INCORROUT GARBAGE APPEARED ON THE SQL SCRIPT SCREEN, WHE
   SI40028      SQL-DB-MSGCPF4102 DEBUG VIEW NOT FOUND FOR SQL TRIGGER
   SI39936      OSP-DB Parameter marker extension iteration 1
   SI39841      OSP-DB SQL routine attributes not always set after ALTER
   SI39690      OSP-DB-MSGSQL0205 from QSQBLQDT with multiple complex IN pre
   SI39569      OSP-DB MERGE statement with INSERT and SIGNAL ignore signal
   SI39506      OSP-DB-MSGMCH6903 more than 10 CUBE arguments in SQL
   SI39421      SQL-CMPL-MSGCZM0022 CREATE PROCEDURE WITH RESULT SETS
   SI39339      OSP-DB-MSGSQL0440 when calling procedure with parameter mark
   SI39314      OSP-DB Query wrong records for NOT (row values) IN (subquery
   SI39203      F/QQQVALID-MSGCPD4345-MOD/QQQVALID F/QQQVALID-MSGCPD4345-MOD
   SI38974      OSP-DB Associate locators in create trigger not accepting na
   SI38735      OSP-DB XML namespaces not generated for nested scope
   SI38594      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0122 SELECT STATEMENT
   SI38088      OSP-RC2040-MSGSQL0904 RPG PROGRAM COMPILE FAILS WITH MSGSQL0
   SI37944      SP/QSQRUN1-MSGSQL0101-MOD/QSQPREP SP/QSQRUN1-MSGSQL0101-MOD/
   SI37827      OSP-DB Create schema should not allow XSR object sub-stateme
   SI37454      OSP-DB Global variable in simple update SET list used twice
   SI37381      OSP-DB-OTHER-F/QSQRPARS-T/SAME-MSGMCH1210 ALTER TABLE... SEL
   SI37381      OSP-DB-OTHER-MSGSQL7906 SQL RPGIV TGTRLS *PRV PRECOMPILE FAI
   SI37248      OSP-F/QSQRPARS-T/QSQRPARS-MSGMCH1210 QUERY FAILS AT R610 WIT
   SI37148      OSP-DB XML AS BLOB variable not passed correctly for DRDA
   SI36965      OSP-DB SQL do not allow array constructor as function argume
   SI36818      OSP-DB Arrays over DRDA
   SI36772      OSP-DB-MSGMCH1210 QSQRPARS when precompile with many include
   SI36647      OSP-DB-OTHER-INCORROUT USING STRSQL, PROMPTING FOR A STATEME

Summary Information

System.............................. i
Models..............................
Release............................. V7R1M0
Licensed Program............... 5770SS1
APAR Fixed.......................... SE56408
Superseded by:...................... View fix details for PTF SI64283
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C3298710


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 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: V7R1M0

Operating system(s): OS/400

Reference #: SI50702

Modified date: 26 August 2013