Figure 10: Example SQL statement

				 
EXEC SQL SELECT inorder.ordernum INTO :ordnum
          FROM FINAL TABLE (INSERT INTO orders (custno)
                                   VALUES(:custnum) ) inorder ;