Database Guide


Writing SELECT statements

The following sections explain how to issue SQL SELECT statements using IBM Smalltalk. For instructions regarding updating, inserting, and deleting rows in a database, see Writing UPDATE, INSERT, and DELETE statements.

The instructions in this section contain the following information:

For most simple queries, you code the same series of IBM Smalltalk expressions. When you write IBM Smalltalk code to issue a database query, follow these general guidelines:

The following is an example of a query statement to be issued in an IBM Smalltalk expression:

'SELECT *
        FROM STAFF
        WHERE (STAFF.NAME LIKE 'L%')'


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]