Hello
Here are 3 codes that connect to tera and create data sets.
Why Way2 is not working (error)?
Why Way3 is much quicker than Way1?
What is the name of WAY1 and WAY3?
Is WAY3 called "TERA connector" (AS I underdstand here I must use tera language and cant use sas language (cant use data steps)
IS WAY1 called tera engine? As I understand here I must use sas language and cannpt use tera lanugage
Please note that WAY1 is workking without libaname (I run include statement and porbably here the admin defined it )
/**WAY1- Work 100% but slow**/
proc sql;
create table Way1_VBM374 as
SELECT *
from teradata.VBM374_USED_BRANCH_CUSTOMER as a
where monotonic() <=1000
;
quit;
/**WAY2- error*/
proc sql;
create table Way2_VBM374 as
SELECT top 1000 *
from teradata.VBM374_USED_BRANCH_CUSTOMER
;
quit;
/*30 SELECT top 1000 **/
/* ____*/
/* 22*/
/* 76*/
/*ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, */
/* CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. */
/**/
/*ERROR 76-322: Syntax error, statement will be ignored.*/
/**WAY3- Work 100% and quick**/
proc sql;
connect to teradata (server=dwprod schema=DWP_vall authdomain=TeraDataAuth);
create table Way3_VBM374 as
select * from connection to teradata
(
SELECT top 1000 a.*
from VBM374_USED_BRANCH_CUSTOMER as a
);
disconnect from teradata;
quit ;
... View more
