15.10 - HSHSPB Assembler Source - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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:

 

Table 7: HSHSPB Source Default Settings That Are Safe to Change 

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'.
(The deprecated keyword IBOCRSW is equivalent to IBODLYN.)

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'.
(The deprecated value 'D' is now equivalent to 'A'.)

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.

 

Table 8: HSHSPB Source Default Settings That Should Probably Not Be Changed 

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.
(The deprecated value 'C' should not be used).

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.
(The IBCCSC keyword is deprecated and should not be used.)

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:

 

Table 9: HSHSPB Source Default Settings That Should Never Be Changed 

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.