Hi,
I have code that works loading & appending a sas data set into oracle table using my 32 bit machine. Just got a new 64 bit machine and now I get errors with the same code.
Errors: SQL*Loader utility failed to execute reasons like not installed; trouble creating log file;remove any double sets of quotes.
I got some other code but I'm having problems with it. I stopped it as it
was going on and on.
Oracle table=TEST_CONSULTS_GA (5 field names)
gamonth is sas data set I want to load with only 181 records;
SAS9.4
Thank you in advance for any help.
80
81
82 libname ora oracle path="(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST =
82 ! scan-szaddb74.ssdc.kp.org)(PORT = 1521))
83 (CONNECT_DATA = (SERVICE_NAME=ARIRDRA_CMI)))" user = "cmimu_t" password
83 ! = XXXXXXXXX;
NOTE: Libref ORA was successfully assigned as follows:
Engine: ORACLE
Physical Name: (DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST =
scan-szaddb74.ssdc.kp.org)(PORT = 1521)) (CONNECT_DATA =
(SERVICE_NAME=ARIRDRA_CMI)))
84
85 Proc Append BASE = ORA."TEST_CONSULTS_GA"n(DBCOMMIT=4000
NOTE: Writing HTML Body file: sashtml2.htm
86 DBFORCE = YES
87 BULKLOAD=YES
88 BL_BADFILE='ora.TEST_CONSULTS_GA.bad'
89 BL_SQLLDR_PATH= 'C:\orant\Ora12\BIN\sqlldr'
90 BL_DATAFILE='C:\users\u937411\test\gamonth.dat'
91 BL_CONTROL='C:\users\u937411\ga.ctl'
92 BL_LOAD_METHOD = Truncate
93 BL_RECOVERABLE = NO
94 BL_OPTIONS = 'PARALLEL=TRUE'
95 BL_LOG= '\gamonth.log) force;
96 run;
ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE APPEND used (Total process time):
real time 15:40.53
cpu time 4.09 seconds
When your using BULKLOAD control, log and data files will be created by default to current directory. Make sure you have write access or specify the right path.
For more information check these: http://support.sas.com/kb/51/802.html
http://support.sas.com/resources/papers/proceedings13/072-2013.pdf In this paper check Bulk Load processing sub-heading
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: