Verify connections and set up sample tables and stored procedures.
检验连接并建立示例表和存储过程。
The IBM DB2 sample database includes a number of sample Tables, Views, and stored procedures.
IBMDB 2SAMPLE数据库包含许多示例表、视图和存储过程。
Creating database objects for managing XML data, including a test database, sample tables, and views.
创建用于管理XML数据的数据库对象,包括一个测试数据库、样例表和视图。
Since neither is based on the sample tables, the quality factor should only be taken as a very rough comparison measure.
质量系数只能作为一个粗糙的标准来比较图片。
Or, if you want to build a diagram with sample objects (similar to sample tables in a logical data model) you could use named objects.
如果你的图中有一个示范的对象(类似于数据模型中的数据表例子),你也可以用一个有名字的对象。
One study was set in a gourmet food store in an upscale community where, on weekends, the owners commonly set up sample tables of new items.
其中一个研究是在一个高级社区的美食店进行的,每个周末,店主都会摆出一款新菜式的样品。
To help you get up to speed quickly on these features, this article described how to create a test database and sample tables for storing XML documents.
为了帮助您快速掌握这些特性,本文描述了如何创建一个测试数据库和样例表来存储XML文档。
Start by creating a physical data model with a SAMPLE database, creating a SAMP schema, and creating some tables and columns.
首先创建一个物理数据模型,模型中包括一个SAMPLE数据库、一个SAMP模式和一些表和列。
The user needs to have rights to create, modify, and delete tables in the SAMPLE database.
该用户需要在SAMPLE数据库中创建、修改和删除数据表的权利。
Next create a sample database and populate it with some tables.
接下来,创建一个样例数据库,并在其中创建以下的表。
In our sample application, however, you need to reverse the complexity because you are displaying dynamic tables.
然而,在我们的示例应用程序中,由于您要显示动态表,因此需要逆转复杂性。
When the SAMPLE database is initially created, statistics are not collected on the tables.
SAMPLE在创建最初,还没有在表上收集统计信息。
The following code gives an example based in the sample database tables.
以下代码给出了一个针对示例数据库表的例子。
For the sample query in this article, Figure 12 shows the index report, which describes the existing indexes of the referenced tables.
对于本文的查询样例,图12显示了索引报告,它描述了引用表的现有索引。
In most cases, a simple database might help but should have all the tables and sample data to support a business transaction being tested.
在大多数情况下,一个简单的数据库就可以帮助解决问题,但其中应该包括支持所要测试的业务事务的所有表格和示例数据。
The sample code to read from a schema and get its tables is shown in Listing 1.
清单1显示了用于读取一个模式并获取它的表的示例代码。
Wine-lovers can gather round wooden tasting tables, or sit in low winged armchairs to sample a glass or two.
红酒爱好者可以聚集在木制的品酒桌旁,或坐在低靠背的座椅上,慢慢品上两杯。
Since the tables are relatively large, the sample is built on 1% of the data to reduce the performance cost.
由于这些表相对比较大,这个例子构建于1%的数据以减少性能的损失。
Now, let's define some sample data and tables so that we can look at concrete query examples.
现在,让我们来定义一些示例数据和表,以查看具体的查询示例。
Since you have connected to a V9.1 sample database, you should be able to see all the tables, columns, tablespaces, and other database objects that are of importance.
因为已经连接了一个V9.1示例数据库,所以应该能够看到所有表、列、表空间和其他重要的数据库对象。
The reason for this is that the other tables in the DB2 UDB SAMPLE database have no primary key, and hence no index information to associate a unique ECO key with.
原因是DB2UDBSAMPLE数据库中的其他表没有主键,因此没有索引信息可以关联惟一的ECO 键。
Besides other tables, the SAMPLE database contains a table named SALES.
除了其他表之外,SAMPLE数据库包含一个名为SALES的表。
Sample 3 contains a more complex XML input as well as db2 outputs (three tables).
示例3包含一个更复杂的XML输入和db 2输出(3个表)。
Once you can connect to the IBM DB2 UDB SAMPLE database, you can use the data Explorer to open up the tables, views, or procedures node.
一旦连接到IBMDB 2UDBSAMPLE数据库,就可以使用DataExplorer打开表、视图或过程节点。
The table, which is named EMP, is based on the underlying tables EMPLOYEE and DEPARTMENT in the SAMPLE database.
这个表名为EMP,它基于SAMPLE数据库中的底层表employee和DEPARTMENT。
Now, create our tables by importing the DDL from the catabase.ddl file found in the download code sample.
现在,从下载的代码样本里找到的catabase .ddl文件,并执行它来创建我们的表格。
Run sample delete statements to reproduce the bad application logic that deleted all rows in two tables.
运行示例delete语句,模拟删除两个表中所有行的错误的应用程序逻辑。
The rest of this article focuses on creating the sample schema for Bigdog's Surf Shop — which consists of these two tables — in a Derby database.
这篇文章其余的部分将侧重于在Derby数据库中创建Bigdog ' sSurfShop的示例模式——模式中包含这两个表。
The sample template shown in the following tables can be used to calculate cost savings for some common processes and projects.
在下列列表中显示的范例模板,可以用于为共同的过程和项目计算节省的成本。
At the end of the paper, we provide some sample canned queries that will help users to filter the information needed out of these tables.
在本文的结尾,我们提供了一些固定的示例查询,将有助于用户从这些表中筛选出所需信息。
应用推荐