Topic
2 replies Latest Post - ‏2013-04-04T03:59:43Z by F0C7_M_Oenbrink
F0C7_M_Oenbrink
F0C7_M_Oenbrink
2 Posts
ACCEPTED ANSWER

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
    43 Posts
    ACCEPTED ANSWER

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

    ‏2013-04-03T16:23:32Z  in response to F0C7_M_Oenbrink
    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
      ACCEPTED ANSWER

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

      ‏2013-04-04T03:59:43Z  in response to p175
      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.