SQL Communication Area › SQLSTATE

SQLSTATE

SQLSTATE is a five-character string where CA IDMS returns the status of the last SQL statement executed. It is divided into a two-character class and a three-character subclass. Standard values are associated with each class and subclass, which minimizes the need for vendors to define their own values and makes applications more portable from one environment to another.