Document Outline

• HP NonStop MXDM User Guide for SQL/MX Release 3.2
• Contents
• About this guide
  • Publishing history
  • New and changed information
  • Supported Release Version Updates (RVUs)
  • Audience
  • Organization
  • Related documentation
    • NonStop SQL/MX customer library
  • Notation Conventions
  • HP encourages your comments
• 1 Introduction to MXDM
  • Overview
  • MXDM features and functionalities
  • MXDM functional flow
• 2 Installing and uninstalling MXDM
  • Supported version of SQL/MX
  • Contents of the installation package
  • Prerequisites
  • Installing MXDM
    • Installing the 32-bit version of MXDM
    • Installing the 64-bit version of MXDM
  • Uninstalling MXDM
• 3 Managing MXDM system objects
  • Starting up MXDM
  • Adding a system
  • Connecting to a system
  • Disconnecting from a system
  • Using the Systems Tool
  • Editing a system definition
  • Copying a system definition
  • Removing a system
  • Testing a system definition
  • Setting the connection timeout
  • Exiting MXDM
• 4 Navigating MXDM
  • MXDM interface
  • MXDM banner
  • Using the MXDM menus
    • Using the File menu options
    • Using the Edit menu options
    • Using the Tools menu options
    • Using the Windows menu options
    • Using the Help menu options
  • Using the MXDM toolbar
  • Selecting an area
  • Adjusting the display of an area
  • Using the My Favorites pane
    • Creating a folder to store favorites
    • Creating a favorite
    • Using a favorite
    • Viewing a list of favorites
    • Removing a favorite
    • Removing a favorites folder
    • Considerations
  • Using the navigation tree
  • Using the right pane
  • Working with windows, tabs, and panes
    • Cloning tabs and managing multiple open windows
    • Expanding and collapsing panes
• 5 Performing basic MXDM operations
  • Obtaining version and build information
  • Resolving errors and error messages
  • Sorting and moving data columns
  • Working with data grids
    • Introduction to data grids
    • Obtaining row details for a data grid
    • Copying data grid information
    • Customizing the data grid
    • Searching the data grid
  • Copying data
    • Copying data to the clipboard
    • Copying data to a file
    • Copying data to a spreadsheet
    • Copying data to a browser
  • Saving and importing system definitions
• 6 Viewing database objects
  • Viewing catalogs and their objects
    • Viewing catalog attributes
    • Viewing catalog registrations
    • Viewing schemas within a catalog
    • Viewing catalog DDL
  • Viewing schemas
    • Viewing schema attributes
    • Viewing tables within a schema
    • Viewing schema views
    • Viewing schema procedures
    • Viewing SQL/MP aliases within a schema
    • Viewing schema DDL
  • Viewing table properties
    • Viewing table column properties
    • Viewing table primary key properties
    • Viewing hash key properties
    • Viewing store order properties
    • Viewing check constraints
    • Viewing unique constraints
    • Viewing foreign key properties
    • Viewing table attributes
    • Viewing table partition properties
    • Viewing information on related objects
    • Viewing DDL information of a table
    • Viewing information related to table statistics
    • Viewing information related to table privileges
    • Displaying table indexes and their properties
      • Viewing the table index columns
      • Viewing the table index attributes
      • Viewing the DDL output for a table index
      • Viewing information related to table index partitions
    • Displaying table triggers and their properties
      • Viewing the table trigger attributes
      • Viewing information on related objects
      • Viewing the DDL output for a table trigger
  • Managing objects using the SHOW DDL option
  • Viewing schema views and their properties
    • Viewing properties related to view columns
    • Viewing attributes of a view
    • Viewing information on related objects
    • Viewing DDL information of a table
    • Viewing information related to view privileges
  • Viewing procedures and their properties
    • Viewing attributes of a procedure
    • Viewing parameters of a procedure
    • Viewing information on related objects
    • Viewing DDL information of a procedure
    • Viewing information related to procedure privileges
  • Viewing SQL/MP aliases and their properties
    • Viewing attributes of the SQL/MP alias
    • Viewing DDL information of a SQL/MP alias
  • Viewing table statistics and their properties
• 7 Managing MXCS objects
  • Viewing MXCS servers
  • Stopping an MXCS server
  • Viewing MXCS Services
  • Starting up an MXCS service
  • Stopping an MXCS service
  • Viewing data sources
  • Creating a data source
    • Using General Properties
    • Adding and modifying the resource management policy
    • Using the DEFINEs and SETs tab
    • Using the Control Query Defaults tab
    • Using the Control Table Statements tab
      • If-Locked
      • MDAM
      • Priority
      • Similarity check
      • Table Lock
      • Timeout
  • Copying a data source
  • Starting up a data source
  • Stopping a data source
  • Updating a data source
  • Deleting a data source
  • Starting and stopping server traces
  • Viewing MXCS user permissions
  • Adding an MXCS user
  • Editing MXCS user permissions
  • Deleting an MXCS user
• 8 Launching the NonStop SQL/MX Remote Conversational Interface
  • Introduction to RMXCI
  • Locating the RMXCI program
  • Launching RMXCI
  • Setting Auto Logon options
• A Using the SQL Whiteboard
  • Introduction to the SQL Whiteboard
  • Viewing the SQL Whiteboard
  • SQL Whiteboard panes
  • Statement List pane
  • Statement pane
    • Parameter prompts
    • Page mode
    • Executing SQL queries
    • Cancelling a query from the SQL Whiteboard
  • Statement Details pane
  • Reusing a connection
  • Loading and saving SQL statements to a file
  • Highlighting the SQL syntax
  • Managing the layout of panes
• Glossary
• Index