

Generating Reports From Database Files › Selective Processing › What You Can Do
What You Can Do
Data that meets specified criteria can be selected for a report by applying selection criteria to logical records.
How to Do It
Data can be selected:
- With conditional statements set up by a WHERE clause. This retrieves only those records with a job ID equal to 3051.
- By searching for defined values with CONTAINS or MATCHES patterns:
- Retrieves employee records where the character set CAS appears somewhere in the name.
- Retrieves employee records where the first three characters of the employee name are CAS.
- Retrieves employee records where names start with CA followed by any alphabetic character.
- Retrieves employee records where ids start with 02 followed by any two digits.
Copyright © 2014 CA.
All rights reserved.
 
|
|