IBM Support

SI46457 - F/QDBSIGEX-MSGCPF4160 LABEL ON/COMMENT ON CAUSING FIELDPROC

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

F/QDBSIGEX-MSGCPF4160 LABEL ON/COMMENT ON CAUSING FIELDPROC


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI46695   00/00    0000
PRE  5770SS1  710  SI38411   00/00    0000
PRE  5770SS1  710  SI37443   00/00    0000
CO   5770SS1  710  SI46299   00/00    0000
CO   5770SS1  710  SI44268   00/00    0000
CO   5770SS1  710  SI44269   00/00    0000
DIST 5770SS1  710  SI44619   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

-----------------------------------------------
Customer has a file with a FIELDPROC column referencing a
program that is used for encryption. When customer issues the
LABEL ON COLUMN statement against the file, it appears to work,
but subsequent queries are failing because the FIELDPROC for the
column has been overwritten, and the program isn't found. It
generates msgSQL0204 for the query, and a msgCPF4160 for DSPPFM.

CORRECTION FOR APAR SE51574 :
-----------------------------
When the column label information for a field was changed, the
field procedure information for that field was lost.

The field procedure information will be preserved after the
LABEL ON COLUMN statement completes.

CIRCUMVENTION FOR APAR SE51574 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI46018      OSP-DB-OTHER-INCORROUT FOREIGN KEY IS NOT IN CHECK PENDING S
   SI46018      OSP-DB SQL0901 CREATE OR REPLACE view failure
   SI46018      OSP-DB SQL DELETE FROM statement without WHERE clause using
   SI46018      OSP-DB MSGMCH1210 F/QDBCHGFI T/QDBCHGFI ALTER TABLE
   SI44974      OSP-DB SQL0901 F/QSQCRTV Reason/4408 - Create or Replace Vie
   SI44655      OSP-DB-UNPRED Adding or changing the long name may corrupt a
   SI44620      OSP-DB msgCPF4204 t/ SYSBAS_XREF_CHG_CCSID using QDBCXRC api
   SI44603      OSP-DB-JRN-UNPRED NO JOURNAL ENTRIES ARE GENERATED WHEN THE
   SI44538      OSP-DB-OTHER-INCORROUT AN INDEX OVER A PARTITIONED TABLE MAY
   SI44284      OSP-DB-OTHER-F/QSQCRTV-T/QSQCRTV-MSGSQL0901 CREATE REPLACE O
   SI44266      OSP-OTHER-F/QDBCRTFI-T/QLICRDUP-MSGCPF327E CRTDUPOBJ INTO EM
   SI44153      OSP-DB ALTER TABLE performance improvement
   SI43236      OSP-DB HUNG JOBS WITH A DAMAGED MACHINE INDEX
   SI43109      OSP-DB-UNPRED Problems with renaming the long name of a file
   SI42904      OSP-DB CHGLF UNIT parm not using SSD storage
   SI42786      OSP-DB-OTHER-F/QDBCHGFI-T/QDBXXREFSP-MSGCPF2958 QADBIFLD DEL
   SI42699      OSP-DB-OTHER-RC8-MSGCPD32CC MSGCPD32CC RC/8 USING THE QDBRPL
   SI42699      OSP-DB Internal Maintenance
   SI42640      OSP-DB 7.1 upgrade MCH1210 f/ QQQQUERY t/ QQQQUERY or CPF989
   SI42555      OSP-DB-OTHER-MSGCPF325E MSGCPF325E
   SI42555      OSP-DB CALL QDBCXRC Failure results in CCSIDS of 66535 for Q
   SI41611      OSP-DB MCH3406 f/#dbdds t/QDBDLTFI dropping a partitioned ta
   SI41896      OSP-DB-OTHER-F/QDBCHGFI-T/QDBCHGFI-MSGCPF9898 JOB FAILS WITH
   SI41265      OSP-DB Internal Maintenance
   SI41119      OSP-DB Incremental Enhancement
   SI41013      OSP-DB-OTHER-INCORROUT CHGLF UNIT(*SSD) DOES NOT CHANGE THE
   SI40655      OSP-DB Internal Maintenance
   SI40535      OSP-DB Directory locking improvements
   SI40488      OSP-DB Incremental Enhancement
   SI40348      OSP-DB Internal Maintenance
   SI40031      OSP-DB MCH3402 f/QDBCHGFI t/QDBCHGFI CRT_NEW_FILE dropping f
   SI40008      OSP-DB ALTER COLUMN TO CHANGE THEIR DB FROM EBCDIC TO UTF16
   SI39751      OSP-DB A FAST DELETE THAT FAILS LEAVES JOURNAL ENTRIES JM AN
   SI39584      OSP-DB-OTHER-F/QSQRUN3-MSGSQL0913 ON DELETE OF ALL THE RECOR
   SI39584      OSP-DB-OTHER-F/QDBDLTFI-T/QSQALTER-MSGCPF3219 CASCADING DROP
   SI39539      OSP-Reduce contention between concurrent ALTER TABLEs
   SI39091      OSP-DB-OTHER-QDBCHGFI Constraint not in check pending after
   SI38877      OSP-DB-OTHER-QDBCHGFI Changes
   SI38680      OSP-DB-OTHER-QDBCHGFI SQL0901 from QSQALTER partitioning a t
   SI38668      OSP-DB-OTHER-THREADS-INCORROUT CONSTRAINT DOESNT GO INTO CHE
   SI38668      OSP-DB-OTHER-F/QDBCHGFI-T/QDBCHGFI-MSGMCH1210 RENAME INDEX F
   SI38668      OSP-T/QDBSIZFI-MSGMCH3402 MQT BECOMES CORRUPTED AFTER CRTDUP
   SI38485      OSP-DB Internal Maintenance
   SI38413      OSP-DB Incremental Enhancement
   SI37514      OSP-DB-OTHER-SAP400-UNPRED AFTER AN ALTER TABLE PRIMARY CONS
   SI37493      OSP CHGPF CAN HANG
   SI37448      OSP-DB Internal Maintenance
   SI36657      OSP-DB Incremental Enhancement
   SI36457      OSP-DB Internal Maintenance

Summary Information

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


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"},"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:
11 May 2012