IBM Support

SI69939 - OSP-DB-OTHER-F/QSQRPARS-T/QSQRPARS-MSGMCH1210 SYNTAX CHECK S

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-F/QSQRPARS-T/QSQRPARS-MSGMCH1210 SYNTAX CHECK S


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R2M0    SI67938   00/00    0000
PRE  5770SS1  V7R2M0    SI67827   00/00    0000
PRE  5770SS1  V7R2M0    SI65498   00/00    0000
PRE  5770999  V7R2M0    MF63305   00/00    0000
PRE  5770999  V7R2M0    MF63360   00/00    0000
PRE  5770SS1  V7R2M0    SI64003   00/00    0000
PRE  5770SS1  V7R2M0    SI64021   00/00    0000
PRE  5770SS1  V7R2M0    SI64015   00/00    0000
PRE  5770SS1  V7R2M0    SI64022   00/00    0000
PRE  5770SS1  V7R2M0    SI62505   00/00    0000
PRE  5770SS1  V7R2M0    SI61631   00/00    0000
PRE  5770SS1  V7R2M0    SI61881   00/00    0000
PRE  5770SS1  V7R2M0    SI59968   00/00    0000
PRE  5770SS1  V7R2M0    SI58904   00/00    0000
PRE  5770SS1  V7R2M0    SI56897   00/00    0000
PRE  5770SS1  V7R2M0    SI56773   00/00    0000
PRE  5770SS1  V7R2M0    SI56724   00/00    0000
PRE  5770SS1  V7R2M0    SI56936   00/00    0000
PRE  5770SS1  V7R2M0    SI56969   00/00    0000
PRE  5770999  V7R2M0    MF59391   00/00    0000
CO   5770SS1  V7R2M0    SI65783   00/00    0000
CO   5770SS1  V7R2M0    SI65782   00/00    0000
CO   5770SS1  V7R2M0    SI58742   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

-----------------------------------------------
The syntax check SQL statement (QSQCHKS) API may fail with an
MCH1210 message (MSGMCH1210) when checking the syntax of an SQL
statement.  This may occur on a direct call to QSQCHKS or may
occur within the Source Entry Utility (SEU) or IBM Rational
Developer for i for an embedded SQL statement.

CORRECTION FOR APAR SE71249 :
-----------------------------
The syntax check SQL statement (QSQCHKS) API is changed to
correctly handle SQL statements and not fail with an MCH1210
message.

