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


Please Help Members By Posting Answers For Below Questions

How would display prime numbers using CL program?

5666


What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?

2504


what is data area and how it is used in rpg program ?

741


how can I tell when to replace the array?

686


1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.

5375






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.

2175


What are the types of identifiers?

554


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

1950


what is the rpg system?

656


What is file identifier where we can use?

629


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?

600


What is difference between bind by copy and bind by reference?

1712


We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?

748


how do I declare a table or array in rpg iv?

720


what is the procedure and explain about real time scenario.

1461