When executing the tests under com.sun.ts.tests.jdbc.ee.escapeSyntax.scalar4.* , DB2 returns:

SQLCODE: -443, SQLSTATE: 38552, SQLERRMC: SYSFUN.TIMESTAMPDIFF;TIMESTAMPDIFF;SYSFUN:03

Which means: "Arithmetic overflow or underflow". The error is reproducible by issuing these commands:

INSERT INTO ctstable3 VALUES ('Java',' HotJava ','JAVA',100,0.5,

{d '1993-07-13'}

,

{t '10:30:55'}

,

{ts '1994-06-12 11:20:10'}

,

{ts '1996-05-10 10:07:05'}

)
go

SELECT

{FN TIMESTAMPDIFF(SQL_TSI_FRAC_SECOND,TSCOL1,TSCOL2)}

FROM ctstable3
go

The problem is on SQL_TSI_FRAC_SECOND. Changing it to SQL_TSI_SECOND makes the query work fine. So, it doesn't seems a problem in either EAP nor TCK, but something specific to DB2. I'll add these tests to the "ignore" list.