Executing a sql before ODBC Stage

asnagaraj · Post by **asnagaraj** » Wed Nov 27, 2002 11:26 pm

I need to fetch only around 1000 records from a table that has more than a lakh records.i fetch data from table using ODBC stage.How can i write a prestage sql to achieve my requirement.

Thanks,
Naga.

Programmer Analyst,
Cognizant,
Chennai.

raviyn · Post by **raviyn** » Wed Nov 27, 2002 11:41 pm

If it is for testing u can use while running the job stop after 1000 rows.

asnagaraj · Post by **asnagaraj** » Wed Nov 27, 2002 11:45 pm

Many thanks for that.

Programmer Analyst,
Cognizant,
Chennai.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 28, 2002 1:25 am

If it's a production requirement, use Oracle to isolate the first 1000 rows, for example using ROWNUM (or whatever this is called in Oracle), for example WHERE ROWNUM <= 1000