Can we found a record existance in a file w/o reading the file?
Answers were Sorted based on User's Feedback
Answer / ravikumar
1.With the help of CHAIN or READ opcodes we can find out record existence.
2.we can find out with the help of FILE INFORMATION DATA STRUCTURE..
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / nkumar
Yes without reading a file we can check the existence of records in a file. There are 3 ways.
1) Type DSPFD and define the file and press enter. Go to las and see the total no of records.
2) Using the file information data structure.
3) Using the RTVMBRD using in the CL program and check teh NBRCURRCD filed value. this will have the total no of records.
| Is This Answer Correct ? | 3 Yes | 5 No |
Write the subfile logic program for the given concept. Load the data to the subfile depends upon the designation where designation is not a key field?
How to update only a field of a PF in an RPG program. I don't want to update the record, only one field.
Anybody can explain the difference between SFLCLR & SFLINZ?
I am Submitting one job in batch that job calls three progams(PGMA, PGMB, PGMC). PGMB should be called after sucessfully completion of PGMA as like for PGMC also. So Can you please tell me how can we do that (without using data area)
Suppose we have 10 records with same name and we are reading using READE,after 4 record i have to use CHAIN what is the output
What is file identifier where we can use?
difference betwen keywords and opcodes
Difference between creating a report using Printer file and WRKQRY(Query Report) ?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
Hi, Can anybody give me real sinario for SFLRCDNBR?with example?
I have a Physical File name 'File1', which is present in two libraries named 'LIB1' & 'LIB2'. These 2 libraries are listed in the library list. Would like to access data from this file from these two libraries using RPG program. How to do this, any idea?
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