How do you know if a record exists without doing a READ and
CHAIN?
Answers were Sorted based on User's Feedback
Answer / avinash
by using file information data structure we can find the
number of records in a file.
Is This Answer Correct ? | 18 Yes | 0 No |
Answer / david lex
setll KeyA FileA;
if %equal( FileA );
...
endif;
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / rizwan
Without using Prg if you want to check the records of a Pf
through command line you can use
DSPFD (Display File Description)
which gives you the Total number of records as well as
deleted records in a PF.
Is This Answer Correct ? | 5 Yes | 1 No |
PGM PARM(&NBRRCD)
DCL &NBRRCD TYPE(*DEC) LEN(10 0)
RTVMBRD FILE(STR) MBR(*FIRST) +
NBRCURRCD(&NBRRCD)
ENDPGM
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sravs
We Can Done THis By using Setll with %found also..
Is This Answer Correct ? | 0 Yes | 5 No |
1.I have a Physical file with 100 records, No duplicates exists, all are Unique,But while i am running Runqry utility i am getting only 80 records..What could be the reason?
difference between CHAIN and READE?
what is overlay? how can we pass parameters in cl or rpg programing? how can we get data area value in cl or rpg programming?
What is the purpose of PUTOVR keyword?
How can we find out whether the job is interactive or Batch through RPG program? 2) How can we find out through CL program?
Hi friends, I am using a load all subfile , and currently i am in in the third page of the subfile , from third page i have selected a record and called some other program .on returning, subfile is being loaded from the frist page. so can any one kindly suggest me in retaining my third page after returning. i.e loading from third page.
When will DUMP & DEBUG be ignored?
WHERE DO WE USE COMIT KEYWORD IN AN RPG PROGRAM? YOU MADE SOME CHANGES TO DATABASE BUT YOU DON'T WANT TO SAVE THOSE CHANGES NOW? HOW DO YOU HANDLE THIS ONE?
What is the difference between inner join @ outer join
Can anybody tell me, does CL/400 handle LEVEL check while running the CL program....? plz share your experience...
1.Write code to read the records from a file and load an array of size 99? Make sure that you take care of all the error conditions?
Need a sql query: retrieve all duplicate records in table?