1.How to load Records of a Physical file(PF) in the reverse
order, in CL program?
Answers were Sorted based on User's Feedback
Answer / anil kumar.anumulasetty
I THIS EXAMPLE I M USING EMPFILE READING IN REVERS ORDER
PGM
DCLF FILE(EMPFILE)
OVRDBF FILE(EMPFILE) SHARE(*YES)
OPNQRYF FILE(EMPFILE) KEYFLD(EMPNO *DESCEND)
READF: RCVF RCDFMT(MPILR)
MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END))
GOTO READF
END:
ENDPGM
| Is This Answer Correct ? | 19 Yes | 0 No |
i have 6 char field in program, but this field is using in all files i want to chage field size as 10 char , how can i do this except using *like defn...?
can i use UPDDTA command in rpg program in which contains a file
What is the difference between ITER and DO ? I know both are used to execute set of statements repeatedly, but what is the main difference?
In ProgramB there is a SBMJOB, which is a call to program C .There is also a CALL to program D from B. How would you check the program C has been executed in D?
1.Suppose my file has 10 fields and I want to make the 2nd field Zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation? 2. Assume my file has 100 records and I want to see only first 10 records. Is this possible through LF? 3.I have 3 jobs A B and C. I want to submit B after successful completion of A and want to submit C after successful completion of B. Without using job scheduler or job queue, how can i do that through CL program? 4.What is difference between Bind by copy and bind by reference?
what is estimation? and what is the level identifier parameter in PF?
You have a *USE authority on a Library and *All authority on a file in that Library.Can you change the data in that file?
how do u find whether a record is locked or not??
Maximum how many files declare in rpgle
which program rpg or cl is efficent to update a transaction onto a database file and why ?
Anybody know the difference of primary file and full procedural file
3 members in a databasefile .how to read records from all the members?????????