PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
F/DEFAULTVALUESNOTRETAINEDUSINGAS-RESULTTABLE DEFAULT VALUES
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770SS1 710 SI38413 00/00 0000
CO 5770SS1 710 SI63294 00/00 0000
CO 5770SS1 710 SI58010 00/00 0000
CO 5770SS1 710 SI56983 00/00 0000
CO 5770SS1 710 SI54479 00/00 0000
CO 5770SS1 710 SI52311 00/00 0000
CO 5770SS1 710 SI49846 00/00 0000
CO 5770SS1 710 SI49847 00/00 0000
CO 5770SS1 710 SI49105 00/00 0000
CO 5770SS1 710 SI49106 00/00 0000
CO 5770SS1 710 SI48826 00/00 0000
CO 5770SS1 710 SI48191 00/00 0000
CO 5770SS1 710 SI48195 00/00 0000
CO 5770SS1 710 SI48198 00/00 0000
CO 5770SS1 710 SI48197 00/00 0000
CO 5770SS1 710 SI48681 00/00 0000
DIST 5770999 710 MF55625 00/00 0000
DIST 5770SS1 710 SI44237 00/00 0000
DIST 5770SS1 710 SI40707 00/00 0000
DIST 5770SS1 710 SI40754 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
-----------------------------------------------
Using SQL to create a table from the definition of another
table. The create statement specifies "Including Column
Defaults" yet one of the resulting columns is getting the data
type default, not the original column default.
CORRECTION FOR APAR SE66893 :
-----------------------------
The original design for INCLUDING COLUMN DEFAULTS was to not
copy the default if the query in the AS clause contained a join.
After a lot of discussion, we decided that this request to
allow the defaults to be copied would be implemented. Now, the
defaults will be copied to the new table as long as the new
column is a direct reference to a column in a table that has a
default.
CIRCUMVENTION FOR APAR SE66893 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI63770 OS-DB-OTHER Fix handling of partition table range boundary v
SI63726 OSP-DB-OTHER-INCORROUT SELECT FROM SYSPARTITIONSTAT RETURNS
SI63261 OSP-DB-OTHER-INCORROUT INCORRECT FIELD CCSID AFTER REPLICATI
SI63060 OSP-DB-OTHER-F/#DBCCR-T/QDBCRTME-MSGMCH5601 ON ALTER TABLE T
SI62598 OSP-DB-OTHER-INCORROUT QSYS2/SYSPARTITIONSTAT LOWVALUE HIGHV
SI61121 OSP - DB Change CRTJRN Max Size for Create Schema
SI61099 OSP-DB reuse remote server job for 3 part SQL
SI60790 OSP-DB INTERNAL MAINTENANCE
SI60689 OSP-DB-MSGMCH0601 CREATE TABLE AS
SI60425 OSP-DB-F/QSQINS-MSGSQL0104 CREATE OR REPLACE TABLE AS
SI58980 OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
SI58011 OSP-DB Internal Maintenance
SI57290 OSP-DB-F/QSQCRTT-MSGSQL0901 CREATE OR REPLACE TABLE using WI
SI57251 OSP-DB-OTHER ALTER TABLE DROP PRIMARY KEY with RESTRICT does
SI57077 OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
SI56982 OSP-DB Internal Maintenance
SI56718 OSP-DB Internal Maintenance
SI56178 OSP-DB-OTHER-T/QSQCRTT-MSGMCH5804
SI54561 OSP-DB Create index fails with miscellaneous errors
SI54490 OSP-DB-OTHER-INCORROUT CREATE TABLE AS.. EXCEPT CREATES EMPT
SI54125 OSP-DB DISPLAY LONG FIELD NAMES FOR SOME SQ MESSAGES
SI54029 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI53289 OSP-DB-OTHER-T/QDBCHGFI-MSGMCH0602 ALTER TABLE WITH DROP COL
SI52312 OSP-DB UNABLE TO USE GENERATE SQL WITH PARTITIONED TABLE IF
SI52260 OSP-DB Create view internal change for complex queries
SI50935 OSP-DB-MSGSQL0901 Create view where function not resolved un
SI50898 OSP-DB-OTHER-T/QSQRUN3-MSGMCH0601 MODULE QSQOPEN PROCEDURE O
SI50354 OSP-DB-OTHER-INCORROUT CREATE TABLE LIKE GENERATES WRONG REC
SI50151 OSP-DB Internal Maintenance
SI50058 OSP-DB Generate REFFLD for CREATE TABLE LIKE and AS
SI50043 OSP-DB-OTHER-MSGSQL7905 CREATE OF LONG NAME GLOBAL TEMP TABL
SI49848 OSP-DB ALLOW EXPLICIT USE OF RDB ALIAS WITH 3-PART SQL STATE
SI49682 OSP-DB-OTHER-T/QDBCRTFIX/13331-MSGMCH3601 CREATE TABLE STMT
SI49602 OSP-MSGMCH3601-PAR-940XBASE IF YOU ADD, REMOVE, AND THEN RE-
SI49361 OSP-DB-OTHER-F/QSQDROP-T/QSQDROP-MSGSQL0204 MSGSQL0204 IF WE
SI49110 OSP-DB Add option to specify system name for create table, v
SI48929 OSP-DB-OTHER-INCORROUT INCORROUT ON OEM SQL STORED PROCEDURE
SI48827 OSP-DB INTERNAL MAINTENANCE
SI47048 OSP-DB-OTHER-F/QSQDROP-T/QSQDROP-MSGSQL0910 DROP SCHEMA FAIL
SI46565 OSP-DB-MSGCPF8361 Remote three part Alias with Embedded SQL
SI44917 OSP-DB-MSGMCH3402-T/QSQALIAS DROPFORCREATEREPLACE procedure
SI44667 OSP-DB table incorrectly searched on local sytem insted of r
SI40615 OSP-DB-UNPRED Three part alias statement rewrite
SI40375 OSP-DB-UNPRED Three part SQL aliases failing to create
SI39873 OSP-DB-UNPRED Use of DDM for SQL three-part aliases failing
SI39369 OSP-DB Internal Maintenance
SI39340 OSP-DB-MSGSQL0901-T/QSQALIAS Reason code 4055 on CREATE ALIA
SI39160 OSP-DB-MSGCPF3324 drop collection fails
SI37682 OSP-DB Internal Maintenance
SI37662 OSP-DB Internal Maintenance
SI37637 OSP-DB Internal Maintenance
SI37438 OSP-DB INTERNAL MAINTENANCE
SI37062 OSP-DB-INCORROUT - MSGSQL0204 ON DROP OF TRIGGER WITH QUOTED
SI48747 OSP-DB-OTHER-UNPRED Internal Maintenance
SI43817 OSP-DB-MSGSQL0104-T/QSQCRTDB
SI43762 OSP-DB-INCORROUT GARBLED LABEL TEXT FOR CREATE DATABASE
SI39374 OSP-DB Internal Maintenance
SI48766 OSP-DB-MSGMCH3601-T/QSQCRTT CHECK_DGTT_SQL on DECLARE GLOBAL
SI48641 OSP-DB STORE PROCEDURES FAILS SQL0601 F/QSQCRTI T/QSQCRTI SI
SI48262 OSP-DB get column names from source table on luw
SI48199 OSP-DB-OTHER-RC480-MSGSQL0904
SI48130 OSP-DB-MSGSQL0350 remote query to z/OS
SI47843 OSP-DB allow create table based on source table on luw
SI47822 OSP-DB create table as based on source table on luw
SI47740 OSP-DB support CREATE TABLE AS with a remote query
SI47670 OSP-DB-PERFM Improved DECLARE GLOBAL TEMPORARY TABLE WITH RE
SI47575 OSP-DB-MSGCPF8350-T/QDBCHGFI SQL0901 4411 Create or replace
SI47476 OSP-DB-MSGSQL0601 Create or replace view in qtemp
SI47365 OSP-DB-OTHER-UNPRED SERVICEABILITY
SI47104 OSP-DB-MSGSQL0601 LIBRARY MSG TOKEN CONTAINS BLANKS FOR DUP
SI46785 OSP-DB MSGSQL0901 CREATE OR REPLACE view failure
SI46728 OSP-CP-OTHER-QCPGENIO messages in job log not handled by SQL
SI46557 OSP-DB-MSGSQL0901-MSGMCH3601-T/QSQCRTT TBLLIKERRS Reason 420
SI46145 OSP-DB-MSGSQL0681 when doing ALTER to add a field proc to a
SI45882 OSP-DB-MSGSQL0683-f/QSQALTER when doing ALTER TABLE to add a
SI45483 OSP-DB-OTHER-MSGSQL0204 MSGSQL0204 TRYING TO CREATE A TABLE
SI44778 OSP-DB-OTHER-UNPRED ALLOCATE(0) ON AN ALTER TABLE DOES NOT R
SI44489 OSP-DB ENHANCE CREATE TABLE WITH DATA TO RETURN ROW_COUNT
SI44239 OSP-DB-OTHER-MSGCPF32A5 A MSGCPF32A5 CCSID 13488 FOR FIELD *
SI43446 OSP-DB-OTHER-F/QDBCHGFI-T/QSQALTER-MSGCPF7304 SQL ALTER TABL
SI43377 OSP-DB-OTHER-F/QSQALTER-T/QSQALTER-MSGSQL0678 ALTER TABLE FA
SI42910 OSP-DB-MSGCPD32F5-F/QDBCRTFI-T/QSQCRTT on create table
SI42841 OSP-DB-OTHER-F/QSQALTER-RC4-MSGSQL0685
SI42524 OSP-F/QSQCRTT-T/QSQCRTT-MSGMCH1210 MSGMCH1210 F/QSQCRTT WHEN
SI42250 OSP-DB Internal Maintenance
SI40968 OSP-DB-INCORROUT SQL0685 PROVIDE REASON CODE IN SQ COMPONENT
SI40942 OSP-DB-OTHER-F/QDBFIXIT-T/QSQCRTT-MSGCPF325E DECLARE GLOBAL
SI40761 OSP-DB-MSGMCH1222 F/QQQSVRTN QQINVFP FOR FIELDPROCEDURE ON D
SI40705 OSP-DB-INCORROUT Query text generated for a CREATE VIEW SQL
SI40467 OSP-DB-MSGSQL7009 UNQUALIFIED FIELDPROCEDURE USING SQL NAMIN
SI40398 OSP-DB-MSGSQL7009 SPECIFYING AN UNQUALIFIED FIELDPROCEDURE
SI39813 OSP-DB-MSGMCH3601 f/QSQCRTT/20507 When an XML column with fi
SI39738 OSP-DB-MSGSQL0901 when attempting to create/alter a partitio
SI39655 OSP-DB-MSGSQL0685 with field procs
SI39616 OSP-DB-MSGSQL0685 when CREATE TABLE LIKE of table with field
SI39562 OSP-DB-MSGSQL0685 with field procs
SI39496 OSP-DB-MSGMCH1864 F/#dbxvfld T/QDBCRTME WHEN FIELDPROC WITH
SI39436 OSP-DB-INCORROUT MSGSQL0901 f/QSQCRTV/20229 when doing CREAT
SI39109 OSP-DB Internal Maintenance
SI39109 OSP-DB Internal Maintenance
SI38804 OSP-DB Internal Maintenance
SI38779 OSP-DB Internal Maintenance
SI38747 OSP-DB Internal Maintenance
SI38699 OSP-DB Internal Maintenance
SI38602 OSP-DB Internal Maintenance
SI38516 OSP-DB Internal Maintenance
SI38422 OSP-DB Internal Maintenance
SI39333 OSP-DB-INCORROUT CREATE TABLE SHOULD BE DISALLOWED WHEN FIEL
SI39209 OSP-DB-OTHER-PERFM QDT REBUILD FOR EACH STATEMENT EXECUTION
SI39209 OSP-DB-OTHER-T/QSQCRTI-MSGMSGMCH5804
SI39049 OSP-DB-OTHER-F/QDBEXDFI-T/QSQALTER-MSGCPF3202 ADD PARTITION
SI38942 OSP-DB Internal Maintenance
SI38790 OSP-DB Internal Maintenance
SI38562 OSP-DB-INCORROUT ALTER TABLE Partitioning
SI38096 OSP-DB-F/QSQALTER-MSGMCH1210 Altering table to bigger then m
SI37875 OSP-DB-OTHER-QDBCHGFI ALTER TABLE FOR PARTITIONED TABLES
SI37720 OSP-DB-QSQCRTI-MSGSQL0901 on CREATE INDEX
SI37632 OSP-DB-QSQCRTI-MSGSQL0901 when CPD435D is signalled on CREAT
SI37404 OSP-DB-QSQALTER-MSGSQL0901
SI37189 OSP-DB-MSGMCH1864 F/#dbxvfld T/QDBCRTME CREATE TABLE AS WITH
SI37189 OSP-DB-INCORROUT EXECUTE IMMEDIATE CREATE TABLE WITH FIELDPR
SI36767 OSP-DB-MSGSQL0901 F/QSQCRTT FOLLOWING CPD32D7 RC=12
SI36609 OSP-DB-QSQCRTI MSGSQL0137 when different error should occur
SI36553 OSP DB GLOBAL VARIABLE PROCESSING
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770SS1 |
APAR Fixed.......................... | View details for APAR SE66893 |
Superseded by:...................... | View fix details for PTF SI64950 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | NONE |
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 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:
26 July 2017