要查询用户的部门编号，使用以下语句。
In order to query the user's department number, use this statement.
可以根据表名或经过优化后的sql语句中的限定符(quantifier)编号识别表，sql语句显示在由db 2 exfmt工具生成的执行计划中。
You can identify a table by its name or by the quantifier number in the optimized SQL statement shown in the execution plan produced by the db2exfmt tool.
要查询本地变量hv_depnot的用户部门编号，使用以下语句。
In order to query the user's department number into host variable hv_depnot, use this statement.
下列示例显示使用一个SELECT语句和一个分级查询子句来返回Meier经理（雇员编号为 101）的所有直接下属。
The following example shows a SELECT statement with a hierarchical query clause to return all direct subordinates for the manager Meier (employee number 101).
RCTE和终止SELECT语句都返回了4 个列，分别是递归的层数、下属的雇员编号、直属经理的姓名以及直属经理的雇员编号。
The RCTE and the final SELECT statement both return four columns, representing the level and the employee number of the subordinate and his name and finally the employee number of the direct manager.
某个语句所引用的文件的文件名或编号无效。
A statement refers to a file name or number that is not valid.
某个语句所引用的文件的文件名或编号无效。
A statement refers to a file name or number that is not valid.
应用推荐