Causes the SQL Option preprocessor to produce a DBRM file.
Restriction: This topic applies to Windows environments only.
Syntax:
NODBRM or DBRM=filename#1;filename#2;...;filename#10
Parameters:
filename
Name of file to write DBRM to
Properties:
Default:
NODBRM
Comments:
By default, the SQL Option preprocessor produces only expanded source code. You must specify the DBRM preprocessor directive
in order to produce a DBRM. When you specify NODBRM, no file is generated.
Multiple DBRM files can be written only if AUTOBIND is also specified. DBRM file names must be delimited by 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 are
ignored. These options do not have to have the same number as the number of DBRM file names specified as the values used will
then default to the previous value if a new one is not specified.
Comments:
By default, the SQL Option preprocessor produces only expanded source code. You must specify the DBRM preprocessor directive in order to produce a DBRM. When you specify NODBRM, no file is generated.
Multiple DBRM files can be written only if AUTOBIND is also specified. DBRM file names must be delimited by 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 are ignored. These options do not have to have the same number as the number of DBRM file names specified as the values used will then default to the previous value if a new one is not specified.