The problem is that EMPNO is included in the SELECT-list.
问题是EMPNO已经包含在SELECT列表中。
Enter 000110 for the empNo value and select the Invoke button.
输入000110作为empno值,并选择Invoke按钮。
The updateEmployee page is to be passed a parameter named empno.
页面updateemployee被传递给一个名为empno的参数。
Select the SOAP bindings, and specify a value for the empno parameter.
选择SOAP绑定,并为empno参数指定一个值。
The EMPNO field only contains numerics and Unicode support is not needed.
empno字段仅仅包含数字,且不需要Unicode支持。
And we also started by creating an index on the EMPNO and DEPTNO columns.
我们还从创建关于EMPNO和deptno列的索引开始。
And, if DB2 USES the index the traditional way, the data will come back in EMPNO order.
如果DB 2以传统方式使用索引,数据将以EMPNO顺序返回。
But with EMPNO listed in the WHERE clause, DB2 will dutifully retrieve that column, too.
但在where子句中列出了EMPNO,DB 2还会尽职地检索该列。
Note: The select statement specified in this example has a parameter marker called: empno.
注意:这个例子中指定的select语句有一个名为:empno的参数占位符。
Create a parameter named empno, and assign it the value of the employee's empno for the selected row.
创建一个名为empno的参数,然后将其赋予员工的empno值,为选中的行。
Remember how you specified the EMPNO field to be the key field (in the DataGrid configuration dialog).
记得您是如何将EMPNO字段指定为关键字段的(在DataGrid配置对话框中)。
If an error message appears stating that a primary key is not defined, select empno as the primary key.
如果出现一条出错信息,声称没有定义一个主关键字,那么您可以选择empno作为主关键字。
You already know that EMPNO will be equal to the value '000010' because that is what the WHERE clause tells DB2 to do.
您已经知道了empno将等于值“000010”,因为那就是where子句要DB 2做的事。
Here DB2 can match on only one column, and since LASTNAME is random, DB2 must do a data sort to bring our rows back in LASTNAME, EMPNO order.
这里DB 2仅可在一列上匹配,并且因为LASTNAME是随机的,DB 2必须执行数据排序来以LASTNAME、EMPNO顺序返回我们的行。
Columns in the existing indexes: If an index already exists on EMPNO or DEPTNO, it might not be wise to create another index on the combination.
现有索引中的列:如果在EMPNO或DEPTNO上已经有了一个索引,那么创建另一个关于该组合的索引也许并不明智。
Select each of the controls listed in the following table and update the Label and Alert messages as shown in the table: Select input [EMPNO:] and click Delete.
选择下表列出的所有控件,并且更新表中所示的标签和警告消息:选择input [empno:],然后单击Delete。
And DEPTNO should be listed second, allowing DB2 to do a direct index lookup on the first column (EMPNO) and then a scan on the second (DEPTNO) for the greater-than.
然后列出DEPTNO,从而允许DB 2对第一列(EMPNO)执行直接索引查找,然后针对大于号扫描第二列(DEPTNO)。
Furthermore, if indexes already exist for both columns (one for EMPNO and one for DEPTNO), DB2 can use them both to satisfy this query so creating another index might not be necessary.
而且,如果已经存在关于这两列的索引(一个关于EMPNO,一个关于DEPTNO),DB 2可以使用它们来满足该查询,因此创建另一个索引也许是没有必要的。
Furthermore, if indexes already exist for both columns (one for EMPNO and one for DEPTNO), DB2 can use them both to satisfy this query so creating another index might not be necessary.
而且,如果已经存在关于这两列的索引(一个关于EMPNO,一个关于DEPTNO),DB 2可以使用它们来满足该查询,因此创建另一个索引也许是没有必要的。
应用推荐