Best way to copy records from a member file into a physical file?
How do you copy the records in a member file into a physical file? I need to export the records in to the member data to an excel file for further manipulation...
Last Comment
ASKER
I figured out what I was doing wrong and was able to do the download into Excel via the data transfer add in.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hey, didn't mean any confusion with the question, I just needed an answer more quickly and your response came 3 days after I posted the question. I figured out what to do after day 1 and just forgot to close the question. But yes, your responses are correct to pull the data and yes I used the Excel method.
IBM System i
IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.
4K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
I'm not understanding your question for 100%.
What do you mean by Question by:
1. a member file
2. a physical file
In DB2-400 all Physicalfiles have members most of the time, only one member but it can be more then one.
so in my opinion there is no diference between a member file or a physical file.
Can you be more specific, or give an example?
Anyway,
You can use command CPYF or use SQL.
In case of using SQL, you can use CREATE ALIAS, to specify a particular member.