The DB2 database has been used in recent projects because the DB2 database client is not very convenient in terms of operation and control, such as the writing of stored procedures. Later, our operations in the database were transferred to the Dbartisan, the latest version seems to be 8.12.
Here's how it's convenient to use this tool:
When writing stored procedures can use the wizard to complete, use very convenient, for example, we first select the database schema (owner), enter the name of the stored procedure, click Next
is the language used to select the Write stored procedure (SQL for example)
Then click Next, such as:
Enter some of the input and output parameters you used in the stored procedure here.
And then freak out the next step:
For example, between Begin and end is where we write SQL statements.
Once you have written the stored procedure, click "Create" above to create a stored procedure.
Although the convenience of this method of writing stored procedures in SQL Server may not be reflected, but in the DB2 is greatly reflected.
Second, DBArtisan8.12 the biggest advantage is that he supports debug, as if in 7.1 does not support Debug.
Is the stored procedure I have written, click: "COMMAND" select "DEBUG ..."
For example, enter the parameters of the stored procedure after the point "Continue"
For example: Press F11 to debug the stored procedure we write, which is very useful in some complex stored procedures.
Third, fully support data Field Association, which is also one of the advantages of Dbartisan.
Let's take a look at the Lenovo feature of Dbartisan Query Analyzer, taking SQL SERVER2005 as an example.
First connect the DBA tool to SQL SERVER2005, create a new query, and look at:
Multiple selections can be made on the associated field.
Is it feeling very good ah! ~~~~~dbartisan8.12 supports most of the current databases.
However, DBArtisan8.12 also has a very bad place, that is, the editor to write stored procedures for Chinese support is not very, do not know that I did not configure the reason, or other reasons.
DBArtisan8.12 can find the registration machine on the Internet, as if the use is not very good, I have DBArtisan8.12 license, the need for friends can be sent to you.
License download
Recommend a good database tool Embarcadero DBArtisan