createTemporaryTable(name, columns, indices)

The data from the selected datasource is filled in the table so that it can be referenced by other datasources. This enhancement in Framework helps in the following way:

• Multiple DB queries can use the same temporary data.

• A complex SQL statement that is executed,can use the data in more than one sub statement.

When the process completes, the data can be cleared from the table so that the table can be reused. Temporary tables are created based on the defined parameters.

Parameters

• name: is the name of the temporary table that can be used in data sources as regular table.

• columns: is an array of JSON objects (each represents one column) that define the column names and domains.

• indices: is an array of JSON objects (each represents one index) that define the index name, an array involved in the columns (order represents the order in the index), and an optional flag that marks the index as unique.

Returns

INSERTINTO and DELETEFROM can be executed on the table using the following methods:

• insertQueryIntoAsync (tableName, selectFromDatasourceName, selectParamsJson

• deleteFromTableAsync:(tableName, whereCond)