• User Guide
•  1. Introduction
  • Introducing Actian Director
  • Installation
  • Intended Audience
  • Internet Connectivity
  •  Documentation
    • Access Local Help
  • Path Notation in This Guide
•  2. Getting Started with Director
  •  Interface Design
    •  Instance Explorer
      • Hide or Show the Instance Explorer
    •  Multiple Document Interface
      • Document Types
      • Select a Document
      • Close a Document
      • Save an Unsaved Document
    •  Main Menu Ribbon Tabs
      • Home Tab
      • Connection Tab
      • Database Tab
      • Query Tab
      • Help Tab
    •  Toolbars
      • Instance Explorer Toolbar
      • Dialog Toolbar
      • Query Document Toolbar
  •  Setting Options for Director
    •  Options Dialog
      • Environment Options (Options Dialog)
      • Query Execution Options (Options Dialog)
      • Query Results Options (Options Dialog)
    • Set Whether to Prompt Before Disconnecting the Instance Explorer
    • Set Whether to Show Advanced Connect Options
    • Set the First <n> Rows to Select in the Instance Explorer
    • Set the Size of Support Log Files
    • Specify Fonts Used in Queries and Results
    • Syntax Coloring
    • Set the User Interface Language
    • Set Connection and Startup Options
    • Set the Maximum Number of Rows to Return When Executing a Query
    • Specify Runtime SET Options
    • Specify Default Output Format and Location for Query Results
  • Access Local Help
•  3. Connecting to and Disconnecting from Actian Database Installations
  • About Connection
  • Instance Code
  • Format of Installation Names
  •  Connecting to an Ingres or Actian Vector Installation
    • Connecting to an Already-Connected Installation
    • Default Connection
    • Connection at Startup
    •  Automatic Connection
      • Configure for Automatic Reconnection at Startup
    •  Connect to Instance Dialog
      • Connection Errors
    • Start a Local Management Server (Windows Only)
    • Connect to an Actian Database Instance
  • Connecting to a Database Using a Server Connection Definition
  •  Disconnecting from an Actian Database Installation
    • Disconnect from an Actian Database Installation
  •  Removing an Actian Database Installation
    • Remove an Actian Database Installation
  • Move an Instance Up or Down in the Instance Explorer
  • Set an Installation Password
  •  Viewing Instance Properties
    •  Instance Properties Dialog
      • General Page Options
      • Environment Page Options
    • View Installation Properties
  •  Setting DBMS Trace Options for an Installation
    •  DBMS Trace Options Dialog
      • General Page Options
      • Output Log Page Options
    • Set DBMS Trace Options
  • Translating Between Instance IDs and Port Values
  • Display and Search Log Files
•  4. Starting and Stopping Actian Database Instances and Components
  • About Starting and Stopping Components
  •  Start Operations
    • State Indicators
    • Startup Errors
    • Start Confirmation and Progress Dialog
    • Start an Instance
    • Start a Stopped Server
  •  Stop Operations
    • Stopping Errors
    • Stop Confirmation and Progress Dialog
    • Stop an Instance
    • Stop a Running Server
•  5. Browsing Databases and Objects
  • About Browsing
  • Instance Explorer Structure
  •  Browse Object Properties
    • Non-browsable Objects
  •  Installation Node
    •  Databases Folder, Database Node
      • Tables Folder, Table Node
      • Views Folder, View Node
      • Procedures Folder, Procedure Node
      • Sequences Folder, Sequence Node
      • Events Folder, Database Event Node
      • Synonyms Folder, Synonym Node
      • Security Folder at Database Level
    •  Security Folder at Installation Level
      • User Node at Installation Level
      • Group Node
      • Role Node
      • Profile Node
    •  Server Connection Definitions Folder
      • Server Connection Definition (vnode)
    • Locations Folder, Location Node
    • Management Folder
