Valid in: | DATA and PROC steps (when accessing DBMS data using |
Alias: | SQLLDR_INDEX_OPTION= |
Default: | none |
Requirement: | To specify this option, you must first set BULKLOAD=YES. |
Data source: | Oracle |
See: | BULKLOAD= data set option |
proc sql; connect to oracle ( user=scott pw=tiger path=alien); execute ( drop table blidxopts) by oracle; execute ( create table blidxopts ( empno number, empname varchar2(20))) by oracle; execute ( drop index blidxopts_idx) by oracle; execute ( create index blidxopts_idx on blidxopts ( empno ) ) by oracle; quit; libname x oracle user=scott pw=tiger path=alien; data new; empno=1; empname='one'; output; empno=2; empname='two'; output; run; proc append base= x.blidxopts( bulkload=yes bl_index_options='sorted indexes ( blidxopts_idx)' ) data= new; run;