Introduction

Use program BST05DBL to delete the contents of files, tables, and keys in the BQL database

Note

• This command is executed without any checking for the formal correctness of the command or whether the table in question allows for the usage of this command, or whether an entry for a key is missing, for example.
• During the execution of this command, the BQL does not accept any other requests.

STC must be down

You must stop the started task before building or rebuilding the keys using BST05DBL.

Syntax DD BQLIN

• To delete the contents of one or several keys:

  +-------------------------------------------------------+
  |DELKEYSEQ keyname,... | tablename,... | FILE filename -|
  | [ GENFILE(nn) ] |
  +-------------------------------------------------------+

• To delete the contents of a table:

  +-------------------------------------------------------+
  |DELTABSEQ tablename [ GENFILE(nn) ] |
  +-------------------------------------------------------+

• To delete the contents of a file:

  +-------------------------------------------------------+
  |CLEAR FILE filename [ GENFILE(nn) ] |
  +-------------------------------------------------------+

BQLIN Keywords

CLEAR DELTABSEQ DELKEYSEQ	Introduces the command: CLEAR FILE filename deletes the contents of all tables and all keys of this file DELTABSEQ tablename deletes the contents of this table DELKEYSEQ keyname,... deletes the contents of the specified key or keys DELKEYSEQ tablename deletes the contents of the keys of this table DELKEYSEQ FILE filename deletes the contents of the keys of all tables of this file
GENFILE(nn)	Number of the generation file