•  6. Working with Databases
  • Database Operations
  • Object Naming Rules
  •  Creating and Deleting Databases
    •  Creating a Database
      • New Database Dialog
      • Create a Database
    •  Deleting a Database
      • Delete Database Dialog
      • Delete a Database
  •  Backing Up and Restoring Databases
    • Backup Database Dialog
    • Back Up a Database
    • Restore Database Dialog
    • Restore a Database
  •  Creating and Modifying Database Locations
    • Location Dialog
    • Create a Location
    • Modify a Location
    • Delete a Location
  •  Working with Views
    • New View Dialog
    • Create a View
    • Delete a View
    • Display View Properties
  •  Working with Procedures, Sequences, Events, and Synonyms
    •  Procedures
      • Procedure Dialog
      • Create a Procedure
      • Modify a Procedure
      • Delete a Procedure
      • View Procedure Properties
    •  Sequences
      • Sequence Dialog
      • Create a Sequence
      • Modify a Sequence
      • Delete a Sequence
      • View Sequence Properties
    •  Events
      • Database Event Dialog
      • Create an Event
      • Delete an Event
      • View Event Properties
    •  Synonyms
      • Synonym Dialog
      • Create a Synonym
      • Delete a Synonym
      • View Synonym Properties
  •  Using Rules
    • New Rule Dialog
    • Create a Rule
    • Delete a Rule
    • View Rule Properties
  •  Generating Statistics
    •  Generate Statistics Dialog
      • General Page (Generate Statistics Dialog)
      • Options Page (Generate Statistics Dialog)
      • Display Formatting Page (Generate Statistics Dialog)
      • Input/Output Files (Generate Statistics Dialog)
      • Output Log (Generate Statistics Dialog)
    • Generate Statistics
  •  Displaying Statistics and Information
    •  Display Statistics Dialog
      • General Page (Display Statistics Dialog)
      • Options Page (Display Statistics Dialog)
      • Display Formatting Page (Display Statistics Dialog)
      • Output File Page (Display Statistics Dialog)
      • Output Log Page (Display Statistics Dialog)
    • Display Statistics
    • Display Database Information Dialog
    • Display Database Information
  •  Modifying System Tables and User Tables
    •  Modifying System Tables (Catalogs)
      • Modify System Tables Dialog
      • Modify System Tables
    •  Modifying User Tables (Catalogs and Secondary Indexes)
      • Modify User Tables Dialog
      • Modify User Tables
  •  Verifying Databases
    • Verify Database Dialog
    • Verify a Database
  •  Altering Databases
    • Alter Database Dialog
    • Alter a Database
  •  Extending Databases
    • Extend Database Dialog
    • Extend a Database
  •  Viewing Database Properties
    • Database Properties Dialog
    • View Database Properties
  •  Setting DBMS Trace Options for Databases
    • DBMS Trace Options Dialog
    • Set DBMS Trace Options
  • Display Log Files
•  7. Working with Tables
  • About Working with Tables
  •  Creating Tables
    •  New Table Interface
      • Table Properties
      • Select Locations Dialog
      • Partition Specification Dialog
      • Column Operations
    •  Create a Table
      • Specify Locations
      • Partition the Table
    • Save a Table
    •  Create a Table Using a Select Statement
      • New Table from Select Dialog
  •  Deleting Tables
    • Delete a Table
  •  Foreign Keys, Indexes, and Constraints
    • Creating Primary Keys, Foreign Key Constraints, and Indexes for Actian Vector Tables
    • Assign Primary Keys
    •  Foreign Key Relationships
      • New Foreign Key Dialog
      • Create a Foreign Key Relationship
      • Delete a Foreign Key Relationship
    •  Constraints
      • New Constraint Dialog
      • Create a Constraint
      • Delete a Constraint
    •  Indexes
      • Index Dialog
      • Create an Index
      • Delete an Index
  •  Viewing Table Properties
    • Table Properties Dialog
    • View Table Properties
  •  Loading Data into Actian Vector
    •  Import Data into an Actian Vector Table with the Import Wizard
      • Start the Import Wizard
      • Choose a Data Source
      • Configure Columns
      • Specify the Data Destination
      • Configure the Data Mappings
      • Complete the Wizard
      • Monitor Import Execution
      • How the Import Wizard Handles Newly Created Tables
      • Failed Import Records
      • vwload Escape Sequences
    • Load Data into an Actian Vector Table Dialog
    • Load Data into an Actian Vector Table
