The DBH start statements initiate the parametrization of the DBH.
The following table lists the DBH start statements in the order in which they are entered:
DBH start statement | Function |
SET-DBH-OPTIONS | Causes the DBH options to be read in. |
ADD-SQL-DATABASE-CATALOG-LIST | Inserts entries in the SQL database catalog. |
ADD-OLD-TABLE-CATALOG-LIST | Inserts entries in the CALL DML table catalog. |
Table 7: DBH start statements
You must enter the SET-DBH-OPTIONS statement first. It is followed by the DBH options you want to use.
The other two start statements are optional, since you can also make entries in the SQL or CALL DML table catalog using administration statements (see section “ADD-OLD-TABLE-CATALOG-ENTRY” and section “ADD-SQL-DB-CATALOG-ENTRY”).
However, if you want to insert entries in the CALL DML table catalog by means of the ADD-OLD-TABLE-CATALOG-LIST start statement when starting the DBH, you must first issue the ADD-SQL-DATABASE-CATALOG-LIST start statement.
END statement
When entering the DBH start statements, you must always use the END statement to conclude parameter input.
The END statement is required at the following points during parameter input:
after the SET-DBH-OPTIONS statement, if this statement concludes parameter input
after the ADD-SQL-DATABASE-CATALOG-LIST start statement
after or instead of the ADD-OLD-TABLE-CATALOG-LIST start statement; you can only omit this END statement when the DBH is started with the default setting for the lowerlevel DBH option OLD-TABLE-CATALOG, which is OLD-TABLE-CATALOG=0 (see "OLD-TABLE-CATALOG").
Example 1
The END statement concludes parameter input after the SET-DBH-OPTIONS statement.
//SET-DBH-OPTIONS ...
//END
Example 2
The first END statement concludes the ADD-SQL-DATABASE-CATALOG-LIST start statement and the second concludes all parameter input.
//SET-DBH-OPTIONS ... //ADD-SQL-DATABASE-CATALOG-LIST ... //END //ADD-OLD-TABLE-CATALOG-LIST ... //END
Example 3
The first END statement concludes the ADD-SQL-DATABASE-CATALOG-LIST start statement and the second concludes all parameter input. The ADD-OLD-TABLE-CATALOG-LIST start statement is not included.
//SET-DBH-OPTIONS ... //ADD-SQL-DATABASE-CATALOG-LIST ... //END //END