Work with User Tables (WRKUSRTBL)

The Work with User Tables (WRKUSRTBL) command allows you to work with finance user tables. Once they are created, you can add or delete user IDs in the tables. Several finance user tables can be defined. Each table must have a unique name.

Finance user table updates can be accessed by any finance job that is submitted after all changes are completed.

Restriction: This command is shipped with public *EXCLUDE authority.

Parameters

Keyword Description Choices Notes
USRTBL User table Name, *SELECT, *ALL Optional, Positional 1
TEXT Text 'description' Character value, *BLANK Optional

User table (USRTBL)

Specifies the name of a table that contains finance user IDs.

The possible values are:

*ALL
Displays all of the user tables currently defined.
*SELECT
The list of existing user table entries is shown. Through this display you can create, change, delete or display existing user tables.
user-table-name
Specify the name of the user table that you want to work with.

Text 'description' (TEXT)

Specifies the text that briefly describes the object.

The possible values are:

*BLANK
No text is specified.
'description'
Specify no more than 50 characters of text, enclosed in apostrophes.

Examples

Example 1: Working With All Finance User Tables 

WRKUSRTBL   USRTBL(*SELECT)

This command allows you to work with the names of all finance user tables. You can create a new table, select an existing table for update, or delete or display tables on the Work with User Table panel.

Example 2: Working With One User Table 

WRKUSRTBL   USRTBL(USRTBL1)

This command allows you to work with the finance user table USRTBL1. From the Work with User Table panel, you can create, change, delete, or display a finance user table.

Error messages

*ESCAPE Messages

CPF8379
Error while processing file &1 in &2.
CPF8380
Error while opening file &1 in &2.
CPF8381
Error while closing file &1 in &2.