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



How to update selected fields from pf without using update opcode. How to read all member in Rp..

Answer / vasu devareddy.g

we can update selected fields from pf using EXCEPT OPCODE

Is This Answer Correct ?    34 Yes 3 No

How to update selected fields from pf without using update opcode. How to read all member in Rp..

Answer / rahul

we can update selected fields of a pf using EXCEPT opcode

Is This Answer Correct ?    12 Yes 0 No

How to update selected fields from pf without using update opcode. How to read all member in Rp..

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

How to update selected fields from pf without using update opcode. How to read all member in Rp..

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

How to update selected fields from pf without using update opcode. How to read all member in Rp..

Answer / sekhar214

UPDATE RCDFMT %FIELDS(FIELD1:FIELD2)

Is This Answer Correct ?    9 Yes 0 No

How to update selected fields from pf without using update opcode. How to read all member in Rp..

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

How to update selected fields from pf without using update opcode. How to read all member in Rp..

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

How to update selected fields from pf without using update opcode. How to read all member in Rp..

Answer / sai reddy

Hi Siva,
what is the major Difference between RPG 3 and RPGLE in terms of coding...please reply me.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More RPG400 Interview Questions

Can AnyOne tell me how to read join logical file in rpg from starting to end?

2 Answers  


two types of read performed in dataqueue?????

4 Answers   CTS,


Q1.How to read the Array? Q2.How to copy the content of one Array to another Array?

4 Answers   IBM,


ESCAPE message sent by child program can be handled by parent program using which keyword?

2 Answers  


1.Can any body share me about thease opcodes with example please.Im new for AS/400.Could u please tell me in real senario? 1.TESTN, 2.EVAL 3.EVALR, TIME, 4.MONITOR 5. ENDMON 6.ON-ERROR 7.COMMIT ROLLBACK?

1 Answers   CSC,






Thanks gagan for your answer,i'm new to as400,i don't know embedded sql in rpg.can you send me the coding for the below mentioned question in embedded sql rpg. how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.

2 Answers   iGate,


what is *place and *auto keyword in prtf ?plz explain

0 Answers   CSC,


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?

8 Answers   HCL,


how can i retrieve the field name from display file at run time? Devendra Singh Tomar

3 Answers  


this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002

1 Answers  


How do you know if a record exists without doing a READ and CHAIN?

6 Answers   IBM,


I have learnt through Net that Debugging a Batch job involves 1. Submit the job with the HOLD (*YES) parameter: SBMJOB HOLD(*YES) or Hold the job queue that before submitting the job by using the HLDJOBQ command. 2. Determine the job name, user, and number of the submitted job by using the WRKSBMJOB command. 3. Type the Start Service Job command on your screen: STRSRVJOB JOB(job name/user/number) 4. Type the Start Debug command on your screen: STRDBG 5. Release the job in the jobq. Type WRKSBMJOB and then put a 6 beside the job to be released and press enter, or, if the job queue was put on hold, release the job queue with the RLSJOBQ command. 6. A display appears when the job is ready to start, saying that you can now begin debugging the job. Press F10 to show the Command Entry display. 7. Now you can start debugging by entering an Add Break Point command: ADDBKP 8.ENDDBG 9.ENDSRVJOB I tried this for RPG/400 Program and up to six steps of the above it's ok,but for me no source is displayed and i typed DSPMODSRC in Command line but still i can't see the sourceif i press F.10 and enter command ADDBKP i don't know how to add break points through it,usually i add break points using F.6 for Interactive job debugs,but since this is batch i don't know sir,Please help me out. I was asked this question in a interview,i know only RPG/400 and i’m asking for debugging of RPG/400 program only sir. or is it only possible to debug BATCH RPG ILE JOB and it is not possible to debug BATCH RPG/400 JOB kindly help me out sir

4 Answers   HSBC,


Categories