All Forums Tools
rajesh4u4e 4 posts Joined 11/08
24 Nov 2008
how can we skip the multi load statement if the file is empty.

Hi I am new to teradata. I am using Teradata on unix. I am facing some problem. can anyone help me please.this is the problem.how can we skip the multi load statement if the file is empty.grep 'test' file1> file2mload statement with file2Thanks,Rajesh

sRavanSarma 23 posts Joined 11/08
29 Dec 2008

I think you can use unix command to check whether your file is empty or not,if [[ -s filename ]], checks FILE exists and has a size greater than zero....

You must sign in to leave a comment.