Keyword |
Description |
Choices |
Notes |
OPNID |
Open ID |
Element list |
Required, Positional 1 |
Element 1: Open ID |
Name |
Element 2: Replace existing OPNID |
*REPLACE, *REUSE, *FAIL |
FROM |
FROM file(s) (use & to extend) |
Character value |
Required, Positional 2 |
FIELDS |
Column Names for result |
Character value, *SELECT |
Optional, Positional 3 |
SELECT |
SELECT |
Character value, * |
Optional, Positional 4 |
WHERE |
WHERE (Select/Omit) |
Character value |
Optional, Positional 5 |
ORDERBY |
ORDER BY (sequencing) |
Values (up to 300 repetitions): Element list |
Optional, Positional 6 |
Element 1: Field name |
Name, *NONE |
Element 2: Key field order |
*ASCEND, *DESCEND, *ASC, *DESC, *DSC |
Element 3: Order by absolute |
*ABSVAL, *ABS, *NO, *YES, *NATURAL |
GROUPBY |
GROUP BY (summarizing) |
Character value |
Optional, Positional 7 |
HAVING |
HAVING (group by select/omit) |
Character value |
Optional, Positional 8 |