This section provides several payload and expected-result examples for Loader.
Variable Payload Format - Insert
Format: | Variable |
Delimiter: | (,) |
DML type: | Insert |
Columns for INSERT: | f1, f2, f3 |
Payload: | 111,222,333 |
Result: | insert of 1 record with |
Variable Payload Format - Update
Format: | Variable |
Delimiter: | (,) |
DML type: | Update |
Columns for UPDATE: | f1, f2, f3 |
Columns in WHERE clause: | f1, f2, f3 |
Payload: | 1xx,2xx,3xx,111,222,333 |
Result: | update of all records |
Variable Payload Format - Upsert
Format: | Variable |
Delimiter: | (,) |
DML type: | Upsert |
Columns for UPDATE: | f2 |
Columns in WHERE clause: | f1, f3 |
Columns for INSERT: | f1, f2, f3 |
Payload: | 2xx,111,333,111,222,333 |
Result: | update of all records |
Payload Format - Delete
Format: | Variable |
Delimiter: | (,) |
DML type: | Delete |
Columns in WHERE clause: | f1, f2, f3 |
Payload: | 111,222,333 |
Result: | deletion of all records |
Fixed Payload Format - Insert
Format: | Fixed |
DML type: | Insert |
Columns for INSERT: | f1, f2, f3 |
Payload: | 111111111122222222223333333333 |
Result: | insert of 1 record with |
Fixed Payload Format - Update
Format: | Fixed |
DML type: | Update |
Columns for UPDATE: | f1, f2, f3 |
Columns in WHERE clause: | f1, f2, f3 |
Payload: | 1xxxxxxxxx2xxxxxxxxx3xxxxxxxxx111111111122222222223333333333 |
Result: | update of all records to |
Fixed Payload Format - Upsert
Format: | Fixed |
DML type: | Upsert |
Columns for UPDATE: | f2 |
Columns in WHERE clause: | f1, f3 |
Columns for INSERT: | f1, f2, f3 |
Payload: | "2xxxxxxxxx 2222222222 " |
Result: | update of all records |
Fixed Payload Format - Delete
Format: | Fixed |
DML type: | Delete |
Columns in WHERE clause: | f1, f2, f3 |
Payload: | 111111111122222222223333333333 |
Result: | deletion of all records |
XML Payload Format - Insert
Format: | XML |
DML type: | Insert |
Columns for INSERT: | f1, f3 |
Payload: | <?xml version="1.0" encoding="utf-8"?> |
Result: | insert of 2 records with |
XML Payload Format - Update
Format: | XML |
DML type: | Update |
Columns for UPDATE: | f1, f2, f3 |
Columns in WHERE clause: | f1, f2, f3 |
Payload: | <?xml version="1.0" encoding="utf-8"?> |
Result: | update of all records |
XML Payload Format - Upsert
Format: | XML |
DML type: | Upsert |
Columns for UPDATE: | f2 |
Columns in WHERE clause: | f1, f3 |
Columns for INSERT: | f1, f2, f3 |
Payload: | <?xml version="1.0" encoding="utf-8"?> |
Result: | update of all records |
XML Payload Format - Delete
Format: | XML |
DML type: | Delete |
Columns in WHERE clause: | f1, f2, f3 |
Payload: | <?xml version="1.0" encoding="utf-8"?> |
Result: | deletion of all records |