Please help. How to create Detail table using Summary

[lenygold via DBMonster.com]

I have a following summary table:

DISP_ID CLAIM_TYPE ERROR_CODE FILE1_TOT FILE2_TOT
-------- ----------------------- ------------------------- -----------------
-- ---------------------
AA HUBC NOERR 379 410
AA HUBC 8018 118
127
AA HUBC 8019 226
235
AA HUBD 8022 15
22
............... ............... ............... ............... ............... ...
............... .
ER HUOP 9947 4
4
ER HUOP 51#L 5
5
............... ............... ............... ............... ............... ...
...............
UR HUBC NOERR 3066 3198
UR HUBC AAAA 144 144
UR HUBC BD01 12
17

I have to create(INSERT) 2 detail tables:

DISP_ID CLAIM_TYPE ERROR_CODE
AA HUBC 8018 <------ 379
ROWS IN TAB1, 410 IN TAB2
AA HUBC 8019 <------ 118
ROWS IN TAB1 , 127 IN TAB2
............... ............... ............... ............... ............... ...
............... ............... ............... .........
............... ............... ............... ............... ............... ...
............... ............... ............... .........
UR HUBC AAAA <------144 ROWS
IN TAB1, 144 IN TAB2
UR HUBC BD01 <------ 12
ROWS IN TAB1, 17 IN TAB2

Is this duable in one query or SP?
Need help. Thank's in advance.

--
Message posted via DBMonster.com

http://www.dbmonster.com/Uwe/Forums.aspx/ibm-db2/200803/1