View previous topic :: View next topic
|
Author |
Message |
maheshurstd
New User
Joined: 16 Feb 2006 Posts: 14
|
|
|
|
Hi
My requirement is that i have some records in a VSAM file, i want to read only the last record & i don't have record key values.
would it be possible for to read the last record.if any one has the code please send it or tell me a way to do it.
How to read the last record in case of DB2
Thanks in advance
Regards
Mahesh |
|
Back to top |
|
|
rdr
New User
Joined: 26 May 2006 Posts: 35 Location: india
|
|
|
|
Hi,
(For VSAM)
Sort the file in decending order.
Now read the file you are actually reading the last record.....
Regards,
Rohit. |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
Hi,
In DB2 you can give the query as follows
Select * from table order by <field name> DEC fetch 1 row only; |
|
Back to top |
|
|
rajandhla
Active User
Joined: 18 Oct 2005 Posts: 182 Location: Luton UK
|
|
|
|
If you can use DFSsort , there is ENDREC option is available which you can use to get the last record......
Regards
jai |
|
Back to top |
|
|
maheshurstd
New User
Joined: 16 Feb 2006 Posts: 14
|
|
|
|
Hi Aji,
would it be possible to use the read file previos record syntax in cobol,
I need the logic by using the cobol program,please give me the syntax
Thanks
Mahesh |
|
Back to top |
|
|
mmwife
Super Moderator
Joined: 30 May 2003 Posts: 1592
|
|
|
|
Hi Mahesh,
You can only use that technique in a pgm that uses CICS.
Another way is to use FileAid in a prev step to get the last rec in a VSAM file and use COBOL in the next step to read it. Will that work for you? |
|
Back to top |
|
|
|