Skip to Content
Information
Space announcement: BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.

PASTE (Paste Data)

The PASTE primary command pastes data captured by a CUT command. Execute without a parameter to paste a field. Use the IN keyword to format a WHERE IN clause list using data from a CUT command; see CUT-Capture-Data.

Multiple executions of the PASTE command can be performed without losing the contents of the cut buffers, which are refreshed when a CUT command is performed after a PASTE command.

image2021-4-28_14-41-42.png

IN

Pastes data captured by a previous CUT COLUMN command into a WHERE clause as an SQL IN list.

 

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

BMC Compuware File-AID for Db2 21.01