ibmdbR (version 1.51.0)

idaShowTables: Return a list of tables

Description

Returns a data frame that contains the names of the tables contained in the current database.

Usage

idaShowTables(showAll=FALSE, matchStr=NULL, schema=NULL, accelerated=FALSE)

Value

A data frame with the columns Schema, Name, Owner, and Type. For DB2 for z/OS connections the columns Acceleratorname and Enable are included as well.

Arguments

showAll

List all tables that are listed in the catalog of the current database (TRUE) or only those tables that are in the current schema (FALSE).

matchStr

If not NULL, only tables that contain the character string in this argument will be returned.

schema

If not NULL, only tables with this schema will be returned. This parameter is ignored if showAll=FALSE.

accelerated

Valid for DB2 for z/OS connections only. If TRUE, only accelerated tables will be returned.

Examples

if (FALSE) {

#Get a list of all tables in the current schema
tabs <- idaShowTables()

}