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.
Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
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 110000PWGG50 Posts
Re: SELECT FROM(oledb tf) WHERE ... PRODUCES -4499 & CRASHES DB2 10.1.22013-04-03T16:23:32ZThis is the accepted answer. This is the accepted answer.I'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 Posts
Re: SELECT FROM(oledb tf) WHERE ... PRODUCES -4499 & CRASHES DB2 10.1.22013-04-04T03:59:43ZThis is the accepted answer. This is the accepted answer.
- p175 110000PWGG
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.