IBM Support

SI64471 - F/DEFAULTVALUESNOTRETAINEDUSINGAS-RESULTTABLE DEFAULT VALUES

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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


System 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 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.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
26 July 2017