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

Tools

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.

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