Quick Tour
VALUES ('1001', '61434', 'CT', '1', 'Michael Jordan', '13 Main', 'Harford');
ISQL> INSERT INTO CUSTMAST
VALUES ('1002', '73677', 'GA', '1', 'Joshua Brown', '4356
Cambridge', 'Atlanta');
ISQL> INSERT INTO CUSTMAST
VALUES ('1003', '10034', 'MO', '1', 'Keyon Dooling', '19771 Park
Avenue', 'Columbia');
ISQL> COMMIT WORK;
Display Records
ISQL> SELECT * FROM CUSTMAST;
Delete Records
ISQL> DELETE FROM CUSTMAST;
ISQL> COMMIT WORK;
2.1.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 interactive interface for 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.1.5Complete Introductory Tutorial Code
Complete source code for the introductory tutorial can be found in
Appendix A "Tutorial Source Code".
FairCom Corporation |