Table of Contents

Search

  1. About the Data Vault SQL Reference
  2. Introduction to SQL Reference for Informatica Data Vault
  3. Date and Time Arithmetic
  4. WHERE Clauses
  5. UNION Operator
  6. Parameterized Query
  7. Functions

Data Vault SQL Reference

Data Vault SQL Reference

Predicates

Predicates

You can use placeholders with the following predicates: > < >= <= = != BETWEEN IN LIKE
For example, the following query uses placeholders for values in the >= and <= predicates:
SELECT * FROM employee WHERE emp_no >= ? and emp_no <= ?;
The following query uses a placeholder for the value in the LIKE predicate:
Select * from employee where first_name like ?;

0 COMMENTS

We’d like to hear from you!