The DB query analyzer allows you to easily create DB2 user-defined functions.

Source: Internet
Author: User
Tags db2 functions function examples

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 itQuery 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

 


 

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.