Buradasın

DB2 SQL Error Codes and Messages

Yapay zekadan makale özeti

SQLCODEs and SQLSTATEs Overview: SQL returns error codes and SQLSTATEs to applications when errors occur
SQLSTATE provides common error codes for IBM relational database systems
SQLCODEs indicate success (00000), warnings (01002-01535), or errors (-00000)
SQLCODE Structure: SQLCODEs are constructed by appending 5 digits to SQ followed by 'L' if '0'
Each SQLCODE has corresponding message in QSQLMSG file
Messages can be sent to job log using CL commands
SQLSTATE Classes: Class 00: Unqualified successful completion
Class 01: Warning conditions
Class 02: No data
Class 07: Dynamic SQL errors
Class 08: Connection exceptions
Class 09: Triggered action exceptions
Class 0A: Feature not supported
Class 0E: Invalid schema name list
Class 0F: Invalid token
Class 20: Case not found
Class 21: Cardinality violation
Class 22: Data exceptions
Class 23: Constraint violations
Class 24: Invalid cursor state
Class 25: Invalid transaction state
Class 26: Invalid SQL statement identifier
Class 27: Triggered data change violation
Class 28: Invalid authorization specification
Class 2D: Invalid transaction termination
Class 2E: Invalid connection name
Class 2F: SQL function exceptions
Class 34: Invalid cursor name
Class 39: External function call exceptions
Class 42: Syntax errors or access rule violations