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 |
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 file identifier where we can use?
What are the commands that can be executed in CLP but not in RPG? Why?
As400 Command to find the Name of the Program to which a Particular Module is Bound..? Ex: IC210AMR (*MODULE) is bound with Other Modules which Forms Program Object as IC210ABP(*PGM) . As400 Command to find the IC210ABP Using IC210AMR..? Thanks
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
How do you find whether a record is locked or not?
please guys help me,I need to write a program that shows more than one way to display a subfile. Both views are of the same file but sorted differently and show different fields of the same file when the user presses a function key. send me code
CAN WE READ RECORDS WITHOUT USING SETLL,READ,CHAIN IN RPG?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
what is estimation? and what is the level identifier parameter in PF?
3 members in a databasefile .how to read records from all the members?????????
2. Which of the following statement(s) explains the difference(s) between the /INCLUDE and ICOPY directives? a.) No difference, they function the same b.) ACOPY cannot be used as a conditional directive c.) IINCLUDE files cannot contain embedded SQL d.) Nesting /TNCLUDE directives is not allowed