Page 1 of 1
Executing a sql before ODBC Stage
Posted: Wed Nov 27, 2002 11:26 pm
by asnagaraj
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.
Posted: Wed Nov 27, 2002 11:41 pm
by raviyn
If it is for testing u can use while running the job stop after 1000 rows.
Posted: Wed Nov 27, 2002 11:45 pm
by asnagaraj
Many thanks for that.
Programmer Analyst,
Cognizant,
Chennai.
Posted: Thu Nov 28, 2002 1:25 am
by ray.wurlod
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