Script Home
  • DB2 database under CentOS installation process steps

    +Read more
    Author:zyq / Release:2014-9-26 / category:DB2 / crowd0 views time+ / Comments Off on DB2 database under CentOS installation process steps /
    This article mainly introduced the DB2 database under CentOS installation process explanation, steps, this paper has a detailed, operation command is complete, need friends can under reference recently because the job needs to learn DB2 database, this tutorial shows you the DB2 database under in...
    CentOSdatabaseinstallation
  • DB2 how to view the current user mode and switch users

    +Read more
    Author:zyq / Release:2014-8-12 / category:DB2 / crowd0 views time+ / Comments Off on DB2 how to view the current user mode and switch users /
    How DB2 view the current user mode and switch users, to other user authorization, etc., all below to introduce the next 1. Connect to the database: db2 connect to study 2. Query for the current user mode: select the current schema from sysibm. Either or select the current schema from sysibm. D...
    user mode
  • DB2 database creation, table ixf files export import the sample

    +Read more
    Author:zyq / Release:2014-8-12 / category:DB2 / crowd0 views time+ / Comments Off on DB2 database creation, table ixf files export import the sample /
    This article mainly introduced the DB2 database creation, table ixf files export import the sample, need friends can under reference 1. create a database /db2inst1 @ localhost ~ $now=1208 #set encoding /db2inst1 @ localhost ~ $db2 create database WMS automatic storage yes using codeset utf-8 ...
    database creationexport import
  • The db2 import and export operation explanation of a single table

    +Read more
    Author:zyq / Release:2013-7-20 / category:DB2 / crowd1 views time+ / sofa /
    1, export the entire DATABASE table structure, methods, stored procedures, etc., and executing scripts: the db2look dbname - e - d - o db. The SQL - username - I w password db2 - TVF db. SQL 2, single table data export and import: export: the db2move dbname export - tn tablename -u db2user -...
    DB2
  • DB2 SELECT statement advanced usage

    +Read more
    Author:zyq / Release:2013-7-19 / category:DB2 / crowd0 views time+ / sofa /
    1, create a result table in the create table new_table_nameas (select * from table_name) definitiononly; 2, create a materialized query table (MQT) in the create table new_table_nameas (select * from table_name) datainitially deferred refresh deferred; refresh table new_table_nam...
    DB2
  • DB2 is common and practical SQL statements

    +Read more
    Author:zyq / Release:2013-7-19 / category:DB2 / crowd0 views time+ / sofa /
    1, find the employee's serial number and date of birth, name, department, if the date of birth is empty, display the date is unknown, and to sort the output by department, the date format as yyyy - mm - dd. select emp_no, emp_name, dept, isnull (convert (char (10), birthday, 120), 'no date') bi...
    DB2SQL statements
  • Commonly used DB2 command summary

    +Read more
    Author:zyq / Release:2013-7-19 / category:DB2 / crowd0 views time+ / sofa /
    1、 打开命令行窗口   #db2cmd 2、 打开控制中心   #db2cmd db2cc 3、 打开命令编辑器  db2cmd db2ce =====操作数据库命令===== 4、 启动数据库实例   #db2start 5、 停止数据库实例   #db2stop  如果你不能停止数据库由于激活的连接,在运行db2stop前执行db2 force application all就可以了/db2stop force 6、 ...
    commonly used commandsDB2

0Wide search 1Web Design 2Script 3Network Programming 4Database 5Operating system 6Network Security