Skip to Content
0
Former Member
Feb 11, 2014 at 03:51 PM

Does NGDBC driver support DatabaseMetaData.getImportedKeys()?

35 Views

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!