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!
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.
As the name of the option suggests it is for table loading only.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.