Bulkload = option

[GeorgeSAS]

Hello everyone,

Can I download Oracle table to local SAS with bulkload option? looks It can only upload.

libname orausr oracle path=xxxxxx authdomain='xxxxxxx';

*----this looks work;
data orausr.zips (bulkload=yes);
    set sashelp.zipcode;
run; 
*------------end--;




*----this not work,ERROR 22-7: Invalid option name BULKLOAD.
data need(bulkload=yes);
set orausr.zips;
run;

*------end;

Thanks!

[LinusH]

You are correct. Bulkload is for external databases.
Performance wise, loading a SAS dataset shows similar (sometimes even better) performance as bulkoafing a database.

[GeorgeSAS]

Is there any availability of corresponded downloading option?

[SASKiwi]

If you are trying to improve the performance of read queries then you could try the READBUFF option which can be set as high as 32767 (32K). You will need to experiment with different values to see what works best, if it has any impact at all.

[SASKiwi]

As the name of the option suggests it is for table loading only.