

Basic System FMS PROC › SELECT Command › Criteria Statement Operands
Criteria Statement Operands
For operands, you can specify any of the following:
- Decimal number constants, such as 10 or 1000.
- Date constants in any acceptable CA Disk format, such as 96200, 96.200, 96/200, 19JUL96, 07/19/96, 1996200, 1996.200, 19JUL1996, 1996/200 or 07/19/1996. If CA Disk has trouble differentiating between a digit Julian date constant, such as 96200, and a decimal number constant, it will issue an appropriate message and ask you to use another format.
- Constant values TRUE, FALSE, YES, NO, ON, or OFF. TRUE, YES, and ON are all equivalent. FALSE, NO, and OFF are all equivalent.
- Expressions that use addition (+) or subtraction (-) to combine a constant value with a field name or other constant value. For example, the expression TODAY-30 represents the date 30 days ago.
- Any of the DSCL select criteria field names listed in the following section.
Copyright © 2015 CA Technologies.
All rights reserved.
 
|
|