注册 | 登录 忘记密码? 51cto首页 | 博客 | 论坛 | 招聘
热点文章 科普系列之-使用Windows的..
 帮助

Change db2 database's codeset and territory


2007-05-30 14:03:12
This is a quik guide for you to change the codeset and territory of your db2 database
 
  1. Start->Run
  2. db2cmd
  3. >db2move db_name export
  4. >db2look -d db_name -e -a -x -o db_name.sql
  5. >db2 drop db db_name
  6. >create db db_name using codeset iso8859-1 territory cn
  7. >db2 -tvf db_name.sql
  8. >db2move db_name load
  9. >db2 set integrity for table_name immediate checked






    文章评论
 
 

发表评论

昵   称:
验证码:  点击图片可刷新验证码  博客过2级,无需填写验证码
内   容: