Executing and deleting commands with FILEMGMT: Difference between revisions
Line 4: | Line 4: | ||
<ol> | <ol> | ||
<li>Issue the COMmands command (or press PF6) from a screen that supports the command.</li> | <li>Issue the COMmands command (or press PF6) from a screen that supports the command.</li> | ||
<li>Select the commands you want to execute and press PF6.</li> | <li>Select the commands you want to execute and press PF6.</li> | ||
Line 11: | Line 10: | ||
===Note=== | ===Note=== | ||
<p>Before you execute commands in Active mode that were previously executed in Inactive mode, run DDGEN against the file. Running DDGEN ensures that the dictionary file definition reflects the current status of the <var class="product">Model 204</var> file. </p> | <p>Before you execute commands in Active mode that were previously executed in Inactive mode, run DDGEN against the file. Running DDGEN ensures that the dictionary file definition reflects the current status of the <var class="product">Model 204</var> file. </p> | ||
==Execute Commands screen== | ==Execute Commands screen== | ||
<p>Press the PF6 (COMmands) key from any screen that supports the command. FILEMGMT displays the Execute Commands screen:</p> | <p>Press the PF6 (COMmands) key from any screen that supports the command. FILEMGMT displays the Execute Commands screen:</p> |
Revision as of 22:33, 28 January 2014
Executing commands
Commands are executed on the appropriate commands screen:
To invoke the Execute Commands screen:
- Issue the COMmands command (or press PF6) from a screen that supports the command.
- Select the commands you want to execute and press PF6.
Note
Before you execute commands in Active mode that were previously executed in Inactive mode, run DDGEN against the file. Running DDGEN ensures that the dictionary file definition reflects the current status of the Model 204 file.
Execute Commands screen
Press the PF6 (COMmands) key from any screen that supports the command. FILEMGMT displays the Execute Commands screen:
- If you entered a file name on the primary screen, only the commands staged for that file are displayed.
- If you did not enter a file name on the primary screen, the commands for all the files staged under your user ID are displayed.
The following Execute Commands screen shows all the files staged under a user ID.
FILEMGMT Execute Commands Line 1 of 8 REPORT Use: OUTFILE ACTIVE _ Immediate _ Delayed INACTIVE _ Use: ________ X ProcFile: FMOUTPUT Password: _ Filename: ABC DECREASE 03/31/2005 _ Filename: ABC INCREASE 03/31/2005 Password: Inactive _ Record: ABC REDEFINE 03/31/2005 _ Field: EMPLOYEE FIRST NAME REDEFINE 03/31/2005 _ Field: EMPLOYEE ID REDEFINE 03/31/2005 _ Field: EMPLOYEE INITIAL REDEFINE 03/31/2005 _ Field: EMPLOYEE LAST NAME REDEFINE 03/31/2005 ===> 1=HELp 2= 3=QUIt 4= 5=REPort 6=EXEcute 7= 8= 9= 10= 11=DELcmds 12= |
FILEMGMT displays the names of files and their records, field groups, and fields. For each item, FILEMGMT displays the current or most recently executed command. To the right of the command, FILEMGMT displays the command status - for example, whether the command is pending, was executed successfully, or could not be executed because of an error condition or privilege violation. All the items that have been selected for execution at least once display a status. To the right of the status, FILEMGMT displays the date the command was requested.
FILEMGMT prompts you only for items that are currently staged by displaying an underscore character (_) in the prefix area to the left of the item name.
If a requested operation affects a set of records, field groups, or fields (for example, a file creation or record definition), FILEMGMT displays a prefix prompt only for the highest order of entity type. For example, file creation is a single operation, affecting the file and all of its records, field groups, and fields. Typing X in the file prefix area and pressing PF6 confirms the file creation and automatically submits for execution all the Model 204 commands constructed for this file and its entries.
Execution options
The dictionary administrator determines the default execution option and the available options. Execution options determine how and when FILEMGMT executes the commands on the Execute Commands screen.
If your system supports more than one mode, you can override the default by specifying the option you want on the ACTIVE or INACTIVE line of the Execute Commands screen. Your choice affects only the items you select for the current session. The default option is restored for subsequent sessions.
FILEMGMT provides the following options:
Option | Function |
---|---|
Active Immediate | Commands for selected items are executed immediately after FILEMGMT verifies that you have the necessary privileges to execute the commands. |
Active Delayed |
Commands for selected items are flagged as pending after FILEMGMT verifies that you have the necessary privileges to execute the commands. FILEMGMT executes the commands at a later time in batch mode. Refer to the appropriate section of the Rocket Model 204 Installation Guide for your operating system for more information. |
Inactive USE File |
Commands for selected items are written to a Model 204 directed output (USE) file. Your run must contain one of these print statements:
If no name is specified, FILEMGMT uses the default file, OUTFILE. If OUTFILE is used, it must be defined with the option DISP=MOD. |
Inactive Procedure File |
Commands for selected items are written to a specified procedure file. The procedure file name has the format: FIM.acct.date.time where:
|
Follow these guidelines when determining execution options:
- If you select the ACTIVE option, FILEMGMT checks all necessary passwords and privileges. These must be correct before FILEMGMT actually executes the command. If your login account password or the file password is invalid for a particular command, FILEMGMT reports an error condition on the line containing the file name.
- If the default is INACTIVE, and both USE and procedure files are available, the two options have Xs in the prefix area. Delete one of the Xs before you execute commands in the INACTIVE mode.
- INACTIVE option does not generate passwords for OPEN statements.
- INACTIVE option is required if you are recreating or copying a file from an earlier Model 204 release and choose to retain the file format of the earlier release.
The Execute Commands screen displays all the execution options supported by your system, and lets you change (and refine) the option you selected on the File Definition - Organization screen. The option you select on the Execute Commands screen applies to all the commands you select from the screen before you press the PF6 (EXEcute) key.
FILEMGMT displays or prompts you for the following information.
Prompt | Response |
---|---|
REPORT Use |
Type the name of a directed output (USE) file to which FILEMGMT is to write a printable report. The report has the same format as the Execute Commands Screen, except that the REPORT line shows the user account name and the current date and time. If you select this option, your run must contain one of these print statements:
Note: Of the four command options described below and in the preceding "Execution Options" section, the screen prompts only for those that were selected by the DBA on the Dictionary Administration File Management Facility screen. |
ACTIVE | Commands can be executed in immediate or delayed mode. |
Immediate | Commands are executed as soon as you issue the EXEcute command on the Execute Commands screen and FILEMGMT confirms your privileges. FILEMGMT displays X if this is the default for your system. You can type X to select this option if no X is displayed. |
Delayed | Commands are ready for execution. They are assigned a status of pending and can be subsequently executed in batch mode. FILEMGMT displays X if this is the default for your system. You can type X to select this option if no X is displayed. |
INACTIVE | Commands can be written to a Model 204 directed output (USE) file or stored in a procedure. |
Use | Commands are written to the USE file specified to the right of the Use prompt. The necessary print statements are the same as for the REPORT Use prompt. Select this option by typing X to the left of the prompt. |
ProcFile | Commands are written to the procedure file specified to the right of the ProcFile prompt. The format for the procedure filename is described in the "Execution options" section. Select this option by typing X to the left of the prompt. |
Password | If you selected the "ProcFile" option, enter the password (if any) associated with the procedure file. Type a valid password for the file (1-10 characters containing no spaces, commas, or colons). |
Filename |
FILEMGMT displays the name of the file that you entered on the primary screen, or displays the names of all files staged under your user ID. If the file is currently staged (for example, for a file creation), you can select the file by typing X in the prefix area to the left of the file name. The absence of a prefix prompt means that the file is no longer staged for a command. FILEMGMT displays on the same line as the file name:
See "FILEMGMT commands" for a listing of the commands.
A status preceded by * indicates that the command cannot be executed until you provide FILEMGMT with more information. Any other status indicator shows the results of the most recent execution attempt. A blank status indicates the command was never selected for execution. |
CmdGen'd | Commands were generated in INACTIVE mode. |
EXECPENDING |
You executed a command in ACTIVE IMMEDIATE mode and were restarted or the system crashed before the command was completed. To recover, run DDGEN to ensure your dictionary is synchronized, and reissue the command. |
FilePriv | The operation failed because you have insufficient file privileges. |
Fistat | The file is physically or logically inconsistent. (See the Rocket Model 204 File Manager's Guide.) |
M204.nnnn | The operation failed because of an incorrect password or some other error condition. "nnnn" indicates the Model 204 error message number. |
OpenError | FILEMGMT was unable to open the file. |
Pending | The command was selected but is not yet executed. Pending status occurs in ACTIVE DELAYED mode. |
PrevExecuted | The command for a field was previously executed as part of a different record or field group. |
*REC DEFN REQD | The record must be completely defined before the command for the record can be executed. |
SizeError | The available space is insufficient for an INCREASE command. |
*SIZING REQD | The file was staged for CREATE, but sizing information was not provided. |
Successful | The command was executed successfully. |
Filename (continued) UserPriv |
You attempted to execute a CREATE command and do not have superuser privileges.
|
Password | If required, type a valid password for the file (1-10 characters containing no spaces, commas, or colons). FILEMGMT indicates on the same line whether the file is active or inactive. "Active" or "Inactive" indicates the mode in which the commands for this file were last executed. If you re-execute the commands, you can change the execution mode by selecting another option at the top area of the screen. For more information, see the discussion of execution options above. |
Record | FILEMGMT displays the name of a record, Field group field group, or field for which a command Field has been generated. The command, status, and execution date are displayed on the same line. For more information about the line, see the "Filename" prompt above. |
Execute Commands screen commands
To issue a command, press a PF key or type a command name at the prompt (===>) and press Enter.
Key | Command | Meaning |
---|---|---|
PF1 | HELp | Displays HELP text for the Execute Commands screen. |
PF3 | QUIt | Exits from the Execute Commands screen and returns to the primary screen. Commands that were executed by pressing PF6 cannot be backed out by using QUIt. |
PF5 | REPort | Writes a report of the commands to the OUTxxxx file. The OUTxxxx file is the file specified in response to the REPORT Use prompt. |
PF6 | EXEcute |
Executes, sets as pending, or writes to a file for later execution the commands that you selected on the Execute Commands screen. The execution mode depends on the ACTIVE/INACTIVE selection. The Execute Commands screen is redisplayed after you press PF6 to show the updated status of all commands. |
PF7 | BACkward | Scrolls backward one screen. If you type BAC at the prompt (===>), followed by a number, FILEMGMT scrolls backward the specified number of lines. |
PF8 | FORward | Scrolls forward one screen. If you type FOR at the prompt (===>), followed by a number, FILEMGMT scrolls forward the specified number of lines. |
PF11 | DELcmds | Takes you to the Delete Commands screen. |
Commands generated from FILEMGMT
FILEMGMT commands
The following tables list the commands that FILEMGMT generates for each entity, the screens from which the commands are generated, and the actions that the commands perform.
File commands
Command | Generated from... | Action |
---|---|---|
CREATE |
File Definition screens File Size Definition screen File Copy screen |
Status is *SIZING REQD; command cannot be executed until sizing is performed. Creates a physical file and links a file definition to the file. Status is *SIZING REQD; command cannot be executed until sizing is performed. Sizing is required in order to link a data set name to the physical file. |
RECREATE |
File Definition screens File Size Definition screen |
Recreates the physical file and links a file definition to the file. Recreates the physical file and links a file definition to the file. |
INCREASE |
File Size Definition screen Increase/Decrease screen |
Resets Table B and Table D sizes. Resets Table B and Table D sizes. |
DECREASE |
File Size Definition screen Increase/Decrease screen |
Resets Table B and Table D sizes Resets Table B and Table D sizes. |
INC DSN | Increase/Decrease screen | Adds data sets for the file. |
RESET |
File Size Definition screen File Parameter Reset screen |
Resets file sizing parameters for an existing file. Resets file organization and security parameters. |
SECURE | Primary screen | Secures Model 204 password. |
DESECURE | Primary screen | Desecures Model 204 password. |
INITIALIZE | File Initialize screen | Initializes the file. |
DELETE | File Delete screen | Deletes file references from the dictionary. |
Field commands
Command | Generated from... | Action |
---|---|---|
DEFINE |
Field Name List screen Field Attributes screen Field Copy screen, if fields are selected for copying Record Copy screen File Size Definition screen, if the file is to be recreated |
Defines the field with default attributes. Defines the field. Defines the field. Defines the field. Defines the field. |
REDEFINE | Field Attributes screen | Redefines the field. |
DELETE | Field Attributes screen | Deletes the field from Model 204 and the dictionary. |
RENAME | Field Attributes screen | Renames the field. |
R/R | Field Attributes screen | Redefines and renames the field. |
Record Commands
Command | Generated from... | Action |
---|---|---|
DEFINE |
Record Name List screen Record Definition screen Field Definition screen, if the file has no records defined File Recreate screen, if the field is sorted, hashed, or has record security, and no record has been explicitly defined File Copy screen, if records are selected for copying File Copy screen, if no record has been defined to the file Record Copy screen File Size Definition screen, if the file is to be recreated |
Status is *REC DEFN REQD; cannot be executed until the record is defined. Defines the record. Status is *REC DEFN REQD; cannot be executed until the record is defined. Defines the record. Defines the record. Status is *REC DEFN REQD; cannot be executed until the record is defined. Defines the record. Defines the record. |
REDEFINE | Record Definition screen | Redefines the record. |
DELETE | Record Definition screen | Deletes the record definition from the dictionary. |
RENAME | Record Definition screen | Renames the record. |
R/R | Record Definition screen | Redefines and renames the record. |
Field group commands
Command | Generated from... | Action |
---|---|---|
DEFINE |
Field Group Definition screen File Size Definition screen, if the file is to be recreated |
Defines the field group. Defines the field group. |
REDEFINE | Field Group Definition screen | Redefines the field group. |
DELETE | Field Group List screen | Deletes the field group definition from the dictionary. |
RENAME | Field Group List screen | Renames the field group. |
R/R | Field Group Definition screen | Redefines and renames the field group. |
Deleting commands
To delete commands:
- Issue the DELcmds command (or press PF9) from the primary screen.
- Select the commands you want to delete and press PF6.