📄️ Read Data from Table
The easiest way to retrieve data from a table is to send a GET request with the table name.
📄️ Filter data with RSQL
DB2Rest uses RSQL or REST SQL to filter data in the database tables. RSQL is very easy to learn and write filtering queries.
📄️ Supported RSQL Operators
DB2Rest supports the following RSQL operators.
📄️ Filtering Examples
It is possible to filter result rows by adding conditions on columns.
📄️ Apply column filtering on a table
Column filtering is the ability to specify exactly the columns from the table that should be retrieved in a query.
📄️ How to add column alias?
In the previous section of vertical filtering,
📄️ Handle large result-sets with Pagination
Sometimes the result of a query execution can fetch many records. It is inefficient to fetch a large number of row.
📄️ Sorting
It is possible order the results retrieved by DB2Rest using the sort request parameter. This will apply ORDER BY
📄️ Query for a single row
DB2Rest can fetch a single unique record with suitable filter condition. In this case the return type is a JSON object,
📄️ Count rows
It is very easy to count the number of records in a table or as a result of a query.
📄️ Restrict Schemas
By default, DB2Rest will load all metadata from all schemas. In case the database under consideration has many schemas with