How to update selected fields from pf without using update
opcode.
How to read all member in Rpg-3,without using any cl command?
Answers were Sorted based on User's Feedback
Answer / vasu devareddy.g
we can update selected fields from pf using EXCEPT OPCODE
Is This Answer Correct ? | 34 Yes | 3 No |
Answer / rahul
we can update selected fields of a pf using EXCEPT opcode
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / gurjit oberoi
without using cl command we can read members in RPG using
EXTMBR in F spec like
EXTMBR(member_name)
Is This Answer Correct ? | 15 Yes | 4 No |
Answer / sivakumar y
Hello Friends, Question asked by vinit is how to read all
members in RPG3, but not in RPGLE.
I think the answer for this question is:
1)Need to declare the rquired file in USROPN mode in RPG.
FFILE1 UF E K DISK Usropn
2)Using QCMDEXC API execute the override command. The
value to be passed in first parameter is like below.
D Cmd1 C OVRDBF FILE(FILE1)
TOFILE(TOOLBOX/FILE1) MBR(*ALL)'
Regards
siva
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / kamlesh
create new LF which is based on multi memeber PF
This LF has only one data member which is based on
all data members present in PF. Now use this LF
in yr RPG3.
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / daithuan
1.Why not use embedded SQL?
2.Why read all members, surely if you want to update the pf file base on a certain condition then every record that matches that condition will be updated.
Hope that helps!!!
Is This Answer Correct ? | 3 Yes | 2 No |
I have two sessions S1 & S2 under this 3 jobs(say j1,j2,j3 under session S1) And 2 jobs(Say j4, j5 Under session S2)is running. How many QTEMP & how many LDA will create for the same.
Can we trigger an rpg program which has user interaction with display file when updating a file using the command ADDPFTRG?
how can we find setll setgt chain read reade readp operations are successfull or not,give example.explain in detail.
Can anybody tell me in which scenario we have to use SQLRPG .(Embeded SQL)....?
how we retrieve records without using key field (ex:name) from Physical File through RPG in as/400?
how to check on which PF , the LF is dependant ?
1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?
I have to change a program. This program is calling a subroutine mor than 100times within it. so will it have any performance issue? if yes than what changes i can make. Thanx for ur valuable answer.
what is meant by record lock.how records are locked.what is the purpose of record lock.if records are locked what happens.how to find out which record is locked.
Why we need to give File and To file Names While we are using OVRDBF. What is your understanding related to this?
in rpg could u please tell me errors types and meanings like 3030 that ....
How to read a record from file where there is multiple record occurrence is available?