Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
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:
-
- 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:
-
- 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.