topic Re: Abort JOB - DI Studio 4.6 in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Abort-JOB-DI-Studio-4-6/m-p/143608#M2307 <HTML><HEAD></HEAD><BODY><P>Just want to add, status handling is performed on the result of a transformation, not on a source table as such. Probably you can use it anyway when designing your exceptions, just bare this in mind.</P><P>An exception is if your table you want to check is a look-up table in the Look-up transform, this transformation can explicitly check the status of the source table.</P></BODY></HTML> Thu, 16 Jan 2014 20:35:16 GMT LinusH 2014-01-16T20:35:16Z Abort JOB - DI Studio 4.6 https://communities.sas.com/t5/SAS-Data-Management/Abort-JOB-DI-Studio-4-6/m-p/143606#M2305 <HTML><HEAD></HEAD><BODY><P>I need abort a job if the source table of this job is empty or does not exist. </P><P>Does anyone know how I can do this in DI Studio 4.6 within a job?</P></BODY></HTML> Thu, 16 Jan 2014 19:05:39 GMT https://communities.sas.com/t5/SAS-Data-Management/Abort-JOB-DI-Studio-4-6/m-p/143606#M2305 DavidCaliman 2014-01-16T19:05:39Z Re: Abort JOB - DI Studio 4.6 https://communities.sas.com/t5/SAS-Data-Management/Abort-JOB-DI-Studio-4-6/m-p/143607#M2306 <HTML><HEAD></HEAD><BODY><P>The topic in the 4.6 user guide describes a general approach: <A href="http://support.sas.com/documentation/cdl/en/etlug/65807/HTML/default/viewer.htm#n13t3zm3lp6u7dn15a8k13mak3gh.htm" title="http://support.sas.com/documentation/cdl/en/etlug/65807/HTML/default/viewer.htm#n13t3zm3lp6u7dn15a8k13mak3gh.htm">SAS(R) Data Integration Studio 4.6: User's Guide</A></P><P></P><P>I think you would specify the "Table Does not Exist" condition: <A href="http://support.sas.com/documentation/cdl/en/etlug/65807/HTML/default/viewer.htm#n0k609ykk0xxipn1b1561htnuphp.htm" title="http://support.sas.com/documentation/cdl/en/etlug/65807/HTML/default/viewer.htm#n0k609ykk0xxipn1b1561htnuphp.htm">SAS(R) Data Integration Studio 4.6: User's Guide</A></P></BODY></HTML> Thu, 16 Jan 2014 19:24:10 GMT https://communities.sas.com/t5/SAS-Data-Management/Abort-JOB-DI-Studio-4-6/m-p/143607#M2306 DaveR_SAS 2014-01-16T19:24:10Z Re: Abort JOB - DI Studio 4.6 https://communities.sas.com/t5/SAS-Data-Management/Abort-JOB-DI-Studio-4-6/m-p/143608#M2307 <HTML><HEAD></HEAD><BODY><P>Just want to add, status handling is performed on the result of a transformation, not on a source table as such. Probably you can use it anyway when designing your exceptions, just bare this in mind.</P><P>An exception is if your table you want to check is a look-up table in the Look-up transform, this transformation can explicitly check the status of the source table.</P></BODY></HTML> Thu, 16 Jan 2014 20:35:16 GMT https://communities.sas.com/t5/SAS-Data-Management/Abort-JOB-DI-Studio-4-6/m-p/143608#M2307 LinusH 2014-01-16T20:35:16Z Re: Abort JOB - DI Studio 4.6 https://communities.sas.com/t5/SAS-Data-Management/Abort-JOB-DI-Studio-4-6/m-p/143609#M2308 <HTML><HEAD></HEAD><BODY><P>I solved the problem by using the lookup Exception. </P><P>Thank you very much.</P></BODY></HTML> Fri, 17 Jan 2014 10:57:03 GMT https://communities.sas.com/t5/SAS-Data-Management/Abort-JOB-DI-Studio-4-6/m-p/143609#M2308 DavidCaliman 2014-01-17T10:57:03Z