IBM Support

SI65128 - OSP-DB-OTHER-INCORROUT SQLCLI RETRIEVE CLOB DATA IN UTF-16

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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


System 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 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.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"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":""}}]

Document Information

Modified date:
26 July 2017