Extract data from adabas files so it cab be used in SQL server

Hi trying to extract Data from adabas files to flat files any ideas I know I can write to work file .But I need to extract the Data so it can be used in SQL Server just a bit just a bit rusty here …

Mary

Mary

What are you trying to achieve? Please describe it in detail.

Do you get any error messages? Please provide a full error message screenshot and log file.

Have you installed all the latest fixes for the products and systems you are using?

The standard way is to create a file with the Parent fields (scalar) plus the ISN.

Then create a file for each of the MU’s and PE’s with ISN and occurrence number (CHILD tables).

1 Like

When you say file you mean work file ?

Yes, you would write out each parent/child “table” to a separate work file as record (fixed columns) or csv file. As Gene says, parent unique identifier is its ISN and the child unique identifier is the ISN plus the MU/PE index.