IBM Support

SI67284 - OSP-MSGCPD4311 SOME SYSTEM STORED PROCEDURES WILL FAIL IN ST

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-MSGCPD4311 SOME SYSTEM STORED PROCEDURES WILL FAIL IN ST


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
CO   5770SS1  V7R2M0    SI67230   00/00    0000
CO   5770SS1  V7R2M0    SI63433   00/00    0000
CO   5770SS1  V7R2M0    SI62290   00/00    0000
CO   5770SS1  V7R2M0    SI58740   00/00    0000
CO   5770SS1  V7R2M0    SI58741   00/00    0000
CO   5770SS1  V7R2M0    SI55644   00/00    0000
CO   5770SS1  V7R2M0    SI55643   00/00    0000
DIST 5770SS1  V7R2M0    SI66171   00/00    0000
DIST 5770SS1  V7R2M0    SI63631   00/00    0000
DIST 5770SS1  V7R2M0    SI60029   00/00    0000
DIST 5770SS1  V7R2M0    SI54177   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

-----------------------------------------------
This failed for customer
STRSQL
>create variable tablename char(7) default ('myTable')
Variable TABLENAME was created in QGPL.
>CALL PROCESS_DETAILED_MONITOR('GS',1,null,null,null,
'QUSRSYS','QAUGDBPMD2','DBSYSLIB',(values tablename))

CORRECTION FOR APAR SE69082 :
-----------------------------
The problem occurs when an expression used on a CALL statement
and the total length of the parameters exceeds 32K. The problem
is fixed with this PTF.

