RDBMS Adapter - Table Functions
Search form
| Function | Description |
|---|---|
| GET | Retrieves one row at a time. |
| INSERT | Inserts one row into a table. |
| UPDATE | Updates non-primary keys and operates on a single row at a time. The primary keys sent in the request are used to populate the where clause in the SQL statement. Updating primary keys is logically equivalent to deleting the row by primary key and then inserting a new row with a new ID with the same non-primary key values. This logic fits the DAO, JDO, or EJB frameworks while simply updating the primary keys does not. |
| DELETE | Deletes one row at a time. The parameters are the primary keys. |
| UPSERT | Combines the INSERT and UPDATE functions. This function checks if a row already exists. If it does not exist, the request is forwarded to the INSERT function; this is determined by performing a count query with the table’s primary keys as part of the where clause, as shown in the properties in the right pane. |
| COUNT | The COUNT table function is used to return the number of entries in a table. The query does not accept any input parameters. |
| AVERAGE | This query executes an avg() function on a table and accepts an input parameter representing the column name. The JDBC API is not used to set the question mark in the statement. This process recreates the statement string replacing the question mark with the value in the input parameter in the request. This is performed before the statement is prepared. |
| MAX | This query executes a max() function on a table and accepts an input parameter representing the column name. |
| MIN | This query executes a min() function on a table and accepts an input parameter representing the column name. |
| SUM | This query executes a sum() function on a table and takes in an input parameter representing the column name. |