Opens an ON control
structure, which ends with ENDON. The statement block is executed whenever the
contents of the field <f> or one of the other fields <fi> has changed since the
statement was last executed.
OPEN CURSOR
Opens a database cursor.
Syntax
OPEN CURSOR [WITH HOLD]
<c> FOR SELECT <result>
FROM <source>
[WHERE <condition>]
[GROUP BY <fields>]
[HAVING <cond>]
[ORDER BY <fields>].
Opens a cursor <c> with
type CURSOR for a SELECT statement. You can use all the clauses of the SELECT
statement apart from the INTO clause. The INTO clause is set in the FETCH
statement. If you use the WITH HOLD addition, the cursor is not closed when a
database commit occurs.
OPEN DATASET
Opens a file.
Syntax
OPEN DATASET <dsn>
[FOR INPUT|OUTPUT|APPENDING|UPDATE]
[IN BINARY MODE
|IN TEXT MODE [ENCODING (DEFAULT|UTF-8|NON-UNICODE)]
|IN LEGACY BINARY MODE [(BIG|LITTLE) ENDIAN] [CODE PAGE <cp>]
|IN LEGACY TEXT MODE [(BIG|LITTLE) ENDIAN] [CODE PAGE <cp>]]
[REPLACEMENT CHARACTER <rc>]
[IGNORING CONVERSION ERRORS]
[AT POSITION <pos>]
[TYPE <c>]
[MESSAGE <mess>]
[FILTER <filt>].
Opens a file <dsn> on the
application server. The additions after FOR specify how the file is read or
written. The MODE additions specifies how content is interpreted (as characters
or in binary form). The ENCODING addition specifies the character representation
in the file. The LEGACY MODE allows you to read files that were written before
Release 6.10. REPLACEMENT CHARACTERS and CONVERSION ERRORS are used to handle
errors during character set conversion. AT POSITION specifies the position in
the file. MESSAGE specifies where system messages are stored. FILTER lets you
specify operating system commands.
OVERLAY
Overlays one string with
another:
Syntax
OVERLAY <c1> WITH <c2>
[ONLY <str>].
This statement overlays
all positions in field <c1> containing letters which occur in <str> with the
contents of <c2>.
<c2>
remains unchanged. If you
omit ONLY <str>, all positions of <c1> containing spaces are overwritten.
