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 |
what is program status data structure?
1.How can you search an entire source file for a particular field name? 2.How can you find the differences between two versions of the source for the same program? 3.What is a hidden field as it relates to a sub file? 4.How do you display a sub file that has no records in the sub file?
1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?
what is kids-rpg?
HOW TO DEBUG A BATCH JOB WHEN IT IS IN MESSAGEWAIT(MSWG) STATUS.I KNOW THE STEPS FOR BATCH DEBUGGING,BUT IM CONFUSING WITH WHEN WE SUBMIT ANY JOB FOR BATCH DEBUG WE PUT IN HELD STATE.SO HERE ALSO DO SAME THING OR ANY OTHER WAY,PLEASE HELP ME....
Hi friends, Can you give the solution for the below mention simple code.and explain.what is output D CHR1 S 4A INZ('PEN') D CHR2 S 10A INZ('MYGET') D CHR3 S 8A INZ('GOOD') D CHR4 S 22A INZ C MOVEL CHR1 CHR4 C MOVE CHR2 CHR4 C EVAL CHR4=CHR3 C MOVE CHR1 CHR4
how can you display specific subfile page on the screen in unequal subfile?
i 'm new to as/400.in an interview i was asked this question.give a practical example for passing information or data through local data area. I know only that data area is an object used to store tiny bits of data or it can store one value at a time and it is used to store frequently changing values or datas.thats all i know about data area can any one tell me how local data area and user defined data area are used to pass data between jobs with a example or coding.thanks in advance.
How do you call procedures in ILE?
what is the necessary command needed before OPNQRYF and why?
1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?
How I can reread the physical file in CL program once the end of file reached in same CL program.