Editing Relational Tables › Edit the Structure of a New Table › Primary Commands for Creating Table Structure

Primary Commands for Creating Table Structure

To manage your table creation session, you can issue the following primary commands (similar to ISPF edit commands) from the command line. If a command appears in all uppercase letters, you must enter the full command name. Otherwise, enter only the part of the command shown in uppercase.

CANcel

Exits this table creation session without creating the table.

CAPS

Converts the column names you enter to uppercase or lowercase characters. If you enter the column name in uppercase, the table editor converts data entered in that column to uppercase. If you enter the column name in lowercase, data entered in that column remains in the case in which you entered it.

The CAPS command applies only to columns containing character data.

Note: By default, CA OPS/MVS sets the names of columns with non-character data to uppercase.

Issue one of these versions of the CAPS command:

• CAPS ON-Sets the names of all character columns to uppercase
• CAPS OFF-Sets the names of all character columns to lowercase
• CAPS ASIS-Resets the case of column names to match the case of the data you entered in those columns

Consider the following when issuing the CAPS command:

• CA OPS/MVS does not change the case of data in columns containing unmodified data, no matter which version of the CAPS command you issue.
• CA OPS/MVS always translates hexadecimal data to uppercase.
• CAPS ASIS mode is in effect when you first enter an editing session.

Change

Replaces one text string with another:

• The command C string1 string2 substitutes string2 for this occurrence of string1.
• To search forward and change the next occurrence of string1, issue the command C string1 string2 NEXT.
• To search backward and change the previous occurrence of string1, issue the command C string1 string2 PREV.
• To change all occurrences of string1, issue the command C string1 string2 ALL.

Note: If you substitute an asterisk (*) for one or both of the strings in any of these CHANGE commands, the table editor uses the string value or values specified on the previous CHANGE command.

DOWN

Scrolls down toward the bottom of the table.

END

Saves changes and exits this editing session.

FIND

Finds a specified text string and places the cursor on that string:

• To search forward for the string, issue the command
  F string NEXT.

  Note: The table editor searches forward by default.

• To search backward for the string, issue the command
  F string PREV.
• To search for the string specified on the last FIND command, issue the command F *.

  To change the direction of a search (but search for the same string), issue the command F * NEXT or F * PREV.

LEFT

Scrolls toward the left side of the column definitions.

RCHANGE

Repeats the last Change command issued.

RESet

Cancels all pending line commands and removes all SQL error messages from your screen.

RFIND

Repeats the last Find command issued.

RIGHT

Scrolls toward the right side of the column definitions.

UP

Scrolls toward the top of the table definition.