IBM Support

SI64407 - OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 MCH1210 F/QSQRCH

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 MCH1210 F/QSQRCH


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI62152   00/00    0000
PRE  5770SS1  710  SI60054   00/00    0000
PRE  5770SS1  710  SI49407   00/00    0000
CO   5770SS1  710  SI62819   00/00    0000
CO   5770SS1  710  SI62820   00/00    0000
CO   5770SS1  710  SI62823   00/00    0000
CO   5770SS1  710  SI58795   00/00    0000
CO   5770SS1  710  SI58007   00/00    0000
CO   5770SS1  710  SI58011   00/00    0000
CO   5770SS1  710  SI56983   00/00    0000
CO   5770SS1  710  SI53926   00/00    0000
CO   5770SS1  710  SI50411   00/00    0000
CO   5770SS1  710  SI50046   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  SI48080   00/00    0000
CO   5770SS1  710  SI48144   00/00    0000
CO   5770SS1  710  SI47141   00/00    0000
CO   5770SS1  710  SI42927   00/00    0000
CO   5770SS1  710  SI40611   00/00    0000
DIST 5770SS1  710  SI59127   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

-----------------------------------------------
MCH1210 f/QSQRCHK t/QSQRCHK m/QSQRCHK p/TREE_ALOC s/59200 on
CREATE OR REPLACE TRIGGER

CORRECTION FOR APAR SE67008 :
-----------------------------
QSQRCHK was fixed to avoid the MSGMCH1210.

CIRCUMVENTION FOR APAR SE67008 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI47138 :
=================================================

If you have not experience this problem, nothing needs to be done.
If you have experienced this problem you need to recreate the SQL
procedure, SQL function, or SQL trigger.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI45954 :
=================================================

DESCRIPTION OF PROBLEM FIXED FOR APAR SE49807 :
-----------------------------------------------
When an SQL trigger program has been removed, DB2 for i will
automatically regenerate the trigger program when the dependent table
is used in such a way that the trigger program should fire.
The automatic regeneration of an SQL trigger program may fail with
MSGSQL0312 F/QSQTRG T/QSQTRGPM on 6.1 or MSGSQL0206 F/QSQXCUTE
T/QSQXCUTE on 7.1.


CORRECTION FOR APAR SE49807 :
-----------------------------
The generated trigger code attempts to use an incorrect label
qualification for locally declared variables, resulting in the
MSGSQL0312 on 6.1 or MSGSQL0206 on 7.1.

SPECIAL INSTRUCTIONS :
-----------------------------
For any cases where MSGSQL0312 or MSGSQL0206 occurs during an attempt
to fire a trigger, the associated trigger needs to be dropped and
recreated from its original SQL source code after application of this
PTF.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI41934 :
=================================================

If you have not experience this problem, nothing needs to be done.
If you have experienced this problem you need to drop and recreate the
SQL procedure, SQL function or SQL trigger.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI40783 :
=================================================

If you have not experience this problem, nothing needs to be done.
If you have experienced this problem, you need to drop and recreate the
function.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI40027 :
=================================================

