How to fetch chunks of data in Teradata

Database
Fan

How to fetch chunks of data in Teradata

Hi,

I have a very urgent requirement.

There are some millions of records in one of my Teradata tables.Now I need to process these records by fetching 10000 records at a time.
For example- say in the first pass I pick up 10000 records and put them in a flat file,process it. Then in second pass pick next 10000 records put in a flat files process it and so on until all my records in the table gets processed.

Any solution to this problem would be really helpful.

Thanks,
Ashish.
1 REPLY
Enthusiast

Re: How to fetch chunks of data in Teradata

I would suggest to fetch the rows by using analytical function
i.e Row_Number()

Select *
From
(select Row_number() OVER(Order by day_of_calendar) val, day_of_calendar, calendar_date from sys_calendar.calendar) x
Where val between 1 and 20

=======

Select *
From
(select Row_number() OVER(Order by day_of_calendar) val, day_of_calendar, calendar_date from sys_calendar.calendar) x
Where val between 21 and 40