SI42984 - OSP-DB SQL CALL statement with a DLVALUE as one of the argum

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

IBM i Support