i want to perform uniqness on db file bt my db file nt
hving key by useing rpgle.
Answer Posted / ravi kumar
Create LF for PF and take UNIQUE keyword in file level and take one field as key field(Whenever UNIQUE keyword is used in LF, It will be compiled successfully if your PF doesn't have DUPLLICATE RECORDS orher wise it will not be compiled.)
After creating LF, You have to use LF in RPGLE. Then you can retrieve and insert records through RPGLE.
I have got success in this way...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
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
can you debug ile rpg program using isdb?
what is the difference between do while and do until?
how do you use commitment control in rpg?
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?
what is *place and *auto keyword in prtf ?plz explain
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
What is file identifier where we can use?
what is a rpg?
how do I declare a minor?
what is the rpg system?
How can we know running job is batch or interactive?
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg