The null indicator flag is a one-byte character that is contained in a null indicator column of a nondelimited ASCII file. When the load process looks at each data row, the null indicator flag indicates whether or not the data in the column defined by the start and end positions is NULL. Unless another flag is specified (using the NULLINDCHAR option), a 'Y' is used to denote that the data column is NULL. Anything else indicates that the data column is not NULL.
The null indicator flag for a given table column can be anywhere in the data row, but its position must be specified by the load or import process and a character must be in that position.
For an example of null indicator flags used in an ASC file, see null indicator.
[ Top of Page | Table of Contents | Glossary | Index ]