Home | Previous Page | Next Page   Programming with SQL > Calling the Database Server >

SQLERRM Character String

SQLERRM can store a character string of up to 70 bytes. The SQLERRM character string contains identifiers, such as a table names, that are placed in the error message. For some networked applications, it contains an error message that the networking software generates.

If an INSERT operation fails because a constraint is violated, the name of the constraint that failed is written to SQLERRM.

Tip:
If an error string is longer than 70 bytes, the overflow is silently discarded. In some contexts, this can result in the loss of information about runtime errors (for example, if an error string contains an identifier that is longer than 70 bytes).
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]