IBM Support

SI65630 - OSP-DB-OTHER-RC6-MSGSQL0752 SET TRANSACTION LEVEL NO COMMIT

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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 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.3.0","Product":{"code":"SWG60","label":"IBM i"},"Component":"5770SS1","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
13 March 2024