Previous Topic

Next Topic

Book Contents

Book Index

CTDUFUPD Example 2

SELECT

FILE=ACT

USER=ANDY

USER=MARY

REPORT=MYREPORT

means that Active User File records containing ((USER=ANDY or USER=MARY) and REPORT=MYREPORT) are selected.

The * and ? masking characters can be used when specifying selection criteria. For example, if USER=A* is specified, records whose USER field starts with A is selected. If USER=B?D?F is specified, records whose USER field contains B as the first letter, D as the third letter and F as the fifth letter are selected.

At least one selection field value must be specified.

Parent Topic

Examples for CTDUFUPD