Without RI or a really good data dictionary you are essentially out of luck for doing this completely automatically. You’ll need to get somebody to at least define the relationship to you — there are ways to deduce relationships based on table names / column names etc. but you can’t be guaranteed that your interpretation is 100% accurate. Once you’ve mapped out the relationships of the tables then generally the easiest way to solve the problem is to write a quicky program that moves the data for you. Depending on how nice you are, you can make the program smart enough to recognize general keys and then move it all together based on simple user input to the JCL (or ISPF panel, etc). Don’t forget the option to allow the requester to either REPLACE or RESUME (append) the test table data.