ISQL and Tools

SELECT orderlist.ol_custnum, custmast.cm_custnum FROM orderlist, custmast

WHERE orderlist.ol_custnum = custmast.cm_custnum;

ROLLBACK WORK;

2.4.4Done

When a client application has completed operations with the server, it must release resources by disconnecting from the data- base. iSQL is an application that provides an interface for interactive SQL. It may not be explicit but a connection is made with the server when the isql tool is launched. Likewise, a disconnect occurs when the isql tool is exited.

Below is the interactive SQL for DONE:

ISQL> quit

This will return the process back to a regular command line prompt.

2.4.5Complete Transaction Processing Tutorial Source Code

Complete source code for the transaction processing tutorial can be found in Appendix A "Tutorial Source Code".

2-16

FairCom Corporation