The awk is giving below output:
SELECT
divrel.child_org_idn org_main_idn
NULL ( VARCHAR(200)) div_nam_2
NULL ( VARCHAR(200)) div_nam_3
NULL ( VARCHAR(200)) div_nam_4
NULL ( VARCHAR(200)) div_nam_5
NULL ( VARCHAR(200)) div_nam_6
NULL ( VARCHAR(200)) div_nam_7
1(DECIMAL(120)) LEVEL
FROM $FDS_REP.org_main_rel_a divrel
JOIN $FDS_REP.org_main_d childdiv
ON childdiv.org_main_idn = divrel.child_org_idn
WHERE divrel.parnt_org_idn = -99999
AND childdiv.src_idn = 116
AND divrel.rel_desc = 'DIVISION HIERARCHY'
UNION ALL
SELECT
divrel.child_org_idn
CASE WHEN LEVEL+1 = 2 THEN childdiv.org_nam ELSE divrec.div_nam_2 END div_nam_2
CASE WHEN LEVEL+1 = 3 THEN childdiv.org_nam ELSE divrec.div_nam_3 END div_nam_3
CASE WHEN LEVEL+1 = 4 THEN childdiv.org_nam ELSE divrec.div_nam_4 END div_nam_4
CASE WHEN LEVEL+1 = 5 THEN childdiv.org_nam ELSE divrec.div_nam_5 END div_nam_5
CASE WHEN LEVEL+1 = 6 THEN childdiv.org_nam ELSE divrec.div_nam_6 END div_nam_6
CASE WHEN LEVEL+1 = 7 THEN childdiv.org_nam ELSE divrec.div_nam_7 END div_nam_7
divrec.LEVEL+1
FROM $FDS_REP.org_main_rel_a divrel
JOIN $FDS_REP.org_main_d childdiv
ON childdiv.org_main_idn = divrel.child_org_idn
JOIN divrec
ON divrel.parnt_org_idn = divrec.org_main_idn
WHERE
childdiv.src_idn = 116
AND divrel.rel_desc = 'DIVISION HIERARCHY'
)
SELECT *
FROM divrec,
My requirement is this entire query should go into a single cell of the excel sheet but its going as different rows of eexcel as the new line is taken as new row. Please suggest...
04-17-2009
