Previous Topic: Creating the IDMSJSRV TaskNext Topic: Setting Up SQL Access


Setting Up Database Access

The ODBC and JDBC drivers use dynamic SQL to access a CA IDMS database from an ODBC or JDBC application. Both the SQL Option and the host component of CA IDMS Server must be installed on the CV. The database can be defined using the Schema compiler or SQL Data Description Language (DDL). In either case, you must include the appropriate SQL definitions in the dictionary associated with the CA IDMS system. The SQL definitions reside in the catalog area of the dictionary.