WRKTBL (Work with Tables)

WRKTBL Command syntax diagram

 

Purpose

The Work with Tables (WRKTBL) command allows you to show a list of tables from one or more libraries.

 

Restrictions

1. Only the libraries to which you have USE authority will be searched.
2. Only the tables to which you have some authority will be shown on the display.
3. To perform operations on the tables, have USE authority to the command used by the operation, and the appropriate authority to the tables on which the operation is to be performed.

 

Required Parameters

TBL

Specifies a list of tables in the libraries that are shown. If no library qualifier is specified, *LIBL is assumed and all libraries in the job's library list are searched for the tables.

The name of the table can be qualified by one of the following library values:

*LIBL: All libraries in the job's library list are searched. All objects in these libraries with the specified object name are shown.

*CURLIB: The current library for the job is searched. If no library is specified as the current library for the job, the QGPL library is used.

*USRLIBL: Only the libraries in the user portion of the job's library list are searched.

*ALLUSR Libraries

*ALL: All libraries in the system, including QSYS, are searched.

library-name: Specify the name of the library to be searched.

*ALL: All tables in the libraries identified in the library qualifier are shown.

generic*-table-name: Specify the generic name of the table. A generic name is a character string of one or more characters followed by an asterisk (*); for example, ABC*. The asterisk substitutes for any valid characters. A generic name specifies all objects with names that begin with the generic prefix for which the user has authority. If an asterisk is not included with the generic (prefix) name, the system assumes it to be the complete object name. If the complete object name is specified, and multiple libraries are searched, multiple objects can be worked with only if *ALL or *ALLUSR library values can be specified for the name. See generic names for additional information.

table-name: Specify the name of the tables that are shown.

Example for WRKTBL

WRKTBL   TBL(LIB1/ABC*)

This command allows you to show a list of tables beginning with ABC that are in library LIB1.

Error messages for WRKTBL

*ESCAPE Messages

CPF9809

Library &1 cannot be accessed.

CPF9820

Not authorized to use library &1.