6,893 pts.
 Member to get updated
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:
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 ..... :)
Last Wiki Answer Submitted:  May 3, 2012  2:00 pm  by  CharlieBrowne   32,835 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,835 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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 pts.

 

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?

 32,835 pts.

 

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,370 pts.