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

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

CL Question

View previous topic View next topic Go down

CL Question

Post  muthuraman on Thu Oct 08, 2009 8:49 pm

How do you fetch last record in CL?

Warm Regards,
Muthuraman.

muthuraman

Posts : 42
Join date : 2009-08-28

View user profile

Back to top Go down

Re: CL Question

Post  JLAVANYA on Thu Oct 08, 2009 10:06 pm

We can do SETLL with *HIVAL and We can use READP.
It will read the last record in the file.




Regards,
Lavanya.J

JLAVANYA

Posts : 6
Join date : 2009-07-30

View user profile

Back to top Go down

Re: CL Question

Post  muthuraman on Fri Oct 09, 2009 4:42 pm

Hi Lavanya,

My questions is How do you fetch last record in CL? not in Rpg?

muthuraman

Posts : 42
Join date : 2009-08-28

View user profile

Back to top Go down

To fetch the last record

Post  Vanithadevi on Fri Oct 09, 2009 8:02 pm

POSITION parameter in OVRDBF command is used to position the record.It specifies the starting position for retrieving records from the database file. To get the last record in the file we have to specify (*END) in the POSITION parameter. RCVF command will reads the record from the file.



Regards,
Vanitha.

Vanithadevi

Posts : 14
Join date : 2009-07-29
Age : 32
Location : Chennai

View user profile

Back to top Go down

Re: CL Question

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