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

View previous topic View next topic 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

View previous topic View next topic Back to top


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