DBRMLIB

The DBRMLIB option specifies where the SQL preprocessor should write its DBRM data set when running under z/OS UNIX System Services.

Read syntax diagramSkip visual syntax diagramNODBRMLIBDBRMLIB('data-set-name')
When the DBRMLIB option is specified without a data set name, the DBRM data set will be written to the current UNIX System Services directory with the same name as the source .pli file but with the extension .dbrm. For example, if you issue the command 
pli -c -qpp=sql -qdbrmlib sample.pli
the DBRM data set will be written to sample.dbrm.
When the DBRMLIB option is specified with a data set name, the data set name must specify the name of a PDS(E) with attributes required by Db2. The DBRM data set will be written to the data set as a member with the same name as the source .pli file. For example, if you issue the command 
pli -c -qpp=sql -qdbrmlib="USER.TEST.DBRM" sample.pli
the DBRM data set will be written to USER.TEST.DBRM(SAMPLE).

You must specify the DBRMLIB option when the compiler invokes the SQL preprocessor under UNIX System Services. This option has no effect except when the compiler invokes the SQL preprocessor under z/OS UNIX System Services.

The default is NODBRMLIB.