Creates and writes to a file on the client computer.
WRITE_CLIENT_FILE( filename, blob-expression [, 'A' ] )
filename The name of the file on the client computer. The name is resolved on the client computer relative to the current working directory of the client application.
blob-expression A binary string to be written to filename on the client computer.
A By default, if the file already exists, it is overwritten. If you want the data to be appended to existing data, specify 'A'. If the file does not already exist, and you specify 'A', the file is still created.
INT
The database server converts filename from the database character set to the client character set. On the client computer, filename is then converted to the operating system character set.
Since the data is a binary string, if you want the data to be in a particular character set, or compressed, or encrypted, you must perform these operations on the data before sending it to the WRITE_CLIENT_FILE function.
Reading of the file is performed by the client software library and the transfer of data is done using the command sequence communication protocol.
When writing to a file on a client computer:
WRITECLIENTFILE authority is required. See WRITECLIENTFILE authority.
The client application must have write permissions on the computer being written to.
The allow_write_client_file database option must be enabled. See allow_write_client_file option [database].
The write_client_file secured feature must be enabled. See -sf server option.
SQL/2003 Vendor extension.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |