About the Examples
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 233 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. |