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.
Did you check this KB article? - http://support.sas.com/kb/57/192.html
Did you check this KB article? - http://support.sas.com/kb/57/192.html
Thanks Anand.. Will try the solution!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.