DB2 7.0, Text Extender, OS 390
I am working on an applicaiton and need to code to check specific SQL codes so we can give a 'soft' message to the end user.

Examples of conditions we would like to check are: index empty, index unavailable. The manual lists SQL states, as well as messages. For example: DES0756N The database is not enabled for Text Extender.

There is a chapter titled 'Return Codes' - however the documentation has text strings, not a specific SQL Code value. For example - 'RC_SE_DOCUMENT_NOT_ACCESSIBLE'. This is something to code for, however I can't figure out what SQL Code to check.

I know we can code for values such as -904 which is documented to mean 'unavailable resource', however I can't determine if this code is valid in the TE environment.