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

ISQL Statements

FairCom Corporation 3-41

has_ccnstrs NOT NULL VARCHAR 1

has_ucnstrs NOT NULL VARCHAR 1

tbl_status NOT NULL VARCHAR 1

rssid NOT NULL INT 4

The following example uses the table command to detail the structure of the tables used in

examples throughout this chapter.

ISQL> table - List the sample tables

TABLENAME

---------

customers

lot_staging

lots

orders

quality

samples

ISQL> table customers

COLNAME NULL ? TYPE LENGTH

------- ------ ---- ------

customer_id NOT NULL INT 4

customer_name CHAR 50

customer_street CHAR 100

customer_city CHAR 50

customer_state CHAR 10

customer_zip CHAR 5

ISQL> table orders

COLNAME NULL ? TYPE LENGTH

------- ------ ---- ------

order_id NOT NULL INT 4

customer_id INT 4

steel_type CHAR 20

order_info CHAR 200

order_weight INT 4

order_value INT 4

order_state CHAR 20

ISQL> table lots

COLNAME NULL ? TYPE LENGTH

------- ------ ---- ------

lot_id NOT NULL INT 4

order_id NOT NULL INT 4

lot_units INT 4

lot_info CHAR 200

ISQL> table lot_staging

COLNAME NULL ? TYPE LENGTH

------- ------ ---- ------

lot_id INT 4

lot_location CHAR 20

start_date DATE

end_date DATE

issues CHAR 200

ISQL> table quality

COLNAME NULL ? TYPE LENGTH

------- ------ ---- ------

1 2 ... 62 63 64 65 66 67 68 69 70 71 72 ... 98 99

Komentarze do niniejszej Instrukcji

Brak uwag

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

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie HP c-tree-SQL ISQL and Tools