I have a requirement like lets say a table is locked by a thread in shared mode.
Then another thread is trying to get exclusive lock on it.
then it must get an error as the lock is already obtained by another thread.
For this type of problem, what error code should be returned from informix.
i am using java api method getErrorCode() which returns vendor specific error codes.
my question is whether informix returns specific return code for these type of error, or it returns an error code which can be returned by other errors.