PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB MSGCPD439A RC8 F/QQQVFMT T/QSQRUN3 / MSGSQL0171
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770SS1 710 SI48642 00/00 0000
PRE 5770SS1 710 SI48829 00/00 0000
PRE 5770SS1 710 SI48846 00/00 0000
PRE 5770SS1 710 SI48853 00/00 0000
PRE 5770SS1 710 SI48874 00/00 0000
PRE 5770SS1 710 SI48128 00/00 0000
PRE 5770SS1 710 SI48152 00/00 0000
PRE 5770SS1 710 SI48274 00/00 0000
PRE 5770SS1 710 SI48090 00/00 0000
PRE 5770SS1 710 SI46490 00/00 0000
PRE 5770SS1 710 SI46574 00/00 0000
PRE 5770SS1 710 SI42954 00/00 0000
PRE 5770999 710 MF52752 00/00 0000
PRE 5770SS1 710 SI38089 00/00 0000
CO 5770SS1 710 SI50950 00/00 0000
CO 5770SS1 710 SI50951 00/00 0000
CO 5770SS1 710 SI50949 00/00 0000
CO 5770SS1 710 SI50048 00/00 0000
CO 5770SS1 710 SI50046 00/00 0000
CO 5770SS1 710 SI49848 00/00 0000
CO 5770SS1 710 SI49105 00/00 0000
CO 5770SS1 710 SI48826 00/00 0000
CO 5770SS1 710 SI48080 00/00 0000
CO 5770SS1 710 SI48144 00/00 0000
CO 5770SS1 710 SI46365 00/00 0000
CO 5770SS1 710 SI42927 00/00 0000
CO 5770SS1 710 SI41416 00/00 0000
DIST 5770ST1 710 SI49109 NONE 0000
DIST 5770SS1 710 SI43720 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
-----------------------------------------------
Since they upgrade the PTF level, querying the table
QUSRBRM.QA1AHS fails MSGCPD439A RC8 f/QQQVFMT t/QSQRUN3 /
MSGSQL0171 on a Korean system.
Here is the statement:
select bkcmdt, TRANSLATE(BKCMDT,
'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++++
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
',X'
000102030405060708090A0B0C0D0E0F101112131415161718191A1B1C1D1E1F
2021
22232425262728292A2B2C2D2E2F303132333435363738393A3B3C3D3E3F4142
4344
45464748494A4B4C4D4F505152535455565758595A5B5C5D5E5F606162636465
6667
68696A6B6C6D6E6F707172737475767778797A7B7C7D7E7F8081828384858687
8889
8A8B8C8D8E8F909A9B9C9D9E9FA1AAABACADAEAFB0B1B2B3B4B5B6B7B8B9BABB
BCBD
BEBFC0CACBCCCDCECFD0DADBDCDDDEDFE0E1EAEBECEDEEEFFAFBFCFDFE')
from QUSRBRM.QA1AHS
CORRECTION FOR APAR SE56843 :
-----------------------------
The x'0E' and x'0F' in the hex literal were causing it to be
considered an IGC literal. For the TRANSLATE function, the
literals must always be interpreted as character strings. This
has been corrected.
CIRCUMVENTION FOR APAR SE56843 :
--------------------------------
None.
Activation Instructions
None.
Special Instructions
None.
Default Instructions
THIS IS A DELAYED PTF TO BE APPLIED AT IPL TIME.
Supersedes
PTF/FIX NO(S). APAR TITLE LINE
-------------- ------------------------------------------------------------
SI50948 OSP-DB-MSGSQL5001 Column qualified with RDB alias name
SI50702 Integrity Problem
SI50592 OSP-DB-OTHER-INCORROUT DBCS SQL HEX(REPLACE('FIELDNAME' X'DB
SI50441 OSP-DB No parameter marker replacement for special Guardium
SI50241 OSP-DB-OTHER-MSGMCH3601 A MSGMCH3601 MAY OCCUR WHEN USING TH
SI50044 OSP-DB Support for Debug of Scalar UDFs with Data Studio
SI50011 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0122 WHEN RUNNING A G
SI49846 OSP-DB ALLOW EXPLICIT USE OF RDB ALIAS WITH 3-PART SQL STATE
SI49744 OSP-DB-OTHER-F/QSQRPARS-MSGMCH3601 MSGMCH3601 F/QSQRPARS ON
SI49638 OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH3203 MSGMCH3203 F/QSQ
SI49514 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0204 SQL STATEMENT FA
SI49112 OSP-DB Add support for multiple event triggers
SI49112 OSP-DB-OTHER-MSGSQL0104 WHEN TRYING TO CREATE A TRIGGER USIN
SI49112 OSP-DB-MSGMCH3601 QSQRCHK for MERGE statement
SI49112 OSP-DB Add option to specify system name for create table, v
SI48882 OSP-DB INTERNAL MAINTENANCE
SI48854 OSP-DB Disallow SELECT statement for RUNSQL command
SI48804 OSP-DB Null results returned for multiple grouping sets quer
SI48309 OSP-DB Named parameters and defaults for procedures
SI48269 OSP-DB-MSGSQL0204 create variable referencing function with
SI48164 OSP-DB INTERNAL MAINTENANCE
SI48142 OSP-DB INTERNAL MAINTENANCE
SI47739 OSP-DB support CREATE TABLE AS with a remote query
SI47435 OSP-DB In *SYS naming, allow '.' for qualifying objects
SI47244 OSP-DB-OTHER-SRCB6005121 WORD 1 SRCB6005121 WORD 3 SRC004000
SI46912 OSP-DB-MSGSQL0129 Delete statement incorrectly indicates max
SI46631 OSP-DB Add support for the XMLTABLE function
SI46554 OSP-DB-OTHER-T/QSQRPARSX/60620-MSGMCH1210 EDITING RGPLE SOUR
SI46386 OSP-DB Too many rows deleted using RRN in row expression
SI46369 F/QSQXCUTE-MSGSQL0104-RIDS/CLEANUP SETTING AN SQL VARIABLE T
SI46347 OSP-DB SUPPORT WRAPPED FUNCTIONS AND PROCEDURES
SI46228 OSP-INCORROUT FETCH FIRST N ROW NOT RECOGNIZED
SI46228 OSP-DB-OTHER-UNPRED DSPPGM, PRTSQLINF AND I SERIES NAV RETRI
SI45871 OSP-DB Support UNIT SSD for DECLARE GLOBAL TEMPORARY TABLE
SI45644 OSP-F/QSQDDL1-T/QSQDDL1-MSGMCH1210 CREATE OR REPLACE VIEW FA
SI45405 OSP-DB CCSID not set for parameters defined as NCHAR type
SI45338 OSP-DB-OTHER-MSGSQL7906 RUNSQLSTM WITH TGTRLS(*V5R4M0) FAILS
SI45048 OSP-DB-MSGSQL0084 prompting CONNECT TO in interactive sql
SI44779 OSP-DB-OTHER-UNPRED ALLOCATE(0) ON AN ALTER TABLE DOES NOT R
SI44779 OSP-DB-OTHER-UNPRED AN ALTER TABLE USING BEFORE COLUMN SYNTA
SI44576 OSP-DB-OTHER-INCORROUT A QUERY WITH AT LEAST 2 TABLES MAY RE
SI44441 OSP-DB-OTHER-MSGSQL5001 SQL RESERVED WORD COLLECT CANNOT BE
SI43721 OSP-DB Loop when prompting SQL statement ALTER TABLE t1 ADD
SI43315 OSP-DB-OTHER-F/DBPMTRAP-T/QSQRPARS-MSGMCH3203 EDITING SQLRPG
SI43315 OSP-DB-OTHER-LOOP RPG PGM WITH SQL COMPILE STARTS LOOPING NO
SI43315 OSP-DB-MSGSQL0199 For sql create view with common table expr
SI43315 OSP-DB SQL function RID disallows column named RID
SI43315 OSP-DB SQL query support for CONNECT BY
SI42953 OSP-DB-OTHER-MSGSQL0204 CALL OF A FUNCTION IS FAILING WITH M
SI42953 OSP-DB SPECIFY PROGRAM NAME ON CREATE TRIGGER
SI42180 OSP-DB-OTHER-MSGSQL0120 SQL STATE 42903 WHEN USING OLAP RANK
SI42092 OSP-DB-OTHER-F/QSQXCUTEX/27892-T/SAME-MSGSQL5001 MSGSQL5001
SI42092 OSP-DB-OTHER-MSGSQL0203 OSP-DB-OTHER-MSGSQL0203
SI42092 OSP-DB-MSGSQL0199 when use label DEFAULT in routine body
SI41834 OSP-DB-OTHER-INCORROUT UNICODE CONSTANTS THAT END IN CHARACT
SI41803 OSP-DB-MSGSQL0113 when TABLESPACE clause should be ignored
SI41803 OSP-DB-MSGSQL0113 CREATE PROCEDURE in RUNSQLSTM with delimit
SI41616 OSP-DB Global variable qualified with system naming restrict
SI41487 SMU-DBPARL-F/QSQRPARS-T/QSQRPARS-MSGMCH1210 DELETING LINES I
SI41415 OSP-DB-INCORROUT VISUAL EXPLAIN OF MERGE FAILS
SI41341 OSP-DB-MSGSQL0802 Update statement with qualified global var
SI41171 OSP-DB Parameter marker data types for simple SQL CASE expre
SI41055 OSP-DB Enable expressions in SQL CALL statement
SI41055 OSP-DB Tolerate the NOT LOGGED clause for CREATE TABLE state
SI40525 F/QSQILVL3-MSGMCH1210-MOD/QSQILVL3 SQL6101 AND MCH1210 F/QSQ
SI40325 OSP-DB Wrong string returned for XMLELEMENT on IGC system
SI40216 OSP-DB-MSGCPD4324 MERGE statement with many host variables
SI40109 OSP-INCORROUT GARBAGE APPEARED ON THE SQL SCRIPT SCREEN, WHE
SI40028 SQL-DB-MSGCPF4102 DEBUG VIEW NOT FOUND FOR SQL TRIGGER
SI39936 OSP-DB Parameter marker extension iteration 1
SI39841 OSP-DB SQL routine attributes not always set after ALTER
SI39690 OSP-DB-MSGSQL0205 from QSQBLQDT with multiple complex IN pre
SI39569 OSP-DB MERGE statement with INSERT and SIGNAL ignore signal
SI39506 OSP-DB-MSGMCH6903 more than 10 CUBE arguments in SQL
SI39421 SQL-CMPL-MSGCZM0022 CREATE PROCEDURE WITH RESULT SETS
SI39339 OSP-DB-MSGSQL0440 when calling procedure with parameter mark
SI39314 OSP-DB Query wrong records for NOT (row values) IN (subquery
SI39203 F/QQQVALID-MSGCPD4345-MOD/QQQVALID F/QQQVALID-MSGCPD4345-MOD
SI38974 OSP-DB Associate locators in create trigger not accepting na
SI38735 OSP-DB XML namespaces not generated for nested scope
SI38594 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0122 SELECT STATEMENT
SI38088 OSP-RC2040-MSGSQL0904 RPG PROGRAM COMPILE FAILS WITH MSGSQL0
SI37944 SP/QSQRUN1-MSGSQL0101-MOD/QSQPREP SP/QSQRUN1-MSGSQL0101-MOD/
SI37827 OSP-DB Create schema should not allow XSR object sub-stateme
SI37454 OSP-DB Global variable in simple update SET list used twice
SI37381 OSP-DB-OTHER-F/QSQRPARS-T/SAME-MSGMCH1210 ALTER TABLE... SEL
SI37381 OSP-DB-OTHER-MSGSQL7906 SQL RPGIV TGTRLS *PRV PRECOMPILE FAI
SI37248 OSP-F/QSQRPARS-T/QSQRPARS-MSGMCH1210 QUERY FAILS AT R610 WIT
SI37148 OSP-DB XML AS BLOB variable not passed correctly for DRDA
SI36965 OSP-DB SQL do not allow array constructor as function argume
SI36818 OSP-DB Arrays over DRDA
SI36772 OSP-DB-MSGMCH1210 QSQRPARS when precompile with many include
SI36647 OSP-DB-OTHER-INCORROUT USING STRSQL, PROMPTING FOR A STATEME
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770SS1 |
APAR Fixed.......................... | View details for APAR SE56843 |
Superseded by:...................... | View fix details for PTF SI64283 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | C4143710 |
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:
14 November 2013