A group-level link defines a master-detail relationship between two data sets.
The following figure shows two data sets with a group-level link defined. Next to the data sets the resulting XML data structure is shown.
An example is shown below.
|Data Set: DEPT||Data Set: EMP|
Select DEPT.DEPTNO as DEPTID, DEPT.DNAME as DNAME, DEPT.LOC as LOC from OE.DEPT DEPT
Select EMP.EMPNO as EMPNO, EMP.ENAME as ENAME, EMP.JOB as JOB, EMP.MGR as MGR, EMP.HIREDATE as HIREDATE, EMP.SAL as SAL, EMP.COMM as COMM, EMP.DEPTNO as DEPTNO from OE.EMP EMP where DEPTNO=:DEPTID
You must define a unique bind variable in the child query.