CIRCUMVENTION FOR APAR SE71249 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI69869      OSP-DB-MSGMCH3601-QSQRUN3 when more than 32700 literals in I
   SI68819      OSP-DB-OTHER-F/QSQRUN1X/11752-MSGSQL0199 EXISTING SQL STMT F
   SI68775      OSP-DB-MSGSQL0199 Create table with remote subselect with CT
   SI68579      OSP-MSGSQL0199 SQL STATEMENT WITH RESERVED WORDS USED AS COR
   SI68489      OSP-DB LISTAGG in Create table AS does not return correct in
   SI68424      OSP-DB-MSGSQL0104 Obfuscating trigger containing SELECT * sy
   SI68315      OSP-DB INTERNAL MAINTENANCE
   SI68253      OSP-DB-OTHER-MSGSQL0340 MCH0601 EDITING SQLRPGLE
   SI68075      OSP-DB INTERNAL MAINTENANCE
   SI67939      OSP-DB Allow literal reuse for some Select from INSERT state
   SI67881      OSP-DB UNIQUE KEYS clause for JSON_OBJECT and JSON_OBJECTAGG
   SI67861      OSP-DB-MSGSQL0143 Confusing error for CREATE INDEX syntax er
   SI67861      OSP-DB SQL CONNECT does not allow variable for password
   SI67861      OSP-DB SQL DELETE USING LIMIT X OFFSET X WITH NC IS NOT LIMI
   SI66945      OSP-DB INFRASTRUCTURE
   SI66896      SQL-RUN-UNPRED PROBLEM WITH INTERACTIVE SQL PARSER CAUSES WH
   SI66405      OSP-DB-OTHER ON R730 SYSTEM CRTSQLRPGI TGTRLS(V7R1M0) MAY FA
   SI66405      OSP-DB-OTHER-MSGSQL7906 TGTRLS(V7R1M0) AND LIMIT KEYWORD
   SI66405      OSP-DB INFRASTRUCTURE
   SI66121      OSP-DB COMMENT ON PACKAGE sets default schema name wrong
   SI65990      OSP-DB QSYS2.HISTORY_LOG_INFO AND QSYS2.DISPLAY_JOURNAL PARA
   SI65860      OSP-DB INTERNAL MAINTENANCE
   SI65809      OSP-DB INTERNAL MAINTENANCE
   SI65803      OSP-DB-OTHER-F/QSQRLEX-T/QSQRLEX-MSGMCH1210 LONG COMMENT
   SI65781      OSP-DB INTERNAL MAINTENANCE
   SI65718      OSP-DB INTERNAL MAINTENANCE
   SI65098      OSP-DB-OTHER-THREADS-MSGMCH1210 SQL STATEMENT GENERATES SQL0
   SI64790      OSP-DB-OTHER USING SEU AND A PROGRAM WITH SQL LIMIT CLAUSE W
   SI64535      OSP-DB JSON_TABLE doesn't return nested column data in CCSID
   SI64390      OSP-DB-OTHER-F/QSQRPARS-T/QSQRPARS SQL FAILURE
   SI64299      OSP-DB INTERNAL MAINTENANCE
   SI64189      OSP-DB INTERNAL MAINTENANCE
   SI64018      OSP-DB-OTHER-F/QQQVFMT-T/QSQRCHK-MSGCPF4278 SQL ROUTINE FAIL
   SI63695      OSP-DB INTERNAL MAINTENANCE
   SI63618      OSP-DB-OTHER SQL FUNCTION WITH CONTAINS SQL SHOULD NOT EXECU
   SI63618      OSP-DB-OTHER-F/QSQCHKS-T/QSQCHKS-MSGMCH3601 SYNTAX CHECK SQL
   SI57909      OSP-DB INTERNAL MAINTENANCE
   SI54401      OSP-DB INTERNAL MAINTENANCE
   SI62765      OSP-DB INTERNAL MAINTENANCE
   SI62628      OSP-DB INTERNAL MAINTENANCE
   SI62583      OSP-DB INTERNAL MAINTENANCE
   SI62509      OSP-DB INTERNAL MAINTENANCE
   SI62297      OSP-DB INTERNAL MAINTENANCE
   SI62059      OSP-DB INFRASTRUCTURE
   SI61879      OSP-DB INTERNAL MAINTENANCE
   SI61223      OSP-DB Restrict RRN function in mask or permission
   SI60593      OSP-DB INFRASTRUCTURE
   SI60197      OSP-DB Allow FOR UPDATE clause with OFFSET and FETCH N ROWS
   SI60188      OSP-DB INFRASTRUCTURE
   SI60053      OSP-DB INTERNAL MAINTENANCE
   SI59713      OSP-DB-OTHER-F/DBOPEXPRQDS-T/QQQOOODBOP-MSGMCH3601 MCH3601 F
   SI59450      OSP-DB INTERNAL MAINTENANCE
   SI59351      OSP-DB INTERNAL MAINTENANCE
   SI59064      OSP-DB INFRASTRUCTURE
   SI58997      OSP-DB INFRASTRUCTURE
   SI58906      OSP-DB INFRASTRUCTURE
   SI58741      OSP-DB INFRASTRUCTURE
   SI58186      OSP-DB Allow extended indicators in dynamic sq in sql routin
   SI58102      OSP-DB INTERNAL MAINTENANCE
   SI57932      OSP-DB No return value allowed for compound dynamic statemen
   SI57574      OSP-DB-OTHER-LOOP CREATE PROCEDURE PROMPT LOCKS SQL SESSION.
   SI57541      OSP-DB RUNSQLSTM error for obfuscated procedure containing c
   SI57425      OSP-DB-INCORROUT TIMESTAMP PRECISION LOST
   SI57417      OSP-DB MSGSQL0199 when using INLINE as correlation name
   SI57123      OSP-DB Support CREATE OR REPLACE TABLE
   SI56939      OSP-DB Internal Maintenance
   SI56696      OSP-DB-OTHER-MSGSQL7906 EXECUTE IMMEDIATE FAILS COMPILE IN S
   SI56644      OSP-DB-OTHER-MSGSQL0180 ON PROGRAM USING PARAMETER MARKER CO
   SI56239      OSP-DB INTERNAL MAINTENANCE
   SI56191      OSP-DB-OTHER-RC1-MSGCPD4365 MSGCPD4365 RC1
   SI56191      OSP-F/QSQDDL1-T/QSQDDL1-MSGMCH1210 RUNSQLSTM FAILS WITH MCH1
   SI56096      OSP-DB INTERNAL MAINTENANCE
   SI55960      SQL-CMPL INCREASE MAXIMUM NUMBER OF FUNCTION PARAMETERS
   SI55496      OSP-DB-OTHER-MSGSQL9001 CREATE TRIGGER FAILS ON MERGE
   SI55281      OSP-DB Allow UPDATE statement reuse when contains special re
   SI55208      OSP-DB-OTHER-F/QSQRXLTR-T/QSQRXLTR-MSGMCH3601 WHEN QRWOPTION
   SI54682      SQL-CMPL PIPELINED TABLE FUNCTION SUPPORT
   SI54682      OSP-DB INTERNAL MAINTENANCE
   SI54088      OSP-DB-MSGMCH3601 QSQRXLTR when running heavy SQL workload
   SI53689      OSP-DB-MSGCPD4324 QQQVSEL Global variable and NOT IN predica
   SI53628      OSP-DB-MSGSQL0525 CREATE PROCEDURE statement in c program
   SI53501      OSP-DB INTERNAL MAINTENANCE
   SI53446      OSP-DB INTERNAL MAINTENANCE
   SI53362      OSP-MSGSQL0312 STORED PROCEDURE RUNNING INSERT W/SUBSELECT W
   SI52898      OSP-DB Support OLD and NEW as trigger correlation names
   SI52748      OSP-DB Internal maintainence
   SI52605      OSP-DB Internal maintenance
   SI52534      OSP-DB EDITING A SQLCBL PGM INCORRECTLY REPORTS A SYNTAX ERR
   SI52336      OSP-DB Internal maintainence
   SI52194      OSP-DB Internal maintainence
   SI51928      OSP-DB Internal maintainence
   SI51822      OSP-DB INTERNAL MAINTENANCE
   SI51752      OSP-DB INTERNAL MAINTENANCE
   SI51683      OSP-DB INTERNAL MAINTENANCE
   SI51469      OSP-DB INTERNAL MAINTENANCE
   SI51228      OSP-DB MSGCPD439A RC8 F/QQQVFMT T/QSQRUN3 / MSGSQL0171

Summary Information

System..............................i
Models..............................
Release.............................V7R2M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE71249
Superseded by:......................
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C9297720


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

[{"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":"V7R2M0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16F","label":"PTF Cover Letters - IBM i 7.2 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R2M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
28 August 2019