Purpose
Sends data in Indicator Mode to the Teradata server.
Usage Notes
- Req
- IndicReq
- FMReq
This parcel is generated by CLIv2 at the direction of the application.
Parcel Data
The following information applies to the IndicData parcel.
| Flavor | Parcel Body Length | Parcel Body Fields | |
|---|---|---|---|
| 68 | 2 to maximum body size |
|
|
Field Notes
The following notes apply to IndicData fields.
The NullIndicators Field contains one bit for each item in the Data Field, stored in the minimum number of 8-bit bytes required to hold them, with the unused bits in the rightmost byte set to zero.
Each bit is matched on a positional basis to an item in the Data Field (that is, the ith bit in the NullIndicators Field corresponds to the ith item in the Data Field).
| If a bit is... | Then the value of the corresponding data item is... |
|---|---|
| ON | null. |
| OFF | not null. |
Whether the null indicator bit is ON or OFF, the length of the corresponding data item is meaningful.
For example,
| If the data item is to contain... | Then... |
|---|---|
| a variable length string | length portion of the data item is set to the actual length of the string (which is zero if the data item represents a null value). |
| an integer | the data item occupies four bytes (which will be zero if the data item represents a null value). |
The Data Field contains a formatted record of data:
The order of the items and their data types and lengths are determined by the USING row descriptor in the Teradata SQL statement.
The values of the items are represented in client internal format.
A null value is explicitly indicated by a null indicator bit, as explained in the earlier section.