Open Datapath using iQuery (OPNSQLF)

Where allowed to run: All environments (*ALL)
Threadsafe: No
Parameters
Examples
Error messages

Parameters

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
Top

Examples

None
Top

Error messages

Unknown
Top