SI49603 - OSP-DB CLI DBCLOB PARAMETER AND SQL_NTS

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI40869   00/00    0000
CO   5770SS1  710  SI39897   00/00    0000
CO   5770SS1  710  SI39896   00/00    0000
CO   5770SS1  710  SI39898   00/00    0000
CO   5770SS1  710  SI39899   00/00    0000
CO   5770SS1  710  SI39900   00/00    0000
CO   5770SS1  710  SI39902   00/00    0000
CO   5770SS1  710  SI39904   00/00    0000
CO   5770SS1  710  SI39905   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 using CLI, a DBCLOB parameter with a length specified as
SQL_NTS is not correctly processed.

CORRECTION FOR APAR SE55081 :
-----------------------------
CLI has been corrected to handle a length of SQL_NTS for DBCLOB
parameters.

CIRCUMVENTION FOR APAR SE55081 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


None.

********************************************************************
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 SI49280:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI49223:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI49024:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI48678:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI48099:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI47722:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI47696:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI47409:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI47248:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI46915:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI46817:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI46760:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI46709:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI46313:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI45862:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI45491:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI45015:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI43864:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI43406:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI43149:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI42837:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI42751:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI42416:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI42282:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI42110:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI42083:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI42042:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI41640:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI41209:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI40907:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI40870:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI40765:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI40502:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI40066:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI40016:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI39917:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI39903:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI39831:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI39767:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI39712:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI39470:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI39288:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI38661:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI38539:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI38402:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI38124:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI37818:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI37679:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI37303:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI37245:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI37141:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI37053:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI36715:
================================================


