Accessing and updating data

Access data by using the SQL Query Builder, work with filters and views, and work with SQL DDL statements.

Sampling the contents of a table
Display up to 1000 rows of a table. Ensure that you are connected to a database.

Testing the SQL statement for a relational view
See the contents of a relational view by testing and viewing the result set of a SQL query. This result set gives you a preview of the contents in the relational view.

Deploying data objects to a database
Define, generate, and apply SQL Data Definition Language (DDL) statements in the Data Definition view of the Data perspective. Generate SQL DDL statements for only DB2 Universal Database databases.