HP c-tree-SQL ISQL and Tools Instrukcja Użytkownika Pobierz pdf (Strona 13)

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".

1 2 ... 8 9 10 11 12 13 14 15 16 17 18 ... 98 99

Brak uwag

HP c-tree-SQL ISQL and Tools Instrukcja Użytkownika Strona 13