Interested to Buy Any Domain ? << Click Here >> for more details...
1)how to do date validation in rpg?
2)how to delete dUPLICATE RECORDS?
- 12 Answers
- 33176 Views
- IBM, Opus, I also Faced
- E-Mail Answers
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
What is a record lock error?
what is file information data structure?
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
how do I declare a minor?
What is ment by record level identifier?
how does the rpg element work?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
how do I declare a table or array in rpg iv?
what is the necessary keyword needed to scroll subfile records?
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.
what is the difference between do while and do until?
How to write record if no field or the field are different in physical file in rpgle ?
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 diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
