临时程序表t PT ?
在应用程序会话定义已创建的临时表之后,并发运行的会话不需要重新定义它。
After an application session defines a created temporary table, concurrently running sessions do not have to redefine it.
应用程序将继续消费越来越多的用户临时表空间。
The application will keep on consuming more and more user temporary table space.
碎片整理程序不能在已分区分区、备份服务器、或者临时表上运行。
The defragmenter may not be run on the partition partition, secondary server, or a temporary table.
这些改进对于使用大型业务智能化(BI)应用程序和数据仓库的组织尤其有意义,因为它们依赖于索引和临时表。
These enhancements will be of particular interest to organizations with large business intelligence (BI) applications and data warehouses, which depend on indexes and temporary tables.
这里有必要提到现在支持在声明的全局临时表中包含xml列,因为这可以帮助程序员提高应用程序的运行时性能。
New support for including XML columns in declared global temporary tables deserves brief mention, because it can help programmers to improve the runtime performance of their applications.
为应用程序堆、语句堆、缓冲池和临时表空间这些区域中的本地处理调优联邦系统。
Tune the federated system for local processing in the areas of application heap, statement heap, buffer pool, sort heap, and temp tablespace.
例如,客户机应用程序可以使用SQL和结果集逻辑把VSAM或IMS数据读取到全局或声明的临时表中,然后处理它们。
For instance VSAM or IMS data can be retrieved into a global or declared temporary table and subsequently processed by client applications using SQL and result set logic.
如果在应用程序代码中的多个位置实例化相同的临时表,该表的定义可以集中在一个地方。
If the same temporary table may be instantiated from multiple locations in application code, the definition of the table is centralized at one place.
过程开发人员不必为了得到临时表的DDL而找遍应用程序代码(可能是由其他人来维护的)。
The procedure developer does not have to hunt through application code (which may be maintained by another person) to find the DDL of the temporary table.
虽然临时表总是用于SQL过程中,但也能被任何可连接db2的应用程序创建。
Although temporary tables are most often used in SQL procedures, they can also be created by any application which can establish a connection to DB2.
应用程序编程改进:临时表和版本控制。
Application programming improvements: Temporal tables and versioning.
应用程序编程改进:临时表和版本控制。
Application programming improvements: Temporal tables and versioning.
应用推荐