![AVG function [Aggregate]](arrow-left.gif){kind=icon}
![BIGINTTOHEX function [Data type conversion]](arrow-right.gif){kind=icon}
Extracts individual LONG BINARY and LONG VARCHAR cells to individual operating system files on the server.
The IQ data extraction facility includes the BFILE function, which allows you to extract individual LONG BINARY and LONG VARCHAR cells to individual operating system files on the server. You can use BFILE with or without the data extraction facility.
See Chapter 9, “Function Support” in Unstructured Data Analytics in Sybase IQ.
Users must be specifically licensed to use the large object data types LONG BINARY and LONG VARCHAR. For details on the Unstructured Data Analytics Option, see Unstructured Data Analytics in Sybase IQ.
