Avatar of Anthony
AnthonyFlag for United States of America asked on

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...
IBM System i

Avatar of undefined
Last Comment

8/22/2022 - Mon
Theo Kouwenhoven

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.

I figured out what I was doing wrong and was able to do the download into Excel via the data transfer add in.
Theo Kouwenhoven

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck