Considerations for delete operations – HP Neoview Release 2.4 Software User Manual
Page 67
•
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 Delete Operations
67