None.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI36478:
================================================


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI49478      OSP-DB-OTHER-F/QSQCLI-T/QSQCLI-MSGMCH3601 F/QSQCLI EXECUTING
   SI49280      OSP-DB-OTHER-INCORROUT MSGFPC1400 MSGFOC1405 MSGFOC1400 MSGF
   SI49223      OSP-INCORROUT INSERT INTO DBCLOB VIA LOB_LOCATOR (CLI) IGNOR
   SI49024      OSP-DB-OTHER-F/QSQCLI-T/QP2USER2-RC14-MSGSQ99999 SQ99999 RC1
   SI48678      OSP-DB-OTHER-F/SQLFT-T/SQLFT-MSGMCH3601 SQLFETCH - POINTER N
   SI48678      OSP-DB-MSGSQL0519 CLI USING REMOTE SYSTEM
   SI48099      OSP-DB-OTHER-INCORROUT SQLGetSubstring
   SI47722      OSP-DB-OTHER-F/QSQCLI/SQLSSA-MSGMCH3601
   SI47722      OSP-DB-OTHER Incorrect CLI Handle Count in Health Center
   SI47722      OSP-DB-OTHER-MSGSQL9999-RC14 MAXIMUM CLI HANDLES ALLOCATED
   SI47696      OSP-DB-MSGSQL0804 on SQLFetch CLI Call
   SI47409      OSP-DB-INCORROUT CLI changing parameter indicators
   SI47409      OSP-OTHER-F/QSQCLI2-T/QSQCLI2-MSGMCH3601 APPLICATION USING C
   SI47248      OSP CLIENT IS TESTING USING THE SQL CLI SQLGETCOL AND ONLY G
   SI46915      OSP-DB-OTHER SYSPROC.XSR_COMPLETE FAILS USING 64-BIT JVM
   SI46915      OSP-DB-PERFM SQLAllocHandle Performance
   SI46817      OSP-DB-MSGSQL0335 graphic type in cli
   SI46760      OSP-DB hold cursors get closed in cli
   SI46709      OSP-DB-MSGMCH5003-T/QSQVATTR with graphic type
   SI46313      OSP-DB-OTHER-INCORROUT MSGSQL0502 IN LONG RUNNING QSQSRVR JO
   SI46135      OSP-DB-OTHER-INCORROUT Result Set not returned from Java Sto
   SI45862      OSP-DB-OTHER-RC1-MSGSQL7049 MSGSQL7049 RC1
   SI45862      OSP-DB-MSGMCH3601-T/SQLED
   SI45862      OSP-DB-MSGSQL0190 CLI Binding Binary
   SI45862      OSP-DB-OTHER-PERFM NATIVE JDBC PERFORMANCE CLI SYNC TOKEN
   SI45862      OSP-DB-MSGMCH3603-T/QSQVATTR with cli
   SI45862      OSP-DB-MSGMCH3601 T/F F_MAPFLDS when using Native driver and
   SI45491      OSP-DB-QRWTDSCD/FNDSQLPAS during DRDA DESCRIBE
   SI45015      OSP-DB-OTHER-UNPRED QSQSRVR JOBLOGS ALWAYS CREATED IF AN SQL
   SI44432      OSP-DB CLI PARAMETER CCSID
   SI43864      OSP-DB-MSGSQ30000-F/QRWSEXEC with Z/OS Application Server
   SI43406      OSP-DB-OTHER-F/QSQCLI-T/QSQCLI-MSGMCH3402 SQLDISCONNECT
   SI43149      OSP-DB-OTHER-INCORROUT OUTPUT PARAMETERS ARE NOT RETURNED NU
   SI42837      OSP-DB-MSGMCH3601-T/SQLPRD in long running job
   SI42751      OSP-DB Internal Maintenance
   SI42416      OSP-DB-OTHER-F/QSQCLI-T/QSQCLI-MSGSQ99999 USING SQLGETLENGTH
   SI42282      OSP-DB VARCHAR data is not translated corrrectly
   SI42282      OSP-DB-OTHER-MSGSQL7049 MSGSQL7049 MAY OCCUR WHEN USING SQL
   SI42110      OSP-DB-OTHER-PERFM TEMPORARY STORAGE FOR LOB LOCATORS NOT FR
   SI42110      OSP-DB-OTHER-INCORROUT FAILED JDBC CONNECTION PREVENTS NEW C
   SI42083      OSP-DB-MSGSQL0805 with CLI METADATA over drda
   SI42083      OSP-DB SQLPROCEDURECOLUMNS RETURNS INCORRECT SQL_DATA_TYPE V
   SI42083      OSP-DB-OTHER-F/QSQCLI-T/QSQCLI-MSGMCH3601 USING RTVDIRINF
   SI42083      OSP-DB-OTHER-SAP400-RC0-MSGSQ99999
   SI42042      OSP-DB SQL0452 RC4 FOR A DB2 CLI PGM TO RETRIEVE MULTIPLE RO
   SI42042      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-RC3-MSGSQL0452 SQLC PROGRAM
   SI41640      OSP-DB-MSGMCH3601-F/QSQCLI/SQLGI
   SI41209      OSP-DB-PERFM CLI SYNC TOKEN CONTENTION
   SI40907      OSP-DB-UNPRED MCH3402 from QSQCLI (issue 44609)
   SI40870      OSP-DB SQLCancel userid wrong
   SI40765      OSP-DB-UNPRED SQLDisconnect preventing disconnect in warning
   SI40502      OSP-DB CLI errors during BRMS IASP saves
   SI40066      OSP-DB CLI Return Column CCSID
   SI40066      OSP-DB-OTHER-MSGSQ99999-F/SQLPR-RC0
   SI40016      OSP-DB SQL0805 SAVING IASP LIBRARY WITH BRMS IF VOLUMES ARE
   SI39917      OSP-DB-MSGSQL0189 REUSING JDBC STATEMENT
   SI39917      OSP-DB-MSGSQL0901 T/SQLAH
   SI39903      OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC
   SI39831      OSP-DB no data returned in clob output parm
   SI39767      OSP-DB-MSGMCH3601 F/SQLEX
   SI39712      OSP-DB-UNPRED BRMS remote connections preventing IASP switch
   SI39470      OSP-DB-UNPRED Java stored procedure result sets failing over
   SI39288      OSP-DB-OTHER PUT BACK CODE TO CLOSE *NONE CURSORS DURING COM
   SI38661      OSP-DB Internal Maintenance
   SI38539      OSP-DB Internal Maintenance
   SI38402      OSP-DB-MSGMCH3601 with null data binding
   SI38124      OSP-DB- incorrect describe logic
   SI37818      OSP-DB-MSGMCH3601-F/QSQCLI/SQLEX
   SI37679      OSP-DB Internal Maintenance
   SI37303      OSP-DB cli indicator problem
   SI37245      OSP-DB-MSGMCH3601-F/QSQCLI/SQLED
   SI37141      OSP-DB Internal Maintenance
   SI37053      OSP-DB-OTHER-MSGSQL0804 ONDEMAND APP USING UNBOUND COLUMNS
   SI36715      OSP-DB-MSGMCH1210 F/QSQCLI/SQLDS
   SI36478      OSP-DB LDAP server performance

Summary Information

System i Support