Extracting View from DataStudio vs Datastage

[Naren12345babu]

Hi All,

I am trying to extract data from a view.
When I extract the data using SELECT COL1,COL2,COL3 from ViewName in IBM DataStudio, I am getting all records. Lets say 40000

When I use the same query in datastage ODBC COnnector stage, I am getting 32000.

Please help me.

Thanks
Naren

[UCDI]

Did you double check that you are in the same environment / actual database? Is there any limit on the database extract stage?