Descriptor Transitions

ODBC descriptors have the following three states.

State

Description

D0	Unallocated descriptor
D1i	Implicitly allocated descriptor
D1e	Explicitly allocated descriptor

The following tables show how each ODBC function affects the descriptor state.

SQLAllocHandle

D0 Unallocated

D1i Implicit

D1e Explicit

D1i [1]	--	--
D1e [2]	--	--

[1] This row shows transitions when HandleType was SQL_HANDLE_STMT. [2] This row shows transitions when HandleType was SQL_HANDLE_DESC.

SQLCopyDesc

D0 Unallocated

D1i Implicit

D1e Explicit

(IH)

--

--

SQLFreeHandle

D0 Unallocated

D1i Implicit

D1e Explicit

-- [1]	D0	--
(IH) [2]	(HY017)	D0

[1] This row shows transitions when HandleType was SQL_HANDLE_STMT. [2] This row shows transitions when HandleType was SQL_HANDLE_DESC.

SQLGetDescField and SQLGetDescRec

D0 Unallocated

D1i Implicit

D1e Explicit

(IH)

--

--

SQLSetDescField and SQLSetDescRec

D0 Unallocated

D1i Implicit

D1e Explicit

(IH) [1]

--

--

[1] This row shows transitions when DescriptorHandle was the handle of an ARD, APD, or IPD, or (for SQLSetDescField) when DescriptorHandle was the handle of an IRD and FieldIdentifier was SQL_DESC_ARRAY_STATUS_PTR or SQL_DESC_ROWS_PROCESSED_PTR.

All Other ODBC Functions

D0 Unallocated

D1i Implicit

D1e Explicit

--

--

--