If you have not experience this problem, nothing needs to be done.
If you have experienced this problem you need to drop and recreate the
SQL trigger.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI64356      OSP-DB-F/QSQRCHK-MSGMCH1210 when returning a SQL0390 process
   SI64356      OSP-DB-OTHER-F/QSQRCHK-MSGMCH1210 WHEN RECURSIVE COMMON TABL
   SI63968      OSP-DB SQL0110 using GX literal for a partition table range
   SI63762      OS-DB-OTHER Fix handling of partition table range boundary v
   SI63576      OSP-DB-MSGSQL0901 running concurrent CREATE OR REPLACE TABLE
   SI63378      OSP-DB Internal Maintenance
   SI63229      OSP-DB Do not issue SQL7901 for create package
   SI62822      OSP-DB INTERNAL MAINTENANCE
   SI62525      OSP-DB INFRASTRUCTURE
   SI62153      OSP-DB INFRASTRUCTURE
   SI60795      OSP-DB INTERNAL MAINTENANCE
   SI60417      OSP-DB-OTHER BETTER SQL IDENTIFIER NAMES
   SI60323      OSP-DB-MSGMSG0601 T/QQQFVMT Proc/MAP using lateral correlati
   SI60309      OSP-DB Internal Maintenance
   SI60055      OSP-DB INTERNAL MAINTENANCE
   SI59738      OSP-DB Internal Maintenance
   SI59349      OSP-DB INTERNAL MAINTENANCE
   SI59312      OSP-DB-OTHER-MSGSQL0900 AFTER CRTSQLCI to REMOTE RDB
   SI59126      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-RC2-MSGSQL0101 SQL RPG OBJE
   SI58990      OSP-DB INTERNAL MAINTENANCE
   SI58976      OSP-DB OFFSET clause changes for internal processing
   SI58952      OSP-DB INTERNAL MAINTENANCE
   SI58910      OSP-DB Internal Maintenance
   SI58910      OSP-DB Internal Maintenance
   SI58454      OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-RC21-MSGCPD4374 UPDATING X
   SI58317      OSP-DB-OTHER-INCORROUT QDT is not rebuilt when SELECT * and
   SI58126      OSP-DB INTERNAL MAINTENANCE
   SI58084      OSP-DB-OTHER-PERFM EXTRA CONNECTION DONE WITH 3-PART NAMING
   SI58061      OSP-DB-INCORROUT SQL ROUTINE CONDITION HANDLER NOT ACTIVATED
   SI58010      OSP-DB-MSGSQL0206 when column not defined at precompile time
   SI58010      OSP-DB Internal Maintenance
   SI57910      OSP-DB-OTHER-F/QRNXIEX/26-MSGRNX0115 .NET APP FAILS
   SI57899      OSP-DB-MSGSQL0150 Unable to use XMLTABLE and a view in a tem
   SI57233      OSP-DB-OTHER-F/QQQVFMT-T/QSQRCHK-MSGCPF4278 SQL STORED PROCE
   SI57185      OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN1-MSGCPD4324 MSGCPD4324 F/QQQ
   SI56984      OSP-DB Internal Maintenance
   SI56942      OSP-DB Internal Maintenance
   SI56793      OSP-DB Update SYSTRIGGERS to correct REMARKS column
   SI56756      OSP-DB CPYFRMIMPF CAN RUN SLOW IF OVRDBF IS USED.
   SI56722      OSP-DB Internal Maintenance
   SI56632      OSP-DB-PERFM SQL ROUTINE GRAPHIC/VARGRAPHIC PERFORMANCE
   SI56444      SQL-CMPL-INCORROUT TRIGGER EVENT PREDICATE OF A MULTIPLE EVE
   SI56251      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-RC2-MSGSQL0101 SQL MERGE ST
   SI56251      OSP-DB INTERNAL MAINTENANCE
   SI56226      OSP-DB INTERNAL MAINTENANCE
   SI56124      OSP-DB INTERNAL MAINTENANCE
   SI55930      SQL-CMPL-INCORROUT DEBUGGER ARRAY TYPE VARIABLES
   SI55454      OSP-DB-OTHER-F/QSQPARSP-T/QSQPARSP-MSGMCH0601 DBGVIEW *SOURC
   SI55432      OSP-DB Internal Maintenance
   SI37644      SQL-CMPL-MSGSQL5032 DECLARE VARIABLE STATEMENT NOT SCOPING T
   SI55384      OSP-DB CREATE TABLE with range partition starting value grea
   SI55279      OSP-DB Internal Maintenance
   SI55237      OSP-DB CREATE TABLE with range partition starting value grea
   SI55237      OSP-DB-F/QSQRCHK-MSGMCH0601 when there are a large number of
   SI55212      OSP-F/QSQDDL1-T/QSQDDL1-MSGMCH1210 RUNSQLSTM FAILS WITH MCH1
   SI55202      OSP-DB-OTHER-INCORROUT NO MSGSQL0206 AT COMPILE WHEN SQL_GVA
   SI55202      OSP-DB-OTHER-T/QSQRUN4X/42011-MSGSQL0204 SQL0204 ISSUED WHEN
   SI55161      OSP-DB Internal Maintenance
   SI55033      OSP-DB Internal Maintenance
   SI54953      OSP-DB INTERNAL MAINTENANCE
   SI54750      OSP-DB-OTHER-UNPRED UPDATING A TABLE WITH BOTH A NULLABLE FI
   SI54704      OSP-DB Internal Maintenance
   SI54629      OSP-DB INTERNAL MAINTENANCE
   SI54559      OSP-DB INTERNAL MAINTENANCE
   SI54559      OSP-DB INTERNAL MAINTENANCE
   SI54280      SQL-CMPL DEBUGGER SUPPORT FOR SQL VARIABLES WITHIN SQL ROUTI
   SI54089      OSP-DB RUNSQL sends duplicate messages to joblog
   SI54019      OSP-DB INTERNAL MAINTENANCE
   SI53937      OSP-DB Internal Maintenance
   SI53908      OSP-DB ADD LOCK TABLE SUPPORT MULTIPLE MEMBER FILES
   SI53836      OSP-DB Internal Maintenance
   SI53692      OSP-DB-MSGCPD4324 QQQVSEL Global variable and NOT IN predica
   SI53647      OSP-DB RUNSQL not writing error to joblog with *LIST option
   SI53619      OSP-DB-MSGSQL5001 when using a global variable in a DISTINCT
   SI53500      OSP-DB INTERNAL MAINTENANCE
   SI53407      OSP-DB Add option for listing to RUNSQL command
   SI53277      OSP-DB SYSROUTINEDEP column PARM_SIGNATURE has the wrong dat
   SI53147      OSP-DB Serviceability Enhancement for SQL
   SI53106      SQL-CMPL-MSGSQL7032 SQL ROUTINE FAILS TO CREATE
   SI53105      OSP-DB-MSGSQL0518 During CREATE TABLE with a range partition
   SI52969      OSP-DB-MSGMCH3601-F/QRWSDSCD CREATE PROCEDURE FAILURE W/LOOP
   SI52945      OSP-DB-MSGSQL9001 SQL PRECOMPILE FAILS WITH SQL0122 WHEN USI
   SI52827      OSP-DB-OTHER-UNPRED A CREATE OF A MATERIALIZED QUERY TABLE M
   SI52781      SQL-CMPL-MSGSQL7032 SQL ROUTINE FAILS TO CREATE
   SI52708      OSP-DB-OTHER-INCORROUT THE COLUMN NAME OF A GLOBAL VAR WITH
   SI52313      OSP-DB UNABLE TO USE GENERATE SQL WITH PARTITIONED TABLE IF
   SI52285      OSP-F/QSQRCHK-T/QSQRCHK-MSGMCH0601 A CALL TO A STORED PROCED
   SI52240      OSP-DB-MSGSQL0338 with implied parentheses in join order
   SI52233      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 CRTSQLCBLI FAILS
   SI52204      OSP-DB Column name for global variable with long AS name
   SI51795      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 CRTSQLCBLI FAILS
   SI51353      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 CRTSQLCBLI FAILS
   SI51190      OSP-DB-OTHER-INCORROUT CREATE INDEX WITH RCDFMT KEYWORD DOES
   SI51022      OSP-DB-OTHER QSQDSRC CCSID PROBLEM
   SI50950      OSP-DB-MSGMCH3601 QSQRCHK create variable in RUNSQLSTM
   SI50413      OSP-DB-OTHER-F/QDBIOERRQO-T/QQURB-RC1-MSGCPF503E UDF WITH TR
   SI50413      OSP-DB-OTHER-SAP400-F/QSQTRGPM-T/QDBTRIG2-MSGSQL7032 CREATE
   SI50308      OSP-DB Add REFFLD for CREATE TABLE AS with CAST in select li
   SI50207      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 MSGMCH1210 F/QSQ
   SI50057      OSP-DB Generate REFFLD for CREATE TABLE LIKE and AS
   SI50045      OSP-DB Support for Debug of Scalar UDFs with Data Studio
   SI50012      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0122 WHEN RUNNING A G
   SI49891      OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGSQL0204 SQL0204 ON EXT
   SI49758      OSP-DB-OTHER-INCORROUT QGENOBJNAM QUOTES SPECIAL CHARACTERS
   SI49543      OSP-DB MSGSQL0180 using date, time or timestamp default valu
   SI49512      OSP-DB BREAKPOINT SET INCORRECTLY IN SQL STORED PROCEDURE
   SI49408      OSP-DB INTERNAL MAINTENANCE
   SI49271      OSP-DB-QSQRXTRT-MSGMCH3402
   SI49107      OSP-DB-OTHER-MSGSQL0104 WHEN TRYING TO CREATE A TRIGGER USIN
   SI48884      OSP-DB INTERNAL MAINTENANCE
   SI48849      OSP-DB INTERNAL MAINTENANCE
   SI48818      OSP-DB-OTHER MSGCPD4324 F/QQQVSEL T/QSQRUN3 R710
   SI48572      OSP-DB INTERNAL MAINTENANCE
   SI48418      OSP-DB SQL0204 FOR SEQUENCE OBJECT
   SI48281      OSP-DB SQL STATEMENT MAY USE THE WRONG LIBRARY - EVEN THOUGH
   SI48281      OSP-DB SQL0204 FOR SEQUENCE OBJECT
   SI48193      OSP-DB-OTHER-RC480-MSGSQL0904
   SI48183      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0138 WHEN USING LEFT
   SI48138      OSP-DB INTERNAL MAINTENANCE
   SI48138      OSP-DB-OTHER-F/QQQVFMTX/2800-T/QSQCRTVX/9034-MSGCPD4306 CREA
   SI46532      OSP-DB-F/QRWTEXEC-MSGSQL0525 Using 3 part names and multiple
   SI40612      OSP-DB-UNPRED Three part alias statement rewrite
   SI38793      OSP-DB Internal Maintenance
   SI47838      OSP-MSGSQL0373-PAR-940XCOM TABLE HAS AN IDENTITY COLUMN AND
   SI47738      OSP-DB Alter view with LEVEL pseudo column loses data type
   SI47651      OSP-DB-MSGSQL0204 UDF not found using delimited qualifier
   SI47552      OSP-DB-MSGCPF9898 SQL CREATE PROCEDURE statement in RUNSQL
   SI47436      OSP-DB In *SYS naming, allow '.' for qualifying objects
   SI47358      OSP-DB ADD SQL_GVAR_BUILD_RULE QAQQINI OPTION
   SI47335      OSP-DB-OTHER-MSGSQL0203 ON SQL PRE-COMPILE AFTER A DECLARATI
   SI47323      OSP-DB Add a listing option to the RUNSQLSTM command
   SI47142      OSP-DB INTERNAL MAINTENANCE
   SI47138      OSP-DB-MSGSQL7959 NOT RETURNED
   SI47042      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL0501 SQL STORED PROCE
   SI46737      OSP-DB ALLOW GLOBAL VARIABLES TO BE CHANGED WITHIN TRIGGERS
   SI46683      OSP-DB-MSGSQL0012 using XMLTABLE from CLI
   SI46615      MSGSQL0583 is sent when OLAP function is used in a statement
   SI46569      OSP-DB-OTHER-F/QQQVFMT-T/QSQCRTT-MSGCPD4306 A MSGCPD4306 MAY
   SI46314      OSP-DB Support XMLTABLE function
   SI46227      OSP-INCORROUT FETCH FIRST N ROW NOT RECOGNIZED
   SI46126      OSP-DB-F/QSQRCHK-MSGMCH1210 when sending a MSGSQ20058 during
   SI46055      OSP-DB-OTHER-UNPRED CCSID 1026 CONVERSION PROBLEM. QUOTE CHA
   SI45954      OSP-DB Internal maintenance
   SI45832      OSP-DB-OTHER-MSGSQL0203 REFERENCING A FIELD IN A JOIN USING
   SI45832      OSP-DB-OTHER SQL function not inlined when it has a duration
   SI45763      OSP-DB-OTHER-INCORROUT SQL ORDER BY ON CTE DOES NOT RETURN T
   SI45763      OSP-DB Looping in QSQRCHK procedure NODETYP when UDT is used
   SI45763      OSP-DB-MSGSQL0171 using graphic argument with EXTRACT built
   SI45676      OSP-F/QSQALTER-T/QSQALTER-MSGSQL0373 ALTER TABLE MSGSQL0373
   SI45665      OSP-DB-OTHER Fixes to improve performance and support DECFLO
   SI45580      OSP-DB-OTHER-UNPRED THE GREATER THAN 0 IS INCORRECTLY PROCES
   SI45495      OSP-DB-F/QSQRCHK-MSGMCH3601 CREATE TRIGGER with a VALUES sta
   SI45484      OSP-DB-OTHER-MSGSQL0204 MSGSQL0204 TRYING TO CREATE A TABLE
   SI45333      OSP-DB-OTHER-PERFM ENHANCEMENTS MADE TO RECOGNIZE STATEMENTS
   SI45059      OSP-DB-MSGSQL0401 derived table with duplicate short names
   SI45031      OSP-DB-OTHER-T/QSQXCUTEX/27868-MSGSQL0206 CREATE TRIGGER - S
   SI44957      OSP-DB-MSGSQL0204 replacement text has alias library not fil
   SI44840      OSP-DB-OTHER-F/QSQRCHK-MSGMCH1210 OSP-DB-OTHER-F/QSQRCHK -MS
   SI44840      OSP-DB-F/QSQRUN1-MSGSQL0101 CREATE TRIGGER
   SI44840      OSP-DB MSGSQL0206 F/QSQXCUTE T/QSQXCUTE
   SI44742      OSP-DB-MSGSQL0204 when an alias changes from local to remote
   SI44440      OSP-DB-OTHER-INCORROUT A QUERY WITH AT LEAST 2 TABLES MAY RE
   SI44440      OSP-DB-OTHER-INCORROUT A QUERY WITH AT LEAST 2 TABLES MAY RE
   SI44440      OSP-DB-MSGSQL0204 DROP TRIGGER HAS ERRLVL(30) IN RUNSQLSTM
   SI44440      OSP-DB A PART OF A TRIGGER WITH A WHILE LOOP BASED ON THE SQ
   SI44440      OSP-DB-F/QQQVFMT-MSGMCH3601 Global variable defined using a
   SI44440      OSP-DB-OTHER-UNPRED COLUMN HEADINGS NOT PROPAGATING
   SI43757      OSP-DB-INCORROUT CREATE FUNCTION should not allow ARRAY as p
   SI43739      OSP-DB-OTHER-F/QDBSIGEX-T/QCPGENIO-RC6-MSGCPF4019 CREATE OF
   SI43683      OSP-DB-OTHER-INCORROUT SQL FROM FILE NOT GETTING DATA FROM C
   SI43621      OSP-DB-OTHER- Queries that contain many CTEs and Unions may
   SI43391      OSP-DB-F/QSQRCHK-MSGMCH1210 Create view using VALUES and UNI
   SI43372      OSP-DB OBJECT NAME NOT CORRECT WHEN USING QGENOBJNAM
   SI43352      OSP-DB-OTHER-MSGSQL0913 SERVICEABILITY CHANGE
   SI42984      OSP-DB SQL CALL statement with a DLVALUE as one of the argum
   SI37859      OSP-DB Internal Maintenance
   SI42926      OSP-DB SPECIFY PROGRAM NAME ON CREATE TRIGGER
   SI42938      OSP-F/QSQPROC-T/QSQPROC-MSGSQL7032 STORED PROCEDURE COMPILE
   SI42249      SQL exception occurred calling trigger on long running job
   SI41934      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0206 MSGSQL0206 F/Q
   SI41517      OSP-DB-MSGSQL0204 Message when specifying alias name within
   SI41189      OSP-DB INTERNAL MAINTENANCE
   SI41189      OSP-DB-MSGSQL0204 QSQRCHK MERGE STATEMENT WITH GLOBAL VARIAB
   SI41170      OSP-DB-OTHER-F/QQQVALIDX/6578-MSGCPD4345 CREATE VIEW STMT RE
   SI41056      OSP-DB-MSGSQL0130 Host variables in select from insert with
   SI41056      OSP-DB-OTHER-INCORROUT INCORROUT FROM QUERY USING WHERE EXIS
   SI41050      OSP-DB-F/QSQROUTQ-MSGMCH1210 CALL with expressions and XML g
   SI40785      OSP-DB-F/QSQPREP-MSGSQL0901 Prepare CALL statement using ? f
   SI40783      OSP-SQL UDF NOT INLINED IF BEGIN AND END IS USED IN THE UDF
   SI40783      OSP-DB-MSGSQL0204 Alias Not Found Within CREATE TRIGGER or C
   SI40783      OSP-DB-MSGSQL0171 VARCHAR_FORMAT does not allow CLOB or DBCL
   SI40783      OSP-DB-MSGMCH3203 Select with ORDER BY position and ARRAY_AG
   SI40512      OSP-DB Parameter marker extension iteration 2
   SI40408      OSP-DB-MSGMCH3601 QSQPARSP DYNAMIC CREATE TRIGGER
   SI40326      OSP-DB Wrong string returned for XMLELEMENT on IGC system
   SI40246      OSP-DB Allow both operands of the bit functions to be parame
   SI40217      OSP-DB-MSGCPD4302 Grouping sets match select list expression
   SI40110      OSP-INCORROUT GARBAGE APPEARED ON THE SQL SCRIPT SCREEN, WHE
   SI40027      SQL-DB-MSGCPF4102 DEBUG VIEW NOT FOUND FOR SQL TRIGGER
   SI39994      SQL-DB-PERFM SQL ROUTINES GENERATE C FOR SET STATEMENTS WITH
   SI39937      OSP-DB Parameter marker extension iteration 1
   SI39937      OSP-DB-MSGCPD4324 MERGE STATEMENT WITH HOST VARIABLES
   SI39937      OSP-DB Internal Maintenance
   SI39937      OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-RC15-MSGSQL7008 RC15 -COM
   SI39513      OSP-DB Handle unary plus with parameter marker
   SI39419      SQL-CMPL-MSGCZM0022 CREATE PROCEDURE WITH RESULT SETS
   SI39202      F/QQQVALID-MSGCPD4345-MOD/QQQVALID F/QQQVALID-MSGCPD4345-MOD
   SI39051      OSP-DB-OTHER-MSGCZM0045 COMPILE USING A VARIABLE WITH NOT NU
   SI39051      OSP-DB-OTHER-F/QDBCHGFI-T/QSQLABEL-MSGCPF327E IASP VARY ON F
   SI38976      OSP-DB DESC ignored for derived key index columns
   SI38736      OSP-DB-MSGSQL0636 RANGE PARTITION WITH UX'' LITERALS
   SI38708      OSP-DB-OTHER-MSGSQL0312 CRTSQLRPGI FAILS WITH SQL0312 ON THE
   SI38600      OSP-DB-OTHER-INCORROUT SIZE OF RESULT FIELD FROM COMMON TABL
   SI38591      OSP-DB-OTHER-F/QQQVALID-T/QQQVALID-MSGMCH1210 QUERY FAILS WI
   SI38521      OSP-DB-OTHER-F/QQQUDFHL-T/QSQRUN3-MSGCPF426A INVOKING UDFS T
   SI38521      OSP-DB-MSGSQL0136 issued for order by > 32766
   SI38521      OSP-DB-MSGSQL0204 VARIABLE NOT ALLOWED WHEN IT SHOULD BE
   SI38093      OSP-DB Merge with update sub-statement not working with para
   SI37950      OSP-F/QSQBLQDT-T/QSQBLQDT-MSGSQL0205 MSGSQL0205 F/QSQBLQDT T
   SI37914      SQL-CMPL CRTSQLCBLI DOES NOT SUPPORT COMP-5 DATA TYPE
   SI37636      OSP-DB-MSGSQL0204 CREATE VIEW with long schema name in IASP
   SI37487      OSP-DB-MSGSQL0117 SET STATEMENT WHEN TABLE DOESN'T EXIST
   SI37382      OSP-DB-MSGCPD4302 when array subscript within array subscrip
   SI37247      OSP-DB-MSGSQL0901 CREATE ENCODED VECTOR INDEX on identity co
   SI36969      OSP-DB Job hangs
   SI36768      OSP-DB-MSGMCH3203 IN QSQRCHK FOR CREATE VARIABLE
   SI36645      OSP-DB-MSGMCH0601 LDAP fails to start MSGMCH0601 in QSQRCHK

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE67008
Superseded by:......................View fix details for PTF SI68929
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................NONE


IBM 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, 2018, 2019, 2020 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