A fix is available
APAR status
Closed as program error.
Error description
BROKER FAILS TO MATCH SYBASE STORED PROCEDURE WHEN "AS" KEYWOR IS USED IN COMMENTS
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of WebSphere Message Broker v6.0 who * * call Sybase ASE stored procedures. * **************************************************************** * PROBLEM DESCRIPTION: A call to a Sybase ASE stored * * procedure from within a message flow * * fails with message BIP2921E: The * * procedure 'insert1' with 'insert2' * * parameters could not be matched with * * a corresponding Database stored * * procedure. * **************************************************************** * RECOMMENDATION: * **************************************************************** If a call is made to a Sybase ASE stored procedure from within a message flow, and that stored procedure contains the word "AS" embedded in a comment line or in a comment block, the call fails with message BIP2921E. The Sybase ASE ODBC driver informs the application (i.e. the Execution Group) that all the parameters are 'IN' parameters even when some have been defined as 'OUT' or 'INOUT', and therefore the Execution Group fails to match the stored procedure definition with the ESQL definition of the procedure.
Problem conclusion
This has been resolved with a fix to the DataDirect Sybase ASE ODBC v5.0 driver.
Temporary fix
Comments
APAR Information
APAR number
IZ02427
Reported component name
MSSG BROKER AIX
Reported component ID
5724J0501
Reported release
100
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2007-08-02
Closed date
2008-04-30
Last modified date
2008-09-11
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
MSSG BROKER AIX
Fixed component ID
5724J0501
Applicable component levels
R100 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSKM8N","label":"WebSphere Message Broker"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]
Document Information
Modified date:
11 September 2008