All Forums General
tranquilodf 1 post Joined 03/13
12 Mar 2013
Error in running macro with teradata connection

Greetings!

I'm trying to run a macro during a connection or with teradata using SAS and when I run the code I'm getting the error. What can be the reason? Error in teradata?

/*====================== CODE ===========================*/
RSUBMIT;
 proc sql noprint;
  connect to teradata (user=&Login. password=&Senha. server=tdpvivo schema=p_viedb);
   %MonitorDePassos(3,'INÍCIO DA IMPORTAÇÃO DOS DADOS DO DW',0);
   execute
   (
    create volatile table LINHAS_PARQUE_CRT, no log as
    (
     select
      *
      from
      TABLE_TEMP
    )
    with data
    primary index (ID_LNHA)
    index (ID_PSSA)
    on commit preserve rows
   )by teradata;
   execute (commit) by teradata;
/*   %MonitorDePassos(3,'FIM DA IMPORTAÇÃO DOS DADOS DO DW',0);*/
  /* DESCONECTANDO DO TERADATA*/
  disconnect from teradata;
 quit;
ENDRSUBMIT;

 

/*================ error ============= */
WARNING: Apparent invocation of macro MONITORDEPASSOS not resolved.
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
 

Tks

Att,

Lindolfo Junior

KS42982 137 posts Joined 12/12
14 Mar 2013

I don't think it is Teradata error. ERROR 180-322 is a SAS error.

You must sign in to leave a comment.