Member to get updated

7,943 pts.
Tags:
AS/400
Hi, we all know that we can add upto 32767 members in a single PF. But i need to do the below one.... I have 10 members in a PF. I need to update the 10th members record. How can this be done through a CL.?. please help me out in this by giving a detail explanation.      

Software/Hardware used:
AS400 Software
ASKED: May 3, 2012  9:41 AM
UPDATED: May 4, 2012  5:25 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Do you have the member name?
Is thie update with an RPG program, CL program, SQL or some other way?
What have you tried?
What is the business case for this?

ya i have sample PF1, PF1A(member1), PF1B(member2)
For each i updated each member with some 10 records and i need to update a particular record from member PF1B and this should be done through CL. Kindly help me out.

I got some idea that we should do it through OPNQRYF and OVRDBF. But i am not much into it. Kindly help me out…. Thanks in advance ….. :)

Discuss This Question: 3  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
  • Its400
    ya i have sample PF1, PF1A(member1), PF1B(member2) For each i updated each member with some 10 records and i need to update a particular record from member PF1B and this should be done through CL. Kindly help me out. I got some idea that we should do it through OPNQRYF and OVRDBF. But i am not much into it. Kindly help me out.... Thanks in advance ..... :)
    30 pointsBadges:
    report
  • CharlieBrowne
    How will you update it with CL? You will need to call some other process to do an update since there is no CL instruction to allow you to do an update. What is the application you are running that requires this type of process?
    39,815 pointsBadges:
    report
  • deepu9321
    You can use OVRDBF for overriding PF with 10th Member. And, After that you must call a another program which holds the update process. Pradeep.
    3,605 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