Thanks, i did understand it the second time. I was able to do exacltly what you had suggested. Please find the code below. . I am using NOSTOPERROR option, cause i want it to go through the list and drop the table and delete the control record even if the tables does not exists. It does exactly like that, but on the SAS client i still see the error - Table does not exist..., so how do I ensure that it does not generate any errors when it gets called by my wrapper script. Thanks again for all the guidance. In my case a separate Fastload process was createing the data and my ETL code was moving it into our Datamart and then dropping those tables and corresponding control records. DATA _NULL_; set SAS_Table_Del end=last; if _n_ = 1 then call execute ('proc sql NOERRORSTOP; connect to teradata( TDPID="&TdPid." USER="&TdUid." PASS="&TdPass" QUERY_BAND="&Queryband." );'); call EXECUTE ('execute(DROP TABLE ZMKTTO_MCMADHOC.'||strip(Output_Tbl_Nm)||';) BY TERADATA;'); call EXECUTE ('EXECUTE (COMMIT WORK;) BY TERADATA;'); call execute('execute(DELETE FROM ZMKTTO_MCMADHOC.DB_MNGT_CTL_MCM_NEW where Output_Tbl_Nm = '''||strip(Output_Tbl_Nm)||''' and Prcs_flg = '''||'C'||''';) BY TERADATA;'); call EXECUTE ('EXECUTE (COMMIT WORK;) BY TERADATA;'); if last then call execute('disconnect from teradata; quit;'); run;
... View more