Format of update records

The UPDATE_RECORD expression, as used in the sample partial update pipeline, requires that each incoming record have one of the Delimited formats described below.

Format of records to be deleted

The first column in the header row must be a Remove column. The first column in each record must have a value of 1 to delete the record:

Remove|P_WineID|P_Year|P_Wine|P_Winery|...|
1|34699|1992|A Red Blend Alexander Valley|Lyeth|...|

Format of records to be updated

The first column in the header row must be an Update column. The first column in each record must have a value of 1 to update the record properties:

Update|P_WineID|P_Wine|P_PriceStr|
1|34701|Albarino Rias Baixas|1000.00|

Format of records to be added

The header row of records to be added do not begin with a Remove or Update column. Instead, they use the normal set of header row columns (P_WineId, P_Year, and so on). The first column in each record has a normal property value:

P_WineID|P_Year|P_Wine|P_Winery|P_PriceStr|...|
99000|1992|First New Wine Added|Lyeth|18.00|...|

Format of records in your implementation

If your implementation uses Delimited format records, you can use the above format to specify how the records are handled. If you use another format, you must use a record manipulator with the appropriate expressions to handle your source records.