Description

ALL

List all objects - QMF objects, and database tables.

TABLES

List only database table objects - tables, views, and aliases.

QMF

List only QMF objects - queries, forms, and procedures.

QUERIES

List only QMF queries.

FORMS

List only QMF forms.

PROCS

List only QMF procedures.

OWNER

Specifies the ownership qualifier for objects to list. Your own database authorization id is the default.

authorizationid

The name of a user, a schema, or a database collection.

patternstring

Searches for owner names that have a certain pattern. The pattern is specified by a string in which the underscore and percent sign characters have special meanings, as discussed later.

ALL

List all objects regardless of owner.

NAME

Specifies the name of objects to list.

ALL

List all objects regardless of name.

objectname

The name of a QMF object or a database table.

patternstring

Searches for object names that have a certain pattern. The pattern is specified by a string in which the underscore and percent sign characters have special meanings, as discussed later.

LOCATION

Specifies the location of objects to list. The current database server is the default.

servername

The name of a database application server in the distributed network.

This option can only be used when the current location is a DB2 for OS/390 server. The QMF session is connected to a DB2 for OS/390 server when the global variable DSQAO_DB_MANAGER has the value of 2.