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 |
Can AnyOne tell me how to read join logical file in rpg from starting to end?
two types of read performed in dataqueue?????
Q1.How to read the Array? Q2.How to copy the content of one Array to another Array?
ESCAPE message sent by child program can be handled by parent program using which keyword?
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?
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.
what is *place and *auto keyword in prtf ?plz explain
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?
how can i retrieve the field name from display file at run time? Devendra Singh Tomar
this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002
How do you know if a record exists without doing a READ and CHAIN?
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