
Sorry, as a rule we don’t post code. We don’t do your lessons or your work. We help and guide
What you want to do can be done with an OPNQRYF followed by a CPYFRMQRYF to create the physical file
Open Query
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Fcpyfrmqryf.htm
Copy from query file
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Fcpyfrmqryf.htm
This is one of many ways to solve this problem including:
CPYF
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Fcpyfrmqryf.htm
Sql SCRIPT
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Fcl%2Fcpyfrmqryf.htm
You put together some code, if you have questions post your code and the question.
Phil

Ok i found the Mistakes i have done…















