TSO-ISPF JCL COBOL VSAM DB2 CICS IMS-DB Tools Articles Forum Quiz Interview Q&A

Dataset Manipulation Commands


Dataset Manipulation Commands Overview:

Editing and manipulating Commands can be executed by placing the required command between column 1 and Column 6, then pressing ENTER.

Basic Commands:

INSERT:

  • A Single blank line can be inserted with an 'I' between any of column 1 to 6.

  • Multiple blank lines can be inserted by specifying number of lines after 'I'. (For example: To insert 11 Lines, 'I11')

REPEAT:

  • A Single line can be duplicated once with an 'R' between any of Column 1 to 6.

  • A single line can be duplicated multiple times by specifying number of times to duplicate after 'R'. (EG: To duplicate 6 times, 'R6')

  • Multiple Lines can be duplicated once by specify 'RR' in the Column 1 to 6 of First line and another 'RR' in Last line.

DELETE:

  • A Single line can be deleted with a 'D' between any of column 1 to 6.

  • Multiple lines can be deleted by specifying number of lines after 'D'. (EG: To Delete 6 Consecutive Lines, 'D6'). Also Multiple Lines can be deleted by specifying 'DD' in the Column 1 to 6 of First line and another 'DD' in Last line of deletion. This is similar to previous example as given in the above screen shots.


COPY/MOVE Commands:

The COPY and MOVE Commands are similar in execution, but COPY command retains the original content and MOVE remove the original content.

COPY:

  • A single line can be copied with a 'C' between any of column 1 to 6.
  • Multiple lines can be copied by specifying 'CC' in the Column 1 to 6 of First line and another „CC‟ in last line to be copied.

Similarly, MOVE can be done with 'M' or 'MM', only difference being original content will be removed.

PASTE:

Once copy or move is performed, those lines marked by 'C' or 'M' can be pasted or inserted in-between by using 'A' or 'B' in Column 1 to 6. 'A' places the line after the current line 'A' is specified. 'B' places the line before the current line 'B' is specified.

OVERLAY:

If 'O' (Single Line) or 'OO' (Multiple Line) is used instead of A or B, then the data marked by C or M will overlay on the lines marked by O or OO. All blanks on the line marked by O will be overwritten by the corresponding data on the line marked by C or M. If the entire data on the C or M line was written, then the Overlay is successful. If you move a line to overlay another line and complete Overlay was not possible, then the system will not move the line. It will copy the line and display error message.


Exclude/Show commands:

Use X or XX to exclude one or more lines of data from being displayed on the screen temporarily, where as delete remove the data permanently from the file.

  • X: Identifies a line to be excluded.

  • X5: Identifies the first of 5 (or any number of) lines to be excluded.

  • XX: Identifies the first and last lines of a block of lines to be excluded. (Usage is like Block copying)

Use the F line command to display the first lines of a block of excluded lines and the L Line Command to show the last line(s) of an excluded block.

  • F: Indicates that the first line of the block is to be displayed.

  • L3: Indicates that the last 3 (or any number of) lines are to be displayed.


Text handling commands:

  • TS text split, to split a text line at the cursor to allow insertion

  • TF text flow, to flow text to the end of a paragraph

  • TE text enter, to format the screen for power typing one or more text paragraphs

  • LC lowercase, to change text from uppercase to lowercase

  • UC uppercase, to change text from lowercase to uppercase


Miscellaneous commands:

  • BNDS to display and allow changes to the current bounds.

  • COLS to display a formatted line for identifying display columns. This is a primary command for Browse Mode.

  • MASK to display and allow changes to the current mask.

  • TABS to display and allow changes to the current tabs line.

Data commands:

The MD (Make Dateline) command converts temporary lines to data lines. Normally, the NOTE lines (that come with models), MASK, BOUNDS etc. are not part of the data. The MD command converts these lines to data and stores them as part of the data set.

Note: You can assign line commands to PF keys by prefixing the command with a colon. For example, to assign the line command I5 to the key PF7 key, type KEYS on the command line to get the current key list, assign: I5 to PF7 and save the key list.


If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!

Are you looking for Job Change? Job Portal