DB-Library routines added to version 10.0

The following table lists DB-Library routines that were added for version 10.0:

Table 1-2: New DB-Library routines

Routine Name

Description

bcp_options

Sets bulk copy options

dbaltbind_ps

Binds a compute column to a program variable, with precision and scale support for numeric and decimal datatypes

dbbind_ps

Binds a regular result column to a program variable, with precision and scale support for numeric and decimal datatypes

dbconvert_ps

Converts data from one datatype to another, with precision and scale support for numeric and decimal datatypes

dbcursor

Inserts, updates, deletes, locks, or refreshes a particular row in the fetch buffer

dbcursorbind

Registers the binding information on the cursor columns

dbcursorclose

Closes the cursor associated with the given handle, releasing all the data belonging to it

dbcursorcolinfo

Returns column information for the specified column number in the open cursor

dbcursorfetch

Fetches a block of rows into the program variables declared by the user in dbcursorbind

dbcursorinfo

Returns the number of columns and the number of rows in the keyset if the keyset hit the end of the result set

dbcursoropen

Opens a cursor, specifying the scroll option, concurrency option, and the size of the fetch buffer (the number of rows retrieved with a single fetch)

dbsechandle

Installs user functions to handle secure logins

dbsetdefcharset

Sets the default character set for an application

dbsetdeflang

Sets the default language name for an application

DBSETLENCRYPT

Specifies whether or not password encryption is to be used when logging into SQL Server 10.0 or later

dbsetversion

Specifies a DB-Library version level

dbtextsize

Returns the number of text or image bytes that remain to be read for the current row