help on balance size of extract file

[Sharon Zzz]

Hi,

 

I wonder if there is any option to control the file size balance of the extracted out put file.  Here is what I have used to extract file:

 

select getDate();
set temporary option TEMP_EXTRACT_NULL_AS_EMPTY='ON';
set temporary option TEMP_EXTRACT_COLUMN_DELIMITER=':|:';
--set temporary option TEMP_EXTRACT_NAME1='/export/sybase/migrate/tcasaTRD';
set temporary option TEMP_EXTRACT_NAME1='/dbdumps1/ARCHIVE/FOrder2008';
set temporary option TEMP_EXTRACT_NAME2='/dbdumps1/ARCHIVE/FOrder2008_1';
set temporary option TEMP_EXTRACT_NAME3='/dbdumps1/ARCHIVE/FOrder2008_2';
set temporary option TEMP_EXTRACT_NAME4='/dbdumps1/ARCHIVE/FOrder2008_3';
set temporary option TEMP_EXTRACT_NAME5='/dbdumps1/ARCHIVE/FOrder2008_4';
set temporary option TEMP_EXTRACT_NAME6='/dbdumps1/ARCHIVE/FOrder2008_5';
set temporary option TEMP_EXTRACT_NAME7='';
select * from Forder2008;
set temporary option TEMP_EXTRACT_NAME1='';
set temporary option TEMP_EXTRACT_NAME2='';
set temporary option TEMP_EXTRACT_NAME3='';
set temporary option TEMP_EXTRACT_NAME4='';
set temporary option TEMP_EXTRACT_NAME5='';
set temporary option TEMP_EXTRACT_NAME6='';
select getDate();

 

However, it kept on writing all the outputs to the FOder2008 instead of the _1.._5?  Could someone help me with the correct option setting so that it can write to 6 files evenly?

 

thanks.

 

Sharon