DBRM

Causes the SQL Option preprocessor to generate one or more DBRM files.

Syntax:

DBRM[=[path\]filename#1[;[path\]filename#2;...;[path\]filename#10]]
NODBRM

Parameters:

path
The full path to an alternative directory where you want to store the DBRM file. If no path is specified, the DBRM file is written to the working directory.
filename
An alternative filename prefix for the generated DBRM file. If no filename is specified, the default filename prefix is the same as the COBOL source filename. All generated DBRM files have a .DBR extension. When AUTOBIND is also specified, you can specify up to ten DBRM files. Otherwise, the limit is one. See Comments below for more information.

Properties:

Default: NODBRM

Dependencies:

When specifying more than one DBRM file, you must also specify AUTOBIND.

Comments:

You must specify the DBRM preprocessor directive to produce a DBRM. When you specify NODBRM (default), no file is generated.

By default, the SQL Option preprocessor produces only expanded source code.

Multiple DBRM files can be generated only if AUTOBIND is also specified. When specifying multiple DBRM files:

  • Delimit DBRM paths/filenames using a semi-colon (;) with no spaces in the string.
  • A maximum of 10 DBRM files are supported.
  • If only one DBRM is specified and more than one collection-id, authid or location is specified, a compile error SQL0334 is generated.
  • If more than one DBRM is specified, then multiple collection-ids, authids, and locations can be specified but are limited to the number of DBRM file names specified. Any number in excess is ignored.
  • If the number of collection-ids, authids, and locations is not the same as the number of DBRM file names, the values used default to the previous value if a new one is not specified.