The DB query analyzer allows you to easily create DB2 user-defined functions.
The DB query analyzer allows you to easily create DB2 user-defined functions.
Magenfeng
(Guangdong Union Electronic Service Co., Ltd., Guangzhou 510300, China)
SummaryThis article describes in detail the "universal database Query Analyzer", the Chinese version of the "DB Query Analyzer", and the English version of the "DB Query Analyzer" 6.03 to facilitate the creation of DB2 functions. The process of creating a DB2 storage is the same as that of creating a DB2 database. You can follow these steps. This example also applies to database systems (such as ORACLE) Where SQL statements are separated by commas ).
Starting from version 6.01, the SQL "Execution Plan" function has been added to the Chinese and English versions of the universal database query analyzer. From version 6.02, you only need to set the option "SQL Execution Plan connection Automatic Recovery" in the "tool-à option" window to "selected" status, even if the database server goes down during the "SQL Execution Plan" period, as long as the database server processes the startup status at the time of the "SQL Execution Plan, the "SQL Execution Plan" will be executed.
The universal database query analyzer in both Chinese and English versions is fully compatible with any Microsoft Windows operating system series, including Windows 10, Windows 8, Windows 7, Vista, Windows XP, Windows 2000, Windows NT, Windows ME, and Windows 98. When running on a Windows operating system, you do not need to change any operating system settings.
KeywordsDB query Analyzer and DBQuery Analyzer
1 Introduction
Ma genfeng, a local programmer in China (Interview with Ma genfeng in CSDN: A Chinese programmer who is a master of massive data processing and analysis) Released personal work ---- universal database Query Analyzer, Chinese Version DB Query Analyzer and English version DB Query Analyzer. It has powerful functions, friendly operation interface, good operability, spanning a variety of database platforms and even EXCEL and text files.
You can use it①Query ODBC data sources (including all databases, TXT/CSV files, and EXCEL files in the world.② You can execute multiple DML statements and even the storage process at the same time, and the results will be returned in the table, text box, and file you set;③When exporting tens of millions of data records from a database, the efficiency is no different from that of DBMS;④With the powerful SQL "Execution Plan" function, you only need to set the option "SQL Execution Plan connection Automatic Recovery" in the "tool-à option" window to "selected" status, even if the database server goes down during the "SQL Execution Plan" period, as long as the database server processes the startup status at the time of the "SQL Execution Plan, the "SQL Execution Plan" will be executed;⑤Version 6.03 is fully compatible with any Microsoft Windows operating system series, including Windows 10, Windows 8, Windows 7, Windows Vista, Windows 2003, Windows XP, Windows 2000, Windows NT, Windows ME, and Windows 9X, which can be run directly on Windows OS, you do not need to change any settings or configurations of any operating system.
DB query analyzer is online in Zhongguancun (Http://xiazai.zol.com.cn/detail/27/264455.shtml) Downloads exceed 0.11 million times, ranking first 10 in the entire database category ranking.
In the "New Product & tool comments" section of "programmer" 2007, "Special Recommendation" was edited and the "universal database query analyzer" was released.
I also wrote about the related technologies of "universal database query analyzer ".77Article, published on "computer programming skills and maintenance", "software", "Computer Age", "computer programming skills and maintenance", Baidu Library, CSDN resources, and my blog (CSDN blog, Sina Blog, QQ space, and Sohu blog ).
This article will take the Chinese version DB query analyzer version 6.03 as an example to introduce in detail version 6.03 to easily and quickly create DB2 functions. The creation of DB2 storage process is the same as this, you can refer to the following steps. This example also applies to database systems (such as ORACLE) Where SQL statements are separated by commas ).
2 6.03 Chinese Version DB query analyzer as an Example
The following uses the Chinese version of the "universal database query analyzer" database query analyzer 6.03 as an example to access the DB2 database based on AIX.
Front-end Operating System: Windows 2000Server Operating System
Foreground program: DB query analyzer 6.03
Background Database: DB2
Figure 1 log on to the background database
How to obtain the Chinese version of "universal database Query Analyzer" DB Query Analyzer "and the English version of" DB Query Analyzer "in" Zhongguancun online"Source installation packageFor details, see How to use the ZOL one-click installer to download the Zhongguancun online source installation package and How to downloadthe installation package by ZOL Downer.)
3 DB query analyzer create DB2 function examples conveniently and quickly
Figure 2 in the SQL Editor, enter the SQL statement used to create the DB2 Function
Figure 3 when the SQL separator is set to ';', an error occurs during function execution)
Figure 4 open the options window and set the SQL separator to '$'
Because only the newly opened window takes effect after the SQL separator settings are changed, a new window is created. on the lower right side of the status bar, you can see that the separator between SQL statements has changed to '$ ', as shown in:
Figure 5 install DB query analyzer 6.03 on Windows 8 (iii)
Figure 6 in the new window, paste the DB2 function creation statement in window 1
Figure 7 run the DB2 function creation statement. You can see that the statement has been successfully executed"
Figure 8 use two groups of test data to test the function execution and check whether the result is consistent with the expected value.
Figure 9 Execution of SQL statements containing user-defined functions
Figure 10 execution result data is successfully returned when an SQL statement containing a custom function is executed.
4. I wrote 77 technical articles on "universal database query analyzer ".
Currently, the following six articles are published in several Chinese computer publications:
[1] Ma genfeng-DB QueryAnalyzer interrupted SQL statement execution · Hangzhou: computer age, Issue 1, 12th
[2] Ma genfeng-DB query analyzer executes DML statements in batches and returns more detailed information. · Beijing: computer programming skills and maintenance, Issue 1, 24th
[3] Application of Transaction Management in margenfeng DBQuery Analyzer in DB2 · Beijing: computer programming skills and maintenance, Issue 1, 22nd
[4] Ma genfeng-DB query analyzer interrupted SQL statement execution · Tianjin: software, Issue 1, 6th
[5] Ma genfeng · Application of Transaction Management in Oracle in universal database query analyzer · Shanghai: "micro-computer application", Issue 1, 11th
[6] margenfeng New Product & tool comments Special Recommendation: "universal database query analyzer" released · programmer, Issue 2 in 2007
The following 71 articles are published on Baidu Library, CSDN resources, and my own blogs:
Tips for using the universal database query analyzer (1) until the use of the universal database query analyzer (16) 16 articles
The 1st tip ofDB Query Analyze until 16 articles in The 16th skills of DB Query Analyzer
How to configure ODBC on the client to access a remote DB2 for Windows Server
How to configure odbc dsn in Client toaccess remote DB2 for Windows
How to configure ODBC on the server to access the local DB2 forWindows Server
How to configure odbc dsn to access localDB2 for Windows
Top software developer killer SQL statements
Which SQL statement is the trump card tothe senior software developer
DB query analyzer executes DML statements in batches and returns more detailed information
Using the universal database query analyzer to test SQLite's support for the four SQL statements
Use the Object Browser of the "DB query analyzer" to display the database data dictionary
Universal database query analyzer users have basically covered all current Database Systems
The DBMS that DB Query Analyzer Users oftenuse cover all kinds of DBMS
Functions required by the query analyzer-interrupted query execution
EXE file shelling Technology for universal database query Analyzer
Exe packer prevent DB Query Analyzer frombeging debugged
The self-developed "universal database query analyzer" has finally achieved great results.
DB Query Analyzer interrupt SQL statement execution
DB query analyzer executes DML statements in batches and returns more detailed information
Application of Transaction Management in DB Query Analyzer in DB2
DB query analyzer interrupts SQL statement execution
Application of Transaction Management in universal database query analyzer in Oracle
Special Recommendation: universal database query analyzer release
Four SQL statements that must be mastered by software developers (I)
Four SQL statements that must be mastered by software developers (II)
Four SQL statements that must be mastered by software developers (III)
Four SQL statements that must be mastered by software developers (4)
Four SQL statements that must be mastered by software developers (Comprehensive)
Summit ---- "universal database query analyzer" 5.01 released
Universal database query analyzer and EXCEL powerful combination for data analysis
DB query analyzer executes Multiple SQL statements in batches and views their respective execution times
When DB query analyzer accesses EXCEL, you must add brackets or double quotation marks before and after the table name.
The table name must be enclosed in double quotation marks or squarebracket while accessing EXCEL by DB Query Analyzer
How to Use ZOL one-click installer to download the Zhongguancun online source installation package
How to download the installation package byZOL Downer
DB query analyzer 6.03, the best database client tool on any Windows Operating System
DB Query Analyzer, the mostexcellent Universal database Access tools on any Microsoft Windows OS
DB query analyzer 6.03 installation and running demonstration on Windows 8.1
Demonstration of DB QueryAnalyzer 6.03 Installation and Running on Microsoft Windows 8
DB query analyzer 6.03 allows you to easily create DB2 User-Defined Functions
How to easily create DB2user function by DB Query Analyzer 6.03
DB query analyzer 6.03 Zhongguancun online:
Http://xiazai.zol.com.cn/detail/27/264455.shtml
DBQuery Analyzer 6.03 Zhongguancun online:
Http://xiazai.zol.com.cn/detail/43/420901.shtml
Note:
If your computer is installed with a version earlier than "universal database query analyzer", Uninstall the old version before installing the new version. Thank you!
Author profile:
Ma genfeng, Master, research direction: database application.
I have developed a universal database Query Analyzer. The Chinese version is DB Query Analyzer and the English version is DB Query Analyzer. It has powerful functions, friendly operation interface, good operability, spanning a variety of database platforms and even EXCEL and text files.
I have also developed a File Delete Absolutely to permanently Delete files in Windows without being recovered by other software.
These two software are free to use. They are downloaded from several major software download websites, such as Zhongguancun online, skysoftware station, huajun Software Park, Pacific computer, extraordinary software station, and green alliance.
Author's blog:
CSDN blog: http://blog.csdn.net/magenfeng
Sina Blog: http://blog.sina.com.cn/magenfeng
QQ space: http://user.qzone.qq.com/630414817