论坛首页 入门技术论坛

DB2 Quick Start In 3 Minutes

浏览 1737 次
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (0)
作者 正文
   发表时间:2008-05-08  

Env: Windows XP SP2

==== DB2 Quick Start


D:\Program Files\IBM\SQLLIB\BIN>db2
(c) Copyright IBM Corporation 1993,2002
Command Line Processor for DB2 SDK 8.2.3

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 => create db mydb
DB20000I  The CREATE DATABASE command completed successfully.
db2 => connect to mydb user admin
Enter current password for admin:

   Database Connection Information

 Database server        = DB2/NT 8.2.3
 SQL authorization ID   = ADMIN
 Local database alias   = MYDB

db2 => create schema myschema
DB20000I  The SQL command completed successfully.
db2 => create table myschema.mytable(id int, name varchar(30))
DB20000I  The SQL command completed successfully.
db2 => insert into myschema.mytable values(101,'Bruce Lu')
DB20000I  The SQL command completed successfully.
db2 => select * from myschema.mytable

ID          NAME
----------- ------------------------------
        101 Bruce Lu

  1 record(s) selected.

db2 => drop table myschema.mytable
DB20000I  The SQL command completed successfully.
db2 => drop schema myschema restrict
DB20000I  The SQL command completed successfully.
db2 => connect reset
DB20000I  The SQL command completed successfully.
db2 => drop db mydb
DB20000I  The DROP DATABASE command completed successfully.
db2 => db2stop
DB20000I  The DB2STOP command completed successfully.
db2 => quit
DB20000I  The QUIT command completed successfully.

D:\Program Files\IBM\SQLLIB\BIN>

==== Reference

快速参考: DB2 命令行处理器(CLP)中的常用命令

论坛首页 入门技术版

跳转论坛:
Global site tag (gtag.js) - Google Analytics