User guide

21
Table Editor Commands
(NTP 297-1001-360, Basic Translations Tools Guide)
Note: In addition to the Table Editor commands below, see the FINDTAB,
FINDREF, SHOWUSES, and SHOWUSERS commands under “DMS
CI: Level Commands” within this QRG.
>HELP use HELP <command> to get command description.
>ABORT used to cancel a command or input.
>
REPlace
used to replace a specified tuple with a new tuple; user is
prompted for field values or field values may be specified
(i.e., REP <field 1> <field 2> <field 3>).
>ADD adds tuple(s) to a table.
>
DELete
deletes a tuple from a table.
>CHAnge changes the value of existing field data for a tuple.
>CHECK displays next <COUNT> tuples or ALL tuples
>SUBtable enters subtable. Parameter not required if only one subtable.
>
RETurn
exits back from a subtable in a previous level.
>OVErride CAUTION: This command cancels the system prompt
when a “NO JF AVAILABLE” and/or “MACHINES OUT
OF SYNC” condition exists.
>VERIFY CAUTION: This command turns on/off the system prompt
for verification and confirmation when altering table data.
>COUNT without parameters displays the number of tuples in a table.
>
COUNT <parameters>
count number based upon the following parms:
& = And EQ = Equal to GT = Greater than
GE = Greater than or equal to NE = Not equal to
LE = Less than or equal to LT = Less than
EX: >TABLE LINEATTR
>COUNT (PRTNM EQ POTS)
Note: Counts the tuples with a pretranslator name equal to POTS.
>
FORMAT PACK
defines the format to be printed/displayed at 130
lines per character—ignores CUSTFLDS table.
>FORMAT UNPACK defines the format to be printed/displayed at 70
lines per character as defined in CUSTFLDS table.
>
LISt
displays tuple(s) within a table; to LIST examples, enter:
>LIST <number of tuples to list> or >LIST ALL
>
LIST <condition>
%see count parameters
>HEADING displays heading line without a tuple display.
>DOWn moves cursor down specified number of tuples in the table.
>NEXT positions to next tuple in table but does not display it.
>
UP
moves cursor up the specified number of tuples in the table.
>
PREV
positions to the previous tuple but does not display it.
>POSition positions the cursor at a specified tuple in the table.
>DISplay displays the tuple entry for the current tuple.
>LOCate locates tuple by field(s) but does not display (see DISplay).
>
RANge
displays the table heading field(s) by number and/or name
plus parameter type(s) with a sample of valid inputs.
>INForm displays the current table name.
>TOP positions on the first tuple in the table and displays it.
>FIRST positions to first tuple in table but does not display it.
>BOTtom positions on the last tuple in the table and displays it.
>
LAST
positions on the last tuple in the table but does not display it.
>
LEAVE
exits current table (or number of levels specified, i.e., ALL).
>
POF
enters the Pending Order (PO) subsystem (see following).
Pending Order Subsystem
(NTP 297-1001-360, Basic Translations Tools Guide)
The commands available in the Pending Order (PO) subsystem include:
>
ACTIVATE
activates POs.
>CREATE enters the file name of any previously produced DMO file in
the PO subsystem.
>
DELETE
use to delete the POF and SFDEV file.
>DISPLAY Use the DISPLAY command to display the contents of all or
specified POs in the PO subsystem by either the due date or
sort option, which uses the parameters TIME and POF.
>HELP <cmd_name> Use HELP command to display a brief functional
description of desired PO subsystem command.
>LEAVE leave the Pending Order Subsystem.
Other Supporting Commands:
>DUMPTAB used to move table(s) into SFDEV for manipulation by user.
>DMOPRO activates/applies the SFDEV file to switch translations.
>DMOVER verifies the DUMPTAB SFDEV file and checks it for errors.
>INPUT replaces table tuples by looking for (a) key field(s) match.
>PUT add or replace tuples in a table if there is no matching key
field or fields already in the table. It will replace a tuple if it
finds a matching key field or fields.