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.
For sample data from the EMPLOYEE table, see 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. |