I tryng execute on teradata a Insert procedure from SAS, but i receive a strange error .
I need execute:
connect to teradata as tera (user=xxxxx password=xxxxx database='ZZZ' tdpid='db1xxxxh.xxx.xxxxx.xxx' );
INSERT INTO D_REL_PDD_V.VW_RTDM_SOLICITACAO
(OID_RTDM_SOLICITACAO, NOM_FLUXO, NOM_TIPO, NOM_SUBTIPO, COD_AGENCIA)
execute (commit) by tera;
disconnect from tera;
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.
tks a lot!!!
WORK is a reserved word. If the Teradata database name is WORK, you need to quote it: "WORK".TESTE_TERA
If WORK is some SAS object, you can't refer to it in a pass-through EXECUTE.