IBM Support

MF64711 - OSP-DB-OTHER INSERTING TO A FILE WITH A FIELD PROCEDURE MAY

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER INSERTING TO A FILE WITH A FIELD PROCEDURE MAY


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

-----------------------------------------------
Inserting to a file with multiple field procedures may not see
the field procedure called for every field and causing some of
the data to not get encoded.

CORRECTION FOR APAR MA46940 :
-----------------------------
When there are multiple field procedures, with different encoded
and/or decoded lengths, the internal structures used to build
the field procedure parameters map slightly differently.  Reused
storage from call to call, for input mapping processing (decoded
to encoded conversion) wasn't being properly initialized in
every structure, which made a source field appear to be "null",
which skips invoking the field procedure.  The processing has
been corrected.

The files with fieldprocs need additional processing to take
advantage of this fix.  After the fix is loaded, remove the
fieldprocs and add them back in.  An alternative option is to
save the file, delete the file and restore the file.

CIRCUMVENTION FOR APAR MA46940 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF64355      F/#DBXGDER-MSGMCH3601 ALTER TABLE FOR COLUMN ADDING A FIELD
   MF60238      OSP-DB-OTHER-INCORROUT QUERY/400 TO OUTF OR *PRINT PRODUCES
   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 MA46940
Superseded by:......................
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................NONE


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:
09 March 2018