Hi Team,
I am using a bulk load in oracle. But its not working as expected. Giving a below error.
Could you please advise
27 %put pathname = %sysfunc(pathname(work));
pathname = /data/sas/work/Bus/Dev/SAS_work174F00003C0D_clulup0027/SAS_workA06300003C0D_xxxxxx
28 %put getoptionpath = %sysfunc(getoption(work));
getoptionpath = /data/sas/work/Bus/Dev/SAS_work174F00003C0D_clulup0027/SAS_workA06300003C0D_xxxxxxxxx
29
30 proc sql;
31 create table cdwmiusr.&test_prefix.claim_movements_polisy
32 (BULKLOAD=YES
33 BL_DATAFILE="%sysfunc(pathname(work))/polisy.dat"
34 BL_USE_PIPE=NO
35 BL_DELETE_DATAFILE=yes
36 BL_CONTROL = "%sysfunc(pathname(work))/polisy.ctl"
37 BL_LOG = "%sysfunc(pathname(work))/polisy.log"
38 bl_badfile = "%sysfunc(getoption(work))/polisy.bad"
39 bl_discardfile = "%sysfunc(getoption(work))/polisy.dsc"
40
41 )
42 as select * from &test_prefix.claim_movements_polisy;
NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
ERROR: The SQL*Loader utility failed to execute(OS RC=127). Some possible reasons:
-SQLLDR not installed.The cmd assumed is "sqlldr". If it is anything else use BL_SQLLDR_PATH to specify it.
-SQLLDR may be having trouble creating the log file.Make sure you have write permission to the dir where the log is
created(default is current dir) If BL_LOG is specified, make sure the path specified is a valid one.
-Remove any double sets of quotes you may be having-keep only one set.
