DB-OPEN

Open a record, cursor set, or file.
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.

Targets:

  • SQL
  • VSAM Batch

SQL

Syntax: 
DB-OPEN CUR[SOR] cursorname
General Rule:
  1. A cursor set can be opened, processed, and closed multiple times in the same program. A DB-OPEN issued for an open cursor set causes an error; first code a DB-CLOSE.
Parameters:

CUR[SOR] cursorname

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

Example:
Open cursor set D2MAST-CURSOR, previously defined in DB-DECLARE. 
DB-OPEN CURSOR D2MAST-CURSOR

VSAM Batch

Syntax: for Format 1 
DB-OPEN FILE filename [... filename]
... MODE option
Syntax: for Format 2 
DB-OPEN FILE ALL
... MODE option
General Rule:
  1. DB-OPEN is required for single-platform applications.
Parameters:

FILE filename

File(s) to process.

MODE option

File processing mode: INPUT, OUTPUT, I-O, EXTEND

All

Specify all files defined in the data view.

Example:
Open the AORDER and ASUPLIR files for I-O processing. 
DB-OPEN FILE AORDER ASUPLIR MODE I-O
Parent topic: Database Calls