MXDM User Guide for SQL/MX Release 3.5
Introduction to MXDM
Overview
MXDM features and functionalities
MXDM functional flow
Installing and uninstalling MXDM
Supported SQL/MX versions
Contents of the installation package
Prerequisites
Installing MXDM
Installing the 32-bit version of MXDM
Installing the 64-bit version of MXDM
Uninstalling MXDM
Managing MXDM system objects
Starting up MXDM
Starting up the 32-bit version of MXDM
Starting up the 64-bit version of 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 timeout in MXDM
Timeout Settings
Exiting MXDM
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
Hiding an area
Showing a hidden area
Using My Favorites pane
Creating a folder to store favorites
Creating a favorite
Using a favorite
Displaying a list of favorites
Removing a favorite
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
Performing basic MXDM operations
Obtaining version and build information
Using the error log
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
Managing database objects
Searching database objects
Working with change ownership feature
Recovering a schema
Granting create catalog or SA privileges
Revoking create catalog or SA privileges
Managing catalogs and their objects
Displaying catalogs
Creating a catalog
Dropping a catalog
Registering a catalog
Unregistering a catalog
Granting create schema privilege
Revoking create schema privilege
Managing schemas and their properties
Displaying schema attributes
Displaying tables in a schema
Displaying views in a schema
Displaying indexes in a schema
Displaying schema procedures
Displaying SQL/MP aliases within a schema
Displaying sequence generators within a schema
Displaying materialized views in a schema
Displaying schema DDL
Displaying other schema options
Creating a schema
Dropping a schema
Changing ownership of a schema
Reverting change ownership of a Schema
Granting create schema privilege
Recovering a schema
Managing tables and their properties
Displaying tables
Creating a table
Altering a table
Dropping a table
Renaming a table
Creating a table using existing table
Granting privileges on a table
Revoking privileges on a table
Managing indexes and their properties
Displaying indexes
Creating an index
Altering an index
Renaming an index
Dropping an index
Managing views
Views
Managing views and their properties
Managing stored procedures in Java
Displaying procedures and their properties
Creating a stored procedure in java
Dropping a stored procedure in Java
Granting privileges on a procedure
Revoking privileges on a procedure
Managing SQL/MP aliases
SQL/MP aliases
Managing SQL/MP aliases and their properties
Managing sequence generators
Sequence generators
Managing sequence generators and their properties
Managing triggers
Triggers
Managing triggers and their properties
Managing PL/MX functions
Granting privileges on PL/MX functions
Revoking privileges on PL/MX functions
PL/MX function attributes
PL/MX function parameters
PL/MX function related objects
PL/MX function related privileges
Materialized views (MVs)
Viewing materialized views properties
Granting privileges on materialized views
Revoking privileges on materialized views
Refreshing database objects to get the current status
Managing objects using the SHOW DDL option
Displaying table statistics and their properties
Managing MXCS objects
Displaying MXCS servers
Stopping an MXCS server
Displaying MXCS Services
Starting up an MXCS service
Stopping an MXCS service
Displaying 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
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
Starting tracing for data sources
Stopping tracing for a data source
Displaying MXCS user permissions
Adding an MXCS user
Editing MXCS user permissions
Deleting an MXCS user
Refreshing MXCS objects to get the current status
Launching the NonStop SQL/MX Remote Conversational Interface
Introduction to RMXCI
Locating the RMXCI program
Launching RMXCI
Setting Auto Logon options
Websites (NonStop)
Support and other resources
Accessing Hewlett Packard Enterprise Support
Accessing updates
Customer self repair
Remote support
Warranty information
Regulatory information
Documentation feedback
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
Search
Home
Managing database objects
Managing views
Managing views
Views
Managing views and their properties