PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

How to get the record based on key

Go down

How to get the record based on key

Post  rajkumar400 on Mon Dec 27, 2010 12:12 pm

Is there any way to get the record from file using key ( RPG CHAIN )?

Thanks.
Raj

rajkumar400

Posts : 59
Join date : 2010-12-25

View user profile

Back to top Go down

Re: How to get the record based on key

Post  Janani Ravikumar on Thu Dec 30, 2010 6:02 pm

I think we cannot get the records in CL by key as we do in RPG (chain)





Regards,
Janani.

Janani Ravikumar

Posts : 7
Join date : 2010-07-19

View user profile

Back to top Go down

Re: How to get the record based on key

Post  soundhar on Fri Dec 31, 2010 10:32 am

i m not sure abt it,just try with ovrdbf

soundhar

Posts : 67
Join date : 2010-07-14
Location : Vridhachalam/chennai

View user profile

Back to top Go down

Re: How to get the record based on key

Post  soundhar on Tue Jan 11, 2011 2:03 pm

WE CAN DO IT USING OVRDBF COMMAND POSITION PARAMETER

soundhar

Posts : 67
Join date : 2010-07-14
Location : Vridhachalam/chennai

View user profile

Back to top Go down

Re: How to get the record based on key

Post  razuk_r on Tue Jan 11, 2011 7:19 pm

Yes, POSITION will work. But if it is not found it will go to next equivalent record. So we need to conditionally process. Please let me know if Im wrong.

razuk_r

Posts : 65
Join date : 2009-07-31
Location : Chennai

View user profile

Back to top Go down

Re: How to get the record based on key

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum