arraysize within datastage For Select Statements In Oracle

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
makreddy
Participant
Posts: 21
Joined: Wed Sep 14, 2005 10:40 pm
Location: hyderabad
Contact:

arraysize within datastage For Select Statements In Oracle

Post by makreddy »

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
Aravind
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

There is no environment variable for Array size.
You are the creator of your destiny - Swami Vivekananda
makreddy
Participant
Posts: 21
Joined: Wed Sep 14, 2005 10:40 pm
Location: hyderabad
Contact:

Post by makreddy »

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.
Aravind
Post Reply