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 .
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 in Baidu.com.
By April 17st, 2013, you’ll get 1.04 million results if you search 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.
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.
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.
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.
Figure4 Set ‘Text’ style by select ‘Query’-à’Display’-à’Text’ item
Figure5 Selectthe ‘Text’ in the dropdown list toolbutton ‘Display’
You can get the result after you execute SQLstatement.
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’.
Figure7 Locate key words ‘4405’ in ‘Result area’
Click find you can locate ‘4405’ in other place.
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
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