# ODBC in SAS - Error updating table entry: Optional feature not implemented

**URL:** <https://community.cdata.com/t/odbc-in-sas-error-updating-table-entry-optional-feature-not-implemented/337>\
**Category:** Data Sources\
**Tags:** article, odbc, sas\
**Created:** [August 16, 2023, 8:08pm UTC](https://community.cdata.com/t/odbc-in-sas-error-updating-table-entry-optional-feature-not-implemented/337 "2023-08-16T20:08:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arlin\_P](https://avatars.discourse-cdn.com/v4/letter/a/e480ec/32.png) [@Arlin\_P](https://community.cdata.com/u/Arlin_P)\
**Post date:** [August 16, 2023, 8:08pm UTC](https://community.cdata.com/t/odbc-in-sas-error-updating-table-entry-optional-feature-not-implemented/337/1 "2023-08-16T20:08:35Z")

</div>

This error is related to the SAS tool that you are using. It is generally caused by the syntax used when updating/deleting the data. To bypass this, please try to manipulate your data using the Pass-Through Facility syntax described in the solution from the forum: [Solved: ODBC MySQL table update - Optional feature not implemented error - SAS Support Communities](https://communities.sas.com/t5/SAS-Programming/ODBC-MySQL-table-update-Optional-feature-not-implemented-error/m-p/232197)

PROC SQL;

CONNECT TO ODBC (DSN=“\<_DNS Name\>_”);

EXEC (DELETE FROM _\<table\_name\>_ WHERE _\<condition\>_😉 BY ODBC;

QUIT;