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
