DynaTrace

DynaTrace displays events such as database access. In the basic setting, you can select the type of event to log and the table to log (optional). If you select the detailed option, information on every field in a selected table appears.

Through the advanced features, you can create customized queries.

To show field-level data, click Display fields.

Advanced enables a dialog box of options for creating a custom query.

To run DynaTrace (simple)

  1. From a form, click Tools > Trace.
  2. Click the Dyna tab.
  3. If you are using the Dyna tab, click Display fields, if you want to see field-level data.

    If you want to create a custom query, follow the instructions in the next section.

  4. When you are finished making selections, click Start.
  5. When you are finished reviewing data, click Stop.
  6. If you want to save the data to a text file, click Save As.

To run an advanced DynaTrace

Using this feature requires knowledge of the function you are querying.

  1. From a form, click Tools > Trace.
  2. Click the Dyna tab.
  3. Select the Operation you will view.

    Choices are Read, Delete, Insert, and Update.

    For example, if you want to view how the database is handling insert operations for a specific table, select Insert.

  4. Select the table you want to view.
  5. If you want to see field-level data, click Display fields.
  6. Click Advanced.
  7. Make selections for these items:
    Option Meaning
    Status

    Required.

    Specify the name of a valid operation for the function you are viewing, for example, CHAIN, READ.

    Operations typically include the currently active program name and the database logical file name, for example, TST001 CHAIN_LOCK MITBAL00.

    Wildcards "*" and "?" are allowed. "*" means any number of characters. "?" means a single character. For example, to trace any operations with MITBAL, use status match "*MITBAL*".
    Time

    Optional.

    You can choose to perform the trace before or after the status operation has been executed.

    Select Before or After from the drop-down list.
    Display

    Optional.

    Display a variable selection for trace output, program variables or database fields.

    Wildcards "*" and "?" are allowed. "*" means any number of characters. "?" means a single character.

    For example, use "ITBAL.*" to print all MITBAL fields or "IN9?" to print values of indicators starting with 9, including, IN90, IN91, etc.
    Variable

    Optional.

    You can use a variable name for a trace condition. The variable can be a program instance variable, such as, IN91, or a database field, such as, ITBAL.CONO.

    EQ

    Optional.

    Equality selector. From the drop-down menu, choose "==" for equal or "!=" for not equal.
    Value

    Optional.

    You can use a variable value for a trace condition.

    Examples:

    • a string representation of the value

    • a string for MvxStrings

    • numeric for Java numerical data types

    • true/false for Boolean types, including, indicators.
  8. When you are finished making selections, click Start.
  9. When you are finished reviewing data, click Stop.
  10. If you want to save the data to a text file, click Save As.

    You will be prompted for a location to save the file.