This section provides several payload and expected-result examples for Loader.

Example 1

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
f1=111 f2=222 f3=333

Example 2

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
where f1=111 and f2=222 and f3=333

Example 3

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 
setting f2=2xx
where f1=111 and f3=333

if there's no match with the where condition then insert 1 record with
f1=111 f2=222 f3=333

Example 4

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
where f1=111 and f2=222 and f3=333

Example 5

Fixed Payload Format - Insert

Format: Fixed
DML type: Insert
Columns for INSERT: f1, f2, f3
Payload: 111111111122222222223333333333
Result:
insert of 1 record with
f1=1111111111 f2=2222222222 f3=3333333333

Example 6

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
(f1=1xxxxxxxxx f2=2xxxxxxxxx f3=3xxxxxxxxx)
where (f1=1111111111 f2=2222222222 f3=3333333333)

Example 7

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 
setting f2=2xxxxxxxxx
where f1=empty string and f3=empty string

if there's no match with the where condition then insert 1 record with
f1=10 spaces and f2=2222222222 and f3=10 spaces

Example 8

Fixed Payload Format - Delete

Format: Fixed
DML type: Delete
Columns in WHERE clause: f1, f2, f3
Payload: 111111111122222222223333333333
Result:
deletion of all records
where f1=111 and f2=222 and f3=333

Example 9

XML Payload Format - Insert

Format: XML
DML type: Insert
Columns for INSERT: f1, f3
Payload:
<?xml version="1.0" encoding="utf-8"?>
<Message type="TERAJMSA">
  <records>
    <row>
      <f1>111</f1>
      <f2>222</f2>
      <f3>333</f3>
    </row>
    <row>
      <f1>111</f1>
      <f2>222</f2>
      <f3>333</f3>
    </row>
  </records>
</Message>
Result:
insert of 2 records with
f1=111 and f2=null and f3=333

Example 10

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"?>
<Message type="TERAJMSA">
  <records>
    <row>
      <update>
        <f1>1xx</f1>
        <f2>2xx</f2>
        <f3>3xx</f3>
      </update>
      <where>
        <f1>111</f1>
        <f2>222</f2>
        <f3>333</f3>
      </where>
    </row>
  </records>
</Message>
Result:
update of all records
setting f1=1xx f2=2xx f3=3xx
where f1=111 and f2=222 and f3=333

Example 11

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"?>
<Message type="TERAJMSA">
  <records>
    <row>
      <update>
        <f2>2xx</f2>
      </update>
      <where>
        <f1>111</f1>
        <f3>333</f3>
      </where>
      <insert>
        <f1>111</f1>
        <f2>222</f2>
        <f3>333</f3>
      </insert>
    </row>
  </records>
</Message>
Result:
update of all records
setting f2=2xx
where f1=111 and f3=333

if there's no match with the where condition then insert 1 record
with f1=111 and f2=222 and f3=333

Example 12

XML Payload Format - Delete

Format: XML
DML type: Delete
Columns in WHERE clause: f1, f2, f3
Payload:
<?xml version="1.0" encoding="utf-8"?>
<Message type="TERAJMSA">
  <records>
    <row>
      <f1>a</f1>
      <f2 null='false'>b</f2>
      <f3>c</f3>
    </row>
    <row>
      <f1>111_1</f1>
      <f2 null="true">222</f2>
      <f3>333_1</f3>
    </row>
  </records>
</Message>
Result:
deletion of all records
where (f1=a and f2=b and f3=c)
OR
where (f1=111_1 f2 is null and f3=333_1)