IBM Support

SI51031 - OSP-DB MSGCPD439A RC8 F/QQQVFMT T/QSQRUN3 / MSGSQL0171

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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


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:
14 November 2013