PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB SQL statement using RDB alias fails
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
CO 5770SS1 V7R2M0 SI63610 00/00 0000
CO 5770SS1 V7R2M0 SI63283 00/00 0000
CO 5770SS1 V7R2M0 SI58026 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
-----------------------------------------------
SQL statement using a RDB alias fails
CORRECTION FOR APAR SE67371 :
-----------------------------
Code has been changed to correctly resolve the RDB alias.
CIRCUMVENTION FOR APAR SE67371 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI64472 F/DEFAULTVALUESNOTRETAINEDUSINGAS-RESULTTABLE DEFAULT VALUES
SI63830 OSP-DB-OTHER-T/QSQDROP-MSGCPFA030 RESULTS IN A MSGSQL0901
SI63771 OS-DB-OTHER Fix handling of partition table range boundary v
SI63611 OSP-DB-OTHER-SAP400-MSGSQL0636 ALTER TABLE ADD PARTITION RAN
SI63467 OSP-DB-OTHER-INCORROUT SELECT FROM SYSPARTITIONSTAT RETURNS
SI63263 OSP-DB-OTHER-INCORROUT INCORRECT FIELD CCSID AFTER REPLICATI
SI63185 OSP-DB-OTHER-F/#DBCCR-T/QDBCRTME-MSGMCH5601 ON ALTER TABLE T
SI63153 OSP-DB-QSQCRTV-Indicate that view created with Deflate optio
SI61120 OSP - DB Change CRTJRN Max Size for Create Schema
SI61100 OSP-DB reuse remote server job for 3 part SQL
SI60789 OSP-DB INTERNAL MAINTENANCE
SI60741 OSP-DB-MSGMCH0601 CREATE TABLE AS
SI60556 OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 SQL INSERT FAILS WITH MSG
SI60427 OSP-DB-F/QSQINS-MSGSQL0104 CREATE OR REPLACE TABLE AS
SI58981 OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
SI58027 OSP-DB Internal Maintenance
SI57252 OSP-DB-OTHER ALTER TABLE DROP PRIMARY KEY with RESTRICT does
SI57091 OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
SI56945 OSP-DB Internal Maintenance
SI56717 OSP-DB Internal Maintenance
SI56179 OSP-DB-OTHER-T/QSQCRTT-MSGMCH5804
SI56137 OSP-DB Extend QSQPRCED() to include some QAQQINI options
SI54717 OSP-DB Create index fails with miscellaneous errors
SI54491 OSP-DB-OTHER-INCORROUT CREATE TABLE AS.. EXCEPT CREATES EMPT
SI54060 OSP-DB DISPLAY LONG FIELD NAMES FOR SOME SQ MESSAGES
SI54042 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI53290 OSP-DB-OTHER-T/QDBCHGFI-MSGMCH0602 ALTER TABLE WITH DROP COL
SI52820 OSP-DB Internal Maintenance
SI52749 OSP-DB Internal maintainence
SI52684 OSP-DB UNABLE TO USE GENERATE SQL WITH PARTITIONED TABLE IF
SI52606 OSP-DB-MSGSQL0901-F/QSQALTER ALTER TABLE with DROP PARTITION
SI52268 OSP-DB Create view internal change for complex queries
SI52268 OSP-DB INTERNAL MAINTENANCE
SI51229 OSP-DB INTERNAL MAINTENANCE
SI51908 OSP-DB INTERNAL MAINTENANCE
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R2M0 |
Licensed Program............... | 5770SS1 |
APAR Fixed.......................... | View details for APAR SE67371 |
Superseded by:...................... | View fix details for PTF SI75932 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | C7290720 |
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 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 April 2021