SI65795 - OSP-DB-OTHER-F/QSQRLEX-T/QSQRLEX-MSGMCH1210 LONG COMMENT

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI54547   00/00    0000
PRE  5770SS1  710  SI54531   00/00    0000
CO   5770SS1  710  SI62819   00/00    0000
CO   5770SS1  710  SI62820   00/00    0000
CO   5770SS1  710  SI62822   00/00    0000
CO   5770SS1  710  SI49110   00/00    0000
CO   5770SS1  710  SI49111   00/00    0000
CO   5770SS1  710  SI47393   00/00    0000
CO   5770SS1  710  SI43016   00/00    0000
CO   5770SS1  710  SI43018   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

-------------------------------------------------
When an SQL comment with more than 64K - 1 characters is
encountered, the SQL parser may fail with an MCH1210 message
(MSGMCH1210).

CORRECTION FOR APAR 'SE68034' :
-------------------------------
SQL comments are limited to 64K - 1 characters.  When an SQL
comment is encountered which is longer than this limit, an
SQL0011 (MSGSQL0011) message should be generated.  The SQL
parser is being modified to correctly generate an SQL0011
(MSGSQL0011) message when a comment with 64K or more characters
is encountered.

CIRCUMVENTION FOR APAR 'SE68034' :
----------------------------------
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
--------------  ------------------------------------------------------------
   SI62823      OSP-DB INTERNAL MAINTENANCE
   SI60207      OSP-DB INFRASTRUCTURE
   SI56798      OSP-DB RUNSQLSTM error for obfuscated procedure containing c
   SI55170      OSP-DB-OTHER-F/QSQRXLTR-T/QSQRXLTR-MSGMCH3601 WHEN QRWOPTION
   SI54628      OSP-DB INTERNAL MAINTENANCE
   SI54556      SQL-CMPL PIPELINED TABLE FUNCTION SUPPORT
   SI53957      OSP-DB-MSGMCH3601 QSQRXLTR when running heavy SQL workload
   SI47599      OSP-DB-PERFM INTERNAL MAINTENANCE
   SI47550      OSP-DB-MSGCPF9898 SQL CREATE PROCEDURE statement in RUNSQL
   SI47394      OSP-DB INTERNAL MAINTENANCE
   SI46044      OSP-DB Internal maintenance
   SI43017      OSP-DB INTERNAL MAINTENANCE
   SI38759      OSP-DB Use 65535 for dynamic sql when it is the job ccsid
   SI38089      OSP-DB XML does not work in ISQL when job ccsid is 65535
   SI37051      OSP-DB-MSGMCH4421-T/QSQRXLTR
   SI53627      OSP-DB-MSGSQL0525 CREATE PROCEDURE statement in c program
   SI52499      OSP-DB EDITING A SQLCBL PGM INCORRECTLY REPORTS A SYNTAX ERR
   SI50949      OSP-DB-MSGSQL5001 Column qualified with RDB alias name
   SI50699      OSP-DB INTERNAL MAINTENANCE
   SI49106      OSP-DB-OTHER-MSGSQL0104 WHEN TRYING TO CREATE A TRIGGER USIN
   SI48785      OSP-DB-OTHER-F/QSQTRG-T/QSQTRG-MSGMCH1210 CREATE TRIGGER FAI
   SI48139      OSP-DB INTERNAL MAINTENANCE
   SI44416      OSP-DB-MSGCPD4308 QQQVFMT SQL routine with XML variable usin
   SI42179      OSP-DB-MSGCPF2499 RUNSQLSTM with CL command containing /*all
   SI41835      OSP-DB-OTHER-INCORROUT UNICODE CONSTANTS THAT END IN CHARACT
   SI41342      OSP-DB INTERNAL MAINTENANCE
   SI40218      OSP-DB-MSGCPD4324 MERGE statement with many host variables
   SI40111      OSP-INCORROUT GARBAGE APPEARED ON THE SQL SCRIPT SCREEN, WHE
   SI37456      OSP-DB-MSGMCH1210 QSQRLEX when very long string
   SI37147      OSP-DB Syntax error when comma decimal point used
   SI36817      OSP-DB Arrays over DRDA
   SI36771      OSP-DB Arrays over DRDA

Summary Information

System i Support