用例5：采用使用动态sql和外部表的存储过程。
Case 5: Having stored procedure using dynamic SQL and external tables.
例如，需要在创建访问一组表的存储过程之前，先创建这组表。
An example would be the need to first create the set of tables before creating the stored procedure that access them.
这意味着，即使是在用户访问表的同时，也可以改变表的存储位置。
This means that even while users are accessing a table, you can change where the table storage resides.
您在DSNDB07创建的表空间将用作处理SQL联接和排序以及临时表的存储。
Table Spaces that you create in DSNDB07 will be used as storage for processing SQL joins and sorts as well as for temporary tables.
数据库分区技术为大表的存储管理提供了较优的解决方案。
Partition technique provides a good solution to the storage management of large tables in RDBMS.
表中的每个行都存储一组相关数据，并且存储在行中的数据被称为记录。
Each row in the table stores a set of related data and the data stored in a row is called a record.
由于关系数据和索引存储在表空间内不同的存储对象中，因此它们具有不同的读和写计数器。
Since relational data and indexes are stored in separate storage objects within a table space, they have separate read and write counters.
元素和属性表存储xml文档的结构容器。
The elements and attributes tables store the structural containers of the XML document.
DB 2V9.5引入了XML数据的基础表行存储。
数据库模式包含单个表，用于存储Friend的信息。
The database schema consists of a single table to store the Friend's information. It has three columns
图6显示了运行数据库创建脚本后的事件存储表。
Figure 6 shows the event store table after running the database creation scripts.
完成了通过存储过程声明临时表的封装。
It completes the encapsulation of the temporary table declaration through stored procedures.
存储数据的表名称为CellLocation。
The name of the table this data is stored in is CellLocation.
tcb表存储每个活动TCP连接的控制值。
The TCB table stores the control values for each active TCP connection.
我们在本例中使用的属性存储在属性表中。
The properties that we use in this example are stored in the property sheet.
基本上，DB 2处理与表空间关联的所有存储管理任务——完全联机并且不需要人工干预。
Basically, DB2 handles all of the storage management tasks associated with the table space - completely online and without the need for manual intervention.
为此，我们可以从xml_contents表中存储的市场营销信息XML文档中提取出数据。
For this purpose we can extract data from our Marketing Info XML documents stored in the XML_CONTENTS table.
然后，当手动更新RUNSTATS配置文件时，就可以查看该表中所存储的建议。
The recommendations stored in this table can then be reviewed and refined when manually updating the RUNSTATS profile.
我们在单独的MySQL表中存储索引，从而在这些实体中索引数据。
We index data in these entities by storing indexes in separate MySQL tables.
该系统一方面能完全代替人工到现场抄表的工作，另一方面，还能对数据进行存储、计算、分析。
The system can not only relieve artificial meter reading on site but also store, compute and analyze the data.
数据库被分割成一个或多个被称作是表空间的逻辑存储单元。
A database is divided into one or more logical storage units called table Spaces.
索引视图与聚集表具有相同的存储结构。
Indexed views have the same storage structure as clustered tables.
您应当创建一个或多个USER临时表空间来存储临时表的数据。
You should create one or more USER temporary table spaces for storing data of temporary tables.
这些目录表用于存储本文讨论的表选项、数据文件和外部列。
These catalog tables are needed to store the table options, data files, and external columns discussed in this article.
存储过程使用的表的ddl。
在分区数据库环境中，数据库管理器必须有方法知道表的哪些行存储在哪个数据库分区上，以便发现它需要的数据。
In a partitioned database environment, the database manager must have a way of knowing which table rows are stored on which database partition, so that it can find the data it needs.
创建“现有表”时，首先会创建一个代理表，然后检索和存储远程表中的元数据，并将该元数据放入到这个代理表中。
Creating an "existing table" creates a proxy table, then retrieves and stores metadata from a remote table and places the metadata into the proxy table.
有一个名为ph _ threshold的sysadmin表，它用来存储调度器任务的阈值。
There is a sysadmin table called ph_threshold that is used to store thresholds for the scheduler tasks.
每个产品的图像url需要存储在单独的图像表中。
The image URLs for each product need to be stored in a separate image table.
SAPHCM模块在表中存储代表Infotype 的主数据。
The SAP HCM module stores master data in tables that represent Infotypes.
应用推荐