Listing 1 shows an example of two connection handles, one connecting to an Informix server and the other connecting to a DB2 server, and how a table is created in both Informix and DB2 databases.
清单1展示一个包含两个连接句柄的示例,其中一个连接到Informix服务器,另一个连接到DB 2服务器,并展示如何在Informix和DB 2数据库中创建表格。
Informix provides access to external data sources through the virtual table interface (VTI).
Informix通过虚拟表接口(VTI)提供对外部数据源的访问。
The actual schema of the table (Listing 1) used in the Informix port of this agent includes how much virtual memory is allocated and used.
该代理的Informix端口中使用的表的实际模式(清单1)包括分配和使用多少虚拟内存。
Let's use the sales demo database tables provided with Informix as an example table. You can create this demo database by running the script dbaccessdemo_ud in the sqldist bin directory.
我们以Informix所附带的销售演示数据库表作为示例表,可通过运行sqldistbin目录中的dbaccessdemo_ud脚本来创建此演示数据库。
Read data from the Informix SYSCHUNKS system table and include mirror chunks according to this criteria.
从InformixSYSCHUNKS系统表中读数据,并根据以下标准包括镜像块。
After successfully converting from Informix 11.50.xc7 to 11.70.xc1, you can use the following command to create a table with list fragmentation.
成功地由Informix 11.50 .xC 7升级到11.70 .xC1之后,您可以使用以下命令,创建一个有存储残片清单的表格。
In this case, a table scan is very expensive, because the Informix engine has to access data randomly.
该例中,表扫描极其昂贵,因为Informix引擎必须随机地访问数据。
The optimizer in Informix Extended Parallel Server (XPS) could use more than one index on each table in a query, and now Informix 11.7 can as well.
InformixExtendedParallelServer (XPS)中的优化器可以在一个查询中使用每个表上的多个索引,现在Informix 11.7也可以。
If a specific feature you're looking for is not listed in the table, you can assume (for the most part) that it exists in all Informix editions.
如果您正在寻找的特定功能没有在该表中列出,则您可以假设(对于一般情况)其存在于所有Informix版本中。
Actually, a table scan of an in-memory table is much faster than searching the same table through an index, especially with the Informix light scan mechanism.
实际上,对内存中的表进行表扫描要比通过索引搜索同一表快得多,尤其是在使用 Informix轻型扫描机制时。
"Informix".mqipubsub table: Before using the publish and subscribe services, you have to setup this table.
“informix ”. mqipubsub表:在使用发布和订阅服务之前,必须建立这个表。
When creating a foreign key, Informix automatically creates a B-Tree index on the child table when creating a foreign key.
创建一个外键时,Informix自动地在子表上创建一个B-Tree索引。
Next, contestants needed to add appropriate indexes to each table, so that Informix would not scan the whole table to find the row it needed to update.
接下来,参赛者需要向每个表添加合适的索引,以便Informix无需扫描整个表即可找到它需要更新的行。
The following table is designed to make it easier for you to determine the unique characteristics of each Informix edition.
下表被设计用于使您更容易地确定每一个Informix版本的独特特性。
The publisher name and subscriber names have to be defined in the "informix".mqipubsub table.
发布者的名称和订阅者的名称必须在“informix ”. mqipubsub表中定义。
The table "informix".mqipolicy stores 37 attributes for each policy.
表 "informix".mqipolicy 存储每种策略的37 个属性。
Add users that need access to the 'informix'.sysauth table in the sysuser database.
添加需要访问sysuser数据库中‘informix’。sysauth表的用户。
We'll replicate the employees table of the "db1" database in an update-anywhere fashion between server1 and server2. (The following steps assume the informix account is used.)
我们将使用 update-anywhere 方式在服务器 1和服务器 2之间复制 “db1”数据库的employees表(以下步骤假设使用了informix帐户)。
The table "informix".mqiservice stores the mappings.
表“informix ” .mqiservice存储这种映射。
Table 1. MySQL and Informix data size limits
表1.MySQL和Informix数据大小限制
Table 2 describes the editions available in DB 9 and Informix IDS 10.
表2描述了DB9和InformixIDS 10中可用的版本。
Table 2 describes the editions available in DB 9 and Informix IDS 10.
表2描述了DB9和InformixIDS 10中可用的版本。
应用推荐