The HSHSPB allows default values to be specified for some DBCAREA fields. These defaults will be used by applications that do not explicitly specify a value for those DBCAREA fields. If an application does specify a value, that HSHSPB default will be ignored.
If a default value is changed, the HSHSPB must be assembled and link-edited. The resulting load module will be used by any application with the resulting load module in its search order at execution time. Any number of HSHSPBs may exist, but since all have the same module name, only one will be used for a particular execution of any application.
The default for the following values can be safely changed for any application:
Keyword |
Default |
Description |
MVSTDP |
'TDP0' |
The default for the Input‑TDP‑path (DBCNITDP) value when executing under z/OS, chosen as an EBCDIC four-character value beginning with TDP. |
IBODLYW |
'Y' |
The default for the Wait‑during‑delay (DBODLYN) option, chosen as either 'Y' or 'N'.
|
IBOFSVB |
'Y' |
The default for the Save‑response‑buffer (DBOFSVB) option, chosen as either 'Y' or 'N'. |
IBO2FBU |
'Y' |
The default for the Two‑response‑buffers (DBO2FBU) option, chosen as either 'Y' or 'N'. |
IBORTS |
'N' |
The default for the return‑time (DBORTS) option, chosen as either 'Y' or 'N'. |
IBCSMAX |
16 |
The default for the Anticipated‑number‑of‑concurrent‑sessions (DBCISMAX) value, chosen as a value between 1 and 999. |
IBCRBRL |
1024 |
The default for the Request‑buffer‑length (DBCIRBRL) value, chosen as a value between 256 and 2147483639. |
IBCFBRL |
1024 |
The default for the Response‑buffer‑length (DBCIFBRL) value, chosen as a value between 256 and 32767, 65535, or 2147483639. The actual maximum depends upon the setting of the Maximum‑parcel option. |
IBODEN |
'N' |
The default for the Data‑encryption (DBRIDEN) option, chosen as either 'Y' or 'N'. |
RCD |
'N' |
The default for the Refresh‑cached‑data (DBRIRCD) option, chosen as either 'Y' or 'N'. |
IBORPF |
'D' |
The default for the Request‑parcel‑format (DBRIRPF) option, chosen as either 'A' or
'O'. |
IBOTRAK |
'N' |
For diagnostic use under the direction of Teradata Support personnel, the status of internal CLIv2 tracking, chosen as either 'N', 'I', 'E', or 'A'. |
IBOTRPG |
0 |
For diagnostic use under the direction of Teradata Support personnel, the number of 4096byte areas to be used for internal CLIv2 tracking, chosen as a value from 0 to 255. |
IBOTRCM |
'00000000' |
For diagnostic use under the direction of Teradata Support personnel, the component mask for CLIv2 internal tracking, chosen as an eight character hexadecimal value. |
DUI |
'N' |
The default for the Delegate‑user‑identity value, chosen as either 'N' or 'Y'. |
The default for the following values can be changed for any application, but depending on the design of the application may result in errors indicated by the Teradata Database when the application is executed.
Keyword |
Default |
Description |
IBOKRSP |
'N' |
The default for the Keep‑response (DBCNITSM) option, chosen as either 'Y', 'N', or 'P'. |
IBOSCS |
(No default provided) |
The default for the Set‑character‑set (DBOSCSP) option, chosen as either null or 'N'.
The name of the character set is given by the IBCCSN keyword. |
IBCCSN |
(No default provided) |
If the Set‑character‑set (DBOSCSP) option is 'Y', the default for the Character set
name, chosen as one of the defined EBCDIC one to thirty character values. |
IBOTSM |
'D' |
The default for the Transaction‑semantics (DBCNITSM) option, chosen as either 'D', 'A', or 'T'. |
IBOLCS |
'N' |
The default for the Language‑conformance (DBCNILCS) option, chosen as either 'N', '2', or '3'. |
IBOC2SC |
'D' |
The default for the C2S‑conversion (DBCIC2SC) option, chosen as either 'R', 'I', or 'D'. |
IBOC2SCC IBOS2CC |
'D' |
The default for the S2C‑conversion (DBCIS2CC) option, chosen as either 'R', 'I', or 'D'. |
IBODF |
'D' |
The default for the Date‑form (DBCNIDF) option, chosen as either 'D', 'T', or 'A'. |
LANG |
'EN' |
The default for the Language‑id (DBCNILID) value, chosen as one of the defined EBCDIC two‑character values. |
COUNTRY |
(No default provided) |
The default for the Country‑id (DBCNICID) value, chosen as null or one of the defined EBCDIC two-character values. |
RR |
(No default provided |
The default for the Return‑result‑to value, chosen as either 1, 2, 3, 4, or 5. |
RSO |
'N' |
The default for the Result‑sets‑OK value, chosen as either 'N' or 'Y'. |
TSP |
'8' |
The default for the Timing‑precision (DBCITSP) value, chosen as a value between 0 and 20. |
CIN |
'O' |
The default for the Column‑info value, chosen as either 'O' or 'E'. |
The default for the following values should never be changed without a detailed analysis of the design of every affected application (that is, an application will very likely exhibit programming errors if these defaults are changed). Defaults for these should not have been provided but are maintained for compatibility:
Keyword |
Default |
Description |
IBORMOD |
'R' |
The default for the Response‑mode (DBORMOD) option, chosen as either 'F', 'R', 'M', 'I' or 'X'. |
IBOIDTA |
'N' |
The default for the Use‑presence (DBOIDTA) option, chosen as either 'Y' or 'N'. |
IBODLYT |
'Y' |
The default for the Tell‑if‑delay (DBODLYT) option, chosen as either 'Y' or 'N'. (The deprecated keyword IBOCRTL is equivalent to IBODLYT.) |
IBOFLOC |
'Y' |
The default for the Locate‑mode (DBOFLOC) option, chosen as either 'Y' or 'N'. |
IBORVAR |
'N' |
The default for the Variable‑length‑request (DBORVAR) option, chosen as either 'Y' or 'N'. |
IBOFVAR |
'N' |
The default for the Variable‑length‑fetch (DBOFVAR) option, chosen as either 'Y' or 'N'. |
IBOBSYW |
'Y' |
The default for the Wait‑for‑response (DBOBSYW) option, chosen as either 'Y' or 'N' |
IBOBTPM |
'Y' |
The default for the Parcel‑mode‑fetch (DBOBTPM) option, chosen as either 'Y' or 'N'. |
IBOFUNT |
'E' |
The default for the Request‑processing‑option (DBOFUNT) option, chosen as either 'E', 'P', 'S', or 'B'. |
IBOQMOD |
'P' |
The default for the Request‑mode (DBOQMOD) option, chosen as either 'P' or 'B' |
IBOCTYP |
'R' |
The default for the Connect‑type (DBOCTYPE) value, chosen as either 'R' or 'C'. |
IBO2PC |
'N' |
The default for the 2PC (DBO2PC) option, chosen as either 'Y' or 'N'. |
IBOMP |
'O' |
The default for the Maximum‑parcel (DBCIMP) option, chosen as either 'O' or 'H' |
IBOROB |
'D' |
The default for the Return‑objects‑as (DBRIROB) option, chosen as either 'D', 'T', or 'S'. |
IBOAPH |
'N' |
The default for the APH‑response‑OK (DBRIAPH) option, chosen as either 'Y' or 'N'. |
MDR |
0 |
The default for the Max‑decimal‑returned (DBRIMDR) option, chosen as any value not greater than the decimal precision value obtained using the DBCHQE SQL‑limits query. A zero is equivalent to the client default, 18. |