MATLAB: Does the TABLES function of Database Toolbox not use the catalog argument with Oracle databases

Database Toolbox

I noticed that the output of TABLES function does not depend on the catalog argument when connected to an Oracle database. For example, the following TABLES calls return identical output:

dbmeta = dmd(connection);
mydbmeta  = get(dbmeta);
databasetables = tables(dbmeta, mydbmeta.Catalogs,mydbmeta.Schemas)
databasetables2 = tables(dbmeta, 'test', mydbmeta.Schemas)

Best Answer

This is expected behavior. The metadata returned by the TABLES command is database-dependent. The Oracle engine considers schema but not catalog when returning this metadata.

Related Solutions

MATLAB: How to access SQL column default value via JDBC DatabaseMetaData in Database Toolbox v3.10 (R2011b)

Accessing default values using SQL is not possible using Database toolbox directly.

As a workaround, it is possible to use documented java.sql calls with a simple Java class file called databaseUtils.java.

It has to be compiled with

javac databaseUtils.java –Xlint:unchecked

with the –Xlint flag to get around the warning.

You will need to add the directory where databaseUtils.class lives with the JAVAADDPATH command in MATLAB, for example

javaaddpath c:\

You can access the column default values using the following syntax:

b = databaseUtils;
b.dmdColumns(db.DMDHandle,'dwmart','dbo'); % where db is the database used.

MATLAB: Do I receive an error about a Java method called dmdColumns when using the COLUMNS function in the Database Toolbox 3.0 (R14)

Database functions that use the "catalog" argument, like COLUMNS, accept only a single catalog. The error you received occurs when you provide multiple catalogs. Check the contents of "catalog" to ensure it only contains a single catalog name. If it contains more than one, index one of the names. For example,

catalogs = get(dbmeta, 'Catalogs');
catalog = catalogs{1};
columninfo = columns(dbmeta, catalog, 'tablename');

Note that this applies for all functions that operate on metadata objects and use the catalog argument, such as TABLES, PROCEDURES, and so on.

Best Answer

Related Solutions

MATLAB: How to access SQL column default value via JDBC DatabaseMetaData in Database Toolbox v3.10 (R2011b)

MATLAB: Do I receive an error about a Java method called dmdColumns when using the COLUMNS function in the Database Toolbox 3.0 (R14)

Related Question