Displaying data in dbisqlc

You can use dbisqlc is to look at information in databases.

The instructions and examples in this section use a database for a fictional company. The sample database contains information about employees, departments, sales orders, and so on.

All this information is organized into a number of tables that are made up of rows and columns.

You display information from a database using the SELECT statement. The following example shows the command to type in the dbisqlc command window. Once you have typed the command, click Execute to carry out the command. The example displays the first several columns and rows of the results of the query, which appear in the dbisqlc data window.

Enter:

SELECT *
FROM Employees

• In the examples, SQL keywords are shown in uppercase; however, SQL statements are case-insensitive.

• In many examples, each clause of a SQL statement is placed on a separate line for readability. You can enter SQL statements either all on one line, or you can break them over several lines.

The dbisqlc Data window displays a set of rows and columns containing information about the employees. Each row contains information about one employee, and each column contains a particular piece of information for all employees.

The visible portion of the dbisqlc data window cannot hold the entire Employees table. It does not display all the information about each employee, and does not display the entire list of employees.

To see information about each employee (other columns) use the scroll bar at the bottom of the data window. This is a standard Windows scroll bar.

To see more information on other employees (other rows), use the scroll bar to the right of the data window. The employee table in the sample database contains approximately 75 employees.

Sometimes, the vertical scroll bar behaves slightly differently than standard scroll bars, as the number of rows in the result may be unknown. In this case, a guess as to the number of rows is used. If dbisqlc determines that its guess is wrong, the guess is adjusted and the slider “jumps.”