DB2 graphic QMF Version 8

Map menu

Use the Map menu to control the attributes and view of a spatial map.

Add Layer

Select Map--> Add Layer to add a layer to the spatial map. The Add Layer dialog box opens.

Note:
You can select this option only if there is at least one result set open that contains spatial data, which means that the layer must have a column with GEO spatial data, as defined in the database.

Table 84. Add layer dialog box
Field Description
From File Select this radio button to select a shape file from a file.
  1. Select the From File radio button.

    The Add Layer dialog box refreshes with an input field for Name.

  2. Type the name of the file in the Name field.
  3. Click Add.
From Database Select this radio button to select a shape file from a database.
  1. Select the From Database radio button.

    The Add Layer dialog box refreshes with entry fields for Server, Owner, Name, and Type.

  2. At the Server field, select the server from the drop-down list.
  3. At the Owner field, type the name of the owner of the shape file.
  4. At the Name field, type the name of the object owner.
  5. At the Type field, select one of the following shape object types from the drop-down list:
    • Query
    • Table
  6. Click Add.
  7. Optional: Click List Objects.

    The Objects at [Owner] dialog box opens. Use the List Objects dialog box to view a list of objects matching your entries for server, owner, name, or type.

  8. Optional: Click Properties from the Objects at [Owner] dialog box.

    The [Owner Properties] dialog box opens. Use this dialog box to review historical detail for the object.

From Open Document Select this radio button to add a layer from an open spatial document. The Add Layer dialog box is refreshed, and a list box opens where you can select the layer.

List Objects

Click List Objects at the Add Layer dialog box to open the Objects at [Server] dialog box. This control is available only if you are adding a layer from a database.

Table 85. Objects at [Server]
Field Description
Server Select the server from the drop-down list.
Owner Type the owner name of the shape file
Name Type the name of the shape file.
Type Select the object type, either table or query.
Comment Review or type a comment associated with the object.
Refresh List Click Refresh List to repaint the Objects at [Server] dialog box
OK Click OK to select the object and close the dialog box
Cancel Click Cancel to return to the previous dialog box without making any changes
Properties Click Properties to open the [Object] Properties dialog box, which provides various information about the object, including a comment (that can be updated), attributes, usage summary, and number of times the object has been accessed

Properties

Click Properties at the Objects at [Server] dialog box to obtain detailed information for the object. The [Server] Properties dialog box opens.

Table 86. [Server] Properties dialog box
Field Description
Comment A comment associated with the object. You can type information in this field.
Shared with other users This check box indicates whether the object is shared with other users
Attributes Various attributes associated with the object, including:
  • Level

    The internal level of the object.

  • Type

    The type of the object.

  • Subtype

    The subtype of the query object, either SQL or prompted, or of the table object either T (for table) or V (for view).

  • Restricted

    Specifies whether the object is shared or restricted.

  • Model

    Specifies the internal object model of the object. For prompted queries, this is always REL. For all other objects, it is unused.

Usage Summary The type of usage summary statistics, such as:
  • Show First Used

    Click this radio button to view details about when the object was first used. The bottom half of this group box is updated.

  • Show Last Used

    Click this radio button to view details about when the object was last used. The bottom half of this group box is updated.

  • Show last modified

    Click this radio button to view details about when the object was last modified. The bottom half of this group box is updated.

  • Date, usage information

    From Usage Summary

  • Time

    From Usage Summary

  • User ID

    From Usage Summary

  • SQL ID

    From Usage Summary, the CURRENT SQLID of the person who first used, last used, or last modified the object, such as DB2ADMIN

  • Environment

    From Usage Summary, the environment (such as Windows, TSO, or CICS), in which the object was first used, last used, or last modified

  • Mode

    From Usage Summary, the mode (Online or batch) in which the object was first used, last used, or last modified

  • Command

    From Usage Summary, the command (such as IMPORT) that was used when the object was first used, last used, or last modified

Number of times
  • Number of times used
  • Number of times run
  • Number of times cancelled

Run History

Click Run History on the [Server] Properties dialog box to obtain summary history for the object. The [Object] Run History dialog box lists each time the object has run, if detailed object tracking is enabled in the QMF for Windows Administrator for your resource limits group.

History information is available for the user ID, date, start time, end time, success flag, and byte count.

Table 87. [Object] Run History dialog box
Field Description
User ID The user ID associated with the object, when it was run
Date The date on which the object was run
Start Time The time at which the object was submitted to run
End Time The time at which the object completed running
Success A code indicating the final result of the run
Byte Count The number of bytes retrieved by running the object (if the object is a query)

Display

Click Display on the Object [Run History] dialog box to obtain detailed run history for the object.

