PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-F/DBPMTRAP-MSGMCH3203 QRYDFN FAILS W/ MCH3203 F
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
CO 5770999 V7R3M0 MF63746 00/00 0000
CO 5770999 V7R3M0 MF62912 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
-----------------------------------------------
Query/400 qrydfn fails where a FieldProc is defined to fire
within an Alternate Field.
CORRECTION FOR APAR MA46398 :
-----------------------------
Customer had a Query/400 defined over views one of which used a
column value with a field procedure defined over that column for
encoding and decoding purposes. That view was used in the
Query/400 in a Left Outer context The default value for
Query/400 or any Native query request for a column is not NULL
(as in SQL) but the column default value which is then provided
to the field procedure. This default value per a field
procedure call was being invoked on a SQE run time node that
didn't support that type of upcall to the field procedure, so a
function check occurred. This PTF logic will move the default
upcall for alternate values when the join is to no row (left
outer) to a different node supporting the upcall.
CIRCUMVENTION FOR APAR MA46398 :
--------------------------------
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
-------------- ------------------------------------------------------------
MF62911 LIC-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-RC1720-MSGMCH3203 Outer
Summary Information
System.............................. i
Models..............................
Release............................. V7R3M0
Licensed Program.................... 5770999
APAR Fixed.......................... View details for APAR MA46398
Superseded by:...................... View fix details for PTF MF69761
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C7283730
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, 2021, 2022 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.
Was this topic helpful?
Document Information
Modified date:
18 May 2022