We are on AS400 V5R4.
We are planning to do a data refresh. We use the JD Edwards EnterpriseOne software. I coudl try to do the refresh by running built in tools to kick off and run and perform the refresh for me. However, this process takes forever to run.
What I would like to do is have some AS400 scripts created to run and do the COPYLIB to refresh my LIBs and update a couple of tables for me.
The refresh will be copying our 3 Production LIBs (COPD7333, PD7333DNT and PD7333) to our 3 development LIBs (CODV7333, DV7333DNT and DV7333) and our 3 test LIBs (COPY7333, PY7333DNT and PY7333)
I would like to break up the program script into two. So one script to copy the production libs to development libs. And another script to copy production libs to test libs.
After the copy has been completed, I need to have two different tables up dated. Two sets of tables for both development lib and test lib.
The first table AFTER the copy that needs to be updated is: F983051 which is in the PY7333DNT lib for test and in the DV7333DNT lib for development. After the script copies the production lib (PD7333DNT) to PY7333DNT (test lib) that F983051 has a field that will show “PD7333” for production. Well, after the copy that field will need to be updated to reflect the test environment (PY7333). And after the copy from production to development lib (DV7333DNT) that table will need to be updated for development.
So two tables will need to be updated: F983051/PY7333DNT & F983051/DV7333DNT
WHERE VRENHV = ‘PD7333’
The other table is the F9861 table. Similar to the F983051 table, after each refresh, this table will need to be updated. ALL the records in this table that refrence: PD7333 in the SIPATHCD field I want those records created for: DV7333 (for development) and PY7333 (for test).
So, in the testing refresh script, there should FIRST be steps to SAVE the existing LIBs: COPY7333, PY7333DNT and PY7333
Then the refresh tasks to copy production LIBs to create or update the test LIBs above. Or however you recommend doing so on the AS400.
Then in that same testing script have commands to update the two tables mentioned.
And any other commands steps that should be included. Any data included to ensure data integrity?
Then I need to have another script setup the same way but for the “development” LIBs.
Does all that make sense?
Let me know if you need me to provide you with any other information.