PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER SQL PRECOMPILE LISTING MISSING CCSID VALUE
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
PRE 5770SS1 V7R2M0 SI66066 00/00 0000
PRE 5770SS1 V7R2M0 SI64019 00/00 0000
PRE 5770SS1 V7R2M0 SI63641 00/00 0000
PRE 5770SS1 V7R2M0 SI63642 00/00 0000
PRE 5770SS1 V7R2M0 SI62150 00/00 0000
PRE 5770SS1 V7R2M0 SI60046 00/00 0000
CO 5770SS1 V7R2M0 SI67246 00/00 0000
CO 5770SS1 V7R2M0 SI66945 00/00 0000
CO 5770SS1 V7R2M0 SI66536 00/00 0000
CO 5770SS1 V7R2M0 SI65783 00/00 0000
CO 5770SS1 V7R2M0 SI63693 00/00 0000
CO 5770SS1 V7R2M0 SI58742 00/00 0000
CO 5770SS1 V7R2M0 SI58027 00/00 0000
CO 5770SS1 V7R2M0 SI57835 00/00 0000
CO 5770SS1 V7R2M0 SI54400 00/00 0000
DIST 5770ST1 V7R2M0 SI57912 NONE 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
-----------------------------------------------
When one of the SQL precompilers (CRTSQLCBL, CRTSQLCBLI,
CRTSQLCI, CRTSQLCPPI, CRTSQLPLI, CRTSQLRPG, or CRTSQLRPGI
command) generates a cross reference listing, the CCSID value
for file reference variables may be missing.
Any SQL variable which has a CCSID value different than the job
CCSID should have that CCSID identified in the listing. The
file reference variables BLOB_FILE, CLOB_FILE, DBCLOB_FILE,
XML_BLOB_FILE, XML_CLOB_FILE, XML_DBCLOB_FILE never show a CCSID
value. The SQL variable is defined correctly but the
information is not shown in the listing.
CORRECTION FOR APAR SE69255 :
-----------------------------
The SQL precompilers (CRTSQLCBL, CRTSQLCBLI, CRTSQLCI,
CRTSQLCPPI, CRTSQLPLI, CRTSQLRPG, or CRTSQLRPGI command) will be
modified to correctly show CCSID values for file reference
variables. The CCSID value will only be shown if it is
different than the job CCSID.
CIRCUMVENTION FOR APAR SE69255 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI67481 OSP-DB-MSGCPD4311 external procedure with long parameters wi
SI67286 OSP-DB-OTHER-F/QSQRCHKX/26368-MSGMCH3601 UPDATE STATEMENT FA
SI67245 OSP-DB-PERFM SQL ROUTINE PERFORMANCE
SI66980 OSP-DB-OTHER-MSGSQL7032 RUNSQLSTM CCSID 290, 930, OR 5026 PR
SI66955 OSP-DB CREATE TABLE with hex string default using *STD optio
SI66946 OSP-DB INFRASTRUCTURE
SI66516 OSP-DB-OTHER-F/QDBIOERRQOX/4194-T/QSQRUN2X/20780-MSGCPF5387
SI66485 OSP-DB-OTHER SQL STATEMENT USING A COLUMN OR AGGREGATE FUNCT
SI66485 OSP DESCRIBE OF PARAMETER DATA INCORRECT WHEN TABLE HAS COLU
SI66182 OSP-DB-INCORROUT-MSGSQL0502 WITHIN PIPELINED TABLE FUNCTION
SI66182 OSP-DB-OTHER-INCORROUT WRONG COLUMN NAME USED FOR VIEW WHEN
SI66182 OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 CRTSQLCBLI OPTIO
SI66177 OSP-DB-OTHER-INCORROUT MERGE ON VIEW WITH INSTEAD OF TRIGGER
SI65871 OSP-DB INTERNAL MAINTENANCE
SI65847 OSP-DB INTERNAL MAINTENANCE
SI65811 OSP-DB INTERNAL MAINTENANCE
SI65780 OSP-DB INTERNAL MAINTENANCE
SI65717 OSP-DB INTERNAL MAINTENANCE
SI65359 OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4302 MSGCPF4302 F/QQQ
SI65287 OSP-DB Teraspace memory leak when multiple derived tables in
SI65079 SQL-RUN-PERFM CRTSQLCI/CRTSQLCPPI PERFORMANCE
SI64717 OSP-DB-OTHER-T/QSQINS-MSGSQL0203 INSERT STATEMENT FAILS WITH
SI64451 OSP-DB-OTHER-MSGSQL0326 JOBS SEEING SQL0326 IN APPLICATION J
SI64409 OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 MCH1210 F/QSQRCH
SI64355 OSP-DB-OTHER-F/QSQRCHK-MSGMCH1210 WHEN RECURSIVE COMMON TABL
SI64355 OSP-DB-F/QSQRCHK-MSGMCH1210 when returning a SQL0390 process
SI64304 OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGSQL0205 MSGSQL0205 F/Q
SI64193 OSP-DB INTERNAL MAINTENANCE
SI64193 OSP-DB-OTHER-T/QSINS-MSGSQL0203 INSERT STATEMENT FAILS WITH
SI64051 OSP-DB INTERNAL MAINTENANCE
SI64051 OSP-DB Internal Maintenance
SI63898 OSP-DB-OTHER-F/QSQPLIST-T/QSQPLIST-MSGMCH3601 RUNSQLSTM
SI63874 OSP-DB Correct FULL OUTER JOIN implementation
SI63835 OSP-DB INTERNAL MAINTENANCE
SI63763 OS-DB-OTHER Fix handling of partition table range boundary v
SI63696 OSP-DB INTERNAL MAINTENANCE
SI63635 OSP-DB INTERNAL MAINTENANCE
SI63497 OSP-DB Addition of LTRIM / RTRIM Function Support
SI63377 OSP-DB Internal Maintenance
SI63230 OSP-DB Do not issue SQL7901 for create package
SI63137 OSP-DB-OTHER-RC2-MSGSQL0101 SQL COMPLEX SQL0101 RC2
SI62774 OSP-DB INTERNAL MAINTENANCE
SI62653 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0204 REMOTE THREE PAR
SI62629 OSP-DB INTERNAL MAINTENANCE
SI62588 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0205 COLUMN NAME NOT
SI62582 OSP-DB INTERNAL MAINTENANCE
SI62526 OSP-DB-OTHER-F/QQDAPROC-T/QQDAPROC-MSGMCH3602 ON SOME CRTSQL
SI62526 OSP-DB INFRASTRUCTURE
SI62508 OSP-DB INTERNAL MAINTENANCE
SI62299 OSP-DB INTERNAL MAINTENANCE
SI62154 OSP-DB INFRASTRUCTURE
SI61997 OSP-DB Internal Maintenance
SI61896 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0204 SQL0204 F/QSQRUN
SI61880 OSP-DB INTERNAL MAINTENANCE
SI61321 OSP-DB SQL0171 when using VARGRAPHIC type with INSTR() or LO
SI61195 OSP-DB-OTHER-T/QSQSCHEM-MSGCPD0018 RUNSQLSTM PROBLEM WITH CL
SI60800 OSP-DB-OTHER-T/QSQPMAIN-MSGCPF9999 FROM CRTSRCPF/CHGSRCPF/AD
SI60800 SQL-CMPL-CURR ALLOW COMPILEOPT('OPTION(*EVENTF)') ON SQL PRE
SI60800 OSP-DB INTERNAL MAINTENANCE
SI60793 OSP-DB-F/QSQINS-MSGMCH3402 DLTF on table with row and column
SI60592 OSP-DB INFRASTRUCTURE
SI60558 OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 SQL INSERT FAILS WITH MSG
SI60423 OSP-DB-OTHER BETTER SQL IDENTIFIER NAMES
SI60322 OSP-DB-MSGMSG0601 T/QQQFVMT Proc/MAP using lateral correlati
SI60310 OSP-DB Internal Maintenance
SI60263 OSP-DB-OTHER-INCORROUT QDT is not rebuilt when SELECT * and
SI60187 OSP-DB-OTHER-MSGSQL0053 RUNSQLSTM PROBLEM WITH UNICODE CCSID
SI60142 OSP-DB-INCORROUT INLINED SQL FUNCTION
SI60141 OSP-DB-MSGMCH3601-QSQPROC RUNSQL of compound dynamic stateme
SI60052 OSP-DB INTERNAL MAINTENANCE
SI60039 SQL-CMPL-CURR-T/QSQPRUN-MSGSQL8016 SQL PRECOMPILE
SI59967 OSP-PERFM SQL INSERT SLOW AFTER A FAILED ALTER TABLE
SI59737 OSP-DB Internal Maintenance
SI59608 OSP-DB INFRASTRUCTURE
SI59449 OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-RC21-MSGCPD4374 UPDATING X
SI59414 OSP-DB INFRASTRUCTURE
SI59348 OSP-DB INTERNAL MAINTENANCE
SI59311 OSP-DB-OTHER-MSGSQL0900 AFTER CRTSQLCI to REMOTE RDB
SI59123 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-RC2-MSGSQL0101 SQL RPG OBJE
SI59063 OSP-DB INFRASTRUCTURE
SI58991 OSP-DB INTERNAL MAINTENANCE
SI58975 OSP-DB OFFSET clause changes for internal processing
SI58951 OSP-DB INTERNAL MAINTENANCE
SI58909 OSP-DB Internal Maintenance
SI58909 OSP-DB Internal Maintenance
SI58907 OSP-DB INFRASTRUCTURE
SI58804 OSP-DB-OTHER-F/QSQPLIST-T/QSQPLIST-MSGMCH3402 ALTER TABLE FR
SI58740 OSP-DB INFRASTRUCTURE
SI58101 OSP-DB INTERNAL MAINTENANCE
SI58101 OSP-DB-OTHER-PERFM EXTRA CONNECTION DONE WITH 3-PART NAMING
SI58062 OSP-DB-INCORROUT SQL ROUTINE CONDITION HANDLER NOT ACTIVATED
SI58026 OSP-DB Internal Maintenance
SI57930 OSP-DB-MSGSQL0206 when column not defined at precompile time
SI57911 OSP-DB INTERNAL MAINTENANCE
SI52755 SQL-CMPL-CURR CRTSQLRPGI FAILS WHEN COMPILING LARGE SOURCE F
SI57897 OSP-DB-MSGSQL0150 Unable to use XMLTABLE and a view in a tem
SI57834 OSP-DB-OTHER-F/QLIDLOBJ-T/QSQDDDL1-MSGCPC2191 QGENOBJNAM DAT
SI57749 OSP-DB-OTHER-MSGSQL0104 RUNSQLSTM PROBLEM WITH TRIMMED RECOR
SI57567 OSP-DB-OTHER-MSGSQL0104 RUNSQLSTM PROBLEM WITH TRIMMED RECOR
SI57533 OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN1-MSGCPD4324 MSGCPD4324 F/QQQ
SI57533 OSP-DB-OTHER-F/QQQVFMT-T/QSQRCHK-MSGCPF4278 SQL STORED PROCE
SI56946 OSP-DB Internal Maintenance
SI56940 OSP-DB Internal Maintenance
SI56794 OSP-DB Update SYSTRIGGERS to correct REMARKS column
SI56757 OSP-DB CPYFRMIMPF CAN RUN SLOW IF OVRDBF IS USED.
SI56720 OSP-DB Internal Maintenance
SI56633 OSP-DB-PERFM SQL ROUTINE GRAPHIC/VARGRAPHIC PERFORMANCE
SI56593 SQL-CMPL-INCORROUT TRIGGER EVENT PREDICATE OF A MULTIPLE EVE
SI56348 OSP-DB Formatting for SQL routine text lost using RUNSQLSTM
SI56323 OSP-DB INTERNAL MAINTENANCE
SI56253 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-RC2-MSGSQL0101 SQL MERGE ST
SI56253 OSP-DB INTERNAL MAINTENANCE
SI56136 OSP-DB Extend QSQPRCED() to include some QAQQINI options
SI56125 OSP-DB INTERNAL MAINTENANCE
SI55931 SQL-CMPL-INCORROUT DEBUGGER ARRAY TYPE VARIABLES
SI55612 OSP-DB Internal Maintenance
SI55601 OSP-DB Internal Maintenance
SI55601 OSP-DB-F/QSQRCHK-MSGMCH0601 when there are a large number of
SI55601 OSP-DB CREATE TABLE with range partition starting value grea
SI55601 OSP-DB-OTHER-T/QSQRUN4X/42011-MSGSQL0204 SQL0204 ISSUED WHEN
SI55601 OSP-DB-OTHER-INCORROUT NO MSGSQL0206 AT COMPILE WHEN SQL_GVA
SI55588 OSP-DB-OTHER-F/QDBCRTFI-T/QSQCRTT-MSGCPF3204
SI55495 OSP-F/QSQDDL1-T/QSQDDL1-MSGMCH1210 RUNSQLSTM FAILS WITH MCH1
SI55455 OSP-DB-OTHER-F/QSQPARSP-T/QSQPARSP-MSGMCH0601 DBGVIEW *SOURC
SI55430 SQL-CMPL-CURR-INCORROUT CORRECT DATE/TIME/TIMESTAMP HOST VAR
SI55290 OSP-DB-MSGMCH3601-T/QSQRCHK using array variables
SI55283 OSP-DB Internal Maintenance
SI55222 OSP-DB Internal Maintenance
SI54999 OSP-DB INTERNAL MAINTENANCE
SI54868 OSP-DB-OTHER-UNPRED UPDATING A TABLE WITH BOTH A NULLABLE FI
SI54866 SQL-CMPL DEBUGGER SUPPORT FOR SQL VARIABLES WITHIN SQL ROUTI
SI54746 OSP-DB Internal Maintenance
SI54683 OSP-DB INTERNAL MAINTENANCE
SI54606 OSP-DB Internal Maintenance
SI54555 OSP-DB INTERNAL MAINTENANCE
SI54520 QRY-QRYRUN-THREADS-MSGCPD4302 IN DEFINE RESULT FIELDS CPD430
SI54070 OSP-DB Internal Maintenance
SI53986 OSP-DB RUNSQL sends duplicate messages to joblog
SI53912 OSP-DB ADD LOCK TABLE SUPPORT MULTIPLE MEMBER FILES
SI53690 OSP-DB-MSGCPD4324 QQQVSEL Global variable and NOT IN predica
SI53646 OSP-DB RUNSQL not writing error to joblog with *LIST option
SI53618 OSP-DB-MSGSQL5001 when using a global variable in a DISTINCT
SI53547 OSP-DB-MSGSQL0901 invoking function LPAD with parameter 1 va
SI53502 OSP-DB INTERNAL MAINTENANCE
SI53481 OSP-DB INTERNAL MAINTENANCE
SI53428 OSP-DB-MSGSQL0901 ALTER TABLE ALTER PARTITION on a table wit
SI53428 OSP-DB-MSGSQL0312 INCORRECT ERROR MESSAGE
SI53428 OSP-DB-MSGSQL0901 ALTER TABLE ALTER PARTITION on a table wit
SI53425 OSP-DB INTERNAL MAINTENANCE
SI53405 OSP-DB Add option for listing to RUNSQL command
SI53293 OSP-DB-MSGSQL9001 SQL PRECOMPILE FAILS WITH SQL0122 WHEN USI
SI53214 SQL-CMPL-MSGSQL7032 SQL ROUTINE FAILS TO CREATE
SI53146 OSP-DB Serviceability Enhancement for SQL
SI53071 OSP-DB Internal maintenance
SI52897 OSP-DB-OTHER-UNPRED A CREATE OF A MATERIALIZED QUERY TABLE M
SI52831 OSP-DB CREATE TABLE with range partition starting value less
SI52818 OSP-DB Internal Maintenance
SI52789 SQL-CMPL-MSGSQL7032 SQL ROUTINE FAILS TO CREATE
SI52745 OSP-DB-OTHER-INCORROUT THE COLUMN NAME OF A GLOBAL VAR WITH
SI52745 OSP-F/QSQRCHK-T/QSQRCHK-MSGMCH0601 A CALL TO A STORED PROCED
SI52745 OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 CRTSQLCBLI FAILS
SI52685 OSP-DB UNABLE TO USE GENERATE SQL WITH PARTITIONED TABLE IF
SI52604 OSP-DB-MSGSQL0338 with implied parentheses in join order
SI52458 OSP-DB Internal maintainence
SI52344 OSP-DB INTERNAL MAINTENANCE
SI52271 OSP-DB INTERNAL MAINTENANCE
SI52193 OSP-DB Column name for global variable with long AS name
SI52016 OSP-DB-MSGSQL0156 TRUNCATE sends wrong message for an index
SI51984 OSP-DB INTERNAL MAINTENANCE
SI51927 OSP-DB INTERNAL MAINTENANCE
SI51755 OSP-DB Internal Maintenance
SI51682 OSP-DB INTERNAL MAINTENANCE
SI51529 OSP-DB Incremental Enhancement
SI51461 OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 CRTSQLCBLI FAILS
SI51282 OSP-DB Internal Maintenance
SI51241 OSP-DB Internal Maintenance
SI55089 SQL-CMPL-CURR-INCORROUT SQL PRECOMPILER CODE GENERATION
Summary Information
System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE69255
Superseded by:...................... View fix details for PTF SI85721
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C8249720
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.
Was this topic helpful?
Document Information
Modified date:
12 March 2024