What is the difference between replacing a file and replacing a member in AS/400

15 pts.
Tags:
AS/400
AS/400 - CL Command
WRKQRY
What is the difference between replacing a file and replacing a member in AS/400? Option 2: Replace file Option 4: To replace the member I mean the difference between below options in WRKQRY?

Software/Hardware used:
AS/400 , i series

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    Replace a file will be needed if the columns selected are different than the previous extract. If the files are the same the effect of replacing a member or file is the same. On the AS/400 files can contain more than one member and replacing a member would only replace that subset of data. When Query/400 makes a file it only has one member so the effect is roughly the same.
    50,505 pointsBadges:
    report
  • TomLiotta
    A non-SQL database file can have many members. (SQL tables can have only one member.) Each member shares the same file definition. You can replace individual members of a file or add new members. . Each member has a name that lets you choose which one to read (or write). By default, a member name is the same as the file name. . If you replace a member, it must have the same field definitions as the replacing member. If you replace a file, the new file can have any changes you want to make. When you replace a file, all previous members are gone. . Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following