SAVE-DBH-OPTIONS

This statement saves the DBH options with their current values.

Scope of validity

DBH administration

Function

You use the SAVE-DBH-OPTIONS administration statement to save the DBH options with their values that are currently set in the DBH session to a SAM file. You can use this file as a DBH configuration file when DBH is started.
The content of the output file corresponds to the outputs in the case of SHOW-DBH-OPTIONS, SHOW-SQL-DB-CATALOG-ENTRIES and SHOW-OLD-TABLE-CATALOG-ENTRIES.
In the output file these outputs are converted to the corresponding DBH start statements SET-DBH-OPTIONS, ADD-SQL-DATABASE-CATALOG-LIST and ADD-OLD-TABLE-CATALOG-LIST. The passwords required are supplemented.

SAVE-DBH-OPTIONS

TO-FILE = *SESCONF / <filename 1..54>

Operands

TO-FILE =

Determines the file to which the DBH options and their current values are to be saved.

TO-FILE = *SESCONF
The DBH options and their current values are saved to the file which is currently assigned to the DBH as a DBH configuration file via the link name SESCONF. The DBH options entered there which were valid when the DBH started are overwritten.

TO-FILE = <filename 1..54>
Explicit specification of a file to which the DBH options and their current values are saved. If no user ID is specified, the file is created in the DBH ID. If a user ID is specified, the file must be shareable or co-ownership must have been declared there for the DBH ID. An existing file of the same name is overwritten.

Example

File output following entry of the administration statement SAVE-DBH-OPTIONS TO-FILE=<file>:

//SET-DBH-OPTIONS-
//    DBH-IDENTIFICATION=*PARAMETERS(-
//        CONFIGURATION-NAME=Z-
//       ,DBH-NAME=X-
//    )-
//   ,ADMINISTRATION=*PARAMETERS(-
//        ACCOUNTING=*OFF-
//       ,ADMINISTRATOR=*ANY(-
//            PASSWORD=X'E7E7E7'-
//        )-
//       ,MSG-OUTPUT=*PARAMETERS(-
//            MSG=*ALL-
//           ,OPEN-CLOSE-MSG=*NONE-
//           ,MAIL=*NONE-
//        )-
//       ,SECURITY=*PARAMETERS(-
//            PRIVILEGE-VIOLATIONS=10-
//           ,SAT-SUPPORT=*OFF-
//        )-
//    )-
//   ,CPU-RESOURCES=*PARAMETERS(-
//        DBH-TASKS=1 - 
//       ,SERVICE-TASKS=*PARAMETERS(-
//            INITIAL=1 - 
//           ,MAXIMUM=1 - 
//           ,JOBCLASS=*STD    -
//           ,WORK-FILES=*PUBLIC-DISK(-
//                CAT-ID=*STD-
//               ,PRIMARY-ALLOCATION=*STD-
//               ,SECONDARY-ALLOCATION=*STD-
//            )-
//           ,RECORDS-PER-CYCLE=*STD-
//        )-
//    )-
.
.

Administration command in ISP format and at the CALL DML interface

The OPT,SAVE administration command corresponds to the SAVE-DBH-OPTIONS administration statement here.

OPT,SAVE,F[ILE]-N[AME]={*S[ESCONF]|<filename 1..54>}