IBM Support

MF60238 - OSP-DB-OTHER-INCORROUT QUERY/400 TO OUTF OR *PRINT PRODUCES

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT QUERY/400 TO OUTF OR *PRINT PRODUCES


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF58834   00/00    0000
CO   5770999  710  MF54634   00/00    0000
CO   5770999  710  MF52350   00/00    0000
CO   5770999  710  MF51165   00/00    0000
CO   5770999  710  MF49764   00/00    0000
DIST 5770SS1  710  SI50740   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 '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 Query/400 report is sent to OUTF or *PRINT but no records are
returned, if the report is returned to the display then many
records are shown.

Whilst running the different reports it was noted that the 0
return runs were using a HASH join, whereas the working does
not.

CORRECTION FOR APAR MA44659 :
-----------------------------
The genned code (for function MAX) will be changed to unsigned
arithmetic. This will fix the problem.

CIRCUMVENTION FOR APAR MA44659 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF MF51964 :
=================================================

After loading the PTF, existing physical and logical files that have a
Field Procedure (fielproc) should be saved, deleted & restored.  This
is to recreate the generated mapping code in the "cursor" MI object.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF60179      LIC-DB Allow UTF-16 casing map
   MF60073      OSP-DB internal support for field procedures
   MF58835      LIC-OTHER-THREADS-INCORROUT IMPROVE TIMING WINDOW SO THAT QW
   MF58316      LIC-OTHER-THREADS-INCORROUT IMPROVE TIMING WINDOW SO THAT QW
   MF57368      OSP Database Field Procedure Enhancements
   MF56718      OSP-MSGCPD32D7 AN ALTER ON A COLUMN OF TYPE DATE FAILS WHEN
   MF54635      OSP-DB FieldProc Enhancements
   MF53509      LIC-DB-F/DBMAP2FL-T/QDBPUT-MSGMCH3203 MCH3203 F/DBMAP2FL-T/Q
   MF51964      OSP-DB-OTHER-LOOP AFTER A FIELDPROC WAS REGISTERED AND ACTIV
   MF51142      LIC-DB-THREADS-PERFM Extra field procedure threads created d
   MF50697      LIC-DB-MSGMCH3203 CQE function check with field procedures
   MF50414      LIC-DB Incorrect field procedure output for variable length
   MF50171      LIC-DB-F/#DBGETAX-T/QDBPUT-MSGMCH3203 Problem inserting VL d
   MF50114      LIC-DB-F/QDBSIGEX-T/QSQRUN-MSGCPF5029 Data mapping error on
   MF50046      OSP FieldProc native reads of Variable Length fields
   MF49992      OSP-MSGMCH0601 F/T:QDBGETM/QDBGETM when file has FieldProc (
   MF49879      LIC-DB-INCORROUT Alter Table statement fails during Set Fiel
   MF49756      LIC-DB-OTHER-F/QQQSVRTN -T/QQQSVRTN-MSGMCH3601 Fieldproc and
   MF49527      LIC-DB-OTHER MCH5003 on insert LOB value
   MF49490      LIC-DB-OTHER Fieldproc encoding of CLOB results in function
   MF49334      LIC-DB-OTHER Field procedures could fail for variable length
   MF49255      LIC-DB-OTHER Date/Time fix for field procedures
   MF49034      LIC-DB-OTHER Internal maintenance option for journal
   MF48761      LIC-DB-OTHER Field procedure fixes for date/time/timestamp
   MF48148      OSP-Database DBMP Fixes
   MF48108      LIC-DB Fix decimal float round operation to use proper round
   MF48069      OSP-Database DBMP Fixes
   MF47912      OSP-Database DBMP Fixes
   MF56702      LIC-DB-OTHER-UNPRED 0400 1967 VLOGs generated by RmtmRequest
   MF49752      LIC-DB-OTHER-F/QQQSVRTN -T/QQQSVRTN-MSGMCH3601 Fieldproc and

Summary Information

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


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.

[{"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:
19 June 2015