DB2

C:\Program Files\IBM\SQLLIB\BIN>db2
(c) Copyright IBM Corporation 1993,2002
Command Line Processor for DB2 ADCL 9.1.0

You can issue database manager commands and SQL statements from the command
prompt. For example:
    db2 => connect to sample
    db2 => bind sample.bnd

For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
 ? CATALOG DATABASE for help on the CATALOG DATABASE command
 ? CATALOG          for help on all of the CATALOG commands.

To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.

For more detailed help, refer to the Online Reference Manual.

db2 => db2start
DB20000I  The DB2START command completed successfully.

db2 => connect to sample

   Database Connection Information

 Database server        = DB2/NT 9.1.0
 SQL authorization ID   = TAD-CENT...
 Local database alias   = SAMPLE

db2 => create table emp(empid int, name varchar(30))
DB20000I  The SQL command completed successfully.

db2 => insert into emp values(10, 'Mike')
DB20000I  The SQL command completed successfully.

db2 => insert into emp values(20, 'Tammy')
DB20000I  The SQL command completed successfully.

db2 => insert into emp values(30, 'Emma')
DB20000I  The SQL command completed successfully.

db2 => select * from emp

EMPID       NAME
----------- ------------------------------
         10 Mike
         20 Tammy
         30 Emma

  3 record(s) selected.

db2 => create unique index ixpk_emp on emp(empid)
DB20000I  The SQL command completed successfully.