Use the Bulk Execute operation to combine multiple statements of the same data manipulation operation into one statement.

Configuring Bulk Ops in the Visual Editor

To configure the operation in the Visual Editor, select the connector inside your flow and specify the following connector properties.

• Connector Configuration: Select a connection you created. See Establishing a Connection for more information.
• Operation: Choose Bulk Execute.
• SQL Query: Enter one or more SQL statements. See the following examples. The statements can also contain expressions.

Bulk Insert

The following examples combine multiple inserts into a single Sybase request:

SQL

INSERT INTO [master].[dbo].Products (ProductName) VALUES ('Ikura'); INSERT INTO [master].[dbo].Products (ProductName) VALUES ('Konbu');

<cdata-sybasebulk-execute config-ref="CData_Sybase_Configuration" query="INSERT INTO [master].[dbo].Products (ProductName) VALUES ('Ikura'); INSERT INTO [master].[dbo].Products (ProductName) VALUES ('Konbu');" doc:name="CData Sybase"/>

Bulk Update

The following examples combine multiple updates into a single Sybase request:

SQL

UPDATE [master].[dbo].Products SET ProductName='Ikura' WHERE Id = 'MyId1';UPDATE [master].[dbo].Products SET ProductName='Konbu' WHERE Id = 'MyId2';

<cdata-sybasebulk-execute config-ref="CData_Sybase_Configuration" query="UPDATE [master].[dbo].Products SET ProductName='Ikura' WHERE Id = 'MyId1';UPDATE [master].[dbo].Products SET ProductName='Konbu' WHERE Id = 'MyId2';" doc:name="CData Sybase"/>

Bulk Delete

The following examples combine multiple deletes into a single Sybase request:

SQL

DELETE FROM [master].[dbo].Products WHERE Id = 'MyId1'; DELETE FROM [master].[dbo].Products WHERE Id = 'MyId2'; 

<cdata-sybasebulk-execute config-ref="CData_Sybase_Configuration" query="DELETE FROM [master].[dbo].Products WHERE Id = 'MyId1'; DELETE FROM [master].[dbo].Products WHERE Id = 'MyId2'; " doc:name="CData Sybase"/>