Tell-if-delay - Call-Level Interface Version 2

Tell‑if‑delay

Tell‑if‑delay is a one byte EBCDIC field that specifies whether the application is to be informed of a delay in executing the request. A delay may be loss of communication with the Teradata Database, a restart of the Database, or the request being delayed within the Database by workload management, when the Database supports such notification.

If a restart is detected during logoff processing, CLIv2 reconnects the session and resubmits the logoff request.

In this language...	The variable name for Tell‑if‑delay is...
COBOL	DBCAREA‑TELL‑IF_DELAY
PL/I	TELL_IF_DELAY
C	tell_if_delay
IBM Assembler	DBODLYT

This routine...	Does this for Tell‑if‑delay...
DBCHINI	writes
DBCHCL	reads (CON; RSUP; IWPF; IRQ; CRQ)

Tell‑if‑delay is used by...	To...
applications	write

Tell‑if‑delay is initialized by DBCHINI to the default value provided for Tell‑if‑delay in the HSHSPB.

When the value for Tell‑if‑delay is not appropriate for the application, you should perform the following procedure before calling DBCHCL.

1 Set Change Options to 'Y'.

2 Change the value for Tell‑if‑delay as follows.

If CLIv2 is to...	Then change the value for Tell‑if‑delay to...
inform the application of a delay	Y
not inform the application of a delay	N

If a restart occurs during a logoff request, CLIv2 reconnects the session and resubmits the logoff request.

Use mnemonics for the codes. Mnemonics are provided in the language definition file for the DBCAREA.

The Tell‑if‑delay and Wait‑during‑delay DMCAREA options interact as described in the following table.

		Wait‑during‑delay
		N	Y
Tell‑if‑delay	N	Invalid	The application is not informed of the delay and waits for the delay to end.
	Y	For delays due to loss of communication with or a restart of the Database, the application is informed that Tell‑if‑delay was honored with a final return code 286, and the session will be logged off when the Database becomes available (the request may or may not have executed). For delays by Database workload management, the application receives a response indicating the request was not executed rather than be delayed.	The application is informed that Tell‑if‑delay was honored with a preliminary return code 286, and subsequently receives the response when the delay ends and the request is executed.