A SERVICE OF

logo

Quick Tour
FairCom Corporation 2-3
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.4 Done
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.5 Complete Introductory Tutorial Code
Complete source code for the introductory tutorial can be found in
Appendix A "
Tutorial Source Code".