Version 6.4.3
- New Features and Enhancements (6.4.3)
  - New Features and Enhancements for Version 6.4.3
- Updates and Changed Behaviors (6.4.3)
  - Updates and Changed Behaviors for Version 6.4.3
Version 6.4 HotFix 2
- New Features and Enhancements (6.4 HotFix 2)
  - New Features and Enhancements for Version 6.4 HotFix 2
- Updates and Changed Behaviors (6.4 HotFix 2)
  - Updates and Changed Behaviors for Version 6.4 HotFix 2
    - Data Visualization
      - Data Visualization Reports
    - Standalone Jobs
      - Create Materialized Views Standalone Job
Version 6.4 HotFix 1
- New Features and Enhancements (6.4 HF1)
  - New Features and Enhancements for Version 6.4 HF1
- Updates and Changed Behaviors (6.4 HF1)
  - Updates and Changed Behaviors for Version 6.4 HF1
    - Retention Management
      - Update Retention Job
      - Purge Expired Records Job
    - Security
      - Report Designer and Report Viewer System-Defined Roles
Version 6.4
- New Features and Enhancements (6.4)
  - New Features and Enhancements for Version 6.4
- Updates and Changed Behaviors (6.4)
  - Updates and Changed Behaviors for Version 6.4
Version 6.3
- New Features and Enhancements (6.3)
  - New Features and Enhancements for Version 6.3
- Updates and Changed Behavior (6.3)
  - Updates and Changed Behavior for Version 6.3
    - Data Vault
    - Jobs
Version 6.2 Hot Fix 2
- New Features and Enhancements (6.2 HotFix 2)
  - New Features and Enhancements for Version 6.2 HotFix 2
- Updates and Changed Behavior (6.2 HotFix 2)
  - Updates and Changed Behavior for Version 6.2 HotFix 2
Version 6.2 Hot Fix 1
- New Features and Enhancements (6.2 HotFix 1)
  - New Features and Enhancements for Version 6.2 HotFix 1
- Updates and Changed Behavior (6.2 HotFix 1)
  - Updates and Changed Behavior for Version 6.2 HotFix 1
Version 6.2
- New Features and Enhancements (6.2)
  - New Features and Enhancements for Version 6.2
- Updates and Changed Behavior (6.2)
  - Updates and Changed Behavior for Version 6.2
Version 6.1.1
- New Features and Enhancements (6.1.1)
  - New Features and Enhancements for Version 6.1.1
- Updates and Changed Behavior (6.1.1)
  - Updates and Changed Behavior for Version 6.1.1
Version 6.1
- New Features and Enhancements (6.1)
  - New Features and Enhancements for Version 6.1
- Updates and Changed Behavior (6.1)
  - Updates and Changed Behavior for Version 6.1

Release Guide

6.4.3
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1

Back Next

Queries

UNION Operators: You can use the UNION and UNION ALL operators in queries. The operators combine the result sets of two or more SELECT statements.
For more information, see the
Informatica Data Archive 6.2 Data Vault Query Reference
.
Parameterized Queries: You can include parameters in queries. A parameterized query uses parameters or placeholders in place of values. When you define the SQL statement, you can use placeholders in place of the values. When you run the SQL statement, supply the values for the placeholders in a separate statement.
For more information, see the
Informatica Data Archive 6.2 Data Vault Query Reference
.

Data Vault

Rename Saved Search

Table of Contents

Release Guide

Release Guide

Queries

Queries