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...
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Theo KouwenhovenApplication ConsultantCommented:
Hello Anthony,

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?

You can use command CPYF or use SQL.
In case of using SQL, you can use CREATE ALIAS, to specify a particular member.
Anthony6890Author Commented:
I figured out what I was doing wrong and was able to do the download into Excel via the data transfer add in.
Theo KouwenhovenApplication ConsultantCommented:
Ask the right question and we give you the right answer.
- copy records from a member file into a physical file
Use the OS2 CPYF command.

- Copy Records from a member file into Excel,
use the PC-program R2PCB.EXE program
Or use ODBC to directly download into Excel

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Anthony6890Author Commented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
IBM System i

From novice to tech pro — start learning today.