World Programming Limited develop and sell the World Programming System (WPS), an interpreter for the language of SAS. A great alternative - Request a free evaluation of WPS.
WPS
ModulesWPS Engine for MySQL
MySQL Database Connectivity
The WPS Engine for MySQL integrated module provides connectivity to version 5 (and upwards) MySQL databases.
| Type of Access | Supported |
|---|---|
| Reading |  |
| Writing | |
| Updating | |
| Creating new tables | |
| Implicit Pass through support | |
| Explicit Pass through support | |
| 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.
| Platform | Supported |
|---|---|
| AIX on pSeries (Power) | |
| Linux on x86 | |
| Mac OS X on x86 | |
| Solaris on Sparc | |
| Solaris on x86 | |
| Windows on x86 | |
| Linux on System z | |
| z/OS on System z |
