suppose i i am changing / updating record of subfile and i
want to change the record in reverse order . means i want to
change the bottom record first and so on through readc . how i
do it please any one explain .
Answers were Sorted based on User's Feedback
Answer / maheshg
better to have multi occurance of DS load all the record
which is read through READC and read DS in reverse oreder
for changing / updating.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / baggy
That is possible by using embedded sql to fetch the data
using CURSORS to subfile and group by ASCEND or DESCEND
| Is This Answer Correct ? | 1 Yes | 1 No |
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
What are the necessary keywords required to code a message subfile?
can anybody help me that what is the procedure of debugging the service program?
ESCAPE message sent by child program can be handled by parent program using which keyword?
Assume my file has 100 records and I want to see only first 10 records. Is this possible through lf?
How to read data from Nth member of a physical file containing some X number of members in it? "Provided member names are unknown"
Are all these RPG/400 Interviewed Questions being asked recently? are current?
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.
Difference between RESET and CLEAR
Can we used ovrdbf command after the opnqry file if yes then What will be out put of your program?
Suppose we add one field in physical file and this physical file is used by several programs.how do we know which program is using that file? What are the impact analysis.
What you have to do in the display file when you are using message subfile?