IBM Support

SI64283 - OSP-DB-OTHER-F/QSQRPARS-T/QSQRPARS SQL FAILURE

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-F/QSQRPARS-T/QSQRPARS SQL FAILURE


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI58135   00/00    0000
PRE  5770SS1  710  SI56772   00/00    0000
PRE  5770SS1  710  SI56982   00/00    0000
PRE  5770SS1  710  SI56983   00/00    0000
PRE  5770SS1  710  SI56898   00/00    0000
PRE  5770SS1  710  SI56725   00/00    0000
PRE  5770SS1  710  SI56985   00/00    0000
PRE  5770999  710  MF59386   00/00    0000
PRE  5770SS1  710  SI55280   00/00    0000
PRE  5770SS1  710  SI55325   00/00    0000
PRE  5770SS1  710  SI55554   00/00    0000
PRE  5770SS1  710  SI50960   00/00    0000
PRE  5770SS1  710  SI50926   00/00    0000
PRE  5770SS1  710  SI50925   00/00    0000
PRE  5770SS1  710  SI50927   00/00    0000
PRE  5770SS1  710  SI48642   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  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
CO   5770SS1  710  SI62819   00/00    0000
CO   5770SS1  710  SI62822   00/00    0000
CO   5770SS1  710  SI62823   00/00    0000
CO   5770SS1  710  SI58008   00/00    0000
CO   5770SS1  710  SI58007   00/00    0000
CO   5770SS1  710  SI48080   00/00    0000
CO   5770SS1  710  SI48144   00/00    0000
CO   5770SS1  710  SI42927   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

-----------------------------------------------
When an SQL query contains a ROW CHANGE expression which
references an unqualified table, the SQL parser may fail with an
SQL0901 message (MSGSQL0901).

One or more of the following messages may be left in the job log
when this error occurs: MCH1210 (MSGMCH1210) and MCH3601
(MSGMCH3601).

CORRECTION FOR APAR SE66922 :
-----------------------------
The SQL parser will be modified to correctly handle a query
which contains a ROW CHANGE expression which references an
unqualified table and no longer fail with an SQL0901 message
(MSGSQL0901).

CIRCUMVENTION FOR APAR SE66922 :
--------------------------------
None.


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
--------------  ------------------------------------------------------------
   SI63456      OSP-DB Allow FOR UPDATE clause with OFFSET and FETCH N ROWS
   SI62820      OSP-DB INTERNAL MAINTENANCE
   SI60206      OSP-DB INFRASTRUCTURE
   SI60056      OSP-DB INTERNAL MAINTENANCE
   SI59350      OSP-DB INTERNAL MAINTENANCE
   SI58188      OSP-DB Allow extended indicators in dynamic sq in sql routin
   SI58125      OSP-DB INTERNAL MAINTENANCE
   SI58009      OSP-DB No return value allowed for compound dynamic statemen
   SI57416      OSP-DB MSGSQL0199 when using INLINE as correlation name
   SI57179      OSP-DB Support CREATE OR REPLACE TABLE
   SI56941      OSP-DB Internal Maintenance
   SI56642      OSP-DB-OTHER-MSGSQL0180 ON PROGRAM USING PARAMETER MARKER CO
   SI56238      OSP-DB INTERNAL MAINTENANCE
   SI56097      OSP-DB INTERNAL MAINTENANCE
   SI55630      SQL-CMPL INCREASE MAXIMUM NUMBER OF FUNCTION PARAMETERS
   SI55277      OSP-DB Allow UPDATE statement reuse when contains special re
   SI55213      OSP-DB-OTHER-MSGSQL9001 CREATE TRIGGER FAILS ON MERGE
   SI54991      OSP-F/QSQDDL1-T/QSQDDL1-MSGMCH1210 RUNSQLSTM FAILS WITH MCH1
   SI54627      OSP-DB INTERNAL MAINTENANCE
   SI54557      OSP-DB INTERNAL MAINTENANCE
   SI53936      OSP-DB Internal Maintenance
   SI53691      OSP-DB-MSGCPD4324 QQQVSEL Global variable and NOT IN predica
   SI53499      OSP-DB INTERNAL MAINTENANCE
   SI53443      OSP-DB INTERNAL MAINTENANCE
   SI53341      OSP-MSGSQL0312 STORED PROCEDURE RUNNING INSERT W/SUBSELECT W
   SI53276      OSP-DB SYSROUTINEDEP column PARM_SIGNATURE has the wrong dat
   SI52850      OSP-DB Support OLD and NEW as trigger correlation names
   SI52257      OSP-DB SQL MERGE qualification of columns in insert substate
   SI51039      OSP-DB Support dynamic compound statement in SQL
   SI51031      OSP-DB MSGCPD439A RC8 F/QQQVFMT T/QSQRUN3 / MSGSQL0171
   SI50948      OSP-DB-MSGSQL5001 Column qualified with RDB alias name
   SI50702      Integrity Problem
   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..........................View details for APAR SE66922
Superseded by:......................
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................NONE


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.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
26 July 2017