PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-INCORROUT SQLCLI RETRIEVE CLOB DATA IN UTF-16
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770SS1 710 SI51371 00/00 0000
PRE 5770SS1 710 SI40869 00/00 0000
CO 5770SS1 710 SI39897 00/00 0000
CO 5770SS1 710 SI39896 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
DIST 5770SS1 710 SI50365 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
-----------------------------------------------
The SQLGetCol and SQLGetData APIs do not function correctly when
retrieving data as SQL_WCHAR from a CLOB column with an EBCDIC
CCSID.
The following problems were encountered.
1. Each partial chunk is data is null terminated, with
the null termination overwriting retrieved data. The
documentation for SQLGetCol explicitly states "If the
application is retrieving the data in multiple chunks,
the null-terminating byte is only added to the last
portion of data."
2. The value returned in pcbValue is the number of
CLOB bytes, not in the number of bytes needed for
WCHAR data.
CORRECTION FOR APAR SE67415 :
-----------------------------
These two problems have been correctly when retrieving WCHAR
data from a
EBCDIC CLOB column.
CIRCUMVENTION FOR APAR SE67415 :
--------------------------------
None.
Activation Instructions
None.
Special Instructions
None.
Default Instructions
THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.
Supersedes
PTF/FIX NO(S). APAR TITLE LINE
-------------- ------------------------------------------------------------
SI64357 OSP-DB-OTHER-F/QSQCLI-T/QSQCLI-RC14-MSGSQ99999 FETCHING ROWS
SI63412 OSP-DB-OTHER-F/QSQCLI-MSGMCH0601 SQLEX
SI62839 OSP-DB-MSGMCH3601-T/QSQSFIRT Backup to cloud
SI57585 OSP-DB-CLI-MSGSQ99999 Spurious message from SQLFreeEnv cause
SI62068 OSP-DB-OTHER-F/QSQCLI-MSGMCH0601 SQLSETCONNECTATTR setting S
SI60362 OSP-DB-OTHER-F/QSQCLI-T/QP2USER2-RC21-MSGSQ99999 PHP/ZEND-CL
SI59568 OSP-DB-OTHER-F/QSQCLI-MSGSQ99999 SQLCLI API SQLGETLENGTH RET
SI59080 OSP-DB-OTHER-F/QSQCLI-T/QSQCLI-MSGSQ99999 QSQCLI SQ99999 WHE
SI58279 OSP-DB SP/QSQCLI-MSGSQ99999-MOD/SQLSCA-PRCS/9-RIDS/SQLSETCON
SI57513 OSP-DB-MSGSQL0842 being issued incorrectly
SI57270 OSP-DB-OTHER-F/QSQCLI-T/QSQCLI-MSGMCH3601 SQLCON
SI57014 OSP-DB INTERNAL MAINTENANCE
SI57076 OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
SI56899 OSP-DB-OTHER-INCORROUT RESULTS ARE NOT CORRECT FOR PROCEDURE
SI56792 OSP-DB-OTHER-F/QSQCLI-RC10-MSGSQ99999 WHEN A STORED PROCEDUR
SI56584 OSP-DB-OTHER-INCORROUT CLI SQLError rc -1
SI56279 OSP-DB-OTHER-INCORROUT RESULTS ARE NOT CORRECT FOR PROCEDURE
SI55990 F/SQLTR-MSGMCH3601 BRMS BATCH JOB FAILING WITH MCH3601
SI55762 OSP-DB-OTHER-F/QSQCLI-T/QSQCLI-MSGMCH3601 INVALID CLI HANDLE
SI55311 OSP-HASWTRSC-F/QTNROLLB-T/QSQCLI-MSGCPF83D0 MCH3402 - CPF426
SI54543 OSP-DB-OTHER-THREADS-UNPRED INTERNAL ERROR: CLI SIGNALLED AN
SI54035 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI53445 OSP-DB Internal Maintenance
SI53027 OSP-DB-MSGSQL0335 graphic type in cli
SI52792 OSP-DB-OTHER-UNPRED SQL CLI APPLICATION HANGS
SI51373 OSP-DB CLI failure to bind DBCLOB locator from SQLStatistics
SI51345 OSP-DB-MSGSQL0804 SQLEX CLI FAILURE C NULL TERM AND FIXED LE
SI50720 OSP-DB-OTHER-INCORROUT SQLPUTDATA WITH SQL_ATTR_UTF8
SI50589 OSP-DB-OTHER-INCORROUT CLI RETURNS NULLS INSTEAD OF NUMERIC
SI50572 OSP-DB-OTHER-F/QSQCLI-T/QSQCLI-MSGMCH3601 AFTER THE JOB CALL
SI50366 OSP-DB-OTHER-INCORROUT SQLSETENVATTR SQL_ATTR_JOB_SORT_SEQUE
SI50226 OSP-DB-MSGMCH0602-T/QSQROUTX using CLOB data
SI50025 OSP-DB-OTHER-INCORROUT SQLPUTDATA WITH SQL_ATTR_UTF8 INCORRE
SI49817 OSP-DB-OTHER-UNPRED CLI SERVICEABILITY ENHANCMENT
SI49768 OSP-DB-OTHER-INCORROUT SQL CLI PROBLEMS WITH CCSID 1200 DATA
SI49603 OSP-DB CLI DBCLOB PARAMETER AND SQL_NTS
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 |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770SS1 |
APAR Fixed.......................... | View details for APAR SE67415 |
Superseded by:...................... | View fix details for PTF SI67505 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | NONE |
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 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:
26 July 2017