Use Presence Bits - Call-Level Interface Version 2

Use Presence Bits

Usage Notes

The Use Presence Bits field specifies the mode in which data is to be packaged by the client for sending to the Teradata Database.

Language	Variable Name
COBOL:	DBCAREA-USE-PRESENCE-BITS
C: DBCAREA.H:	use_presence_bits

Routine	Action Taken
DBCHINI:	writes
DBCHCL:	reads (CON; RSUP: IRQ)

Used by	Action Taken
application program	writes

Use Presence Bits is initialized by DBCHINI to the default value provided for Use Presence Bits in the site’s SPB.

If the value provided is not appropriate for the application, before calling DBCHCL for the Connect, Run Startup, or Initiate Request function, the application program may set:

Change Options to Y, and

Use Presence Bits to:

Y, if the data string has been prepared in Indicator (IndicData) Mode.

N, if the data string has been prepared in Record Mode.

To send null data to the Teradata Database, set Use Presence Bits to Y and provide a data string as described for the IndicData parcel.

Note: Because DBCHCL does not parse the request string, it is the application program’s responsibility to check whether the request string contains a USING clause and to set Use Presence Bits, Using Data Pointer, and Using Data Length appropriately.

Note: Although Use Presence Bits is read during the call to DBCHCL for Connect and Run Startup functions and stored in the appropriate session and request control blocks, it is not used by the function. Neither function sends an input data string to the Teradata Database.