To store documents or images in your database, you can write an application that reads the contents of the file into a variable, and supplies that variable as a value for an INSERT statement.
You can also use the xp_read_file system procedure to insert file contents into a table. This procedure is useful if you want to insert file contents from Interactive SQL, or some other environment that does not provide a full programming language. DBA authority is required to use this procedure.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|