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

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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

• Users Affected:  CLI applications.
  Problem Description:  SQL0104N when invoking a stored procedure
  using the CALL command with a semi-colon at the end of the CALL
  command.
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, FixPak 2
  

Temporary fix

Comments

APAR Information

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

  IZ07096

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

Fix information

• Fixed component name

  DB2 UDB ESE SOL

• Fixed component ID

  5765F4102

Applicable component levels

• R950 PSN

     UP