Viewing and editing the contents of a cell in the query results

If you are using QMF for Workstation, you can use the Zoom option to view in hexadecimal or binary format the contents of a cell in the query results.

About this task

This topic describes how to:
  • View the contents of a query results cell when the results are read-only. See step 1.
  • View and edit the contents of a query results cell when the results are writable (not read-only). See step 2.

Procedure

  1. To view the contents of a query results cell when the results are read-only:
    1. Right-click a cell in the query results. Select Zoom from the pop-up menu. The Zoom window opens.
    2. The CCSID field specifies the code page that was used to save the data in the selected query results cell.
    3. The current value of the selected query results cell is displayed in the Cell value field.
    4. Click Advanced to expand the dialog with additional fields to display the data in hexadecimal or binary format. This button is disabled for cells with numeric data.
    5. Select Hexadecimal to display the data in hexadecimal format. Select Binary to display the data in binary format. The Zoom window displays samples of the data in the format that you have chosen.
    6. Select Cancel to close the Edit window.
  2. To view or edit the contents of a query results cell when the results are writable (not read-only):
    1. Right-click a cell in the query results and select Edit from the pop-up menu.

      The Zoom Edit window opens.

      The CCSID field specifies the code page used to save the data in the selected query results cell.

      The current value of the selected query results cell is displayed in the Cell value field. The Cell value field is editable.

    2. Make the necessary changes and select OK to apply them.
    3. Click Advanced to expand the dialog with additional fields to display the data in hexadecimal or binary format.

      This button is disabled for cells with numeric data.

    4. Select Hexadecimal to display the data in hexadecimal format or select Binary to display the data in binary format.

      The Zoom Edit window displays samples of the data in the format that you have chosen.

    5. Select Cancel to close the Zoom Edit window.

    To edit a cell in the tables on which the query is based you can use the table editor.