IBM Support

SI42748 - OSP-DB-OTHER-INCORROUT INCORROUT WHEN USING SO JOIN LOGICAL

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT INCORROUT WHEN USING SO JOIN LOGICAL


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF51767   00/00    0000
PRE  5770999  710  MF51692   00/00    0000
PRE  5770999  710  MF49798   00/00    0000
PRE  5770999  710  MF48774   00/00    0000
CO   5770SS1  710  SI42747   00/00    0000
CO   5770SS1  710  SI42442   00/00    0000
CO   5770SS1  710  SI42444   00/00    0000
CO   5770SS1  710  SI42129   00/00    0000
CO   5770SS1  710  SI40213   00/00    0000
CO   5770SS1  710  SI39318   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

-----------------------------------------------
Incorrect result from querying a join logial file.

CORRECTION FOR APAR SE46959 :
-----------------------------
The query processing code was not including all of the s/o specs
from the join logical file.

CIRCUMVENTION FOR APAR SE46959 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI42732      OSP-DB-OTHER-F/QQURB-T/QQURA-MSGCPD4019 CPD4019 WITH SQL PAR
   SI42443      OSP-DB Internal maintenance
   SI42326      OSP-DB Internal maintenance
   SI42232      OSP-INCORROUT WRONG OUTPUT WITH JOIN SELECT/OMIT LOGICAL FIL
   SI42193      OSP-DB SQE Support of Multi dataspace logical
   SI42076      OSP-DB-MSGMCH3601-f/QQQOOODBOP inlining udf with case statem
   SI41935      OSP-DB Internal maintenance
   SI41904      OSP-DB SQE Support of Logical Files - no more service option
   SI41848      OSP-DB Internal maintenance
   SI41801      OSP-DB-OTHER-F/QQQVAP-T/QQQVAP-MSGMCH1210 SQL CCSID CONVERSI
   SI41581      OSP-DB-MSGMCH1884 from #dbenfcn on DELETE
   SI41541      OSP-DB Internal maintenance
   SI41493      OSP-DB-MSGMCH3203 t/QQQOOODBOP SQL MERGE
   SI41493      OSP-DB-INCORROUT Query of logical file with CONCAT
   SI41489      OSP-DB Internal maintenance
   SI41358      OSP-DB OVRDBF function to support buffer length for query
   SI41292      OSP-DB Internal Maintenance
   SI41213      OSP-DB Internal maintenance
   SI41192      OSP-DB Internal Maintenance
   SI38741      OSP-DB-MSGMCH3601 in QQQOOOQSYS
   SI37432      OSP-DB-MSGMCH3402 f/QDMCLOSE on ALTER of table with index
   SI41016      OSP-DB-UNPRED Too many Final Calls for Final Call UDFs
   SI40964      OSP-DB inlining udfs with parameters
   SI40945      OSP-DB SQE Support of Multi dataspace logicals
   SI40806      OSP-DB-OTHER Enable in memory files
   SI40795      OSP-DB-OTHER-F/QDBDLTFI-T/QSQBAS2-MSGCPF3220 MSGCPF3220 F/QD
   SI40748      OSP-DB-SQL Varchar_format & Timestamp_format additional Form
   SI40428      OSP-DB Visual Explain showing incorrect host variable values
   SI40428      OSP-DB SQE Support of Multi dataspace logicals
   SI40311      OSP-DB SQE Support of Multi dataspace logicals
   SI40211      OSP-DB Database monitor internal maintenance.
   SI40093      OSP-DB-MSGSQL0811 using SQL VALUES clause
   SI40038      OSP-DB-SQL-MSGMCH3203  Queries with GROUP BY
   SI39793      OSP-DB-INCORROUT Visual Explain of V5R4 DBMON
   SI39728      OSP-DB-MSGMCH3203 F/QQQOOOUPCL T/QQQOOOUPCL WHEN INVOKING UD
   SI39558      OSP-DB-MSGMCH3203  Fix grouping query with ICU NLSS
   SI39395      OSP-DB-MSGMCH3601  Fix grouping sets problems
   SI39315      OSP-DB Performance enhancement for SQL MERGE statement
   SI39310      OSP-DB-MSGMCH3203  Fix grouping sets problems
   SI39304      OSP-DB-OTHER-INCORROUT
   SI39266      OSP-DB-OTHER VISUAL EXPLAIN IMPROVEMENT
   SI39223      OSP-DB-MSGCPF9898 unexpected CPF9898 when running MERGE
   SI39166      OSP-DB EVI with include recovery
   SI39020      OSP-DB-MSGMCH1819 CQE queries using fieldprocs
   SI38648      SQL-RUN PERF Dispatcher changes
   SI38605      OSP-DB Internal Maintenance
   SI38549      Query a partitioned table in a subquery cause failures.  Mos
   SI38529      OSP-DB-INCORROUT CEILING and FLOOR scalar functions
   SI38419      OSP-DB-MSGMCH1884 Delete from Partitioned Table
   SI38259      OSP-DB-SQL-INCOROUT null value returned for the expression o
   SI38061      OSP-DB-OTHER-F/QQQQUERY-RC6-MSGMSGCPD438C STROBJCVN ON VALID
   SI37960      OSP-DB-OTHER-PERFM OPTIMIZER WILL NOT LOOK AT ALL THE MQTS,
   SI37960      OSP-DB-OTHER-PERFM MQT WILL GET INVALIDATED WHEN IT DOESN' T
   SI37847      OSP-DB-SQL   QAQQINI option ALLOW_ARRAY_VALUE_CHANGES not us
   SI37805      OSP-DB Incorrect result set with partitioned EVI
   SI37785      LIC-DB-SQL Add long index schema to dbmon
   SI37736      OSP-DB-MSGMCH1210 f/t QQQSVRTN/QQINVUDF/IMPLEMENTUDTFINSQE
   SI37397      OSP-DB-OTHER-PERFM NEW QAQQINI OPTION, DETERMINISTIC_UDF_SCO
   SI37194      OSP-DB-F/QQQSRVE1-MSG1210 Date/Time/Timestamp with UNNEST Fu
   SI37149      OSP-DB Longer Schema Support
   SI37127      OSP-DB Internal mainenance for database monitor
   SI36933      OSP-DB-INCORROUT Data mapping errors unexpected for query
   SI36832      OSP-DB-MSGMCH3203 Function check on grouping set query
   SI36464      OSP-DB-MSGMCH3601 f/#cfochkr t/QDBUDR
   SI36464      OSP-DB Incorrect data from logical file cast date to char

Summary Information

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


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 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:
04 April 2011