Integration Server 10.11 | Built-In Services Reference Guide | Db Folder | Summary of Elements in this Folder | pub.db:getTables
 
pub.db:getTables
WmDB. Retrieves the names of tables in the specified database and schema. As an alternative to this service, consider using the services provided with the webMethods Adapter for JDBC.
Input Parameters
You may specify the connection parameters in one of the following ways:
*$dbAlias
*$dbURL, $dbUser, $dbPass, $dbDriver
*$dbConnection
$dbAlias
String Optional. Database alias.
$dbURL
String Optional. JDBC URL that identifies the database resource.
$dbUser
String Optional. User name to use to log into the database.
$dbPass
String Optional. Password for the user.
$dbDriver
String Optional. Name of the JDBC driver to use.
$dbConnection
com.wm.app.b2b.server.DBConnection Optional. Connection object returned by pub.db:connect.
$dbCatalog
String Optional. Name of the database's system catalog. Include this parameter if your DBMS supports distributed databases and you want information from a database that is not the one to which you are connected.
If you are not using a distributed database system or you want information about the database to which you are connected, you do not need to specify this parameter.
If you are running against DB2, use this parameter to specify the database location.
$dbSchemaPattern
String Optional. Name of the schema for which you want the names of tables.
If your database supports pattern-matching on schemas, you may specify a pattern-matching string for the schema name, where _ represents a single character and % represents any string of characters. For example, the value HR% would represent any schema beginning with the characters HR.
If you want the table names from all schemas, set $dbSchemaPattern to null.
If you are running against DB2, you use this parameter to specify the table's AuthID.
$dbTableNamePattern
String Optional. Pattern string describing the tables whose names you want to retrieve.
If your database supports pattern-matching on schemas, you may specify a pattern-matching string, where _ represents a single character and % represents any string of characters. For example, the value HR% would represent any table name beginning with the characters HR.
If you want all table names, set $dbTableNamePattern to null.
$dbTableTypeList
String List Optional. Set of parameters specifying the types of tables whose names you want to retrieve. Common JDBC table types include: TABLE, VIEW, SYSTEM TABLE, ALIAS, and SYNONYM. Check your driver documentation for others.
Output Parameters
This service returns one document (IData object) for each table that matches the specified input criteria. Each document contains information about a table. The document's key will be the same as the table name.
Usage Notes
This service accepts input from a web browser or HTML form.