Table 88. Run Detail dialog box
Field Description
Date The date on which the object was run
User ID The user ID associated with the object, when it was run
Start Time The time at which the object was submitted to run
SQL ID The SQL ID, such as DB2ADMIN, which is the CURRENT SQL ID of the person who first used, last used, or last modified the object, from the Usage Summary
End Time The time at which the object completed running
Environment Environment, such as Windows, which is the environment (Windows, TSO, CICS) in which the object was first used, last used, or last modified, from Usage Summary
Row count The number of rows retrieved by running the query. This object is zero when the object is run from QMF for Windows.
Mode The online or batch mode in which the object was run
Byte Count The number of bytes retrieved by running the object (if the object is a query)
CPU time The amount of CPU time consumed by running the object. This value is zero when the object is run from QMF for Windows.
Result The final result of the run, indicating whether it completed successfully or if it was cancelled prematurely. Some of the results that may be displayed can occur only when the object is run from host QMF.
SQL text The actual SQL text run for the query. SQL text is tracked only if the Enable SQL text tracking resource limit is enabled in QMF for Windows Administrator, for your resource limits group.

Delete Layer

Select Map--> Delete Layer to delete a layer on the spatial map immediately.

Note:
No delete-confirmation message is issued before QMF for Windows deletes the layer.

Layer Properties

Select Map--> Layer Properties to work with the attributes of the mapping points on the layer. One of the following dialog boxes opens, depending on the type of layer.

Layer Labels

Select Map--> Layer Labels to work with the attributes of labels associated with features of the layer. The Layer Labels dialog box opens.

Table 92. Layer Labels dialog box
Field Description
Layer name The name of the layer
Display labels Check this check box to display labels for the selected column in the layer. The check box is enabled when you select a column from the Column drop-down list.
Column A column associated with the layer. Select a column from the drop-down list.
Placement Select one of the following options to determine how to place the labels for the layer:
  • on feature
  • above feature
  • below feature
A feature is a specific point on the layer.
Vertical alignment Select one of the following options to determine how the labels will be placed vertically on the layer:
  • top
  • center
  • baseline
  • bottom
Horizontal alignment Select one of the following options to determine how the labels will be placed horizontally on the layer:
  • left
  • right
  • center
Font Specify the font style for the layer's labels from the Font dialog box

Zoom In

Select Map--> Zoom In to magnify an area of the layer. The cursor changes to a magnifying glass with a (+). Move the cursor to the area you want to view in detail, then click on that spot.

Zoom Out

Select Map--> Zoom Out to obtain a high-level view of the layer or to reset the view after zooming in to the layer.

The cursor changes to a magnifying glass with a (-). Move the cursor to the area you want to view, then click on that spot.

Zoom to Fit

Select Map--> Zoom to Fit to fit the map to the work area.

Zoom to Current Layer

Select Map--> Zoom to Current Layer to view the selected layer. You can toggle between layers by selecting a different layer, then selecting Map--> Zoom to Current Layer.

The image is adjusted to fit your work area.

Pan

Select Map--> Pan to drag the map image left to right, or up and down, to obtain different views of the layer.

The cursor changes to a hand when you select this option. Place the hand over the map image, click the mouse, then hold down the main mouse button to shift the image.

Identify

Select Map--> Identify to obtain detailed information about a point on the spatial map.

Select the Identify option, then hover over on the map. Place the cursor over the area about which you would like additional information. The cursor changes to a pointer with an "I" symbol. Click that area. The Identify Results dialog box opens.

Table 93. Identify Results dialog box
Field Description
Location An output field that identifies the coordinates of the location (X and Y axes)
Range Specify the range, or radius, for which you want information, such as an area of 30-degrees beyond the selected location.

The Identify Results dialog is refreshed with identifying information for all features within the specified range.

Note:
The larger the range, the more features will be identified.

For example, by specifying a range of 1 within all visible layers, information is collected for two customers of a bank, including information regarding their checking accounts, average daily balance, and the main roads surrounding their homes.

Layers Select the layers for which you want identifying information. Choices are:
  • visible layers
  • selected layers
  • all layers in the spatial map
Features The individual layers included in the results, within the specified radius. The Query Results Explorer pane provides a tree-view of the layers and associated categories of data within each layer
Attributes The detailed information available for the selected layers, for the specified range and layers

Export

Select Map--> Export to export the map file to another location. The Save As dialog box opens. Specify the directory path, file name, and file type, then click Save.

Note:
The file will be exported as an image file, as a *.bmp (bitmap) or a Windows enhanced metafile (*.emf) file type.

Refresh

Select Map--> Refresh to redraw and refresh the contents of the spatial map.

Map Properties

Select Map--> Properties to define general settings for the spatial map application.

Table 94. Map Properties dialog box
Field Description
Scrollbars on map Check this check box to add vertical and horizontal scrollbars on the spatial map work area.
Escape key Specify the action to take when pressing the Escape key. Choices are:
  • Ignore
  • Stop drawing layer
  • Stop drawing map
Border style Specify the type of border to use on the spatial map to delineate features. Choices are:
  • None
  • Flat
  • 3-D
Background color Select, from the color palette, the background color that will fill the background area of the map

Export Map to Procedure

Select Map--> Export Map to Procedure to generate the SQL for the spatial map, in a procedure document. The original spatial map is retained.

Layers

Select Map--> Layers to view the layers selected for the spatial map.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004