IBM Support

SI48929 - OSP-DB-OTHER-INCORROUT INCORROUT ON OEM SQL STORED PROCEDURE

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT INCORROUT ON OEM SQL STORED PROCEDURE


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI38413   00/00    0000
CO   5770SS1  710  SI48854   00/00    0000
CO   5770SS1  710  SI48826   00/00    0000
CO   5770SS1  710  SI48191   00/00    0000
CO   5770SS1  710  SI48194   00/00    0000
CO   5770SS1  710  SI48193   00/00    0000
CO   5770SS1  710  SI48195   00/00    0000
CO   5770SS1  710  SI48196   00/00    0000
CO   5770SS1  710  SI48198   00/00    0000
CO   5770SS1  710  SI48197   00/00    0000
CO   5770SS1  710  SI48681   00/00    0000
DIST 5770999  710  MF55625   00/00    0000
DIST 5770SS1  710  SI44237   00/00    0000
DIST 5770SS1  710  SI40706   00/00    0000
DIST 5770SS1  710  SI40707   00/00    0000
DIST 5770SS1  710  SI40754   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

-----------------------------------------------
INCORROUT on OEM SQL stored procedure after PTF update

No information is returned

CORRECTION FOR APAR SE54312 :
-----------------------------
Calling the stored procedure multiple times with the same
parameters returned the expected result set for the first CALL,
but an empty result set on all subsequent CALLs.  The stored
procedure created a global temporary table and populated it
using SQL INSERT statements. The query producing the result set
had comparisons to an IDENTITY column in the global temp table.
For performance, global temp tables are cleared and reused in
some cases, which caused different IDENTITY column values in
this case.
Logic is changed to not reuse a global temp table if it contains
an IDENTITY column.

