IZ07096: SQL0104 WHEN CALLING STORED PROCEDURE WITH A SEMI-COLON

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• Calling a stored procedure containing a semi-colon will return
  SQL0104 after applying DB2 v8 FixPak 12 or higher.  DB2 v9 GA is
  also affected.  This issue occurs only when connecting to DB2
  for z/OS.
  
  CLI traces will show that the SQL statement is truncated.  This
  issue can be reproduced regardless of whether
  the internal SYSIBM.SQLPROCEDURECOLS is called.
  
  SQLPrepareW( hStmt=1:1, pszSqlStr=" call TESTSP(?,?,? );",
  cbSqlStr=22 )
  ---> Time elapsed - +1.656000E-003 seconds
  ( StmtOut="CALL TESTSP(?,?,?" )
  

Local fix

• Change application by removing the semi-colon from the CALL
  command or add curly braces around the call command i.e. {CALL
  TESTSP(?,?,?);}
  

Problem summary

• See ERROR DESCRIPTION.
  

Problem conclusion

• Problem was first fixed in Version 9 Fixpak 5 (s080512).  At
  a minimum this fix should be applied on the client side.
  

Temporary fix

• See LOCAL FIX.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  LI72596

• APAR is sysrouted TO one or more of the following:

  IZ28246

Fix information

• Fixed component name

  DB2 UDB ESE SOL

• Fixed component ID

  5765F4102

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP

• R910 PSN

     UP

• R950 PSN

     UP