Error not captured in log file in bteq using shell script
I am facing a very wierd problem. I am running two "show sel * from dbname.tablename" query using bteq in a shell script and exporting to a file.
When i run this, i am using a log file to capture the status on the queries in shell script. One of the tables doesn't exist. So, when i run the shell script, i get an error on the unix promt from where i am running this.