BoolStyle option
Specifies the boolean style. During a load, the loader process requires all the boolean values so that they use one style only.
The following table lists the boolean styles and their
values.
| Style name | Value |
|---|---|
| 1_0 | 1 or 0 |
| T_F | T or F |
| Y_N | Y or N |
| YES_NO | YES or NO |
| TRUE_FALSE | TRUE or FALSE |
The default style is 1_0. You can specify the values in mixed case. For example, you can specify a value of true, True, TRUE, or tRuE.
If you specify the YES_NO option on the command line, the system assumes that the data in the boolean field is in the form yes or no. If the data is any of the other values (for example, true, false, 1, 0, t, f, y, or n), the system discards the record into the nzbad file and logs an error with the record number in the nzlog file.