var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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;
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.
How are you executing the query. From the command line ?
IIIRC it is -a option
to get SQLCA.
If using Java, there is description here
DB2 Database for Linux, UNIX, and Windows
Visit the new-look IDUG Website
, register to gain access to the excellent content.