applied subcommand

The applied subcommand describes operations recorded in the database, including:

• Row updates

• Row inserts

• Row deletes

• Executions of applied stored procedures (request stored procedures use the execute subcommand)

• Modifications to text or image data

• Truncate table or partition

The syntax for the applied subcommand is:

distribute command_tags applied [owner=owner_name]
  {'table'.rs_update
      yielding before param_list after param_list |
  'table'.rs_insert yielding after param_list |
  'table'.rs_delete yielding before param_list |
   'table'.function_name [param_list]
      yielding after param_list before param_list |
  'table'.rs_datarow_for_writetext
      yielding datarow column_list |
  'table'.rs_writetext
      append [first] [last] [changed] [with log]
      [textlen=100] column_list}|
  'table'.rs_updatetext
      {partialupd | _pu} [{first | _fi}] [last] [{changed | _ch}] [with log]
      [{withouttp | _wo}]
      [{offset |_ os}=offset {deletelen | _dln}=deletelength]
      [{textlen | _tl}=length] text_image_column |
‘table’.rs_truncate [partition_name[, partition_name]...] yielding}