CUT (CU)


CUT is only valid in Edit table mode. Use CUT to copy (append) one or more rows of data into the current paste buffer, or clipboard. The clipboard can only contain rows from a single table. Mark the rows to be copied with the C (for a single row) or CC (for multiple rows) line command (see also C-Copy). The paste buffer stores the data until the next CUT REPLACE command overwrites the current content. Use the PASTE command to insert the paste buffer contents into the current table or use PASTE DS to copy its content to a data set (see PASTE-PAS). File-AID for Db2 supports one paste buffer per session. The message n Row(s) cut indicates that the selected row(s) have been copied to the clipboard.

image2021-3-9_15-32-1.png

CUT Warning Window

When attempting to CUT (append) rows into the current clipboard that already contains rows from a different table, the CUT Warning Window (see the following figure) displays. It identifies both tables so you can evaluate whether to replace the rows in the clipboard.

Enter Y to continue with the CUT, and replace the existing rows on the clipboard.

Enter N (default) to cancel the CUT, and leave the clipboard unmodified.

CUT Warning Window

image2021-3-9_15-32-48.png


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*