World Programming Limited (WPL) develop and sell the World Programming System (WPS), an interpreter for the language of SAS. A great alternative - Request a free evaluation of WPS.

Engine Module
WPS Engine for MySQL

MySQL Database Connectivity

The WPS Engine for MySQL module provides connectivity to version 5 (and upwards) MySQL databases.

Type of Access Supported
Reading Yes
Writing Yes
Updating Yes
Creating new tables Yes
Implicit Pass through support Yes
Explicit Pass through support Yes
Bulk Loading  

The WPS engine for MySQL connects to a MySQL database using the MySQL C call level interface.

Dependencies and Usage

You can only do update and delete processing on MySQL tables that have a primary key defined.

The WPS Engine for MySQL can only be used on the supported platforms indicated in the table below.