1)how to do date validation in rpg?
2)how to delete dUPLICATE RECORDS?
Answer Posted / madhusudhan
1. Date Validation you can do with TESTD
2. Duplicate Records. There are two ways to delete this
a. Through SQL, after selecting the RRN numbers, you can
use the delete statement in SQL to delete the unwanted
record based on the RRN
b. Through RPG, but if you use the SETLL and READE, all
the records along with the duplicates will get deleted , so
you need to use one variable for count, once it reaches 1 ,
stop doing the delete.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
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
1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
What is the difference between copybooks and subprocedures in as400?
How to select highest score of each subject or how to select highest income of every month?
How many program bind in one module....
what is an online rpg?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
how does the rpg element work?
what is the difference between do while and do until?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
how do I declare a table or array in rpg iv?
what was the robotech rpg?