FLUSH Statement

Clears the read / write data caches, forcing a data write if required and causing subsequent READSEQ and READBLK statements to re-read the source data.

Syntax

FLUSH seqfile.variable {SETTING setting-var} {ON ERROR statement(s)}  [ THEN statement(s) | ELSE statement(s) ]

Syntax Elements

seqfile-var The name of a variable containing a sequential file reference (assigned via an OPENSEQ statement).

setting-varThe name of a variable to which the return status is assigned. See Operation for details of the possible values for this variable.

statement(s)A sequence of one or more valid DataBasic statements, either separated by semicolons, or contained on separate lines and followed by an END statement.

See Operation for details of the circumstances under which the different clauses are executed.

Operation

The following details circumstances under which the different clauses are executed and the values returned in setting-var:

Clause Executed

Reason

setting-var

STATUS() Value

THEN

Flush successful

Current position

0

ELSE

File or item does not exist

2420

206

ON ERROR

Item not opened for sequential access (not opened with OPENSEQ)

B45

12

 

File or item not open

B12

12

 

General file error

Error number

Error number

Note

  • If an error occurs but there is no ON ERROR clause, the DataBasic Debugger will be entered with error B53 as well as the setting-var value.

  • The final column give the values returned by the STATUS function if this is used instead of a SETTING clause.