Skip to Content

 

Information
Limited support 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.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Catalog Manager for Db2 13.1.

Editing data

Use the following procedure to edit data.

  1. Invoke the data editing function. For more information, see Methods-for-invoking-the-data-browsing-function.
  2. Set the options for controlling the display and the SQL processing. For more information, see Setting-options-for-editing-data.

  3. Press Enter.If another user has begun an editing session in the table or view, the Other Users Editing This Table panel is displayed. To edit the table or view, press Enter. To display the Edit DB2 Table Options panel, press END or CANCEL.

    If no other users are editing the table, the Edit DB2 Table panel is displayed (see following figure) according to the Initial Display Mode value that was selected in the Edit DB2 Table Options panel ( see Setting-options-for-editing-data).

    DEFF --------------------------  Edit DB2 Table  -----------------------------
    Command ===>                                                  Scroll ===> CSR

    QZU.QZUT01_DCII9S05 (1/300)
    ******     COLUMN_1 COLUMN_2 COLUMN_3     COLUMN_4 COLUMN_5 COLUMN_6
    000001      1818599        0  AABN0000467 1124064  4064     'DEFENDANT ARRAIGN
    000002      1818629     7364  AABN0000478 1130064  0064     'DEFENDANT ARRAIGN
    000003      1818687    26700  AABN0000495 1139064  9064     'DEFENDANT ARRAIGN
    000004      1818706   -20104  AABN0000501 1141064  1064     'DEFENDANT ARRAIGN
    000005      1818722    27713  AABN0000506 1145064  5064     'DEFENDANT ARRAIGN
    000006      1818733   -14913  AABN0000510 1146063  6063     'DEFENDANT ARRAIGN
    000007      1818754     7200  AABN0000517 1148064  8064     'DEFENDANT ARRAIGN
    000008      1818758    16000  AABN0000519 1148064  8064     'DEFENDANT ARRAIGN
    000009      1818781     7300  AABN0000525 1160064  0064     'DEFENDANT ARRAIGN
    000010      1818810     3300  AABN0000536 1164064  4064     'DEFENDANT ARRAIGN
    000011      1818836     6800  AABN0000543 1171064  1064     'DEFENDANT ARRAIGN
    000012      1818895        0  AABN0000561 1176064  6064     'DEFENDANT ARRAIGN
    000013      1818902        0  AABN0000562 1177064  7064     'DEFENDANT ARRAIGN
    000014      1818932     4275  AABN0000573 1182064  2064     'DEFENDANT ARRAIGN
    000015      1818944        0  AABN0000577 1184064  4064     'DEFENDANT ARRAIGN
    000016      1818954     5985  AABN0000578 1185064  5064     'DEFENDANT ARRAIGN
    000017      1447973    18000  AABN0000585 1655233  5233     'DEFENDANT ARRAIGN
    000018      1819036        0  AABN0000600 1209064  9064     'DEFENDANT ARRAIGN
    000019      1448522        0  AABN0000603 0773625  3625     'DEFENDANT ARRAIGN
    000020      1448585   -31536  AABN0000612 0774002  4002     'DEFENDANT ARRAIGN
    Warning

    Note

    If the selected table contains no data, then the placeholder *INS is displayed.

  4. Edit the table using the following commands:

    Action

    Description

    Edit data

    Move the cursor to the column and row and type the new values. You can switch between column and row views.

    You can also make changes using the command line:

    Type C originalString changedString or CHANGE originalString changedString in the Command line.

    Warning

    Note

    Any changes that you have made to the data are highlighted before the viewing mode is switched.

    View data

    To switch from column view to row view, type ROW on the Command line, and then press Enter.

    To switch back to column view, click END.

    To view additional rows of data , press F11 to go to the next row or F10 to return to previous row.

    Warning

    Note

    You can change your default view to Row view by changing your table editor options. see Setting-options-for-editing-data.

    Insert row

    Type I next to the row you want to precede the insertion

    Repeat row

    Type R next to the row that you want to repeat.

    Delete row

    Type D next to the row that you want to delete. *DEL is displayed

    Warning

    Note

    Any deletions are highlighted.

    Zoom row

    Type Z to zoom the row and enter row view.

    To update a column with a hex value, zoom the row and enter the update on the zoomed field.

    Undo uncommitted changes

    Type U and press Enter next to the row that you want to undo any uncommited changes.

    Commit changes

    To save updated, inserted, or deleted data,

    1. Click END or type SAVE on the Command line (commit and return you to the table editor) or END ( commit and exit the table editor) on the command line.

      The Statistics panel is displayed.

    2. Review and press Enter to save or type CANCEL to rollback the changes
    Warning

    Note

    To leave the table editor without committing your changes, type CAN or CANCEL on the Command line.

    Sort viewed data

    1. Type SORT columnName order to change the order of the data that you are viewing. You are prompted to define column sequence and order (ascending/descending).
    2. Click END and the table editor displays changes.

    Find data

    Type F SearchString or FIND SearchString in the Command line

    Warning

    Note

    The online Help (click F1) contains a complete list of commands and their descriptions.

  5.  If the address space is insufficient to display all of the selected rows, Catalog Manager displays a message that refers to memory constraints. To display more rows, complete the following steps:

    1. Ensure that you are in column view mode.
    2. On the Command line, type MORE .

    3. Press Enter.The Display More Rows Options panel is displayed.

      DEFF-R -------------------  Display More Rows Options  ------------------------
      Command  ===>                                                                  
                                                                                    
      Specify the following options.                                                 
      Press ENTER to continue or press END or CANCEL to exit.                        
                                                                                    
      Save table changes . . . . . Y    Y/N save changes. N will discard changes     
                                        made since the last SAVE.                    
                                        (this is ignored in table BROWSE mode)       
                                                                                    
      Current range of rows displayed is: 1 .. 300
                                                                                    
      Begin next display with row . . . . 301
    4. In the Save table changes field, type Y to save the edits that you have made since you last saved the changes.
    5. To display the next set of rows in the table, press Enter.

    The Edit DB2 Table panel is displayed with the next set of rows.

    Warning

    Note

    If the message that refers to memory constraints is displayed again, repeat Step 5 until all of the selected rows have been displayed and edited.

  6. Press SAVE or END to terminate the editing session.
  7. (optional) If you typed Y for the Confirm before update value on the Edit and Browse Options panel, respond to the Confirm Updates popup.
    • Press Enter to save the changes and end the editing session.
    • Press END to cancel saving the changes and return to the editing session.
  8. (optional) If you typed Y for the Display Statistics value on the Edit and Browse Options panel, the Statistics popup is displayed. You can commit the edits or rollback the data to its original value.When the editing session is ended, the Edit DB2 Table Options panel is displayed. The panel includes a confirmation message.

Related topic

Editing-table-data


 

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

BMC AMI Catalog Manager for Db2 12.1