I would have thought that by now people would be using the searchable index
on the manuals to get this info. How about searching for either SQLCODE or
SQLCA. Both would find the answer.

Regards

Malcolm

-----Original Message-----
From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]
On Behalf Of Superboer
Sent: 17 October 2007 07:40
To: informix-list@iiug.org
Subject: Re: sqlca

This is well doced somewhere.

the value of sqlca.sqlcode is an error number representing the error
encountered.
see the error message manual.

finderr <errno> gives also the description.
examples...:

$ finderr -245
-245 Could not position within a file via an index.

The database server encountered an error when it attempted to look up
a
row through an index. Check the accompanying ISAM error code for more
information. The table file or the index file might have been
corrupted. Unless the ISAM error code or an operating-system message
points to another cause, run the oncheck utility (secheck with IBM
Informix
SE or tbcheck with IBM Informix OnLine) to check and repair table and
index.


$ finderr -692
-692 Key value for constraint constraint-name is still being
referenced.

You have violated a referential constraint. This situation usually
occurs when you are trying to delete a row in a column (parent key)
that another row (child key) is referencing. If you are using
cascading
deletes, database logging must be on.

etc.

btw notfound is 100

Superboer

On 17 okt, 08:16, Trisha <informixt...@hotmail.com> wrote:
> i want to know the sqlca value in sqlca.sqlcode.
>
> for example we are checking sqlca.sqlcode < 0 is failure of sql
> statement.
>
> what is the value stored in sqlca.sqlcode is it -1 or -2
> how to find out that value?
>
> regards
> trusha


_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list