One of the data sources in my project is DB2 tables in AS/400 system.
The data structure of the table is as follows:
Col A,Col B,Col C,Col D
1234,ab2f,pazz,"&Col E=ZZ&Col F= &Col G=5478&Col H=100.00
2345,cd3f,ddzz,"&Col F=IN&Col G=9801&Col H=250.25&Col J=20060630
The Problems in reading Col D are
1. The record starts with the Quote Character but doesn't end with it.
2. The '&' seperated columns are not following a uniform pattern i.e., it varies from record to record (some start with Col E and some with Col X etc).
3. This field contains around 300 '&' seperated columns in all possible combinations and we have 1 million records per monthly extract.
![Sad :(](./images/smilies/icon_sad.gif)
Is there anyway to read this data using the available stages in Datastage?
![Confused :?](./images/smilies/icon_confused.gif)
It would be of great help if this issue is resolved.
Thanks in advance...