Controls whether client file reads are permitted for the connection.

Allowed values

On, Off, Prompt

Default

Prompt

Remarks

This option controls whether the database server can read files on the client computer. On means reading is allowed. Off means reading 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.

This option allows a data file to be read without user intervention in cases where LOAD TABLE is executed from a stored procedure or trigger.

READCLIENTFILE authority is required to read a file on a client computer.

See also

• Accessing data on client computers
• READCLIENTFILE authority
• READ_CLIENT_FILE function [String]
• SET OPTION statement [Interactive SQL]
• LOAD TABLE statement
• allow_read_client_file option [database]
• allow_write_client_file option [database]
• isql_allow_write_client_file option [Interactive SQL]
• Security of client side data