Request capabilities

Table 2-1 describes each request capability:

Table 2-1: Request capabilities

CS_REQUEST capability

Meaning

Capability relates to

CS_CAP_ EXTENDEDFAILOVER

Extended HA failover

Connections

CS_CON_INBAND

In-band (non-expedited) attentions

Connections

CS_CON_OOB

Out-of-band (expedited) attentions

Connections

CS_CSR_ABS

Fetch of specified absolute cursor row

Cursors

CS_CSR_FIRST

Fetch of first cursor row

Cursors

CS_CSR_LAST

Fetch of last cursor row

Cursors

CS_CSR_MULTI

Multi-row cursor fetch

Cursors

CS_CSR_PREV

Fetch previous cursor row

Cursors

CS_CSR_REL

Fetch specified relative cursor row

Cursors

CS_DATA_BIN

Binary datatype

Datatypes

CS_DATA_VBIN

Variable-length binary type

Datatypes

CS_DATA_LBIN

Long variable-length binary datatype

Datatypes

CS_DATA_BIT

Bit datatype

Datatypes

CS_DATA_BITN

Nullable bit datatype

Datatypes

CS_DATA_BOUNDARY

Boundary datatype

Datatypes

CS_DATA_CHAR

Character datatype

Datatypes

CS_DATA_VCHAR

Variable-length character datatype

Datatypes

CS_DATA_LCHAR

Long variable-length character datatype

Datatypes

CS_DATA_DATE

Date datatype

Datatype

CS_DATA_DATE4

Short datetime datatype

Datatypes

CS_DATA_DATE8

Datetime datatype

Datatypes

CS_DATA_DATETIMEN

Null datetime values

Datatypes

CS_DATA_DEC

Decimal datatype

Datatypes

CS_DATA_FLT4

4-byte float datatype

Datatypes

CS_DATA_FLT8

8-byte float datatype

Datatypes

CS_DATA_FLTN

Nullable float datatype

Datatypes

CS_DATA_IMAGE

Image datatype

Datatypes

CS_DATA_INT1

Tiny integer datatype

Datatypes

CS_DATA_INT2

Small integer datatype

Datatypes

CS_DATA_INT4

Integer datatype

Datatypes

CS_DATA_INT8

Big integer datatype

Datatypes

CS_DATA_INTN

Null integers

Datatypes

CS_DATA_MNY4

Short money datatype

Datatypes

CS_DATA_MNY8

Money datatype

Datatypes

CS_DATA_MONEYN

Null money values

Datatypes

CS_DATA_NUM

Numeric datatype

Datatypes

CS_DATA_SENSITIVITY

Sensitivity datatype

Datatypes

CS_DATA_TEXT

Text datatype

Datatypes

CS_DATA_TIME

Time datatype

Datatypes

CS_DATA_UCHAR

2-byte character datatype

Datatypes

CS_DATA_UNITEXT

Unitext datatype

Datatypes

CS_DATA_XML

XML datatype

Datatypes

CS_OPTION_GET

Current option values

Datatypes

CS_PROTO_DYNAMIC

Use TDS DESCIN/OUT protocol

Commands

CS_PROTO_DYNPROC

Add “create proc” in the front of dynamic prepares

Commands

CS_REQ_BCP

Bulk copy requests

Commands

CS_REQ_CURSOR

Cursor requests

Commands

CS_REQ_DBRPC2

Large RPC name requests

Commands

CS_REQ_DYN

Dynamic SQL requests

Commands

CS_REQ_LANG

Language requests

Commands

CS_REQ_LARGEIDENT

Large identifier requests

Commands

CS_REQ_MIGRATE

Migration requests

Connection

CS_REQ_MSG

Message data

Commands

CS_REQ_MSTMT

Multiple server commands per Client-Library request

Connection

CS_REQ_NOTIF

Event notifications

Connection

CS_REQ_SRVPKTSIZE

Server-specified packetsize

Connection

CS_REQ_PARAM

Parameter data

Commands

CS_REQ_RPC

Remote procedure requests

Commands

CS_REQ_URGNOTIF

Use 5.0 event notification protocol

Commands

CS_WIDETABLES

Wider and increased number of columns per table

Commands