i want code and what are used key words are ...like wrkmbrpdm screen
(q) i have a file with 3 fields empno,empname,empaddr...
here you give the empno it displays from that number to remaining empno's how?
sub file screen:
employee details
pos to:empno then enter
empno empname empaddr
so file have 100 records from 1 to 100 so the above pos you give the 55 empno...it displays the from 55 to remaining...
......
please share this answel
Answers were Sorted based on User's Feedback
Answer / raghav
This can be achieved by using File Information Data Structure. First extract the RRN of the required record and pass it to the SFLRCDNBR (Hidden Field).
This will take the cursor to the desired record on the subfile.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
After displaying the sub file, create one subroutine with setll and pass this field value to another local variable, DOW the subfile data, display each record in subfile.
Is This Answer Correct ? | 0 Yes | 0 No |
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
What is journalling and commitment control?
is this a rpg channel?
Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
What would be the effect on the field where reverse image, underline and high intensity?
suppose one file is used by 100 user and file is locked by 100 user, what are the impact analysis?
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?
Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?
what built in function can be used with SETLL.If you want to check whether the search argument is successful or not? Please give me answer with example?
what are the types of identifers
HOW TO DELETE THE RECORD FROM MASTER FILE WHICH IS LINK BY ANOTHER TRASATION FILE WITH REFERTIAL INTYGRITY?