Mapping CLI Codes to SQLSTATE Values | Teradata Vantage - Mapping CLI Codes to SQLSTATE Values - Advanced SQL Engine - Teradata Database

SQL Stored Procedures and Embedded SQL

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
xqq1557098602407.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1148
lifecycle
previous
Product Category
Teradata Vantage™

The following table lists CLI codes mapped to their corresponding SQLSTATE codes.

CLI Code SQLSTATE Code CLI Code SQLSTATE Code
Class Value Subclass Value Class Value Subclass Value
36 08 T36 280 08 V80
40 08 T40 282 08 V82
41 08 T41 286 08 V86
151 08 U51 361 0A W61
171 0A U71 362 0A W62
181 0A U81 363 0A W63
185 0A U85 364 08 W64
190 0A U90 365 08 W65
229 08 W29 370 08 W70
230 08 W30 375 08 W75
231 08 W31 376 08 W76
232 08 W32 377 08 W77
233 08 W33 378 08 W78
234 08 W34 379 08 W79
235 08 W35 380 08 W80
236 08 W36 381 08 W81
237 08 W37 382 08 W82
238 08 W38 383 08 W83
239 08 W39 384 08 W84
240 08 W40 385 08 W85
241 08 W41 386 08 W86
242 08 W42 387 08 W87
243 08 W43 426 08 X26
244 08 W44 427 08 X27
272 08 V72 428 08 X28
429 08 X29 524 08 524
430 08 X30 527 08 527
512 08 512 529 0A 529
513 08 513 530 2C 530
521 08 521 532 0A 532