Code: Select all
#!/bin/bash
# Create a Tally Table.
export SQLFile=/tmp/TallyLoad.sql
echo -n "" > $SQLFile
export DataFile=/tmp/Tally.dat
echo -n "" > $DataFile
export i
for i in {1..100000}
do
echo "${i}" >> $DataFile
done
echo 'DROP TABLE Tally;' >> $SQLFile
echo 'CREATE TABLE Tally(N INT) UNSEGMENTED ALL NODES;' >> $SQLFile
echo 'COPY Tally FROM ' "'""${DataFile}""'" ';' >> $SQLFile
vsql < $SQLFile
rm $SQLFile
rm $DataFile