SORT Statement
Posted: Tue Nov 03, 2009 3:35 pm
Hi All,
I am having Query Regarding SORT Statement. I am having a Sequential File (Dynamic in nature) i.e. Record Count Vary on daily Basis, say On 3rd/Nov/2009 Record Count = 5000, 4/Nov/2009 Record Count = 10000, 5/Nov/2009 Record Count = 50
I want to get Last 500 Records How To Achieve this?. For 5/Nov/2009 will I be Getting Error or On 50 Records will be Fetched.
Thanks
Kind Rgds
Vineet Anand
I am having Query Regarding SORT Statement. I am having a Sequential File (Dynamic in nature) i.e. Record Count Vary on daily Basis, say On 3rd/Nov/2009 Record Count = 5000, 4/Nov/2009 Record Count = 10000, 5/Nov/2009 Record Count = 50
I want to get Last 500 Records How To Achieve this?. For 5/Nov/2009 will I be Getting Error or On 50 Records will be Fetched.
Thanks
Kind Rgds
Vineet Anand