首页 > 数据库技术 > 详细

db2 command line notes

时间:2015-12-13 15:24:38      阅读:189      评论:0      收藏:0      [点我收藏+]

  

create database feedb automatic storage yes

db2 list applications

db2stop

db2start

 

db2 -tvsf sample.sql

-t use semicolon as statement termination character;

-v verbose, echo input text to stdout

-s stop processing if error

-f file input

 


db2 list active databases

db2 list database directory show detail

db2 connect to feedb user <user_name> using <password>

db2 list tables for all

db2 list tables for schema <schema_name>

db2 describe table <schema.table_name>

db2 select * from table

 

db2 command line notes

原文:http://www.cnblogs.com/qsort/p/5042697.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!