Modify Database

This action uses the input table data to modify database information. By specifying queries to check for existing data, insert new data, and modify existing data, the action updates database data appropriately. It creates a status page and a table indicating the success or failure of each database modification.

Example Valid Types: NUMERIC, VARCHAR, DATE

  • Field

    Description
  • Label

    A label to identify the action. This label appears under the Action name inside the Action box. If this field is left blank, the default value is “Untitled.”
  • Description

    A brief explanation of what this action does inside the sequence. This description appears as a tooltip when your cursor hovers over the Action box.
  • Fail Message

    A message that identifies potential issues that could happen with this action. This fail message will appear if the action fails when you try generating the sequence. If this field is left blank, the default error message built into the action appears.
  • Data Source

    The data source the modifications will take place.
  • User

    (Optional) A user ID to use when running the SQL queries.
  • Password

    (Optional) The password to use when running the SQL queries.
  • Simple Update
    Used to specify a simple insert or update query.

    • If you use this property, the other three query properties are ignored.
    • Leave blank if you would rather use the Exists, Insert, and Update fields.
  • Exists
    Used in conjunction with the Insert and Update fields.

    • The Update query runs when a record exists.
    • The Insert query runs when a record doesn’t exist.

    Use $[column:type} placeholders to use values from the incoming data set. This run for each row for the incoming dataset.

    Example: select *from well where id = ${id:NUMERIC}

  • Insert
    Used in conjunction with the Exists and Update fields.

    • If this query is run, the Exists query doesn’t return any records.
    • Use ${column:type} placeholders to use values from the incoming data set.

    Example: insert into well (id, name) values (${id:NUMERIC}, ${name:VARCHAR})

  • Update
    Used in conjunction with the Exists and Insert fields.

    • The Update query uses the Exists query to run.
    • Use ${column:type} placeholders to use values from the incoming data set.

    Example: update well set name = ${name:VARCHAR} where ID = ${id:NUMERIC}

  • Output Details
    Select the check box to show the individual status.