# Limitations and considerations

The following limitations apply to the File target endpoint:

* Only the following DDLs are supported: Truncate table, Drop table, Create table, Add Column, Rename Column, Drop Column, and Convert Data Type.

* Full LOB Mode is not supported

* UPDATE and DELETE statements are not supported in Apply Changes replication mode

* Batch optimized apply mode is not supported

* Target lookup is not supported

* The <target folder> parameter cannot include special characters

* When the When source table is altered Apply Changes setting is set to [Ignore ALTER](https://help.qlik.com/en-US/replicate/May2025/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_applychangsetstab.htm#ignore_alter), data files will be updated, but metadata files and metadata headers (if defined) will not.

* Source schema and table names cannot contain periods. If they do, you should use a [global transformation](https://help.qlik.com/en-US/replicate/May2025/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_newTransRuleWiz.htm) to remove/replace the periods; otherwise, data loss will occur.

* Database names, schema names, or table names containing slash (/) or backslash (\) characters are not supported.

* The following Control Tables are not supported as they require UPDATE/DELETE operations, which are not supported:

  * Replication Status (requires UPDATE).

    Name on target: `attrep_status`

  * Suspended Tables (requires DELETE).

    Name on target: `attrep_suspended_tables`

    For more information on Control Tables, see [Control tables](https://help.qlik.com/en-US/replicate/May2025/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/control_tables.htm).