Deleting Rows in SAS

------_=_NextPart_001_01C7B710.0490B3DE
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

How can I update my MySQL database with data I have from a SAS Data Set =
without losing my primary key and other formatting? I am trying to =
simply delete all rows and import all again, but I get the following =
error message. It seems that any time I try to update by removing old =
data and inserting new data, I get this message. Any help would be =
wonderful.=20

Proc sql;
DELETE * FROM mysql.testtable;

ERROR: Error updating table entry: [MySQL][ODBC 3.51
Driver][mysqld-5.0.41-community-nt-log]Optional feature not =
implemented
ERROR: ROLLBACK issued due to errors for data set MYSQL.testtable.DATA.
NOTE: Deletes were rolled back by the DBMS software.

Thanks,

Elliot


SAS PremiumReporting - Testen Sie unsere Reportinglosung mit Ihrer =
personlichen Online-Demo
Gleich anmelden unter www.premiumreporting.de


SAS Institute GmbH, In der Neckarhelle 162, 69118 Heidelberg
Registergericht: Mannheim HRB-Nr. 332269, Geschaftsfuhrer: Mikael =
Hagstrom
------_=_NextPart_001_01C7B710.0490B3DE--