Execute Update - Executes All Non-Select SQL Queries

This component performs a bulk update operation.

Contineo supports Execute Update DB Operation to perform any bulk insert, update, and delete DDL operations. In this database operation, you manually write the SQL Instruction.

Example: To create a new Database test DB.

Steps:

  1. Click + under DB Operations to create the new database operation.

  2. Enter the Name of the operation and select Type as "ExecuteUpdate".

  3. Click OK. The new component is created and opened in the designer.

    Image 1

  4. Click EDIT in the top menu to open the Properties Panel.

  5. Navigate to Properties > Data Source and select the required Data Source. You can create a new data source such as SQL Data Source under Settings.

  6. Click on Properties > Instruction to open the editor to write the SQL Instruction.

    Image 2

  7. Write down the SQL Instruction in the editor and click OK.

    Image 3

  8. Click SAVE to save the configuration.

    Image 4