CIRCUMVENTION FOR APAR SE54312 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI48827      OSP-DB INTERNAL MAINTENANCE
   SI47048      OSP-DB-OTHER-F/QSQDROP-T/QSQDROP-MSGSQL0910 DROP SCHEMA FAIL
   SI46565      OSP-DB-MSGCPF8361 Remote three part Alias with Embedded SQL
   SI44917      OSP-DB-MSGMCH3402-T/QSQALIAS DROPFORCREATEREPLACE procedure
   SI44667      OSP-DB table incorrectly searched on local sytem insted of r
   SI40615      OSP-DB-UNPRED Three part alias statement rewrite
   SI40375      OSP-DB-UNPRED Three part SQL aliases failing to create
   SI39873      OSP-DB-UNPRED Use of DDM for SQL three-part aliases failing
   SI39369      OSP-DB Internal Maintenance
   SI39340      OSP-DB-MSGSQL0901-T/QSQALIAS Reason code 4055 on CREATE ALIA
   SI39160      OSP-DB-MSGCPF3324 drop collection fails
   SI37682      OSP-DB Internal Maintenance
   SI37662      OSP-DB Internal Maintenance
   SI37637      OSP-DB Internal Maintenance
   SI37438      OSP-DB INTERNAL MAINTENANCE
   SI37062      OSP-DB-INCORROUT - MSGSQL0204 ON DROP OF TRIGGER WITH QUOTED
   SI48747      OSP-DB-OTHER-UNPRED Internal Maintenance
   SI43817      OSP-DB-MSGSQL0104-T/QSQCRTDB
   SI43762      OSP-DB-INCORROUT GARBLED LABEL TEXT FOR CREATE DATABASE
   SI39374      OSP-DB Internal Maintenance
   SI48766      OSP-DB-MSGMCH3601-T/QSQCRTT CHECK_DGTT_SQL on DECLARE GLOBAL
   SI48641      OSP-DB STORE PROCEDURES FAILS SQL0601 F/QSQCRTI T/QSQCRTI SI
   SI48262      OSP-DB get column names from source table on luw
   SI48199      OSP-DB-OTHER-RC480-MSGSQL0904
   SI48130      OSP-DB-MSGSQL0350 remote query to z/OS
   SI47843      OSP-DB allow create table based on source table on luw
   SI47822      OSP-DB create table as based on source table on luw
   SI47740      OSP-DB support CREATE TABLE AS with a remote query
   SI47670      OSP-DB-PERFM Improved DECLARE GLOBAL TEMPORARY TABLE WITH RE
   SI47575      OSP-DB-MSGCPF8350-T/QDBCHGFI SQL0901 4411 Create or replace
   SI47476      OSP-DB-MSGSQL0601 Create or replace view in qtemp
   SI47365      OSP-DB-OTHER-UNPRED SERVICEABILITY
   SI47104      OSP-DB-MSGSQL0601 LIBRARY MSG TOKEN CONTAINS BLANKS FOR DUP
   SI46785      OSP-DB MSGSQL0901 CREATE OR REPLACE view failure
   SI46728      OSP-CP-OTHER-QCPGENIO messages in job log not handled by SQL
   SI46557      OSP-DB-MSGSQL0901-MSGMCH3601-T/QSQCRTT TBLLIKERRS Reason 420
   SI46145      OSP-DB-MSGSQL0681 when doing ALTER to add a field proc to a
   SI45882      OSP-DB-MSGSQL0683-f/QSQALTER when doing ALTER TABLE to add a
   SI45483      OSP-DB-OTHER-MSGSQL0204 MSGSQL0204 TRYING TO CREATE A TABLE
   SI44778      OSP-DB-OTHER-UNPRED ALLOCATE(0) ON AN ALTER TABLE DOES NOT R
   SI44489      OSP-DB ENHANCE CREATE TABLE WITH DATA TO RETURN ROW_COUNT
   SI44239      OSP-DB-OTHER-MSGCPF32A5 A MSGCPF32A5 CCSID 13488 FOR FIELD *
   SI43446      OSP-DB-OTHER-F/QDBCHGFI-T/QSQALTER-MSGCPF7304 SQL ALTER TABL
   SI43377      OSP-DB-OTHER-F/QSQALTER-T/QSQALTER-MSGSQL0678 ALTER TABLE FA
   SI42910      OSP-DB-MSGCPD32F5-F/QDBCRTFI-T/QSQCRTT on create table
   SI42841      OSP-DB-OTHER-F/QSQALTER-RC4-MSGSQL0685
   SI42524      OSP-F/QSQCRTT-T/QSQCRTT-MSGMCH1210 MSGMCH1210 F/QSQCRTT WHEN
   SI42250      OSP-DB Internal Maintenance
   SI40968      OSP-DB-INCORROUT SQL0685 PROVIDE REASON CODE IN SQ COMPONENT
   SI40942      OSP-DB-OTHER-F/QDBFIXIT-T/QSQCRTT-MSGCPF325E DECLARE GLOBAL
   SI40761      OSP-DB-MSGMCH1222 F/QQQSVRTN QQINVFP FOR FIELDPROCEDURE ON D
   SI40705      OSP-DB-INCORROUT Query text generated for a CREATE VIEW SQL
   SI40467      OSP-DB-MSGSQL7009 UNQUALIFIED FIELDPROCEDURE USING SQL NAMIN
   SI40398      OSP-DB-MSGSQL7009 SPECIFYING AN UNQUALIFIED FIELDPROCEDURE
   SI39813      OSP-DB-MSGMCH3601 f/QSQCRTT/20507 When an XML column with fi
   SI39738      OSP-DB-MSGSQL0901 when attempting to create/alter a partitio
   SI39655      OSP-DB-MSGSQL0685 with field procs
   SI39616      OSP-DB-MSGSQL0685 when CREATE TABLE LIKE of table with field
   SI39562      OSP-DB-MSGSQL0685 with field procs
   SI39496      OSP-DB-MSGMCH1864 F/#dbxvfld T/QDBCRTME WHEN FIELDPROC WITH
   SI39436      OSP-DB-INCORROUT MSGSQL0901 f/QSQCRTV/20229 when doing CREAT
   SI39109      OSP-DB Internal Maintenance
   SI39109      OSP-DB Internal Maintenance
   SI38804      OSP-DB Internal Maintenance
   SI38779      OSP-DB Internal Maintenance
   SI38747      OSP-DB Internal Maintenance
   SI38699      OSP-DB Internal Maintenance
   SI38602      OSP-DB Internal Maintenance
   SI38516      OSP-DB Internal Maintenance
   SI38422      OSP-DB Internal Maintenance
   SI39333      OSP-DB-INCORROUT CREATE TABLE SHOULD BE DISALLOWED WHEN FIEL
   SI39209      OSP-DB-OTHER-PERFM QDT REBUILD FOR EACH STATEMENT EXECUTION
   SI39209      OSP-DB-OTHER-T/QSQCRTI-MSGMSGMCH5804
   SI39049      OSP-DB-OTHER-F/QDBEXDFI-T/QSQALTER-MSGCPF3202 ADD PARTITION
   SI38942      OSP-DB Internal Maintenance
   SI38790      OSP-DB Internal Maintenance
   SI38562      OSP-DB-INCORROUT ALTER TABLE Partitioning
   SI38096      OSP-DB-F/QSQALTER-MSGMCH1210 Altering table to bigger then m
   SI37875      OSP-DB-OTHER-QDBCHGFI ALTER TABLE FOR PARTITIONED TABLES
   SI37720      OSP-DB-QSQCRTI-MSGSQL0901 on CREATE INDEX
   SI37632      OSP-DB-QSQCRTI-MSGSQL0901 when CPD435D is signalled on CREAT
   SI37404      OSP-DB-QSQALTER-MSGSQL0901
   SI37189      OSP-DB-MSGMCH1864 F/#dbxvfld T/QDBCRTME CREATE TABLE AS WITH
   SI37189      OSP-DB-INCORROUT EXECUTE IMMEDIATE CREATE TABLE WITH FIELDPR
   SI36767      OSP-DB-MSGSQL0901 F/QSQCRTT FOLLOWING CPD32D7 RC=12
   SI36609      OSP-DB-QSQCRTI MSGSQL0137 when different error should occur
   SI36553      OSP DB GLOBAL VARIABLE PROCESSING

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE54312
Superseded by:......................View fix details for PTF SI64950
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.

[{"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":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
07 March 2013