Table null is empty

Shell Programming and Scripting
1

hi

I m executing a shell script in which records are to be fetched from a table. If the sql that is running empty result set it is displaying "table null is empty !". I dont want this msg on the standard output. COuld you please help me in this regard

2

Hi,
you could to redirect the error output from the mysql query to /dev/null.

3

could you please how to do that?
i m trying this way
$JAVA icoredp.tools.oracleUnload -c ${CSORDHOME}/conf -d "," -s "$sql2" > errorlog

4

$JAVA icoredp.tools.oracleUnload -c ${CSORDHOME}/conf -d "," -s "$sql2" 2> /dev/null > errorlog

hope it wil work..