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 |
1.The questions have given an array declaration and move operation then this statement is correct or not?
What is the significance of UDATE?
if there is pf in two libraries and there is a logical file based on the PF, how to find the pf on which the pf is based.
Please help me, I have created window subfile,I have created Footer with same lengh and postion of window SFL. When I call the pgm, first is shows only Footer and then it shows subfile records.This time Footer is not showsing ..plz hel me how can i do it...? Sameple DDS and RPG: A R WIN1 SFL A*%%TS SD 20090130 165346 MUNSHIJ REL-V4R2M0 5769- PW1 A FLD001 1Y 0B 4 3EDTCDE (Z) A ATFILE R O 4 7REFFLD (QWHFDBAS/ATFILE LIB/LIBF- A ILE) A R WINCTL SFLCTL (WIN1) A*%%TS SD 20090202 123459 MUNSHIJ REL-V4R2M0 5769- PW1 A ALTNAME ('y') A SFLSIZ (0004) A SFLPAG (0004) A WINDOW (FOOTER) A ROLLUP (27) A ROLLDOWN (28) A CF12 (12 'Cancel') A 50 SFLDSP A N51 SFLDSPCTL A 51 SFLCLR A 1 2'Select Option,Press enter' A 2 3'1= Select' A R FOOTER A* A WINDOW(8 31 9 43) A 8 4'F12 = Cancel' A R DUMMY ASSUME A 24 10' ' in RPG: Dow *IN12 = *Off Write Footer Fxfmt WInCTL
How Chain operation copies the record's data to the input buffer for the program?
Can we possible to key with the date field?
How do you find out whether a record is present in the physical file without reading the file? for Example Employee No: 100 in an Employee master.How do we find out whther 100 is present in Employee master without reading the file?
11 Answers Bank Of America, CSC, IBM,
What is Multi Occurrence Data Structure(MODS)?
Can a indexed file be accessed in arrival sequence in RPG?
1.WHAT IS WRONG WITH THE CODE BELOW? C CUSTNO CHAIN CUSTMAST IF %ERROR can any body find the wrong please? 2.What builtin function will you use to achieve the following functionality? C QTY IFLT *ZERO C QTY MULT-1 QTY ENDIF
difference between CHAIN and READE?
How to search particular records from the database file in rpg?