Hi
We have to change the array size and record count from 2000 to minimum no say 1 for every odbc stage.
Is there is any way we can change them globally?
Your help on this is much appreciated.
Regards
Sriram
Changing the Record Count & Array Size
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Add a new environment variable as ARRAYSIZE in admin and default it to '1'.
And in all new jobs development parameterize the arraysize value with the variable defined above so that when we change value at admin level it will propagate to all jobs.
for the existing jobs I think ray suggsted method will be better.
And in all new jobs development parameterize the arraysize value with the variable defined above so that when we change value at admin level it will propagate to all jobs.
for the existing jobs I think ray suggsted method will be better.
--
Swathi Ch
Swathi Ch