tdbc::mapSqlState(n) Tcl Database Connectivity tdbc::mapSqlState(n)

```

```

# [NAME](#NAME)

tdbc::mapSqlState - Map SQLSTATE to error class

# [SYNOPSIS](#SYNOPSIS)

```
package require tdbc 1.0
tdbc::mapSqlState sqlstate
```

```

```

# [DESCRIPTION](#DESCRIPTION)

The **tdbc::mapSqlState** command accepts a string that is expected to be a five-character 'SQL state' as returned from a SQL database when an error occurs. It examines the first two characters of the string, and returns an error class as a human- and machine-readable name (for example, **FEATURE\_NOT\_SUPPORTED**, **DATA\_EXCEPTION** or **INVALID\_CURSOR\_STATE**).

The TDBC specification requires database drivers to return a description of an error in the error code when an error occurs. The description is a string that has at least four elements: "**TDBC** *errorClass* *sqlstate* *driverName* *details...*". The **tdbc::mapSqlState** command gives a convenient way for a TDBC driver to generate the *errorClass* element given the SQL state returned from a database.

# [SEE ALSO](#SEE_ALSO)

[tdbc(n)](/man/os/tcl/tdbc.n), tdbc::tokenize, [tdbc::connection(n)](/man/os/tcl/tdbc::connection.n), [tdbc::statement(n)](/man/os/tcl/tdbc::statement.n), [tdbc::resultset(n)](/man/os/tcl/tdbc::resultset.n)

# [KEYWORDS](#KEYWORDS)

TDBC, SQL, database, state

# [COPYRIGHT](#COPYRIGHT)

Copyright (c) 2009 by Kevin B. Kenny.

8.6 Tcl

---

Document: tdbc_mapSqlState(n) from tcl 9.1.0-r1 (Chainguard OS)
Source: https://downloads.sourceforge.net/project/tcl/Tcl/9.1.0/tcl9.1.0-src.tar.gz