Hi, i have a script that runs some SQL code and prints the count of records in a table to another file. This file is being used to setup XML code, so first i will echo a tag, then have the tables and then the closing tag. What i wish for is to setup an IF statement around this so that is there is a 0 count of records trhe word PASS will be written to XML and if there are records then FAIL will be written to XML. Sort of like this: <result>PASS</result> <data> records tablename 0 table </data> Or a fail if there are records. I currently only have the data tag. So far i am echoing the tags and sending the ouput to $dir1, i then open sql, run an sql script and send this to $dir1 and then exit sql and echo the next tag. I am trying to egrep but am struggling since i can't use egrep whilst in sql. Please help.

I would pull all of my table row counts first (suppress headers and spool to a file), then process that file to build your XML code, and your logic at that point could see if a row count is zero or not: spool counts.lst select 'emp',  count(*) from emp; select 'dept', count(*) from dept; select 'ord',  count(*) from ord; spool off emp   17 dept    8 ord    21