Viewing Metadata

In this section:

How to:

Viewing metadata is useful when creating request documents and SQL statements. You can view:
Top of page
x
Procedure: How to View Table Metadata

To view table metadata:

  1. If you are not connected to a defined target, connect to one, as described in How to Connect to a Defined Target.
  2. Expand the Schemas node under the desired connection.
  3. Select a database.
  4. Expand the Tables node.
  5. Scroll down and select a table to view.

    Note: Although the list of tables includes all tables in the RDBMS, the user ID you specified for the connection may not have access to the table you selected. If this is the case, the creation of schemas fails.

    When you select a table, a metadata summary table appears in the right pane containing Property and Value columns. The Value column contains a description of the table and an ellipsis symbol that you can click to access database properties and columns as shown in the following image.

    1. Depending on which properties you want to view, click the ellipsis symbol in the Database Properties or the Columns row.

      The properties (for example, data type and column size, represented by columns in a table) appear in the right pane as shown in the following image.

    2. When you are ready to create a schema, use this information to determine the table (or tables) and fields to use.
Top of page
x
Procedure: How to View Stored Procedure Metadata

To view stored procedure metadata:

  1. If you are not connected to a defined target, connect to one, as described in How to Connect to a Defined Target.
  2. Expand the Schemas node under the desired connection.
  3. Select a database.
  4. Expand the Procedures node.
  5. Scroll down and select the procedure to view.

    Note: Although the list of procedures includes all procedures in the database, the user ID specified for the connection may not have access to the specified procedure. If this is the case, the creation of schemas fails.

    When you select a procedure, a metadata summary table appears in the right pane containing Property and Value columns. The Value column contains a description of the procedure and an ellipsis symbol that you can click to access database properties and columns as shown in the following image.

    1. Depending on the properties you want to view, click the ellipsis symbol in the Database Properties or the Columns row.

      The properties (for example, data type and column size, represented by columns in a table) appear in the right pane as shown in the following image.

    2. Use this information to determine the procedure (or procedures) and fields to use when you are ready to create a schema.
Top of page
x
Viewing Sample Data

The iWay Technology Adapter for RDBMS provides an option that assists you in viewing sample data.

The Return All Rows option is available from any table node and all records for the given table. This option produces a formatted table of all the rows in the selected table.

To access this option, in the left pane of iWay Explorer right-click the table node of interest and select Return All Rows from the drop-down list. The Return All Rows pane opens on the right.

The following image is an example of a Return All Rows pane for a table named ABM_ARS_RATES. Use the scroll bars at the bottom and on the right of the pane to view the entire table.
Top of page
x
About the Search Tool

The iWay Technology Adapter for RDBMS search tool allows you to find specific items in an RDBMS target. An RDBMS target is structured into three major nodes:

These nodes contain subnodes of tables, procedures, Oracle packages, statements, and batches. The search tool is available from all nodes and subnodes in the Schemas, Statements, and Batches hierarchy.

If the database contains more than 64 tables or procedures, you must use the Search Tool to locate that Table or Procedure.
x
Procedure: How to Use the Search Tool

To open the search tool:

  1. Select a node under which you want to find one or more items. You can select either the Schemas, Statements, Batches node, or a sub node such as Tables, depending on which item you are looking for.
  2. Move the cursor over Operations in the right pane and select Search from the drop-down list.

    The Search pane, shown in the following image, opens on the right.

  3. In the Search path, type a specific item name or use the following search options.
    • Use %% for a recursive search.
    • Use % for a wildcard, non-case sensitive.

    The following is an example of a search entry:

    • %%%eda% indicates to recursively search for all nodes that contain the string "eda".
    • %%eda% indicates to recursively search for all nodes that start with the string "eda".
    • %%%eda indicates to recursively search for all nodes that end with the string "eda".
  4. Click OK.

    The Search Result(s) pane appears on the right displaying the items that match the search criteria.

    For example, under the Schemas, ABM, Tables node you can search for all tables that have MLS in the name using a search entry of %%%MLS%.

    The following image shows the search results, which returns all tables with MLS in the table name.

  5. In the Select column, click the item you want to view.
  6. Click OK.

    The item you selected is highlighted in the left pane.

iWay Software