IBM Support

MF54460 - OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT RETURNED ON A FETCH

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT RETURNED ON A FETCH


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
NONE



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 'IBM License Agreement for Machine
Code', the terms of which were provided in a printed document that was
delivered with the machine.

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.





APAR Error Description / Circumvention

-----------------------------------------------
A FETCH sql stmt returns the same row more than once and that is
wrong. The result is that the application writes more than one
row to the file.

The SQL statement is like this:
SELECT * FROM <DDS lf with S/O>
where
rb0annu = 'V' and
rb0fase = '450' and
rb0tito <> -99998888 AND
rb0PROC = 1329339
For each fetched row, depending on some "rpg logic", the program
can write ( native RPG I/O ) a new record to the same file
opened with the SELECT stmt.

But in the incorrect output case, the fetch returns the same row
more than once.

CORRECTION FOR APAR MA41545 :
-----------------------------
A problem was discovered in the RRN bitmap processing code that
is used for selection.  This problem only occurs when new
records are added to a file during the implementation on a FETCH
SQL statement.  A fix was made to correct the RRN processing and
prevent same row from being processed more than once.

CIRCUMVENTION FOR APAR MA41545 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF53932      OSP-DB-OTHER ADD ABILITY TO END A JOB READING FROM AN INDEX
   MF48536      LIC-DB record validity check in Retrieve Sequential
   MF53152      OSP-F/#DBENTAD-T/QDBGETM-RC1716-MSGMCH3203 QUERY FAILS WITH

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770999
APAR Fixed..........................View details for APAR MA41545
Superseded by:......................View fix details for PTF MF68054
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C2115710


IBM 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, 2020 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"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG15V","label":"PTF Cover Letters - IBM i General"},"Component":"5770999","Edition":""},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1"},"Component":"5770999","Edition":""}]

Document Information

Modified date:
01 December 2020