IBM Support

SI45031 - OSP-DB-OTHER-T/QSQXCUTEX/27868-MSGSQL0206 CREATE TRIGGER - S

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-T/QSQXCUTEX/27868-MSGSQL0206 CREATE TRIGGER - S


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI44576   00/00    0000
PRE  5770SS1  710  SI39992   00/00    0000
CO   5770SS1  710  SI44743   00/00    0000
CO   5770SS1  710  SI44202   00/00    0000
CO   5770SS1  710  SI43682   00/00    0000
CO   5770SS1  710  SI43619   00/00    0000
CO   5770SS1  710  SI43373   00/00    0000
CO   5770SS1  710  SI42965   00/00    0000
CO   5770SS1  710  SI42983   00/00    0000
CO   5770SS1  710  SI43111   00/00    0000
CO   5770SS1  710  SI42927   00/00    0000
CO   5770SS1  710  SI42928   00/00    0000
CO   5770SS1  710  SI42930   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

-----------------------------------------------
CREATE TRIGGER - SQL trigger - fails with msgSQL0206 f/QSQXCUTE
t/QSQXCUTE - "Column or global variable XXX not found."

CORRECTION FOR APAR SE49807 :
-----------------------------
The generated trigger code used the wrong label on the variable.
The label code has been corrected.

CIRCUMVENTION FOR APAR SE49807 :
--------------------------------
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 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
--------------  ------------------------------------------------------------
   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 SE49807
Superseded by:......................View fix details for PTF SI68929
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C2115710


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.

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

Document Information

Modified date:
01 December 2011