Previous Topic Next topic Print topic


DBRM

Causes the SQL Option preprocessor to produce a DBRM file.

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.

Previous Topic Next topic Print topic