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
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
what is the difference between do while and do until?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
what is an online rpg?
what is program status data structure?
How to declare the pull button in AS/400..
When it is desirable to describe files Internally?
how do you use commitment control in rpg?
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 copybooks and subprocedures in as400?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
how do I declare a table or array in rpg iv?
what is file information data structure?
are there any useful c runtime apis that I can call from rpg iv?
What is the purpose of record level identifier?