Hi
I am trying to read/select records from SQL server and insert/append the same records to a Teradata Table.
When Using Mload Teradata Utility through 'DATA' Step in SAS.
SAS Enterprise Guide crashes when it encounters MLOAD.
SAS Version is SAS 9.4 TS Level 1M3
The Error meassage is
“Read Access Violation APPEND (2)
Exception occurred at (0A67F9EC)”
The Code is
----------------------------------------------------------------------------------------------------
%let uid = xxx;
%let pwd = xxx;
OPTIONS sastrace=",,,d";
LIBNAME DUMMY TERADATA USER= "&uid.@LDAP" PASS="&pwd." mode=ansi server="DUMMY_SERVER" schema="DUMMY_SCHEMA";
LIBNAME DUMMY_SQL ODBC DSN="DUMMY" USER="&uid.@LDAP" PASSWORD="&pwd." SCHEMA="TEST_SCHEMA";
PROC SQL;
CONNECT TO ODBC(DSN="DUMMY" USER="&uid.@LDAP" PASSWORD="&pwd.");
CREATE TABLE WORK.INTERMEDIATE_TABLE AS
SELECT * FROM CONNECTION TO ODBC(SELECT top 2000 COLUMN_1 FROM TEST_TABLE
);
QUIT;
DATA DUMMY.TARGET_TABLE(DBCREATE_TABLE_OPTS="PRIMARY INDEX(COLUMN_1)" MultiLoad=YES
ML_LOG=TEST_LOG ML_CHECKPOINT=500);
SET WORK.INTERMEDIATE_TABLE;
RUN;
--------------------------------------------------------------------------------------------------
Also, tried using TPT Utility too, faced the same issue
DATA DUMMY.TARGET_TABLE(DBCREATE_TABLE_OPTS="PRIMARY INDEX(COLUMN_1)" TPT=YES MultiLoad=YES
ML_LOG=TEST_LOG ML_CHECKPOINT=500);
SET WORK.INTERMEDIATE_TABLE;
RUN;
The OS is windows
Windows Version 6.2.9200
Thanks for the paper, I have gone through this. The problem still persists
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.