IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 2 replies
  • Latest Post - ‏2013-04-04T03:59:43Z by F0C7_M_Oenbrink
F0C7_M_Oenbrink
F0C7_M_Oenbrink
2 Posts

Pinned topic SELECT FROM(oledb tf) WHERE ... PRODUCES -4499 & CRASHES DB2 10.1.2

‏2013-04-01T15:24:03Z |
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):

SELECT
TF1.*
FROM
TABLE( <oledb table function>() ) TF1
WHERE
<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.
Updated on 2013-04-04T03:59:43Z at 2013-04-04T03:59:43Z by F0C7_M_Oenbrink
  • p175
    p175
    50 Posts

    Re: SELECT FROM(oledb tf) WHERE ... PRODUCES -4499 &#38; CRASHES DB2 10.1.2

    ‏2013-04-03T16:23:32Z  
    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
    F0C7_M_Oenbrink
    2 Posts

    Re: SELECT FROM(oledb tf) WHERE ... PRODUCES -4499 &#38; CRASHES DB2 10.1.2

    ‏2013-04-04T03:59:43Z  
    • p175
    • ‏2013-04-03T16:23:32Z
    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 ?
    See "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.