Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 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 “enabletriggers” (page 51) 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 Appendix E (page 117).

Considerations for Delete Operations 67

1 2 ... 62 63 64 65 66 67 68 69 70 71 72 ... 123 124

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 67