#parameter testing....
# three parameter need to input into------------------------------------------------------
fileno=4
blokst=101004
bloked=101005
datarw=rn3c2nc2t5c
rm block_list 2>/dev/null
rm bbed_table 2>/dev/null
rm bbed_record 2>/dev/null
echo "Get the data use bbed:"
for((i=$blokst;i<=$bloked;i++));do
#output blockno into blocklist
./bbed_blkno "$fileno" " $i" 2>/dev/null
done;
for bkno in `cat block_list`
do
echo "fileno:$fileno " "blockno: $bkno"
bbed parfile=bbed.par password=blockedit <<EOF >bbed0_rowno
set dba $fileno,$bkno
p kdbhnrow
exit
EOF
bbed_rowno=`cat bbed0_rowno|grep kdbhnrow |awk '{print $5}'`
block_rowid=$(($bbed_rowno-1))
for((i=$block_rowid;i>=0;i--));do
bbed parfile=bbed.par password=blockedit <<EOF >>bbed_record
set dba $fileno,$bkno
p *kdbr[$i]
x /$datarw
exit
EOF
done;
more bbed_record|grep col|awk '{print $1 $2 ":" $4}'|awk -F @ '{print $1}' > bbed_table
#end the for statment--------------------------------------------------------------
done;
#rm the temp file-----------------------------------------------------------------
rm bbed_record 2>/dev/null
rm block_list 2>/dev/null
rm *rowno 2>/dev/null
rm bbed_datarecord 2>/dev/null
#format the data----it is very slow ,use better c or c++ dev the code-------------
echo "format data----------"
for bkrow in `cat bbed_table`
do
if [ "$bkrow" == "cols" ];then
echo $rowdata >>bbed_datarecord
rowdata=''
fi
bkrow1=`echo $bkrow|awk -F : '{print $2}'`
rowdata="$rowdata""$bkrow1""|"
done
rm bbed_table 2>/dev/null
echo "Format data completed pls check bbed_datarecord file"
# three parameter need to input into------------------------------------------------------
fileno=4
blokst=101004
bloked=101005
datarw=rn3c2nc2t5c
rm block_list 2>/dev/null
rm bbed_table 2>/dev/null
rm bbed_record 2>/dev/null
echo "Get the data use bbed:"
for((i=$blokst;i<=$bloked;i++));do
#output blockno into blocklist
./bbed_blkno "$fileno" " $i" 2>/dev/null
done;
for bkno in `cat block_list`
do
echo "fileno:$fileno " "blockno: $bkno"
bbed parfile=bbed.par password=blockedit <<EOF >bbed0_rowno
set dba $fileno,$bkno
p kdbhnrow
exit
EOF
bbed_rowno=`cat bbed0_rowno|grep kdbhnrow |awk '{print $5}'`
block_rowid=$(($bbed_rowno-1))
for((i=$block_rowid;i>=0;i--));do
bbed parfile=bbed.par password=blockedit <<EOF >>bbed_record
set dba $fileno,$bkno
p *kdbr[$i]
x /$datarw
exit
EOF
done;
more bbed_record|grep col|awk '{print $1 $2 ":" $4}'|awk -F @ '{print $1}' > bbed_table
#end the for statment--------------------------------------------------------------
done;
#rm the temp file-----------------------------------------------------------------
rm bbed_record 2>/dev/null
rm block_list 2>/dev/null
rm *rowno 2>/dev/null
rm bbed_datarecord 2>/dev/null
#format the data----it is very slow ,use better c or c++ dev the code-------------
echo "format data----------"
for bkrow in `cat bbed_table`
do
if [ "$bkrow" == "cols" ];then
echo $rowdata >>bbed_datarecord
rowdata=''
fi
bkrow1=`echo $bkrow|awk -F : '{print $2}'`
rowdata="$rowdata""$bkrow1""|"
done
rm bbed_table 2>/dev/null
echo "Format data completed pls check bbed_datarecord file"