A heads-up to those considering moving to DB2 Express-C 10.1 Fix Pack 2:
After upgrading to FP2 (on win7 OS & Data Studio 3.2 IDE), we found the following regression defect
(which did not exist in our prior 10.1):
TABLE( <oledb table function>() ) TF1
<filter using a column in the table function> (eg: TF1.column1 'xxx')
produces a -4499 for the session & crashes DB2.
DB2 must then be restarted via admin window command: db2start
You must then find a workaround for all of your affected scripts.
This topic has been locked.
2 replies Latest Post - 2013-04-04T03:59:43Z by F0C7_M_Oenbrink
Pinned topic SELECT FROM(oledb tf) WHERE ... PRODUCES -4499 & CRASHES DB2 10.1.2
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-04-04T03:59:43Z at 2013-04-04T03:59:43Z by F0C7_M_Oenbrink
p175 110000PWGG49 PostsACCEPTED ANSWER
Re: SELECT FROM(oledb tf) WHERE ... PRODUCES -4499 & CRASHES DB2 10.1.22013-04-03T16:23:32Z in response to F0C7_M_OenbrinkI'm not sure what you mean by oledb table functions, but I use table functions defined and created in normal SQL all the time and I have had no issues whatsoever with 10.1.2 on Win7 Pro SP1.
Can you post the DDL for the actual table function definition as well ?
F0C7_M_Oenbrink 270003F0C72 PostsACCEPTED ANSWER
Re: SELECT FROM(oledb tf) WHERE ... PRODUCES -4499 & CRASHES DB2 10.1.22013-04-04T03:59:43Z in response to p175See "CREATE FUNCTION (OLE DB external table) statement" in the DB2 SQL Ref Manual.
Our tests typically access an external MS Excel file, but it could be any OLEDB data source.
All other (non-oledb) table functions seem to be working aok in 10.1.2.