如下:
C:\Program Files\IBM\dwe\SQLLIB\BIN>db2 connect to sample
Database Connection Information
Database server= DB2/NT 9.5.2
SQL authorization ID = SUNNY
Local database alias = SAMPLE
C:\Program Files\IBM\dwe\SQLLIB\BIN>db2 select * from DB2ADMIN.EMPLOYEE fetch first 1 rows only
EMPNOFIRSTNME MIDINIT LASTNAMEWORKDEPT PHONENO HIREDATE JOBEDLEVEL SEX BIRTHDATESALARYBONUS COMM
------ ------------ ------- --------------- -------- ------- ---------- -------- ------- --- ---------- ----------- ----------- -----------
000010 CHRISTINEI HAAS
A0039781995-01-01 PRES
18 F 1963-08-24 152750.00 1000.00 4220.00
1 record(s) selected.
C:\Program Files\IBM\dwe\SQLLIB\BIN>db2look -d sample -e -t DB2ADMIN.EMPLOYEE
-- USER is: DAVID
-- The db2look utility will consider only the specified tables
-- Creating DDL for table(s)
-- This CLP file was created using DB2LOOK Version "9.5"
-- Timestamp: 1/4/2009 10:42:12 AM
-- Database Name: SAMPLE
-- Database Manager Version: DB2/NT Version 9.5.2
-- Database Codepage: 1208
-- Database Collating Sequence is: IDENTITY
CONNECT TO SAMPLE;
-- Table name specified is incorrect