The 5th tip of DB Query Analyzer

时间:2021-03-24 13:04:00

The 5th tip of DB Query Analyzer
             Ma Genfeng  
 (Guangdong UnitollServices incorporated, Guangzhou510300)

Abstract   In DB Query Analyzer, it's very convenientto search key word in SQL edit/ Result area.          

Key words   DB Query Analyzer

1      Brief introduction of DB QueryAnalzyer 

DB Query Analyzer ispresented by Master Gen feng, Ma from Chinese Mainland. It has English versionnamed ‘DB Query Analyzer’ and Simplified Chinese version named The 5th tip of DB Query Analyzer .

DB QueryAnalyzer is one of the few excellent Client Tools in the world for its’powerful function, friendly interface, easy operation and applicability toevery 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 ODBCdriver information, execute multiple SQL scripts or stored proceduressimultaneously, and more.

 

Achievement of DB Query Analyzer

In the Newproducts & Tools reviews of programmer second issue of 2007, DB QueryAnalyzer had been strongly recommended.

Now theSimplified Chinese version of DB Query Analyzer is the top 50 databaseapplication software in the famous software websitehttp://xiazai.zol.com.cn/download_order/sub_550.html . In most case it lies thetop 20 and it has been download more than 95,000 times.

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

By April17st, 2013, you’ll get 3.18 million results if you search The 5th tip of DB Query Analyzerin Baidu.com.

By April 17st, 2013, you’ll get 1.04 million results if you search The 5th tip of DB Query Analyzer inBaidu.com and you’ll get 0.16 million results if you search ‘DB Query Analyzer’in Baidu.com

By April17st, 2013, you’ll get 1.04 million results if you search  ingoogle.com and you’ll get 0.44 million results if you search ‘DB QueryAnalyzer’ in Baidu.com

Master Gen feng Ma, the developer of DB QueryAnalyzer, hopes he can cooperate with some software company such as Sybase,Embarcadero, Microsoft and so on. He thinks it will be the better way that DBQuery Analyzer is assembled in the develop tools according to such softwarecompany so that more and more database application software developer willbenefit from its powerful function, friendly interface, easy operation andapplicability to every production of RDBMS.

2       Preface

In DB QueryAnalyzer, it‘s very convenient to search key word in SQL edit/ Result area.

I will show you anexample.

OS:  Windows 2000 Server

Databasesystem : DB2

Clienttool : DB Query Analyzer 5.04.

3      Execute SQL after connected to DB2  

Run DB Query Analyzer 5.04first, then click ‘File’ menu to choose ‘Connect’ to open the loggingwindow. Select ODBC Data Source ‘unitoll2’, then input user name and password.

Afterwards, execute SQL statementin SQL edit frame.

This is shown inFigure 1.

The 5th tip of DB Query Analyzer

Figure 1   Execute SQL after connected to ODBC DataSource ‘unitoll2’

4    Search key words in SQL edit frame

Left click theSQL edit frame so that SQL edit frame will get focus. Then press ‘Ctrl+F’ orselect the item ‘Edit’--à‘Search’ orpress the toolbutton ‘Search’. Afterwards, a search box can be found, input‘SELECT’ as key words and click find button to locate the key words in SQL editframe.

This is shown in Figure2.

The 5th tip of DB Query Analyzer

Figure 2   Get the date type field value in MS SQLServer

Click find youcan locate key words in other place. This is shown in Figure 3.

The 5th tip of DB Query Analyzer

Figure 3   Get the date type field value in Sybase

5    Search key words in Result area

If you want to locate key words inResult area, you should set ‘Text’ style by select ‘Query’-à’Display’-à’Text’ item as it’s shown in figure4, or select the ‘Text’ in the dropdown list toolbutton ‘Display’ as it’ s shown in figure 5.

The 5th tip of DB Query Analyzer

Figure4   Set ‘Text’ style by select ‘Query’-à’Display’-à’Text’ item

The 5th tip of DB Query Analyzer

Figure5   Selectthe ‘Text’ in the dropdown list toolbutton ‘Display’

You can get the result after you execute SQLstatement.

The 5th tip of DB Query Analyzer

Figure6   Get the result after you execute SQL

Left click the ‘Result area’ so that it will get focus.Then press ‘Ctrl+F’, a search box can be found, input ‘4405’ as key words and click find button tolocate the key words in the ‘Result area’.

The 5th tip of DB Query Analyzer

Figure7   Locate key words ‘4405’ in ‘Result area’

Click find you can locate ‘4405’ in other place.

The 5th tip of DB Query Analyzer

Figure 8   Continueto locate key words‘4405’ in ‘Resultarea’

 

6    63technical articles about DB Query Analyzer have been published or beenpublishing in computer journal,  BaiduLibrary, the CSDN resource or my four blog-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 inComputer Programming Skill & Maintenance 22th 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 strongly recommendedIn the New products & Tools reviews of programmer 2nd issue of 2007.

The following 57 articles have beenpublished or been publishing in Baidu Library, the CSDN resource or my fourblog-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.

13articles from The 1st tip of DB Query Analyze to The 13th 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

 

The 5th tip of DB Query Analyzer

DBQuery Analyzer 5.04 download URL:

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

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

DB Query Analyzer Simplified Chinese version 5.04  downloadURL:

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

Remarks :

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

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

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

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