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

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

Join the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

CL Question

3 posters

Go down

QUESTION - CL Question Empty CL Question

Post  muthuraman 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

Back to top Go down

QUESTION - CL Question Empty Re: CL Question

Post  JLAVANYA 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

Back to top Go down

QUESTION - CL Question Empty Re: CL Question

Post  muthuraman 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

Back to top Go down

QUESTION - CL Question Empty To fetch the last record

Post  Vanithadevi 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 : 39
Location : Chennai

Back to top Go down

QUESTION - CL Question Empty Re: CL Question

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