I am not familiar with bteq and scripting capabilities. I need to write a teradata script that is invoked by a unix shell under cron and checks to see if the data has been updated in a specific table. If the data is updated, either echo a response to the system or write out a response to a flat file like "Yes". If the data is not updated, loop and check again up to 5 times. Any syntax sql is greatly appreciated.