This field displays the null indicator column (by byte location in the data file). This column contains the null indicator flag for the data being loaded into the table column displayed in the Table column field of the Change window. The default value is zero (0), specifying that the data column is not nullable (which means there will always be data to be loaded into this table column).
If you specify a positive integer in this field, then for a given row, the load process inspects this byte location. If this byte location contains the null indicator flag (either the default flag, 'Y', or the character specified in the ASC Options window as the NULLINDCHAR character), the data for the table column is set to NULL. If this byte location does not contain the null indicator flag, the data column denoted by the Start position and End position is loaded into the table column.
[ Top of Page | Table of Contents | Glossary | Index ]