Sample contents of a database table

Sampling the contents of a table

You can display up to 1000 rows of a table. Ensure that you are connected to your database.

To sample the database table contents:

  1. In the Database Explorer view of the Data perspective, right-click on the table whose contents you want to display, and then select Sample contents:

    Sample contents

    Results are displayed in the DB Output view of the Data perspective:

    DB Output

  2. Optional: Click the Parameters tab to view any parameters that were passed to the statement. The name of each parameter and its input value is listed. This page shows values only if host variables are defined for the statement.

  3. Click the Messages tab to view any messages returned by the database while the statement was running.

    Messages tab

Professional hosting     Belorussian informational portal         Free SCBCD 1.3 Study Guide     Free SCDJWS 1.4 Study Guide     SCDJWS 1.4 Quiz     Free IBM Certified Associate Developer Study Guide     Free SCJP 5.0 (Tiger) Study Guide     Free Mock Exam Engine     Free SCWCD 1.4 Study Guide     IBM Test 000-287. Enterprise Application Development with IBM WebSphere Studio, V5.0 Study Guide