Appendix D: Creating a Custom APPX Engine
Linking an RDBMS into APPX
On Unix systems, there are pre-linked versions of APPX for Oracle, Sybase, and DB2. They can be found either in the {appx engine location} directory or the {appx engine loction}/linkable directory as ‘appx.oracle’, ‘appx.sybase’, and ‘appx.db2’. (On Windows/NT systems, if the requested RDBMS has been properly installed, APPX will find all the ‘.dll’ files it needs in the appropriate place at the appropriate time.) If you need to interact with both Oracle and Sybase you will have to make a custom-linked APPX engine, and you should contact APPX Software to find out how to accomplish this. The information needed varies by operating system, and may also be different for different versions of Oracle, Sybase, and DB2.
Table D-1 below shows the relationships between the supported operating systems and the various database managers. Note that Vision and C-ISAM are not supported on Windows/NT systems, and the ODBC interface is only supported on Windows/NT.
| (As of APPX release 4.1.3) | Vision | C-ISAM | Oracle | Sybase | DB2 | SQL Server | MS Access |
| HP-UX | Manual | Manual | Pre-linked | Pre-linked | Pre-linked | ||
| AIX | Manual | Manual | Pre-linked | Pre-linked | Pre-linked | ||
| Solaris | Manual | Manual | Pre-linked | Pre-linked | Pre-linked | ||
| Linux | Manual | Manual | Pre-linked | Pre-linked | Pre-linked | ||
| Windows/NT | Pre-linked | Pre-linked | Pre-linked | ODBC | ODBC |
| Manual: | The installer must manually link Vision or C-ISAM into APPX. |
| Pre-linked: | Interfaces are pre-linked into APPX; for multiple links a custom engine is required. |
| ODBC: | Data can be accessed through the APPX/ODBC interface. |