In QMF in need to select a few records from the production environment based on a condition and insert the selected records into the test environment.
In QMF of the test environment i can select the records from the production table also.
But the resultant set is 500+ records . i need to use a query that will load these records into the test .
WHERE "EMP_SCL_SCUTY_NO" =+389722631
FOR FETCH ONLY WITH UR
I need to save the result of this query and add that resultant rows into the Test environment table
INSERT INTO DBJB.CORPQ003.XPPERP0V
VALUES (from the prev query ) .
Can you guys please suggest me
1) how to save the resultant of the first query into a temp table and load it into the test table.
2) i am looking for the specific SQL commands that i can use in the QMF.