PH54506: GETTING SQLSYNTAXERROREXCEPTION WHEN CALLING A STORED PROCEDURE WITH MULTIPLE OUTPUTS USING ITX JDBC ADAPTER AND DB2 JDBC DRIVER

APAR status

• Closed as program error.

Error description

• The following exception occurs when using ITX V10.1.1.1 JDBC
  Adapter to call a DB2 stored procedure that has multiple
  outputs.
  
  
  JDBC Adapter trace:
  
  <12345-6789-04/25/23 12:45:17>: Preparing procedure call
  operation. Procedure: <procedure_name>(), schema: <schema_name>,
   catalog: null
  <12345-6789-04/25/23 12:45:18>: Generated procedure CALL
  statement: {call "<schema_name>"."<procedure_name>()"()}
  <12345-6789-04/25/23 12:45:18>: Caught exception:
  com.hcl.hip.adapters.m4base.MBaseException
  Error initializing source operation:
  com.ibm.db2.jcc.am.SqlSyntaxErrorException:
  [jcc][t4][10425][12539][4.25.23] Invalid input CALL SQL syntax.
  SQL= call "<schema_name>"."<procedure_name>()"()
  ERRORCODE=-4463, SQLSTATE=42601
  com.hcl.hip.adapters.m4base.MBaseException: Error initializing
  source operation: com.ibm.db2.jcc.am.SqlSyntaxErrorException:
  [jcc][t4][10425][12539][4.25.23] Invalid input CALL SQL syntax.
  SQL= call "<schema_name>"."<procedure_name>()"()
  ERRORCODE=-4463, SQLSTATE=42601
  at
  com.hcl.hip.adapters.m4jdbc.M4JdbcClient.prepareSourceOperation(
  M4JdbcClient.java:1322)
  at
  com.hcl.hip.adapters.m4jdbc.MAdapterImpl.onGetStart(MAdapterImpl
  .java:79)
  at
  com.hcl.hip.tools.adapterdriver.MAdapterImpl.onNotify(MAdapterIm
  pl.java:276)
  

Local fix

• ITXCQ - ITX00061932
  CF / CF
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender users using procedure in jdbc
  adapter.
  
  Problem Description:
  Getting error while running stored procedure with out
  parameters.
  
  Platforms Affected:
  All
  

Problem conclusion

• Applied fix in adapters to fix issue in out parameters. The out
  parameters were not setting correctly in request statement.
  
  Applies to:
  10.1.1.1, 10.1.2.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next service pack or product release is available,
  check the IBM Transformation Extender Release Notes page:
  https://www.ibm.com/support/docview.wss?uid=swg27008337
  
  If the service pack or product release is available, download it
  from Fix Central:
  http://www.ibm.com/support/fixcentral/
  
  If the service pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a case:
  https://www.ibm.com/mysupport/
  
  Prior to version 9.0.0, IBM Transformation Extender was called
  IBM WebSphere Transformation Extender.
  

Temporary fix

Comments

APAR Information

• 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

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels