Does NGDBC driver support DatabaseMetaData.getImportedKeys()?

[Former Member]

If I try to invoke DatabaseMetaData.getImportedKeys() the resultset is empty?

If I try to run the jdbc driver query "SELECT  PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, PKCOLUMN_NAME,  FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, FKCOLUMN_NAME,  KEY_SEQ, UPDATE_RULE, DELETE_RULE, FK_NAME, PK_NAME,  DEFERRABILITY FROM  SYS.P_IMPORTEDKEYS WHERE  SYS.P_IMPORTEDKEYS.PKTABLE_SCHEM = 'mydb'  ORDER BY PKTABLE_CAT, PKTABLE_SCHEM, UPPER(PKTABLE_NAME), KEY_SEQ" I receive an error message (SAP DBTech JDBC: [259] (at 202): invalid table name:  Could not find table/view P_IMPORTEDKEYS in schema SYS), can you hel me, please?

Thank you!

[Former Member]

Hi Roberto,

Yes HANA supports DatabaseMetaData.getImportedKeys() method in ngdbc driver.

The parameters to be provided to get the value for a single DB SAP HANA system are

Catalog name should be null

Schema name should be the schema name of the referencing table

Table name is the Referencing querying whose detail is to be obtained.

The question is old and the response might not be needed, but providing a response for future queries on the topics.

Kindly let me know if you were able to use the DatabaseMetaData.getImportedKeys() method now.

Regards,

Anjali.