DSXchange

Hi,
I am using Oracle Enterprise stage to read data from Oracle database.
Do we have any parameter/Env Variable when we can control the arraysize within datastage relative to select operations to do bulk collects to reduce round trips from DS client to/from the db.

Thanks
Aravind

There is no environment variable for Array size.

So, is there a way to specify the same??? I mean is there any way to reduce round trips from DS client to/from the db while fetching the data.