Syntax error in SQL statement

[mschuene]

I am accessing a Db2 LUW database via LibreOffice using jdbc. Accessing a table, e.g. a timestamp field, runs fine.

SELECT A_TIMESTAMP FROM MYSCHEMA.MYTABLE

However, if I intend to use a Db2 function, the thing fails.

SELECT DATE(A_TIMESTAMP) FROM MYSCHEMA.MYTABLE

For this query, I get a popup saying “Syntax error in SQL statement”. This does not appear to get sent to the database, i.e. the error is not coming from Db2, but from LibreOffice.

What is wrong ?

Thanks
Malte

[Ratslinger]

Hello,

This is the interpreter signaling the error. It checks for certain syntax. In past was mainly defined around HSQLDB embedded.

To get around this, turn on Run SQL command directly. This is a toggle icon on the toolbar or from the menu Edit there is another toggle.