From a message queue (Oracle AQ)

Edit online

About this task

Use the Database Interface Designer to generate type trees for a message on an Oracle AQ message queue. An example of the Generate Type Tree from Queues dialog follows, along with a table describing its fields and their descriptions.

   
Database Name This is the name of the database from which you want to generate a type tree. (This name is automatically inserted based upon your selection in the Navigator.)
Tables/Views This list displays all of the queues that have been defined in this database. Select one or more from this list.

If the queue you want is not displayed in this list, add it by right-clicking in the list, selecting Insert, and typing the desired name.
File name This field displays a system-generated file name based upon the database selection in the Navigator. The default value is the database name with a type tree extension (.mtt) and a default path.

To change any of this information, click the browse button.
Overwrite file This check box determines whether you want to replace the existing type tree file (MTT) upon saving it. The default value is disabled.
Override type This check box determines whether to replace existing types with matching, newly generated types and to add any non-matching new types to the type tree file (MTT). This is useful when you want to add types for additional stored procedures into an existing type tree. The default value is enabled.
Row group format This list displays options to determine the row format in the generated type tree. The default value is Delimited.
Option
Description
Delimited
Select this option to create rows delimited with a pipe character (|) or some other user-defined selection. This is the preferred option if you are using large column widths where the values may be smaller than the width of the columns. The pipe character is the default selection.
Fixed
Select this option to create rows of fixed size in the generated type tree. There are certain situations in which you would want to select Fixed.
Delimiter This is the value for the delimiter to be used when generating this type tree. For a list of available symbols, click the browse button. The Symbols dialog appears, allowing you to select the desired value. The default value is a pipe character (|).
Terminator This is the value for the terminator to be used when generating this type tree. For a list of available symbols, click the browse button. The Symbols dialog appears, allowing you to select the desired value. The default value is <CR><LF >.
Release This is the value for the release character to be used when generating this type tree. For a list of available symbols, click the browse button. The Symbols dialog appears, allowing you to select the desired value. The default value is an exclamation point (!).
Override Column Definitions (For ODBC only) This field is not available for message queues.
Generate type trees in 1.4.0 format (For Oracle adapter only) This check box determines whether you can generate type trees that are compatible with Version 1.4.0 maps. You might enable this functionality if you have legacy 1.4.0 maps that you want to maintain for some reason. The default value is disabled.

For more information about this field, refer to adapter-specific documentation in each adapter reference guide.
Represent date/time columns as text items This check box determines whether to automatically format this information as a text string. By default, the checkbox is deselected, and the information is formatted in its database-specific date and time format.

If you enable this check box (generating date and time as a text string), you might have to use either the TEXTTODATE or TEXTTOTIME function in a map rule to convert the text string to the database-specific date and time format.

If you are generating new type trees, make sure this check box is disabled.

Note: Because of adapter-specific differences in date and time formats, see the adapter-specific instructions in each adapter reference guide.
Treat text item as This list displays the languages available in which to handle text items. The default value is Western.

To generate a type tree from a queue:

Procedure

  1. In the Navigator, select the icon of the database from which you want to generate a type tree.
  2. From the Database menu, click Generate Tree From > Queue.
    The Generate Type Tree from Queues dialog appears, including a list of queues.
  3. If you need to add a queue because it is not displayed in the Tables/Views list, you must insert it following the information in the Note below.

    or

    If you see one or more queues in the Tables/Views list that you want to select, if it is one, select it. If it is multiple queues, press either Shift or Ctrl and click the desired queues.

  4. To create a new type tree, in the File name field, specify the path and name (with an .mtt extension).

    or

    Click the browse button to select a type tree from the Save As dialog. Highlight it and click OK.

  5. Specify the remaining options as needed.
  6. Click Generate.

    The Database Interface Designer and the Type Tree Maker produce a type tree corresponding to the selected queue(s).

    Note: Type trees generated from queues are not graphically represented in the Navigator.