How to fetch chunks of data in Teradata. Urgent!!!!

Tools
N/A

How to fetch chunks of data in Teradata. Urgent!!!!

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

Re: How to fetch chunks of data in Teradata. Urgent!!!!

Hi ,

Is there any easy way to load data present in Excel on to Teradat database.

Tx,
Mohan