Database Write data source

Append or overwrite an existing table using the Database Write data source.

Note: The A&AS database is the exception, to which data can be written using the STORE command.
The parameters for connecting to any databases defined as data sources must already be configured in the Database page in the A&AS web application.

For example, the BookMaster database contains the details of all books available in the library. The BookMaster database contains the following fields: Book_Num, Title, Author, Scode, Pcode, Edition_Num, and Issued as shown in the image below:

Database Write Data Source

The Add Data Source section, allows to create a new Database Write data source variable. Based on the data source, the corresponding database tables are displayed. Use the WRITE command to update the selected table.

The Data Source Details section allows to select the database and the Table/View drop-down lists all the tables found in the selected database. Use the SQL batch size to control the number of operations to be executed in a single transaction. The default value is 100. Users can append the new data to existing records of a table or overwrite the existing records.

The Field Information section lists all the fields that are available in the selected database table. Select the check box corresponding to a field and click Delete. The delete can be reversed by clicking Add. This adds the deleted field as the last row of the table. Use the Up and Down arrows to move the field to the desired position.