CIRCUMVENTION FOR APAR SE69082 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI67232      OSP-DB INFRASTRUCTURE
   SI67110      OSP-DB GENERATE SQL IS GENERATING INCORRECT SQL FOR STORED P
   SI67007      SQL-CMPL-CURR-UNPRED WHEN OLD VERSION TRIGGER PROGRAMS HAVE
   SI66952      OSP-DB-QSQPREP-MSGSQL0303 when using timestamp global variab
   SI66947      OSP-DB GENERATE_SQL and SET OPTION DFTRDBCOL = *NONE
   SI66602      OSP-DB-OTHER SYSIBM/USERS WAS LOCKED BY QDBSRVXR2 AFTER PTF
   SI66519      OSP-DB Internal Maintenance
   SI66169      OSP-DB-OTHER-UNPRED MERGER STATEMENT WITH AN UPDATE OPERATIO
   SI66154      OSP-DB-OTHER-F/#CCCLAP-T/QSQRUN4-MSGMCH0601 JOB USING CCSID
   SI65912      OSP-DB Generate SQL for default permissions not correct
   SI65848      OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGSQL0204 INAV GENERATE S
   SI65790      OSP-DB INTERNAL MAINTENANCE
   SI65668      OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGMCH0601 GENERATE SQL FA
   SI65460      OSP-DB-QSQCALLSP-MSGMCH3601 when using SQL descriptor with S
   SI65452      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH1210 MSGMCH1210 F/QSQ
   SI65221      OSP-DB-OTHER-INCORROUT TRUNCATE STATEMENT NOT CLEARING RECOR
   SI65171      OSP-DB-OTHER-INCORROUT MERGE SHOULD INSERT 2 RECORDS, ONLY 1
   SI65142      OSP-DB-OTHER-F/QSYRVAUT-T/QSQPROC-MSGCPF2236 WHEN JAVA UDF S
   SI65035      OSP-DB DATETIME PRECISION SET TO MAX INSTEAD OF ACTUAL AFTER
   SI64638      OSP-DB Generate_SQL does not generate KEEP IN MEMORY YES
   SI63810      OSP-DB INTERNAL MAINTENANCE
   SI63647      OSP-DB INTERNAL MAINTENANCE
   SI63642      OSP-DB INTERNAL MAINTENANCE
   SI63630      OSP-DB-OTHER-F/QSQRUN4-MSGMCH0601 WHEN USING A QUERY DEFINED
   SI63620      OSP-DB Improve Index Advisor storage management
   SI63436      OSP-DB-OTHER-F/QSQCONN-MSGSQL0751 USING 3 PART NAME FROM A T
   SI62941      OSP-DB-INCORROUT RUNSQLSTM TARGET RELEASE INCORRECT
   SI62724      OSP-DB INTERNAL MAINTENANCE
   SI62552      OSP-DB-MSGSQL0206 Setting Global Variable to Default Value A
   SI62291      OSP-DB INTERNAL MAINTENANCE
   SI61124      OSP-DB Embedded Create trigger uses program target release
   SI58204      OSP-DB Embedded Create trigger uses program target release
   SI62165      OSP-F/QQQSRVI1-T/QQQSVRTN-MSGCPF9898 SAVE AND RESTORE OF RPG
   SI62105      OSP-DB Associate locator statement fails with variable
   SI61881      OSP-DB INTERNAL MAINTENANCE
   SI61412      OSP-DB INFRASTRUCTURE
   SI61280      OSP-DB-OTHER-INCORROUT WRONG RUSSIAN CHARACTERS AFTER AN SQL
   SI60557      OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 SQL INSERT FAILS WITH MSG
   SI60533      OSP-DB-OTHER-UNPRED EXTERNAL PROCEDURE CANNOT BE RESTORED
   SI60475      OSP-DB-MSGMCH3601 External Procedure Call with Basic Default
   SI60317      OSP-DB THREAD_ID same for entire job
   SI60161      OSP-DB-OTHER-UNPRED EXTERNAL PROCEDURE CANNOT BE RESTORED
   SI60062      OSP-DB-OTHER-MSGSQL0723 TRIGGER FIRE SQL0723 THE VALUE OF PA
   SI59990      OSP-DB Add PROCESS_ID and THREAD_ID global variables
   SI60025      OSP-DB-OTHER-PERFM QDBSRVxx JOBS SLOWED BY NATIVE OPENS
   SI59850      OSP-DB-QSQCALLSP-MSGMCH3601 Calling stored procedure using d
   SI59850      OSP-DB Describe Parameter Marker incorrect for CALL with nam
   SI59531      OSP-DB Add PROCESS_ID and THREAD_ID global variables
   SI59304      OSP-DB-F/QSQROUTS-MSGSQ20226 Looping on SQ20226 when running
   SI59303      OSP-MSGSQL0204 ASSOCIATE LOCATOR STATEMENT FAILS WITH MSGSQL
   SI58948      OSP-DB-SQL Support optionally clearing SQLSTATE on truncatio
   SI58739      OSP-DB INFRASTRUCTURE
   SI58276      OSP-DB Internal Maintenance
   SI58152      OSP-DB-MSGSQL0482 not returned on remote procedure
   SI58081      OSP-DB Internal Maintenance
   SI58060      OSP-DB-OTHER-MSGSQL0011 QSQGNDDL PROBLEM WITH WRAPPED COMMEN
   SI57904      OSP-DB-OTHER-T/QSQRUN4-MSGMCH0601 MODULE QSQCALLSP PROCEDURE
   SI57810      OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGMCH1210 ON A CREATE PROC
   SI57524      OSP-DB-JRN-INCORROUT NO AUDIT JOURNAL ENTRY FOR CREATE OR RE
   SI57455      OSP-DB incorrect output with truncate table
   SI57394      OSP-DB-OTHER-THREADS-UNPRED RDB() SHOWS BLANK FOR AN RPG PGM
   SI57081      OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
   SI56938      OSP-DB Internal Maintenance
   SI56758      OSP-DB CPYFRMIMPF CAN RUN SLOW IF OVRDBF IS USED.
   SI56719      OSP-DB Internal Maintenance
   SI56667      OSP-DB Update SYSTRIGGERS to correct REMARKS column
   SI56314      OSP-DB QUERY OF INVALID SQL FIELD DELAYS IN DNS LOOKUP FOR G
   SI56135      OSP-DB Extend QSQPRCED() to include some QAQQINI options
   SI56025      OSP-DB-OTHER-LOOP-T/QSQCMTSP-MSGMCH0601
   SI55997      OSP-DB-OTHER-F/QDBCRTFI-T/QSQCRTT-MSGCPF3204 DECLARE GLOBAL
   SI55642      OSP-DB DNS LOOKUP DELAY FOR SQL CONNECT
   SI55635      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 RUNSQLSTM FAILS
   SI55609      OSP-DB-OTHER-UNPRED AUDIT JOURNAL ENTRY FROM COMMENT ON FOR
   SI55397      OSP-DB Improve LOB locator performance during commit or roll
   SI55298      OSP-DB-INCORROUT-MSGMCH3601 QSQGNDDL GENERATE_SQL procedure
   SI55282      OSP-DB Internal Maintenance
   SI55221      OSP-DB Internal Maintenance
   SI55167      OSP-DB-OTHER-RC2-MSGSQL7049
   SI55113      OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
   SI55050      OSP-DB-MSGMCH3402-F/QSQFETCH ARRAY RESULT SET CURSOR FETCH F
   SI54968      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI54719      OSP-DB Internal Maintenance
   SI54718      OSP-DB INTERNAL MAINTENANCE
   SI54680      OSP-DB INTERNAL MAINTENANCE
   SI54624      OSP-DB-OTHER-T/QSQRUN4-MSGMCH1210 MODULE QSQMERGE
   SI54395      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI54330      OSP-DB-MSGSQL1506 Generate SQL of a DDS file
   SI54320      OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN3-MSGCPI431B A MSGCPI431B MAY
   SI54317      OSP-DB-MSGSQL0901-F/QSQTRNOWN TRANSFER OWNERSHIP FAILURE WIT
   SI54181      OSP-DB-MSGMCH3402-F/QSQSETUP SQL PGM/SRVPGM IN QTEMP QRWTSRV
   SI54123      OSP-DB INTERNAL MAINTENANCE
   SI54113      OSP COMMENT ON FOR STORED PROCEDURE CAUSES A SYSROUTINE SYNC
   SI54112      OSP-DB-OTHER-F/QDBSIGEX-T/QSQPROCR-MSGCPF5009 MSGCPF5009 MSG
   SI54044      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI53985      OSP-DB CREATE OR REPLACE sourced function not replacing corr
   SI53913      OSP-DB ADD LOCK TABLE SUPPORT MULTIPLE MEMBER FILES
   SI53862      OSP-DB INTERNAL MAINTENANCE
   SI53709      OSP-DB SQL procedure parameter DEFAULT value in SYSPARMS mis
   SI53694      OSP-DB DBMON 1000 QVC1C EXPLAINABLE INCORRECT SET FOR SP PRE
   SI53632      OSP-DB-MSGSQL0435 sent for a SIGNAL statement with a warning
   SI53613      OSP-DB-MSGMCH3601-F/QQQSRVE1-T/QQQSRVE1 GLOBAL VAR FAIL ON V
   SI53553      OSP-DB-MSGSQL0901 Calling procedure by program name when par
   SI53375      OSP-DB Internal Maintenance
   SI53250      OSP-DB INTERNAL MAINTENANCE
   SI53222      OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-MSGCPD4373 A MSGCPD4373 MA
   SI53141      OSP-DB Internal Maintenance
   SI53112      OSP-DB INTERNAL MAINTENANCE
   SI53068      OSP-DBMSGSQL0313-F/QSQRUN4 NULL SQL ARRAY VAR PROC OUTPUT FA
   SI52974      OSP-DB-F/QSQVARSERV-MSGMCH3601 CPYF of table that uses row a
   SI52900      OSP-DB Internal maintenance
   SI52889      OSP-DB Internal Maintenance
   SI52841      OSP-F/QSQRUN4-T/QSQRUN4-MSGMCH1210 SIGNAL STATEMENT TRIGGER
   SI52830      OSP-DB-OTHER-INCORROUT GENERATE SQL TRANSLATING '/' TO '.'
   SI52830      OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGMCH1210 MSGMCH1210 F/QZ
   SI52797      OSP-DB-SQL Dynamic Compound Statement Support
   SI52682      OSP-DB-MSGSQL0423 running a SQL routine that has LOBs
   SI52609      OSP-DB INTERNAL MAINTENANCE
   SI52538      OSP-DB-OTHER-T/QSQPROC-MSGSQL0913 DROPPING A SQL PROCEDURE
   SI52538      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH3601 A MSGMCH3601 F/Q
   SI52509      OSP-DB CPF4101 SYSROUTINE NOT FOUND DURING CRTDUPOBJ
   SI52463      OSP-DB INTERNAL MAINTENANCE
   SI52463      OSP-DB SQL0180 Calling RPG External Stored Procedure
   SI52341      OSP-DB-OTHER-T/QSQRUN4X/19306-MSGSQL0204 WITH OVRDBF, MERGE
   SI52341      OSP-DB QIBM_SQL_NO_CATALOG_UPDATE should include Rename Libr
   SI52341      OSP-DB-OTHER-T/QSQROUTX-MSGMCH0602
   SI52269      OSP-DB INTERNAL MAINTENANCE
   SI52269      OSP-DB-OTHER-MSGSQL0443 SERVICEABILITY ENHANCEMENT
   SI52192      OSP-DB INTERNAL MAINTENANCE
   SI52015      OSP-DB-MSGSQL0150 Running TRUNCATE against a SQL catalog tab
   SI52013      OSP-DB INTERNAL MAINTENANCE
   SI51983      OSP-DB Internal Maintenance
   SI51925      OSP-DB Internal Maintenance
   SI51909      OSP-DB INTERNAL MAINTENANCE
   SI51889      OSP-DB INTERNAL MAINTENANCE
   SI51823      OSP-DB-OTHER-MSGCPF5129-T/QSQRUN4 MODULE QSQMERGE
   SI51823      OSP-DB Internal Maintenance
   SI51756      OSP-DB Internal Maintenance
   SI51756      OSP-DB-OTHER-INCORROUT truncating alias
   SI51688      OSP-DB Generate SQL for EVI index with include columns not c
   SI51688      OSP-UNPRED CRTDUPOBJ AND MOVOBJ OF PROGRAM REMOVES CATALOG R
   SI51628      OSP-DB-OTHER-LOOP QSQAPIS/sqludf_create_locator
   SI51595      OSP-DB Internal Maintenance
   SI51530      OSP-DB Incremental Enhancement
   SI51473      OSP-DB Internal Maintenance
   SI51449      OSP-DB-MSGSQL0901-F/QSQGTSPC using LOBs in sql procedure
   SI51431      OSP-DB-MSGSQL0901-F/QSQGTSPC using LOBs in sql procedure
   SI51381      OSP-DB Internal Maintenance
   SI51364      OSP-DB-OTHER-UNPRED SYSTEM SQL APPEARS IN STRDBMON WHEN INCS
   SI51364      OSP-DB-OTHER-LOOP QSQRUN4/QSQCALLSP/MAP_WITH_CCSIDS
   SI51283      OSP-DB Internal Maintenance
   SI51236      OSP-DB-OTHER-MSGSQL0206 global variable is not found on the
   SI51236      OSP-DB-OTHER-INCORROUT SETOPTION does not work with paramete
   SI51236      OSP-DB Internal Maintenance
   SI51236      OSP-DB Support compatible date/time strings in input arrays
   SI51463      OSP-DB INTERNAL MAINTENANCE

Summary Information

System..............................  i
Models..............................  
Release.............................  V7R2M0
Licensed Program....................  5770SS1
APAR Fixed..........................  View details for APAR SE69082
Superseded by:......................  View fix details for PTF SI85799
Recompile...........................  N
Library.............................  QSYS
MRI Feature ........................  NONE
Cum Level...........................  C8249720


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, 2021, 2022, 2023, 2024 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":"BU058","label":"IBM Infrastructure w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0","Product":{"code":"SWG60","label":"IBM i"},"Component":"5770SS1","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
12 March 2024