Using Filters

You can create a filter to display specified or all details of the TDS protocol data. If you do not specify a filter file name, the default filter is used.

Select a default filter.

  1. To see the default filter selections, enter:
    Ribo -gui -l 4000 -d
  2. In the Ribo window, select File > Edit Filter.

    In the Default Filter Selection window:

    • The left column shows token types.
    • The right column shows details for some or all tokens. Selected items are highlighted and represent the token details you want to see from the TDS protocol data.

    Available Tokens Details

    Items

    Description

    TOKEN Details

    Information about the single-byte token itself, like its hexadecimal value and whether it is fixed or variable length. If you do not select (highlight) this detail, only the token name is dumped.

    Pertains to all tokens.

    LENGTH Details

    Information about the various length fields found within a token, including the overall token length.

    Pertains to all tokens.

    SQL_TEXT Details *

    Text of a SQL query. This item overrides DATA Details.

    Pertains only to LANGUAGE tokens.

    DATA Details

    All details of the token beyond what is specified by TOKEN Details. This is what the TDS 5.0 Specification calls the “data stream” that follows the token itself.

    Pertains to all tokens.

    VERBOSE_CAP Details

    Specifies that the flags in a CAPABILITY token are to be dumped in “verbose” format, which indicates the name of each flag and its value. If you do not select this detail, flags are dumped as hexadecimal.

    Pertains only to CAPABILITY tokens.

    PASSWORD Details

    Specifies that the password in the login record is to be dumped. If you do not select this detail, the password is dumped.

    Pertains only to the login record.

    ROW Details *

    Row data of a ROW, PARAMS, ALTROW or KEY token. If you do not select this detail, the data is not dumped. Specifying this detail overrides DATA Details.

    Pertains only to ALTROW, KEY, PARAMS, RPC, RETURN_VALUE and ROW tokens.

    FORMAT Details *

    Format data of a PARAMFMT, ROWFMT, or ALTFMT token. Specifying this detail overrides DATA Details.

    Pertains only to ALTFMT, PARAMFMT, ROWFMT, RPC and RETURN_VALUE tokens.

    RPC Details *

    Overrides DATA Details for DBRPC tokens.

    Pertains only to DBRPC tokens.

    CURSOR Details *

    Overrides DATA Details for all CURSOR tokens.

    Pertains only to CURCLOSE, CURDECLARE, CURDELETE, CURFETCH, CURINFO and CURUPDATE tokens.

    EED Details *

    Overrides DATA Details for EED tokens.

    Pertains only to EED tokens.

    Tip: Selecting items marked with an asterisk (*) when you have not selected DATA Details causes the details to be dumped for certain tokens. That is, these details override DATA Details.
    Note: Every token that occurs legally in TDS version 5.0 or later is recognized by Ribo. See the TDS 5.0 Functional Specification at http://www.sybase.com/detail?id=1040983 .
Related tasks
Capturing and Translating Data Using the GUI
Related reference
Command Line Options