Skip to content
CA RC/Update™ for DB2 for z/OS - 20.0
Documentation powered by DocOps

RC/Edit Commands

Last update October 7, 2014

The following commands are associated with RC/Edit:

CANCEL

Cancels the current edit session and returns to the Edit Options screen. No changes are made to the DB2 table.

The command syntax is:

CANCEL

The mode is Edit.

CAPS

Controls the data capitalization within a column. This attribute is assigned at the column level for more control. When CAPS is ON, all text entered for the column is converted to capital letters. This only affects new or updated data. To change all occurrences, see the UCASE or LCASE commands.

The command syntax is:

CAPS ON <column name>

CAPS OFF <column name>

The mode is Edit.

CHANGE or RCHANGE

Changes the value of a character string or number within a DB2 column.

The command syntax is:

CHANGE old-value new-value [column name]

RCHANGE CHANGE old-value new-value [column name]

The mode is Edit.

  • CHANGE
    Changes the occurrence to another value.
  • RCHANGE
    Changes the next occurrence from a value to another value. You must issue a CHANGE command before RCHANGE.
  • ALL
    Searches for all occurrences of the search string, changes each, and displays a count of the changes. If the change string is longer than the search string in a particular occurrence, there might not be room to make the substitution; counts of changes not allowed and of actual changes are generated.
  • X
    Searches for occurrences in rows or columns that have been excluded with the XCOL or the X line command.
  • NX
    Searches for occurrences in rows or columns that have not been excluded with XCOL or the X line command.
  • Y or NULL
    Searches for NULL values.
  • N or ¬NULL
    Searches for non-NULL values.
    To search for characters that are keywords, enclose them in single quotes.

COMMA

Determines if numeric columns will be formatted with commas. If COMMA is OFF, numeric columns will not be formatted with commas. Turn commas off when editing numeric columns (account or social security numbers).

The command syntax is:

COMMA ON

COMMA OFF

The mode is Edit or Browse.

END

Ends the edit session and saves all changes. If TRACE is ON, the trace screen displays during processing. If errors occur, the RC/Edit error screen displays.

The command syntax is:

END

The mode is Edit or Browse.

EXPLODE

Lets users enter the EXPLODE Facility to edit the contents of a character column using an ISPF full screen editor. To explode a character column, place the cursor on the column and press the EXPLODE function key. This feature allows the user to edit extremely long character data (any size) and to import data into the column from other data sets.

The command syntax is:

EXPLODE

The mode is Edit or Browse.

HEX

Specifies whether data displays in hexadecimal format when displaying the RC/Edit Searched Column Mode, Positional Column Mode, or Explode Facility screens. HEX is a toggle command. If the HEX mode is off, enter HEX and press Enter to turn the hexadecimal display mode on, and vice versa.

The display varies according to column type. When HEX mode is on, all character, graphic, and numeric columns display in hexadecimal format, and all date, time, and domesticate columns display as blanks.

HEX is not supported on Form Mode screens or the RI Editor screen. There are three lines per record display when the HEX mode is on. The first line is the EBCDIC format of the data. The second and third lines are the hexadecimal equivalents of the first line. The two characters that make up the hex representation of each EBCDIC character are directly under that character in vertical format.

Edit hexadecimal data by overtyping the information. Valid characters are 0-9 or A-F. Invalid characters are ignored.

The command syntax is:

HEX

The mode is Edit or Browse.

LCASE and UCASE

Change the case of every character in a character column. All values in the column are converted to the specified case.

The command syntax is:

LCASE column_name

The mode is Edit.

PROTECT and UNPROTECT

Protects or unprotects a column.

The command syntax is:

PROTECT column_name

UNPROTECT {column_name}

The mode is Edit.

  • PROTECT
    Protects a specified column.
  • UNPROTECT
    Unprotects a column that had been protected by the PROTECT command.
Note: Columns that are protected when the edit session ended are not updated. If any data in that column was updated before the column was protected, the update is ignored.

Column specification for UNPROTECT is optional. If no column is specified, all columns that were protected using the PROTECT command are unprotected.

REFRESH

Refreshes the data from the DB2 table. Any pending uncommitted updates are lost.

The command syntax is:

REFRESH

The mode is Edit.

RESET

Clears the current column mapping so the process can be restarted. Use this command with automapping to experiment with different mapping techniques.

The command syntax is:

RESET

SAVE

Saves the changes.

The command syntax is:

SAVE

The mode is Edit.

SCOL

Show Column. Unexclude columns excluded by the XCOL command.

The command syntax is:

SCOL [column name|@ALL]

The column specification and @ALL are optional using SCOL. If no column name is specified, SCOL unexcludes all columns that have been excluded by XCOL.

The mode is Edit.

SDELETE

Toggles the display of deleted records. The default mode is OFF so that deleted records disappear as they are deleted. To view deleted records, enter the SDELETE command. Undelete deleted records using the U line edit command.

Note: The SDELETE command works in Column Display mode only.

The command syntax is:

SDELETE

The mode is Edit.

SET

Changes the value of the column named in the command.

Note: The SET command works only when you are using the Searched Update method.

The command syntax is:

SET <column_name> = new_value [WHERE ...]

Note: If you do not specify a where clause, the value is changed for every row in the retrieved data. The SET command always uses any data query you entered on the RC/Edit Options screen to limit the rows affected by the command.

The SET command automatically commits all update changes made to the data, makes the change requested in the command and commits those changes to the database. The effect of the command is shown only if the Auto Refresh option is ON, or the REFRESH command is issued.

The mode is Edit.

SORT

Sorts the rows in ascending (default) or descending order according to the values in the designated column.

The command syntax is:

SORT column_name {A | D}

SORT with no parameters re-sorts the rows to the initial fetch order.

The mode is Edit or Browse.

SORT?

Displays the Data Query Edit screen. Use the Data Query Edit screen to sort on more than one column during the edit session.

The command syntax is:

SORT?

The mode is Edit or Browse.

SQL

Displays the SQL statement used to retrieve the data for the current edit session.

The command syntax is:

SQL

The mode is Edit or Browse.

STATS

View editing statistics anytime during an edit session using the STATS command. The Statistics Summary screen appears when the STATS command is entered while in an edit session. Pending statistics (the number of updates, deletes, and inserts that will be done if the user saves the data) are included in this screen.

TRACE

Turns online tracing of all activity during SAVE or END processing on or off. If TRACE ON is set, a screen displays showing the progress of the activity as it occurs. You can use this to gauge progress through the rows.

The command syntax is:

TRACE [ON|OFF]

The mode is Edit.

TYPE

Turns the DB2 data type line on and off. The data type line displays the column's DB2 data type along with the column abbreviation.

The command syntax is:

TYPE

The mode is Edit or Browse.

XCOL

Excludes one column or all columns from the display area.

The command syntax is:

XCOL {column name | @ALL}

The mode is Edit.

Was this helpful?

Please log in to post comments.