1)how to do date validation in rpg?
2)how to delete dUPLICATE RECORDS?
Answer Posted / raghav
1. TESTD
2. Delete from File1 F1 where RRN(f1) > (select MIN(RRN(F2)) from File1 F2 where F2.Field1 = F1.Field1)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is ment by record level identifier?
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 I touch the array during treatments?
What are the types of identifiers?
What is a record lock error?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
What is difference between bind by copy and bind by reference?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
When it is desirable to describe files Internally?
what is file information data structure?
how do I declare a table or array in rpg iv?
Explain mdt?
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?