Please advise if I have to use different syntax for teradata? Same code works for db2. ERROR: Teradata prepare: Syntax error: expected something between '(' and ')' PROC SQL; CONNECT TO teradata as APRTERA (user="xxxx" PASSWORD="xxxxx" tdpid=APRTERA mode=teradata); CREATE TABLE MYLIB.SSICORE (COMPRESS=YES) AS SELECT * FROM CONNECTION TO APRTERA ( SELECT RAND() as IDX, M.PROD_ACCT_NO, M.ACCESS_MEDIUM_NO, M.ACCT_CYCL_NO, M.GRP_CD, M.GRP_TRANSPARENT_IN, M.PAPER_SUPRS_IN, L.CUST_LANGUAGE_CD, G.GROUP_NM FROM DWTFORMCRDT0.ACCT_MED_CHG&MONTH_END AS M INNER JOIN DWTFORMCRDT0.ACCT_LOW_CHG&MONTH_END AS L ON M.PROD_ACCT_NO=L.PROD_ACCT_NO AND M.APL_SFX_NO = 0 AND L.APL_SFX_NO = 0 AND M.GRP_TRANSPARENT_IN = 'N' LEFT JOIN DWTFORMCRDT0.GROUP AS G ON M.GRP_CD=G.GROUP_CD ORDER BY M.PROD_ACCT_NO,IDX FETCH FIRST 100000 ROWS ONLY ); DISCONNECT FROM APRTERA; QUIT; RUN; Log PROC SQL; 25 connect to &aprtera; SYMBOLGEN: Macro variable APRTERA resolves to teradata as aprtera (user=xxxxx password="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" tdpid=aprtera mode=teradata ) 26 CREATE TABLE MYLIB.SSICORE (COMPRESS=YES) AS SELECT * FROM CONNECTION TO APRTERA ( 27 SELECT RAND( ) as IDX, 28 M.PROD_ACCT_NO, 29 M.ACCESS_MEDIUM_NO, 30 M.ACCT_CYCL_NO, 31 M.GRP_CD, 32 M.GRP_TRANSPARENT_IN, 33 M.PAPER_SUPRS_IN, 34 L.CUST_LANGUAGE_CD, 35 G.GROUP_NM SYMBOLGEN: Macro variable MONTH_END resolves to _1604 36 FROM DWTFORMCRDT0.ACCT_MED_CHG&MONTH_END M SYMBOLGEN: Macro variable MONTH_END resolves to _1604 37 ,DWTFORMCRDT0.ACCT_LOW_CHG&MONTH_END L 38 ON M.PROD_ACCT_NO=L.PROD_ACCT_NO 39 AND M.APL_SFX_NO = 0 40 AND L.APL_SFX_NO = 0 41 AND M.GRP_TRANSPARENT_IN = 'N' 42 LEFT JOIN DWTFORMCRDT0.GROUP AS G 43 ON M.GRP_CD=G.GROUP_CD 44 ORDER BY M.PROD_ACCT_NO,IDX FETCH FIRST 100000 ROWS ONLY 45 ); ERROR: Teradata prepare: Syntax error: expected something between '(' and ')'. SQL statement was: SELECT RAND( ) as IDX, M.PROD_ACCT_NO, M.ACCESS_MEDIUM_NO, M.ACCT_CYCL_NO, M.GRP_CD, M.GRP_TRANSPARENT_IN, M.PAPER_SUPRS_IN, L.CUST_LANGUAGE_CD, G.GROUP_NM FROM DWTFORMCRDT0.ACCT_MED_CHG_1604 M ,DWTFORMCRDT0.ACCT_LOW_CHG_1604 L ON M.PROD_ACCT_NO=L.PROD_ACCT_NO AND M.APL_SFX_NO = 0 AND L.APL_SFX_NO = 0 AND M.GRP_TRANSPARENT_IN = 'N' LEFT JOIN DWTFORMCRDT0.GROUP AS G ON 2 The SAS System 16:46 Thursday, June 1, 2017 M.GRP_CD=G.GROUP_CD ORDER BY M.PROD_ACCT_NO,IDX FETCH FIRST 100000 ROWS ONLY. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 46 DISCONNECT FROM APRTERA; NOTE: Statement not executed due to NOEXEC option.
... View more
