Restrictions and Limitations
Currently the following restrictions and/or limitations apply to the ITP ODBC Connection:
- You can not use stored functions.
- Data Retrieval Statements and Key Retrieval Statements can only use the SQL SELECT and CALL statements. It is not (yet) possible to use other SQL statements (like CREATE or DROP) or call Stored Functions.
- The UPDATE statement can be used to create DID defined functions to update the database. Such a DID defined function however always expects a result.