Include column in table load
Start position
End position
Null indicator
OK
Cancel
Include column in table load
Start position
End position
Null indicator
OK
Cancel
Include column in table load
Select this check box if you want to load data into the table column displayed in the Table column field of the Change window.
Start position
Type the position (byte) in the ASC data file where the data to be loaded into the table column displayed in the Table column field of the Change window begins. For example, if your ASC file is:
3 4 5 0.........0.........0.... Smith,B. 4973 15.46 Jones,S. 12345 16.34 Davis,S. 452121 93.78
The start position for the second data column is 42.
End position
Type the position (byte) in the ASC data file where the data to be loaded into the table column displayed in the Table column field of the Change window ends. For example, if your ASC file is:
3 4 5 0.........0.........0.... Smith,B. 4973 15.46 Jones,S. 12345 16.34 Davis,S. 452121 93.78
The end position for the second data column is 47.
Null indicator
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.
