Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

xp_cmdshell system procedure Next Page

xp_read_file system procedure


Returns the contents of a file as a LONG BINARY variable.

Syntax

xp_read_file( filename )

Arguments
Remarks

The function reads the contents of the named file, and returns the result as a LONG BINARY value.

The filename is relative to the starting directory of the database server.

The function can be useful for inserting entire documents or images stored in files into tables. If the file cannot be read, the function returns NULL.

Permissions

DBA authority required

See also
Example

The following statement inserts an image into a column named picture of the table t1 (assuming all other columns can accept NULL):

INSERT INTO t1 ( picture )
   SELECT xp_read_file( 'portrait.gif' );