•  8. Using Queries
  • About Using Queries
  • Object Naming Rules
  • Create a New Query
  • Query Options Dialog
  • Query Status Bar Fields
  •  Open an Existing Query
    • File Chooser Dialog
  • Find or Replace Text in a Query
  • Save a Query
  • Close a Query
  • Specify Default Output Format and Location for Query Results
  • Specify Output Format for Query Results
  • Specify Fonts Used in Queries and Results
  • Execute a Query
  • Cancel a Running Query
  • Copy Query Results
  • Save Query Results
  • DBMS Trace Message Display
  •  Recording Queries
    • Start Recording Queries Dialog
    • Start or Stop Recording Queries
•  9. Managing Server Connection Definitions
  • How You Can Use Server Connection Definitions
  •  Creating Server Connection Definitions
    • New Server Connection Definition Dialog
    • Create a Server Connection Definition
  •  Testing a Server Connection Definition
    • Test a Server Connection Definition
  •  Running a Script from a Control File
    • Run a Script
  •  Modifying Server Connection Definitions
    • Modify Server Connection Definition Dialog
    • Modify a Simple Server Connection Definition
  •  Creating and Modifying Login Information for Server Connection Definitions
    • Login Dialog
    • Create a New Login for an Existing Server Connection Definition
    • Modify a Login for an Existing Server Connection Definition
  •  Creating and Modifying Connection Data
    • Connection Dialog
    • Create a New Connection for an Existing Server Connection Definition
    • Modify a Connection for an Existing Server Connection Definition
  •  Creating and Modifying Attributes for Existing Server Connection Definitions
    • Attribute Dialog
    • Create an Attribute for an Existing Server Connection Definition
    • Modify an Attribute for an Existing Server Connection Definition
  •  Deleting Server Connection Definitions
    • Delete a Server Connection Definition
    • Delete a Login for an Existing Server Connection Definition
    • Delete a Connection for an Existing Server Connection Definition
    • Delete an Attribute for an Existing Server Connection Definition
  • Connecting to a Database Using a Server Connection Definition
•  10. Administering Users, Groups, Roles, and Profiles
  • About Administration
  •  Creating Users, Groups, Roles, and Profiles
    •  User Dialog
      • General Page (User)
      • Privileges Page (User)
      • Roles Page (User)
      • Access Page (User)
      • Options Page (User)
    • Create a New User
    •  Group Dialog
      • General Page (Group)
      • Access Page (Group)
    • Create a New Group
    •  Role Dialog
      • General Page (Role)
      • Privileges Page (Role)
      • Grantees Page (Role)
      • Access Page (Role)
      • Options Page (Role)
    • Create a Role
    •  Profile Dialog
      • General Page (Profile)
      • Privileges Page (Profile)
      • Options Page (Profile)
    • Create a New Profile
  •  Modifying Users, Groups, Roles, or Profiles
    • Modify a User
    • Modify a Group
    •  Modify a Role
      • Grant or Revoke Roles for Multiple Users
    • Modify a Profile
  •  Deleting Users, Groups, Roles, or Profiles
    • Delete a User, Group, Role, or Profile
  •  Viewing Properties for Users, Groups, Roles, or Profiles
    • View Properties for Users, Profiles, Groups, or Roles
•  11. Managing Servers and Transaction Logs
  • About Managing Servers and Transaction Logs
  • Management Folder
  •  Configuring Servers
    • Start and Stop Servers
    • Set a Server Startup Count
    • View Hadoop Instance Properties
•  12. Managing Permissions and Viewing Properties
  • Object Permissions
  •  Object Types with Permissions
    • Object Ownership and Granting Object Permissions
  • Grantees
  • Permissions Dialog
  • Set Permissions for Objects
  •  Viewing or Modifying Permissions
    • View Permissions
    • Modify Permissions
  •  Viewing Properties
    • View Properties Dialog
    • Viewing Properties for Objects
    • Copy Settings from Properties Dialogs

User Guide

Copy Settings from Properties Dialogs

O_1234

O_110