Results 1 to 2 of 2

Thread: Sqlca

  1. #1
    Join Date
    Sep 2011

    Exclamation Unanswered: Sqlca

    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.


  2. #2
    Join Date
    Aug 2001
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts