Considerations for update operations, Considerations for upsert operations, Considerations for delete operations – HP Neoview Release 2.5 Software User Manual
Page 73
— All CHAR columns must be of compatible types – that is, either UCS2 or ISO88591, but
not both in the same table.
— There are these differences in the display of data:
◦
If the data in the table is 0.00, it appears in the extract file as .00, the format used
by SQL on the Neoview server.
◦
If a column in the table is NULL, it appears in the table to which it is extracted as
an empty string delimited by double quotes (" "), but if a SQL query extract is then
performed, it appears as an empty string delimited by commas (, ,).
NOTE:
You can globally disable “fast extract” processing by setting this property in the
nvt.properties file:
fast-extract-enabled = false
Considerations for Update Operations
These considerations exist for update operations:
•
Updates to primary key fields are supported.
•
The condition map entry option defaults to true for all primary key columns.
•
The update map entry option defaults to true for all non-primary key columns.
Considerations for Upsert Operations
These considerations exist for upsert operations:
•
Updates to primary key fields are not supported.
•
The condition map entry option defaults to true for all primary key columns.
•
The update map entry option defaults to true for all non-primary key columns.
•
The
option is not supported for upsert operations.
Considerations for Delete Operations
•
Delete operations are supported for the following types of map entry fields:
— Constant map entries
— Field map entries
— Field expression map entries
— NULL map entries
•
default
map entry field types are ignored
•
The WHERE clause is based on the primary key fields unless the condition map entry
field option is explicitly set to false.
•
At least one field map entry field or expression map entry must have condition set to
true
. That is, if all primary key fields are set to false, Transporter returns an error.
•
If only constant map entry fields are true and all primary key fields are false, Transporter
returns an error.
•
If you specify constant map entry fields as true, you must also specify at least one field
map entry or expression map entry as true. Otherwise, Transporter returns an error.
•
If you specify all primary key fields as constant map entry fields, you must also specify at
least one field map entry or expression map entry as true. Otherwise, Transporter returns
an error.
•
If truncate is set to true at either global or job option levels, Transporter returns an error.
•
If no data is deleted from the target table, Transporter exits with an exit code of 0 (zero). For
more information about exit codes, refer to
Considerations for Update Operations
73