Previous Topic: Setting up Catalog ViewsNext Topic: SYSCA.ACCESSIBLE_ SCHEMAS


SYSCA.ODBC_INDEX

This table procedure is used to return index and CALC key information for network records as well as SQL tables. The ODBC driver uses this table procedure to implement the SQLStatistics, SQLSpecialColumns, SQLPrimaryKeys, and SQLForeignKeys functions. If this table procedure is not installed, the ODBC driver queries the catalog SYSTEM.INDEX and SYSTEM.INDEXKEY tables, and returns information only for SQL defined tables.

The JDBC driver uses this table procedure to implement the corresponding DatabaseMetaData.getIndexInfo, getBestRowIdentifer, getPrimaryKeys, getExportedKeys, getImportedKeys, and getCrossReference methods. This table procedure is required for JDBC support.

This table procedure is defined for all releases since Genlevel 9506 of CA IDMS 12.01.