Noaudit, Nullstring, Noaudit nullstring – HP Neoview Release 2.4 Software User Manual
Page 56
noaudit
noaudit = "true" | "false"
The default is false.
For a load operation, this option specifies whether Transporter should use non-transactional
database operations for improved performance. If the
option is not
“insert”
, the noaudit setting is ignored and noaudit is implicitly set to false.
If parallel = true for a job, all targets in that job must have the same setting for noaudit.
This option is ignored for extract operations.
If noaudit is true:
•
The
option must be true.
•
The
option must be true.
•
The
option must be false.
•
The target table must not contain any dependent objects.
•
An error is returned if any of the above conditions are not met.
If noaudit is false:
•
The forcestaging option determines whether Transporter uses transactional or
non-transactional database operation. See
for details.
nullstring
nullstring = "character-string"
There is no default value for a load operation or an extract operation.
This option specifies how to interpret NULL values. This option can be specified as a global
option or in a field definition.
Leading and trailing white space characters are removed from character-string before any
NULL value processing is performed.
character-string
is allowed to be an empty string or to consist entirely of white space
characters. Both are equivalent because leading and trailing white space are always removed.
The length of character-string cannot exceed 64 characters.
For a load operation:
•
If an input field matches character-string, the field is interpreted as a NULL value.
Leading and trailing white space in the input field are ignored in this comparison.
•
For delimited data formats, if nullstring is not specified, only an empty input field
containing no white space is considered a NULL value. For example, when two consecutive
field delimiters appear, this indicates a NULL field value. An input field containing only
white space is not considered a NULL value. It is considered an empty string if the
corresponding data type is a character type, otherwise the record is rejected.
•
For fixed-width data formats, if nullstring is not specified, it is not possible to represent
NULL values in input records. A character field containing only white space is considered
an empty string. For all other types, a field containing only white space is rejected and the
record is written to the
file.
For an extract operation:
•
This option specifies the character string that should be written to targets to represent NULL
values.
•
For delimited data formats, if nullstring is not specified, Transporter does not write any
data characters to the target field to represent a NULL value.
•
For fixed-width data formats, if nullstring is not specified, Transporter rejects any
retrieved record containing NULL values and writes the record to the baddatafile file.
56
Control File Options