Skip to content

Topics

Start from an operational problem and find its SQLSTATE paths.

Topic indexes cover constraint conflicts, authentication and authorization, transaction retry, locks and timeouts, object resolution, and resource or system failures. Topics point to code pages; they do not create a second identity for a condition.

Topic Codes
Constraints and conflicts 23505, 23503, 23502, 23514, 23P01, 23000, 23001
Authentication and privileges 28P01, 28000, 42501
Transactions, locks, and retry 40P01, 40001, 25P02, 25006, 57014
Syntax and object resolution 42601, 42P01, 42P02, 42701, 42703, 42883
Resources and connectivity 53300, 53000, 53100, 53200, 57P01, 57P03, 58000
Data and type boundaries 2202E, 22003, 22007, 22P02