You can use common third-party tools to access DMSII database tables by using the MCPSQL software on the host server and the MCPSQL ODBC driver on the client. These tools can be used to copy or link to the DMSII data, as well as view, change, or report on the data. To perform these actions on the data, you can use the table views within the tools or submit standard SQL queries for SELECT, INSERT, UPDATE, and DELETE operations. Third-party tools that can access DMSII database tables include, but are not limited to, the following:

Occasionally, the results of these queries are not as expected. Some of these problems are due to differences in the ODBC implementation employed by two different platforms. In many cases, Unisys has identified a modified syntax that performs the query correctly and returns the intended results. However, there are some cases, such as when the tool in use modifies the query syntax and performs post-processing of the data that MCPSQL returns, that cannot be corrected or modified. The following sections document known issues with third-party SQL tools and specific syntax that can cause issues along with a workaround when possible.