how can we skip the multi load statement if the file is empty

Teradata Applications

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> file2

mload statement with file2


Thanks,
Rajesh

1 REPLY
Enthusiast

Re: how can we skip the multi load statement if the file is empty

grep 'test' file1> file2
if [ `wc -l file2` -gt 0 ] ; then
mload statement with file2
fi;

Basically this checks the file 'file2' has at least one row - you cold also use onee of the other wc options to check for characters if your file has a data row without any text.

Check 'man wc' for all the options.