Controls whether client file writes are permitted for the connection.

Allowed values

On, Off, Prompt

Default

Prompt

Remarks

This option controls whether the database server can write to files on the client computer. On means writing is allowed. Off means writing is not allowed. Prompt means prompt the user for the action to take.

This option is stored on a per-connection basis and persists only for the duration of the connection. You can set this option using the SET TEMPORARY OPTION statement. If you omit the TEMPORARY keyword, Interactive SQL reports an error.

WRITECLIENTFILE authority is required to write a file on a client computer.

See also

• Accessing data on client computers
• WRITECLIENTFILE authority
• WRITE_CLIENT_FILE function [String]
• SET OPTION statement [Interactive SQL]
• UNLOAD statement
• allow_write_client_file option [database]
• allow_read_client_file option [database]
• isql_allow_read_client_file option [Interactive SQL]
• Security of client side data