|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/24/2008 10:31:45 PM
Posts: 4,
Visits: 4
|
|
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
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/9/2009 2:15:41 PM
Posts: 25,
Visits: 115
|
|
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.
|
|
|
|