How to create DB2 user function easily by DB Query Analyzer 6.03，

How to create DB2 user function easily by DB Query Analyzer 6.03，

How to create DB2user function easily by DB Query Analyzer 6.03

Ma Genfeng  

(Guangdong Unitoll Servicesincorporated, Guangzhou510300)

 

Abstract  The latest version of DB QueryAnalyzer is 6.03 In DB Query Analyzer 6.03, without changing any Windows OS settings or configurations, it can run on any Microsoft Windows OS directly such as Windows10, Windows 8, Windows 7, Windows Vista, Windows 2003, Windows XP, Windows2000, Windows NT, Windows ME, Windows 9X.

                 This essay gives a demonstration of creating DB2 user function easily by DB Query Analyzer. And also the creating process of stored procedure has no difference with that of function. What’s more, the process of creating user function is also applicable to other DBMS, in which comma is the default separator character between SQL statements.

Key words   DBQuery Analyzer

 

 

1   Brief introductionof DB Query Analzyer 

DB Query Analyzer is presented by Master Genfeng, Ma from Chinese Mainland. It has English version named ‘DBQuery Analyzer’ and Simplified Chinese version named   .

DB Query Analyzer is one of the few excellent Client Tools in the world for its’ powerful function,friendly interface, easy operation and applicability to every production of RDBMS.

It lets you query ODBC data sources, author SQL scripts and queries, return query results to a grid or free-form text or a file, retrieve ODBC driver information, execute multiple SQL scripts or stored procedures simultaneously,save the result to files with high efficiency which is as quick as tools provided by database system. What is more, from 6.01, DB Query Analyzer provides SQL Execute Schedule function to execute SQL scripts in certain time.If you select the option ‘SQL Schedule Reconnect’ in window configurations, the Schedule SQL scripts will be executed as long as the Database Server is in use,even though the Database Server had been down.

In DB Query Analyzer 6.03, without changing any Windows OS settings or configurations, it can run on any Microsoft Windows OS directly such as Windows10, Windows 8, Windows 7, Windows Vista, Windows 2003, Windows XP, Windows2000, Windows NT, Windows ME, Windows 9X.

 

Achievement of DB Query Analyzer

In the New products& Tools reviews of programmer second issue of 2007, DB Query Analyzer hadbeen strongly recommended.

Now the Simplified Chinese version of DB Query Analyzer is the top 50 database application software in the famous software website http://xiazai.zol.com.cn/download_order/sub_550.html. In most case it lies the top 10 and it has been download morethan 110,000 times.

77 technical articles about DB Query Analyzer have been published or been publishing in computerjournal, BAIDU Library, the CSDN resource or my four blog-website.

 

 

2   Preface

In this essay I will demonstrate how to create DB2 user functioneasily by DB Query Analyzer 6.03, and also the creating process of storedprocedure has no difference with that of function. What’s more, the process ofcreating user function is also applicable to other DBMS, in which comma is the separatorcharacter between SQL statements.

 

OS :  Windows 8.1

Database system :DB2

Client tool : DBQuery Analyzer 6.03.

 


 

3   How to downloadthe installation packages of DB Query Analyzer from ZOL

 

Recently,Zhongguancun Online distributed the ZOL Downer for users to download theresources from ZOL. In this case, users can just download the ZOL downer withthe code of resources, not the installation packages.

 

But if someonewant to install the PC which is isolated from the INTERNET, he or she will nolonger do that.

 

So how do theusers download the installation packages? Please see the eassy bellow

How to downloadthe installation package by ZOL Downer 

http://blog.csdn.net/magenfeng/article/details/38750901    

 

 

 

4   Log in DB2database

  
 

Figure 1   Log in ODBC DSN UNIT2_1

 

 

5 Create DB2 user function

Figure 2   Input SQL statment tocreate DB2 user function

 

 

Figure 3  Execute SQL statments above,errors occur

 
 

Figure 4   Alter the seperatorcharacter from comma to $$

 
 

Only in the newwindow can the setting take effect, so create a new window firstly, then youcan see the separator character is set to $$ in the right bottom of status barin Figure 5.

Figure 5   Open a new window to create userfunction

 

 

Figure 6   Paste SQL statement from window Untitled-1

 

 

Figure 7 Execute SQL statement

 
 

Figure 8   Execute function created using sample data for testing

 

 

Figure 9  This SQL statement is a sample I used in areal complex work

 

Figure 10   Result return from DB2 DBMS

  

 

 

6     77 technical articles about DB Query Analyzerhave been published or been publishing in computer journal,  Baidu Library, the CSDN resource or my fourblog-website.

 

The following 6 articles have been publishedin computer journal.

DBQuery Analyzer to cancel a running SQL statement in Computer Era 12th issue of 2011 in Hangzhou.

DBQuery Analyzer Returns Information in More Detail While Batch SQL Statement Endof Execution in Computer Programming Skill & Maintenance 24th issue of 2011 in Beijing

TheApplication of the Transactions Control in DB2 with DB Query Analyzer in ComputerProgramming Skill & Maintenance 22nd issue of 2011 in Beijing.

Howdoes DB Query Analyzer cancel the SQL statement committed to DBMS in ComputerEngineering & Software 6th issue of 2011 in Tianjin.

TheApplication of the Transactions Control in Oracle with DB Query Analyzer inMicrocomputer Applications11th issue of 2011 in Shanghai.

    DB Query Analyzer had been stronglyrecommended In the New products & Tools reviews of programmer 2nd issue of2007.

 

The following 71 articles have been publishedor been publishing in Baidu Library, the CSDN resource or my four blog-website.

TheDBMS that DB Query Analyzer Users often use cover all kinds of DBMS have beenpublished.

Howto configure ODBC DSN in Client to access remote DB2 for Windows

Howto configure ODBC DSN to access local DB2 for Windows

WhichSQL statement is the trump card to the senior software developer

Exepacker prevent DB Query Analyzer from beging debugged have been published.

16articles from The 1st tip of DB Query Analyze to The 16th skills of DB QueryAnalyzer have been published.

Thetable name must be enclosed in double quotation marks or sqare bracket whileaccessing EXCEL by DB Query Analyzer

Howto download the installation package by ZOL Downer

DBQuery Analyzer, the most excellent Universal database Access tools on anyMicrosoft Windows OS

Demonstrationof DB Query Analyzer 6.03 Installation and Running on Microsoft Windows 8

Howto easily create DB2 user function by DB Query Analyzer 6.03

 

 

 

DBQuery Analyzer 6.03 download URL: 

http://xiazai.zol.com.cn/detail/43/420901.shtml

http://www.unitedpowersoft.com/UpFile/DBQueryAnalyzer_English_603.rar

  

DB Query Analyzer Simplified Chinese version 6.03  downloadURL:

http://xiazai.zol.com.cn/detail/27/264455.shtml

 

 

  

 

Remarks :

Pleaseuninstall the former version first, then install the latest version.

 

 

 

My blog are  http://blog.csdn.net/magenfeng

http://blog.sina.com.cn/magenfeng

         http://user.qzone.qq.com/630414817

 

Interview with CSDN: http://www.csdn.net/article/2014-08-09/2821124