The command-line processor is the DB2 interface, which best embodies the power of DB2, as well as the simplicity and versatility of DB2. The author makes a detailed exposition of it through examples.0 Reviews:Blair Adamache, DB2 technology
After several days, I have completed HADR. Next, let's share it with you.
System Environment:
OS: SUSE 11sp1-64bit
DB: db29.7.0.5
DB2server1: 192.168.5.151 db2inst1
DB2server2: 192.168.5.152 db2inst2
Steps:
Operations on DB2server1:
Db2inst1 @
Reposted from: longtang Bay
1.1.1 obtain the first N records
SQL Server: Select Top N * From xtable
ORACLE: Select * From xtable where rownum
DB2: Select * From xtable fetch first n rows only
1.1.2 obtain the current date
SQL Server: Select getdate
DB2 default need to switch to db2inst1 this default user to perform the action[Email protected] instance]# Su-db2inst1[Email protected] ~]$ Db2start[Email protected] ~]$ DB2 force application All[Email protected] ~]$ Db2stop[Email protected] db2]$
Comparison | program
Brief introduction
In the view of. NET application developers, using DB2 is no different from using any other relational database. You can see countless examples of using SQL Server and Oracle products to perform database tasks,
The difference between DB2 and Oracle
1, DB2 access to the first 10 lines of data and Oracle Difference
DB2:
SELECT * FROM Test fetch a
Oracle:
SELECT * FROM Test where rownumQuery statement
DB2: Do not provide stealth conversion
SELECT * from
Introduction
In the view of. NET application software developers, using DB2 is no different from using any other relational database. There are countless examples of using SQL Server and Oracle products to execute database tasks, but there are far
Comparison | program | data | Database
Brief Introduction
In the view of. NET application developers, using DB2 is no different from using any other relational database. You can see countless examples of using SQL Server and Oracle products to
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.