Mapping CLI Codes to SQLSTATE Values | Teradata Vantage - Mapping CLI Codes to SQLSTATE Values - Teradata Vantage - Analytics Database

SQL Stored Procedures and Embedded SQL
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
frc1628111662093.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
rjx1472253414573
lifecycle
latest
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