A fix is available
APAR status
Closed as program error.
Error description
Receive SQLCODE -804 when a CHAR field is defined to a stored procedure and in the CALL statement.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All QMF for TSO/CICS V10 and V11 users * * who CALL stored procedures. * **************************************************************** * PROBLEM DESCRIPTION: If a CHAR parameter in a CALL to a * * stored procedure was represented by * * a global variable, the CALL could * * fail with SQLCODE: -804 * * SQLERRM: 09 "Invalid length for input * * variable." * **************************************************************** * RECOMMENDATION: * **************************************************************** The length of CHAR parameters being passed to DB2 in a stored procedure CALL was being incorrectly calculated if the parameter was represented by a global variable.
Problem conclusion
QMF code has been amended to determine the correct length of parameters.
Temporary fix
Comments
ž**** PE14/04/24 FIX IN ERROR. SEE APAR PI16714 FOR DESCRIPTION
APAR Information
APAR number
PM96192
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-08-30
Closed date
2013-11-01
Last modified date
2014-05-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI12043 UI12044 UI12111
Modules/Macros
DSQDCALL DSQDCPAR DSQDCVAL DSQGPSQM DSQGPSQS DSQGPSQX DSQHPSQM DSQHPSQS DSQIPSQM DSQIPSQS DSQIPSQX
Fix information
Fixed component name
QMF-QUERY MGMT
Fixed component ID
566872101
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
06 May 2014