DB2的文档生成器 [英] documentation generator for DB2
问题描述
快速说明让大家知道我写的一个共享软件应用程序
名为SqlSpec，它将生成任何DB2 8.2（和
up）数据库的文档。
除了DB2之外，它还支持SQL Server，Oracle，MySQL，Sybase
ASE，PostgreSQL，Analysis Server和MS Access。这包含了当前市场上100％DBMS的几乎100美元。
这里有： http://www.elsasoft.org
此处有样品，包括一个样品DB2： http://www.elsasoft.org/samples.htm
谢谢，
Jesse
Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.
In addition to DB2, it also supports SQL Server, Oracle, MySQL, Sybase
ASE, PostgreSQL, Analysis Server, and MS Access. This encompasses
pretty much 100% of the DBMS on the market today.
It''s available here: http://www.elsasoft.org
There are samples here, including one for DB2: http://www.elsasoft.org/samples.htm
Thanks,
Jesse
推荐答案
4月3日，07：04，jezemine， < nos ... @ elsasoft.orgwrote：
On 3 Apr, 07:04, "jezemine" <nos...@elsasoft.orgwrote:
只是一个快速的说明，让大家都知道我写的共享软件应用程序
称为SqlSpec，它将为任何DB2 8.2（以及
up）数据库生成文档。
除DB2之外，它还支持SQL Server，Oracle，MySQL ，Sybase
ASE，PostgreSQL，分析服务器和MS Access。这包含了当前市场上100％DBMS的几乎100美元。
这里有： http://www.elsasoft.org
此处有样品，包括一个样品DB2： http://www.elsasoft.org/samples.htm
谢谢，
Jesse
Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.
In addition to DB2, it also supports SQL Server, Oracle, MySQL, Sybase
ASE, PostgreSQL, Analysis Server, and MS Access. This encompasses
pretty much 100% of the DBMS on the market today.
It''s available here:http://www.elsasoft.org
There are samples here, including one for DB2:http://www.elsasoft.org/samples.htm
Thanks,
Jesse
输出看起来不错，但我不知道如何使用
工具连接到DB2。
它要求OLEDB连接字符串（这是一种不寻常的方法
连接到DB2）并需要一些设置。是不是可以通过ODBC连接
？
你能给出一个关于什么样的OLEDB连接字符串的例子
它是'期待？
The output looks nice, but I don''t know how to connect to DB2 using
your tool.
It''s asking for an OLEDB connection string (which is an unusual method
of connecting to DB2) and requires some setup. Is it not possible to
connect via ODBC?
Can you give an example as to what kind of OLEDB connection string
it''s expecting?
4月3日，07：04，jezemine < nos ... @ elsasoft.orgwrote：
On 3 Apr, 07:04, "jezemine" <nos...@elsasoft.orgwrote:
只是一个快速的说明，让大家都知道我写的共享软件应用程序
称为SqlSpec，它将为任何DB2 8.2（以及
up）数据库生成文档。
除DB2之外，它还支持SQL Server，Oracle，MySQL ，Sybase
ASE，PostgreSQL，分析服务器和MS Access。这包含了当前市场上100％DBMS的几乎100美元。
这里有： http://www.elsasoft.org
此处有样品，包括一个样品DB2： http://www.elsasoft.org/samples.htm
谢谢，
Jesse
Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.
In addition to DB2, it also supports SQL Server, Oracle, MySQL, Sybase
ASE, PostgreSQL, Analysis Server, and MS Access. This encompasses
pretty much 100% of the DBMS on the market today.
It''s available here:http://www.elsasoft.org
There are samples here, including one for DB2:http://www.elsasoft.org/samples.htm
Thanks,
Jesse
好的，似乎OLEDB提供商全部设置好了对我来说，在DB2 9中。
我已经尝试过了
provider = IBMDADB2; DSN =< database> ;; UID =< username> ;; PW D = < password> ;;默认
架构=<架构> ;.
它已经到了获取表格。在我的Windows机器上的位和我的CPU已经在最后5分钟内以100％的最高价格获得了
。我不相信
默认模式位工作正常。我该怎么说？我之所以这么说是因为我在我的开发盒上有很多模式但是没有太多
我已经指出它的模式中的表到。
Ta，
J
Ok, It seems that the OLEDB provider is all set up for me in DB2 9.
I''ve tried it with
provider=IBMDADB2;DSN=<database>;UID=<username>;PW D=<password>;Default
Schema=<schema>.
It''s got to the "Fetch tables" bit and my CPU on my windows box has
been maxed out at 100% for the last 5 minutes. I''m not convinced that
the Default Schema bit is working. How can I tell? The reason why I
say that is that I have a lot of schemas on my dev box but not a lot
of tables in the schema that I''ve pointed it to.
Ta,
J
4月3日，13： 27，james _... @ hotmail.com写道：
On 3 Apr, 13:27, james_...@hotmail.com wrote:
4月3日，07：04，jezemine < nos ... @ elsasoft.orgwrote：
On 3 Apr, 07:04, "jezemine" <nos...@elsasoft.orgwrote:
只是一个简短的说明，让大家都知道我写的共享软件应用程序
称为SqlSpec，它将为任何DB2 8.2（和
up）数据库生成文档。
Just a quick note to let you all know about a shareware app I wrote
called SqlSpec that will generate documentation for any DB2 8.2 (and
up) database.
除了DB2之外，它还支持SQL Server，Oracle，MySQL，Sybase
ASE，PostgreSQL，Analysis Server和MS Access。这包括现在市场上几乎100％DBMS的
。
In addition to DB2, it also supports SQL Server, Oracle, MySQL, Sybase
ASE, PostgreSQL, Analysis Server, and MS Access. This encompasses
pretty much 100% of the DBMS on the market today.
这里有： http://www.elsasoft.org
这里有一些示例，包括一个用于DB2的示例： http://www.elsasoft.org/samples.htm
谢谢，
Jesse
Thanks,
Jesse
好的，似乎OLEDB提供程序都是在DB2 9中为我设置的。
我已尝试过
provider = IBMDADB2; DSN =< database> ;; UID =< username> ;; PW D =< password> ;;默认
Schema =< schema> ;.
它已经到了获取表格。在我的Windows机器上的位和我的CPU已经在最后5分钟内以100％的最高价格获得了
。我不相信
默认模式位工作正常。我该怎么说？我之所以这么说是因为我在我的开发盒上有很多模式但是没有太多
我已经指出它的模式中的表到。
Ta，
J
Ok, It seems that the OLEDB provider is all set up for me in DB2 9.
I''ve tried it with
provider=IBMDADB2;DSN=<database>;UID=<username>;PW D=<password>;Default
Schema=<schema>.
It''s got to the "Fetch tables" bit and my CPU on my windows box has
been maxed out at 100% for the last 5 minutes. I''m not convinced that
the Default Schema bit is working. How can I tell? The reason why I
say that is that I have a lot of schemas on my dev box but not a lot
of tables in the schema that I''ve pointed it to.
Ta,
J
好的，我喜欢你的工具除了事实上，我似乎无法选择特定架构这是一个主要缺点。
查看工具用于查询系统目录的
sql它不是
似乎是特定于模式的。这太可惜了。否则我会买的。
Ok, I like your tool apart from the fact that I don''t seem to be able
to select a specific schema which is a major drawback. Looking at the
sql which the tool is using to query the system catalog it doesn''t
seem to be schema specific. This is a pity. I''d buy it otherwise.
这篇关于DB2的文档生成器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
