If the remote tables have restrictions on the data such as check constraints, you can convey these restrictions to the federated server using informational check constraints.
如果远程表在数据上有检查约束,那么可以使用信息检查约束将这些约束传递到联邦服务器。
We recommend to put these audit tables in a separate table space and to archive those data regularly using general database methods.
我们建议把这些审计表放在单独的表空间中,定期使用一般的数据库方法存档这些数据。
Using these folders you can launch the appropriate wizard to create new tables and views.
通过这些文件夹,您可以启动合适的向导来创建新的表和视图。
Now that you have seen the features of rule groups, rule sets, and decision tables, let's look at a scenario that you can implement using these concepts.
既然您已经看到了规则组、规则集和决策表的特性,让我们研究一个可以使用这些概念来实现的场景。
In addition to these tables, we are using a view (Figure 5), allowing us to simplify database access for getting a complete service definition.
除了这些表,我们使用一个视图(图5)简化了获取一个完整服务定义的数据库访问。
There are no indexes on these tables for DB2 to consider using during the execution of the query.
这些表上没有在执行查询期间DB 2可用的索引。
Notice that we have "create Tables" selected, if you are using a database which was created as indicated in a previous section in this document, leave these checkbox unchecked.
请注意,我们选择了“CreateTables”,如果您使用的是按照本文档的前面所述的方法创建的数据库,请将这些复选框设置为未选中状态。
Now you have a grasp of basic database concepts, including schemas, tables, and columns, and you've seen demonstrations of these concepts using a fictitious business named Bigdog's Surf Shop.
目前您已经掌握了基本的数据库概念,包括模式、表和列,还看到了使用名为Bigdog ' sSurf Shop的虚拟公司对这些概念的演示。
The masking in this case is using one of the simpler functions within Optim (substring), but the entire set of masking functionality is available for these files just as it is with relational tables.
在这个例子中的屏蔽使用Optim内部的一个简单函数(substring),但是仅当这些文件带有关系表时才可以使用完整的屏蔽功能。
Deploy these tables into the sample database using the DDL shown in Listing 1 on the local DB2 server, and load some sample data, as shown in figures 2.1 and 2.2.
使用清单1中的DDL,将这些表部署到本地DB 2服务器上的示例数据库中,并装载一些示例数据,如图2.1和2.2所示。
The disk and network Numbers shown in these tables were measured at the network Appliance Filer, using the sysstat command.
在这些表中显示的硬盘和网络资源的使用数据都是在Net workApplianceFiler中使用sysstat命令测量的。
If you're not using one of these development environments you can edit the schema and map files created by the EJBDeploy tool (top-down mapping) to match your existing database tables.
如果您没有使用这些开发环境中的一个,您可以编辑由EJBDeploy工具(自顶向下映射)创建的模式文件和映射文件来匹配您现有的数据库表。
You can clone objects such as tables, views, stored procedures, and functions using the Clone Definition context menu that is available on these nodes in the Server Explorer tree.
您可以在ServerExplorer树中使用节点中的CloneDefinition上下文菜单克隆表、视图、存储过程、函数等对象。
Once I created these tables, I thought it would be a good idea to run some simulations against the setup using plain SQL statements. First thing I do is.
一旦我创建这些表,我认为这将是一个好主意对设置运行一些模拟使用纯s QL语句。我做的第一件事是。
Putting these concepts together, you learned how to create and drop tables by using Derby, and you used the Derby dblook tool to dump the schema contents of a database.
把这些概念融合在一起,您学习了如何用Derby创建和删除表,还使用Derby的dblook工具输出了数据库的模式内容。
Table and use an AS clause to name these columns for the display with the ij tool. Because the query joins these two tables (by using an implicit inner join), you can select columns from both tables.
因为查询(通过使用隐式内连接)将两个表连接,您可以从两个表中选择列。
Based on calculation results of all 25 lists, the author continues to draw data tables, histograms and data curves, and conducts comparison and analysis by using these charts.
再根据整个清单的数据统计结果,列数据表,画柱状图和数据点折线图,并根据图表进行比较和分析。
Based on calculation results of all 25 lists, the author continues to draw data tables, histograms and data curves, and conducts comparison and analysis by using these charts.
再根据整个清单的数据统计结果,列数据表,画柱状图和数据点折线图,并根据图表进行比较和分析。
应用推荐