PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB SQL CALL statement with a DLVALUE as one of the argum
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770SS1 710 SI39992 00/00 0000
PRE 5770SS1 710 SI39724 00/00 0000
PRE 5770SS1 710 SI39418 00/00 0000
CO 5770SS1 710 SI42965 00/00 0000
CO 5770SS1 710 SI42983 00/00 0000
CO 5770SS1 710 SI42982 00/00 0000
CO 5770SS1 710 SI43111 00/00 0000
CO 5770SS1 710 SI42927 00/00 0000
CO 5770SS1 710 SI42953 00/00 0000
CO 5770SS1 710 SI42928 00/00 0000
CO 5770SS1 710 SI42929 00/00 0000
CO 5770SS1 710 SI42930 00/00 0000
CO 5770SS1 710 SI41051 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
-----------------------------------------------
An SQL CALL statement with DLVALUE as an argument does not work.
CALL proc1 (DLVALUE(:mypath));
CORRECTION FOR APAR SE47135 :
-----------------------------
Handling DLVALUE as an argument for CALL has been fixed.
CIRCUMVENTION FOR APAR SE47135 :
--------------------------------
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
-------------- ------------------------------------------------------------
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 SE47135 |
Superseded by:...................... | View fix details for PTF SI68929 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | C1270710 |
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.
Was this topic helpful?
Document Information
Modified date:
13 May 2011