DB-CLOSE

Close files, cursor sets, batch files, and data view areas.
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.

Targets:

  • SQL
  • VSAM Batch

SQL

Close SQL cursor sets.

Syntax: 
DB-CLOSE CUR[SOR] cursorname
General Rule:
  1. In SQL, a cursor set can be opened, processed, and closed multiple times in the same program; you must code DB-CLOSE before you invoke another DB-OPEN.
Parameters:

CUR[SOR] cursorname

Specify cursor. Cursorname must be previously named by DB-DECLARE or DB-PROCESS-ID.

VSAM Batch

Close VSAM batch files.

Syntax for Format 1: 
DB-CLOSE FILE filename1 [ ... filenameN]
Syntax for Format 2: 
DB-CLOSE FILE ALL
General Rule:
  1. DB-CLOSE is required for single-platform applications.
Parameters:

FILE filename

File(s) to process.

ALL

Specify all files and ready all areas defined in the subschema.

Parent topic: Database Calls