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
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
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).
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.
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.