Breaking Column Data Using File Layouts

Hi DBA's,

I need to break up a 34 byte column into several columns. Here is my problem.

Table A:

Col1..Col2..Col3..Col4..Col5..Col6..Col7..Col8..Co l9..Col10

Col 9 is char (2) and Col10 is char (34). It is this column that needs to be broken up into several columns depending on the value in Col 9.

Col1 to Col3 is the key to the record.

So say if record 1 has Col 9 value 'AA' then Col10 ( 34 bytes) is to be spilt into 10+10+10+4 (four columns).The value 'AA' can repeat for several records and the value in Col 10 can change for the same value 'AA'.

Now say record 27 has Col 9 value 'BB' then Col 10 is to be split as 5+25+4 (3 columns).

There are 15 such unique values of Col 9. I have the file layouts for Col 10 for each distinct value of Col 9. So using the file layouts and Table A which exists in my database how do I proceed.

Need I make 15 tables ( one each for the 15 unique Col 9 values). These structure
Col1..Col2..Col3...Col9 (the key fields and Col 9) will be common to every table. Plus the file layouts will serve as additional columns specific to each of these tables.

Kindly help.

Vivek