PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-RC6-MSGSQL0752 SET TRANSACTION LEVEL NO COMMIT
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
CO 5770SS1 V7R3M0 SI63485 00/00 0000
CO 5770SS1 V7R3M0 SI63488 00/00 0000
DIST 5770SS1 V7R3M0 SI65456 00/00 0000
DIST 5770SS1 V7R3M0 SI64151 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
-----------------------------------------------
The sql statement after SET TRANSACTION LEVEL NO COMMIT gets
msgsql0752 rc6. Client was attempting to use 3 part naming.
CORRECTION FOR APAR SE65823 :
-----------------------------
Code will be changed to not issue the MSGSQL0752 when
"TRANSACTION LEVEL NO COMMIT" is in use.
CIRCUMVENTION FOR APAR SE65823 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI65455 F/QSQRUN2-MSGSQL0326 SQL RPG PROGRAM FAILS WITH SQL0326. SEL
SI65403 OSP-DB INTERNAL MAINTENANCE
SI65274 OSP-DB-OTHER-F/QCNSMCTL-T/QRWSQRY-MSGCPF916A CPF916A EXTRACT
SI65043 OSP-DB-MSGSQL0303 assigning NULL to varbinary
SI64994 OSP-DB-OTHER-F/QDBDLTFI-MSGMCH3406 for *SQDT00002
SI64955 OSP-DB-OTHER-F/QSQDSCPT-RC14-MSGSQL0904 OCCURS AT DEALLOCATE
SI64735 OSP-DB-PERFM Improve performance of OPEN statements in stati
SI64637 OSP-DB GRANT STATEMENT WILL FAIL WITH THE SQL0570 WHEN RUN U
SI64149 OSP-UNPRED ENDDBMON OF DBMON WITH PARM HOSTVAR(*CONDENSED) L
SI63993 OSP-DB-OTHER-PERFM OSP-DB-OTHER-PERFM
SI63867 SP/QSQDSCPT-MSGSQL0076-RC9332-MOD/QSQGETDS MSGSQL0076
SI63678 OSP-DB-OTHER-F/QQQVSEL-MSGCPD4324
SI63486 OSP-DB-OTHER-F/QSQCONN-MSGSQL0751 USING 3 PART NAME FROM A T
SI59829 OSP-DB-MSGSQL0900 IMPLICITLY CONNECT RESET FOR SQL DRDA CNN
SI63438 OSP-DB INTERNAL MAINTENANCE
SI63311 OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPF5173 CPF5173 F/QDB
SI63285 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH3601 MCH3601 MCH1210
SI63135 OSP-DB-OTHER-MSGSQL0204 USING UNQUALIFIED TABLE REFERENCE
SI63094 OSP-DB-OTHER-T/QSQRUN3-MSGSQL0901 AFTER 0200 1720 VLOG
SI62938 OSP-DB-OTHER-MSGSQL0326 SQL0326 GENERATING SQLSTATE 01557
SI62824 OSP-DB SQLSTATE 01004 not returned from table function when
SI62229 OSP-DB-MSGSQL0900 with embedded SQL after SETASPGRP
SI62126 OSP ALTER TABLE STATEMENT NOT LOGGED BY DBMON
SI61416 OSP-DB INFRASTRUCTURE
SI61304 OSP-DB-MSGSQL0331 Assignment to input parameter on routine w
SI61276 OSP-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 MSGMCH3601 T/QSQROUTE P
SI61211 OSP-DB statement aborted due to SQL warning
SI61161 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH3601 JOB THAT USE TO
SI60969 OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGMCH1210 ERROR MESSAGE
SI60963 OSP-DB incorrect output with offset clause
SI60904 OSP-DB-MSGCPF5173 QUERY WITH OFFSET AND LIMIT CLAUSES
SI60597 OSP - DB SQFCRT and SQFOVR with XML CLOB File Result in Impr
SI60312 OSP-DB FETCH FIRST with OFFSET returns next row
SI60289 OSP-DB-QSQCALLSP-MSGMCH3601 when using SQL descriptor with S
SI60209 OSP-DB-OTHER-F/QSQRUN2-MSGSQL0303 Assigning from CHAR to DAT
SI60152 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0910 FAST DELETE COMM
SI59856 OSP-DB Return subsystem name instead of server name for CURR
SI59856 OSP-DB Internal Maintenance
SI59804 OSP-DB OFFSET > 4GIG Return SQ20539
SI59701 OSP-DB INFRASTRUCTURE
SI59486 OSP-DB-OTHER-INCORROUT RETURNGLOBALVARIABLE VALUES ARE DIFFE
SI59486 OSP-UNPRED SAVEPOINTS FOR INSERT STATEMENT NOT SET VIA DRDA
SI59486 SP/QSQDSCPT-MSGSQL0076-RC9332-MOD/QSQGETDS MSGSQL0076
SI59265 OSP-DB Internal Maintenance
SI59265 OSP-DB Internal Maintenance
SI59219 OSP-DB Internal Maintenance
SI59207 OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
SI59110 OSP-DB-OTHER CREATE COLLECTION DOESN'T SHOW UP ANYMORE IN TH
SI59107 OSP-DB Internal Maintenance
SI59050 OSP-DB Internal Maintenance
SI59048 OSP-DB Internal Maintenance
SI59047 OSP-DB Internal Maintenance
SI58984 OSP-DB-OTHER-F/QSQSBAS2X/2815-T/SAME-MSGMCH1210 CPYF RSULTS
SI58984 OSP-DB-SQL Support optionally setting indicator on truncatio
SI58943 OSP-DB Internal Maintenance
SI58943 OSP-DB INTERNAL MAINTENANCE
SI58900 OSP-DB Internal Maintenance
SI58759 OSP-DB Internal Maintenance
SI58672 OSP-DB Internal Database Maintenance
SI58551 OSP-DB-QQQOOOSETS-MSGMCH5003 using CURRENT DECFLOAT ROUNDING
SI58542 OSP-DB Internal Maintenance
SI58542 OSP-DB Error using SQL file reference variable
SI58868 OSP-DB Internal Maintenance
Summary Information
System.............................. i
Models..............................
Release............................. V7R3M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE65823
Superseded by:...................... View fix details for PTF SI85798
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C8025730
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:
13 March 2024