This query returns 12 records from the EMPLOYEE table.
该查询从employee表返回12条记录。
This query returns six records from the EMPLOYEE table.
该查询从employee表返回6条记录。
This query returns five records from the EMPLOYEE table.
该查询从employee表返回5条记录。
This query returns four records from the EMPLOYEE table.
该检索从employee表返回4条记录。
Go ahead and use the wizard to point to the EMPLOYEE table as shown in Figure 18.
继续操作并使用向导指向employee表,如图18所示。
Statistics are re-collected on the EMPLOYEE table and its new and remaining indexes.
在employee表和它的新的及剩余的索引上再次收集统计信息。
Here, select the columns from the Employee table to be exported to the select statement.
在此,从employee表中选择要导出到select语句的列。
Manager1 selects the data from the EMPLOYEE table and later tries to update the same data.
Manager 1从employee表中选择数据并稍后尝试更新这些数据。
The children of the EMPLOYEE element maps to the two columns in the EMPLOYEE table by name.
EMPLOYEE的子元素根据名称映射到 EMPLOYEE表的两列。
Same with the ADMRDEPT field, which is actually a link from the EMPLOYEE table back to itself.
ADMRDEPT字段的处理是相同的,该字段实际上是从employee表连接回其自身的一个链接。
A guideline to force the optimizer to choose the index oring operation to access the EMPLOYEE table.
另一个原则是迫使优化器选择索引“或”操作来访问employee表。
The following listing shows a GridBlox that displays rows from the EMPLOYEE table in DB2 sample database.
以下清单展示了一个GridBlox,它显示来自DB 2示例数据库中employee表的行。
Note, when you install the Sample database, the EMPLOYEE table is not automatically assigned a primary key.
注意,安装Sample数据库时,不会为employee表自动创建主键。
You must complete this pairing to import the data from the old EMPLOYEE table into the new EMPLOYEEPAYINFO table.
为了将数据从旧的employee表导入到新的employeepayinfo表中,必须完成这样的配对。
This class contains variables and their respective accessor methods with 1-1 mapping to the Employee table columns.
这个类包含一些变量及其相应的访问方法,这些变量与employee表中的列存在1对1的映射。
Figure 7 shows the Employee XAML application, which was generated using the IBM DB2 sample database Employee table.
图7显示EmployeeXAML应用程序,它是使用IBMDB 2sample数据库中的Employee表生成的。
Right now, you want to show the records from the EMPLOYEE table in a grid, so select the AdapterGrid and click on OK.
现在,需要在网格中显示employee表中的记录,因此选择adaptergrid并单击ok。
The WORKDEPT field of the EMPLOYEE table obviously pointed to the DEPARTMENT table, using the DEPTNO field to link to.
EMPLOYEE表的WORKDEPT字段显然指向DEPARTMENT 表,使用DEPTNO 字段可以链接到该表。
The second cicssdt command inputs the data into the employee table and the cicsadd command adds a file definition entry.
第二个cicssdt命令输入数据到员工表格中,同时cicsadd命令会添加一个文件定义入口。
Go ahead and populate the EMPLOYEE table with the rest of the rows shown in table 1 using insert syntax like that above.
按照表1给出的数据,继续使用和上面类似的insert语法填充employee表中剩下的行。
As all rows in the EMPLOYEE table are X-locked by the first transaction, the second application goes into lock wait mode.
由于employee表中的所有行都被第一个事务独占锁定,第二个应用程序进入了锁等待模式。
The following table is a sample employee table which has the address details of the employees with the following record.
下表是一个示例employee表,该表拥有员工的详细地址,包含以下记录。
Similarly, we do not see a row containing the DEPTID named TRA since no employee in the employee table had a DEPTID of TRA.
类似地,我们也没有看到包含名为TRA的DEPTID的行,因为在employee表中没有DEPTID为TRA的雇员。
Then it updates the employee name in the employee table using the identifier field, which is the primary key for this table.
最后使用field字段(该表的主键)更新employee表中的雇员名称。
Manager1 selects the data from the EMPLOYEE table and later tries to update the phone number of Christine Haas from 3978 to 1092.
Manager 1从employee表中选择数据并在稍后尝试将ChristineHaas的电话号码3978更新为1092。
The next example shows how you can retrieve the value for the aggregate function max for the salary column from the EMPLOYEE table
下面这个例子展示了如何为一个聚合函数max从EMPLOYEE 表中检索salary的值
This false negative scenario would not have the UPDATE cause a fail if a row change timestamp column was added to the EMPLOYEE table.
如果向EMPLOYEE表添加行修改时间戳列,则漏判场景中的UPDATE不会发生失败。
The RENAME command is used to create the shadow table, the data is reloaded into the EMPLOYEE table using the load FROM CURSOR command.
RENAME命令用于创建影子表,而数据是通过LOADFROM CURSOR命令重新装载到employee表中的。
You can also optionally change the name of beans variable names (which by default are set to be the same as the columns of the Employee table).
还可以更改bean变量的名称(默认情况下,bean变量的名称与Employee表列的名称相同)。
To better illustrate the improvement in cardinality estimation, drop all the existing indexes on the EMPLOYEE table except the primary key index.
为了更好地解释说明基数估计值的提高,撤销除主键索引外的所有employee表上的现有索引。
应用推荐