Hi all. I tryng execute on teradata a Insert procedure from SAS, but i receive a strange error . I need execute: proc sql; connect to teradata as tera (user=xxxxx password=xxxxx database='ZZZ' tdpid='db1xxxxh.xxx.xxxxx.xxx' MODE=TERADATA ); execute ( INSERT INTO D_REL_PDD_V.VW_RTDM_SOLICITACAO (OID_RTDM_SOLICITACAO, NOM_FLUXO, NOM_TIPO, NOM_SUBTIPO, COD_AGENCIA) SELECT OID_RTDM_SOLICITACAO, NOM_FLUXO, NOM_TIPO, NOM_SUBTIPO, COD_AGENCIA FROM WORK.TESTE_TERA) by tera; execute (commit) by tera; disconnect from tera; quit; This is a error: ERROR: Teradata execute: Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or '(' between the 'FROM' keyword and the 'WORK' keyword. ====================================================== Any ideas? tks a lot!!!
... View more