Interested to Buy Any Domain ? << Click Here >> for more details...
1)In a pf if we delete a record then how to insert a new
record at the same place in that pf?? any logic or code?
2)A batch job is taking a lot of time to run,found that it
is going into loop and wrapping up so how to skip that loop
and process the job without changing the code?
3)In which scenario C D I R comes and C D G F comes in a
job?
4)If a job came to error while processing a file how we can
know at which record the error hit and how to skip that
record and process other records without changing program
code?
- 1 Answers
- 5518 Views
- JDA, I also Faced
- E-Mail Answers
Answer Posted / sreenadh
1.post deletion of existing record you have to call QCMDEXC api to run a cl command i.e, RGZPFM then insert the record again
2.you have to fail the looping condition manually in batch debug mode using EVAL then came out from debug
4.Take opt 5 after WRKACTJOB againts the job than opt 14 (work with opened files)+f11 to get RRN value where it stuck currently and whats the file name too
Now go to sql fix the junk data and retry the job again
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
how to read database records without locking them?
How to reverse the string in rpg
what does the ovrdbf command do?
Pose, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular name field. How can we do the above using search criteria other than using the if cond?
what opcode could be used to test an alphanumeric field for all numeric values?
In 'o' Specs What Is The Opcode For Write?
in conjunction with which statements can orxx and andxx conditions be used ?
when do you use f-spec. Continuation line ?
What is a query can be displayed without saving it?
what is the difference between normal upddta to pf and updating using dfu program?
how to pick up the changed records every time in a subfile after the first change made ?
how to write code for singlepage in sqlrpgle with update ?
difference between view and index ?
what is procedure prototype and procedure interface.
