Examples of DBRM Directives

Restriction: This topic applies to Windows environments only.

The following are examples of various DBRM directives used together:

XDB(dbrm=mydbrm location=mvsprod grant-execute=public 
    collection-id=nasecoll)
XDB(collection-id=nasecoll authid=naseprod autobind 
    exist-check=required)

Directives can be entered on multiple lines or as one long string. Each string must start with "XDB", unless entered on the IDE/Build Settings/EXEC SQL/Preproc Additional directives entry field.