4—add row

You can use the Add row option to add a new row after a selected row of an opened table. When you select the Add row option, perform these tasks on the Tables panel:

Specify the name of a table in the Table Name field. If the table is not open, specify NOWRITE or WRITE in the "Open tables" field.
Specify a row number or a search operand list to identify a row.

Note: Use the View action bar choice on the Tables panel to specify whether this display is to be in a pop-up or full-screen.

Figure 1. Add row panel (ISPYTPA)

 ┌──────────────────────────────── Dialog Test ────────────────────────────────┐
 │   Menu  Utilities  Help                                                     │
 │ ──────────────────────────────────────────────────────────────────────────  │
 │                Add row   Table ISPKEYS   after row 1      Row 1 to 10 of 73 │
 │                                                                             │
 │ Add variable values and savenames. Underscores need not be blanked.         │
 │ Enter END command to finalize changes.                                      │
 │                                                                             │
 │       Variable  T A Value                                                   │
 │       KEYLISTN  K                                                           │
 │       KEY1DEF   N                                                           │
 │       KEY1LAB   N                                                           │
 │       KEY1ATR   N                                                           │
 │       KEY2DEF   N                                                           │
 │       KEY2LAB   N                                                           │
 │       KEY2ATR   N                                                           │
 │       KEY3DEF   N                                                           │
 │       KEY3LAB   N                                                           │
 │       KEY3ATR   N                                                           │
 │                                                                             │
 │ Command ===>                                             Scroll ===> PAGE   │
 │  F1=Help        F2=Split       F3=Exit        F4=Expand      F5=Rfind       │
 │  F6=Resize      F7=Backward    F8=Forward     F9=Swap       F10=Actions     │
 └─────────────────────────────────────────────────────────────────────────────┘

When you press Enter, a scrollable display is shown (Figure 1), containing all the key and name variables in the table. The pop-up window can also be resized using the RESIZE command.

Each row of the display contains a line command field and these fields:

Variable

Variable name.

T

Type of variable, non-modifiable:

K: Key variable.
N: Name variable; non-key.
S: Save (extension) variable.

A

Attribute of each variable. This attribute is non-modifiable and is not used for this option.

Value

Space for the variable value to be added, up to 2048 characters.

Type the values for the key and name variables in the Value column, which is originally initialized to all nulls. You cannot change the names of the key and name variables because they were established when the table was created.

You can enter save variables, identified as TYPE S, by typing over the underscores with the save variable names and specifying the desired values. The underscores are pad characters; you do not need to blank them out.

You can add a row with no values to the table, but you are asked to confirm such an action to guard against inadvertent use of the END command.

When using the Add row option, be aware that:

The position of the new row in the table depends on whether the table was previously sorted using the TBSORT dialog service. If the table was sorted, the new row is placed in sort order; if it has not been sorted, the new row is placed after the row you specified.
You cannot delete a key or name variable and its value from the display or table row.
You cannot change the variable name for a key or name variable; if you do, an error message is displayed and the original name is restored.
If more than one variable entry has the same name, all instances of that variable are assigned the value of the last occurrence of the variable; that is, the occurrence closest to the bottom of the display that you can scroll.
If the table has keys, the values for the keys in the added row must be different from those in all the existing rows when you leave the Add Row option. Otherwise, a message is displayed and the row is displayed again so you can change the keys.
Blank save names are ignored and do not need to be deleted, even if data is left in the value.
Hexadecimal data that usually cannot be displayed is converted to characters that can be displayed or is typed by using the form:
```
X'nnnnnnnn'
```
where:
n

An integer 0-9 or an alphabetic character A-F. There must be an even number of characters within the quotation marks.
Variables defined with the VDEFINE service as non-character are shown in converted form; do not change them by using the hexadecimal representation. A format or length error causes an error message to be displayed when you use the END command.