Hi everyone:

I wanna get an error message in a table, anybody know how to get it? I mean when I excecute a query if its wrong I get the message error en in SQL result, exalmple if I excecute:

elect * from table;

I get:

elect * from nom_esq.BIT_BITACORA
An unexpected token "elect" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "SELECT".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.11.69

Failed queries => 1

Total execution time => 0 ms
I need to catch:

An unexpected token "elect" was found following "BEGIN-OF-STATEMENT".

I've been lookint at SQLCA and I think that sqlerrmc can help me. If anybody know please help me.

Regards.

How are you executing the query. From the command line ?

IIIRC it is -a option

db2 -a

to get SQLCA.

If using Java, there is description here

DB2 Database for Linux, UNIX, and Windows