DB_GET_BINARY Function

Returns binary large objects (BLOBS) from a DBMS (database management system) server.

Usage

list_var = DB_GET_BINARY(handle, sql_query)

Input Parameters

handle—DBMS connection handle (returned by DB_CONNECT).

sql_query—A string containing an SQL statement to execute on the DBMS server. It must be a query (SELECT) statement.

Returned Value

list_var—A PV‑WAVE LIST variable, one for each row in the query. Each element in the LIST is a PV‑WAVE array of type BYTE.

Keywords

None.

Discussion

Since binary large objects (BLOBS) are transmitted from most DBMS systems in a different way from other data types, using DB_SQL to handle BLOBS would compromise performance.

For queries that return more than one row, specify the order of the rows with the ORDER BY clause in the sql_query.

One column will cause an error.

Note: The value of sql_query is subject to the following restrictions:
It must be a query. UPDATE, INSERT, and/or DELETE will cause an error.
It must only return one column. Queries that return more than one column will cause an error.