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%')'