The examples, called LABs, are a series of nine programs that use a new EMPLOYEE table to load on the database. The examples start with simple syntax statements and progress through more complex operations.
Note: See “EMPLOYEE Table” on page 229 for sample data from the EMPLOYEE table.
|
LAB |
Examples in LAB |
|
LAB1 |
LOGON and LOGOFF statements |
|
LAB2 |
Static SELECT statement |
|
LAB3 |
Static SELECT, INSERT, UPDATE and DELETE statements |
|
LAB4 |
Multiple row return SELECT statement using cursors |
|
LAB5 |
Multiple statement request using cursors |
|
LAB6 |
Static EXEC for a macro This example produces results similar to LAB2, employing a macro. |
|
LAB7 |
The use of a cursor for a macro. This example produces the same result as LAB5. |
|
LAB8 |
The use of dynamic SQL with PREPARE, DESCRIBE, and EXECUTE. This run is the dynamic equivalent of LAB2. |
|
LAB9 |
The use of dynamic SQL, especially the EXECUTE IMMEDIATE construct. This run is the dynamic equivalent of LAB3. |