Simple query with Select-all and Search condition

******************* Query ****************************

Query:<SELECT * FROM emp WHERE empno = 2>

********************* Parsed Query **********************

SELECT ( -1.*),

FROM emp (-1),

WHERE ( ( -1.empno) = ( 2) )

********************* Validated Query **********************

SELECT ( 0.empno), ( 0.ename), ( 0.job), ( 0.hiredate), ( 0.sal), ( 0.comm), ( 0.deptno),

FROM SCHEMA.OAUSER.emp (0)( 0.empno, 0.ename, 0.job, 0.hiredate, 0.sal, 0.comm, 0.deptno, ::0.empno, ),

WHERE ( ( 0.empno) = ( 2) )

******************* End Validated Query ********************

********************* Query Result Specification **********************

Result Column:0 – Name:empno, XoType=4, Nullable=0, Precision = 10, Scale=0

Result Column:1 – Name:ename, XoType=12, Nullable=1, Precision = 32, Scale=0

Result Column:2 – Name:job, XoType=12, Nullable=1, Precision = 32, Scale=0

Result Column:3 – Name:hiredate, XoType=11, Nullable=1, Precision = 19, Scale=0

Result Column:4 – Name:sal, XoType=8, Nullable=1, Precision = 15, Scale=0

Result Column:5 – Name:comm, XoType=7, Nullable=1, Precision = 7, Scale=0

Result Column:6 – Name:deptno, XoType=4, Nullable=1, Precision = 10, Scale=0

********** Execution Plan for SIMPLE STMT *************

SELECT ( 0.empno), ( 0.ename), ( 0.job), ( 0.hiredate), ( 0.sal), ( 0.comm), ( 0.deptno),

FROM SCHEMA.OAUSER.emp (0)( 0.empno, 0.ename, 0.job, 0.hiredate, 0.sal, 0.comm, 0.deptno, ::0.empno, ),

WHERE ( ( 0.empno) = ( 2) )

************** Sub Query:1 **************

Search List:

( 0.empno) = ( 2)

***************** End of Plan ******************

********** IP is being called to execute SubQuery on Table:<emp> with Search Column:<empno>. hstmt:<0x6be880>