Re: Collecting ISAM Errors
In article <3416D246.71FB@bayer.co.uk>, Peter Lancashire <Peter.Lancashi
re.PL1@bayer.co.uk> writes
>
>David McCreery wrote:
>>
>> We have an application that is causing errors. It used Informix 7.12
>>
>> But the only error that the application reports back is the SQL error.
>> What I need to get is the ISAM Error. Is there any way that I can record
>> the full error without having to modify the application code.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>>
Run onstat -u and get the session id for that user.
Run onstat -g ses <session id>
There is a sections last SQL error / last ISAM error encountered.
>> This error is difficult to recreate and I cannot pin-point exactly when it
>> happens.
>>
>> Thanks in Advance
>>
>> David McCreery
>
>David,
>
>If you use 4GL, the ISAM code is in sqlca.sqlerrd[2] when sqlca.sqlcode
>< 0.
>
>If you use ESQL/C, it is in sqlca.sqlerrd[1] when sqlca.sqlcode < 0.
>
>Peter
--
David Williams