Hi
I am getting below error while using SQL pass-through, but does not throw error if I use Implicit LIBNAME method.
ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine
code:
proc sql;
connect to teradata as tera_
(user=TEST_USER pass=Test_pa$$ mode=teradata schema=TESTDB server=dbserver );
create table d_count as select * from connection to tera_
(select count(*) as count_rows from TESTDB.SAMPLE_TABLE
) ;
quit;
there are no special columns in Teradata table,below is the definition of the same table:
CREATE MULTISET TABLE dbase.TEST_NEWFILETINVLSTAT_TEST ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( ID_1 INTEGER NOT NULL, DOC_INVALID_STATUS VARCHAR(20) CHARACTER SET LATIN CASESPECIFIC NOT NULL, FILE_DATE DATE FORMAT 'YYYY-MM-DD' NOT NULL, PROCESS_DATE DATE FORMAT 'YYYY-MM-DD' NOT NULL, RUNDATE DATE FORMAT 'YYYY-MM-DD' NOT NULL, UNI_ID DECIMAL(13,0) NOT NULL) PRIMARY INDEX ( ID_1 ,DOC_INVALID_STATUS );
Any help is appreciated:
Thank you
... View more
