没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
试读
15页
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 separator character between SQL statements.
资源推荐
资源详情
资源评论
How to create DB2 user function easily by DB
Query Analyzer 6.03
Ma Genfeng
(Guangdong Unitoll Services incorporated, Guangzhou 510300)
Abstract The latest version of DB Query Analyzer 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 Windows 10, Windows 8,
Windows 7, Windows Vista, Windows 2003, Windows XP,
Windows 2000, 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 separator character between SQL
statements.
Key words DB Query Analyzer
1 Brief introduction of DB Query Analzyer
DB Query Analyzer is presented by Master Genfeng, Ma from
Chinese Mainland. It has English version named ‘DB Query
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
1
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 Windows 10, Windows 8, Windows 7, Windows
Vista, Windows 2003, Windows XP, Windows 2000, 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 had been 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 more
than 110,000 times.
77 technical articles about DB Query Analyzer have been
published or been publishing in computer journal, BAIDU Library,
the CSDN resource or my four blog-website.
2 Preface
In this essay I will demonstrate how to create DB2 user
function easily by DB Query Analyzer 6.03, 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 separator
character between SQL statements.
OS : Windows 8.1
Database system : DB2
Client tool : DB Query Analyzer 6.03.
2
3 How to download the installation packages of DB
Query Analyzer from ZOL
Recently, Zhongguancun Online distributed the ZOL Downer for
users to download the resources from ZOL. In this case, users can
just download the ZOL downer with the code of resources, not the
installation packages.
But if someone want to install the PC which is isolated from
the INTERNET, he or she will no longer do that.
So how do the users download the installation packages? Please
see the eassy bellow
How to download the installation package by ZOL Downer
http://blog.csdn.net/magenfeng/article/details/38750901
4 Log in DB2 database
3
剩余14页未读,继续阅读
资源评论
- rseyeadkj8412015-10-26安装了,等一会重启看看有没解决
magenfeng
- 粉丝: 471
- 资源: 132
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功