MariaDB [kmantest]> show create table odbc_except\G
*************************** 1. row ***************************
       Table: odbc_except
Create Table: CREATE TABLE `odbc_except` (
  `EMPL` varchar(4) NOT NULL,
  `ITEM` varchar(13) NOT NULL,
  `ORDERNO` varchar(13) NOT NULL,
  `IDEN` varchar(7) DEFAULT NULL,
  `LOCAT` decimal(15,0) DEFAULT NULL,
  `JACTDATE` decimal(15,0) DEFAULT NULL,
  `COMMEN` varchar(26) DEFAULT NULL,
  `PROGRAM` varchar(13) DEFAULT NULL,
  `MADEBY` varchar(4) DEFAULT NULL,
  `ACTTIME` varchar(6) DEFAULT NULL,
  `LOGGEDIN` varchar(13) DEFAULT NULL,
  `NOTES` varchar(401) DEFAULT NULL,
  PRIMARY KEY (`EMPL`,`ORDERNO`,`ITEM`)
) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=KMANTEST' `table_type`=ODBC `tabname`=EXCEPT
1 row in set (0.00 sec)

MariaDB [kmantest]> drop table odbc_except; CREATE TABLE `odbc_except` (   `EMPL` varchar(4) NOT NULL,   `ITEM` varchar(13) NOT NULL,   `ORDERNO` varchar(13) NOT NULL,   `IDEN` varchar(7) DEFAULT NULL,   `LOCAT` decimal(15,0) DEFAULT NULL,   `JACTDATE` decimal(15,0) DEFAULT NULL,   `COMMEN` varchar(26) DEFAULT NULL,   `PROGRAM` varchar(13) DEFAULT NULL,   `MADEBY` varchar(4) DEFAULT NULL,   `ACTTIME` varchar(6) DEFAULT NULL,   `LOGGEDIN` varchar(13) DEFAULT NULL,   `NOTES` varchar(401) DEFAULT NULL ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=KMANTEST' `table_type`=ODBC `tabname`=EXCEPT; 
Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.44 sec)

MariaDB [kmantest]> show create table odbc_except\G
*************************** 1. row ***************************
       Table: odbc_except
Create Table: CREATE TABLE `odbc_except` (
  `EMPL` varchar(4) NOT NULL,
  `ITEM` varchar(13) NOT NULL,
  `ORDERNO` varchar(13) NOT NULL,
  `IDEN` varchar(7) DEFAULT NULL,
  `LOCAT` decimal(15,0) DEFAULT NULL,
  `JACTDATE` decimal(15,0) DEFAULT NULL,
  `COMMEN` varchar(26) DEFAULT NULL,
  `PROGRAM` varchar(13) DEFAULT NULL,
  `MADEBY` varchar(4) DEFAULT NULL,
  `ACTTIME` varchar(6) DEFAULT NULL,
  `LOGGEDIN` varchar(13) DEFAULT NULL,
  `NOTES` varchar(401) DEFAULT NULL
) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=KMANTEST' `table_type`=ODBC `tabname`=EXCEPT
1 row in set (0.00 sec)

MariaDB [kmantest]> select * from odbc_except where jactdate<158654 and empl='JEC';
<snip>
15 rows in set (0.08 sec)

MariaDB [kmantest]> delete from odbc_except where jactdate<158654 and empl='JEC';
Query OK, 0 rows affected, 1 warning (0.06 sec)

MariaDB [kmantest]> select * from odbc_except where jactdate<158654 and empl='JEC';
<snip>
1 row in set (0.23 sec)