Shell Programming and Scripting

#!/usr/bin/awk -f

BEGIN{
        TAB_NAME="INSERT_ONE_" ARGV[ARGC-1] ;
}

if ( $1=="JAM_ONE" && $2=="Starting" ) {
                print "insert into " TAB_NAME " (table_name) values('" $6 "');"

                print "\n";
        }
if ( $1=="JAM_TWO" && $2=="Finishing" ) {
                print "insert into " TAB_NAME " (table_name) values('" $6 "');"

                print "\n";
        }


....some other piece of code..

testing.awk -f x.txt TNAME

awk: testing.awk:32: (FILENAME=./X/X//x.txt FNR=4) fatal: cannot open file `TNAME' for reading (No such file or directory)

for file_name in $xdir/*.done
        do
                if [[ -f $file_name ]]
                then
                testing.awk -f x.txt TNAME >> $command_file
                fi
       done

testing.awk -f x.txt TNAME

awk -f testing.awk x.txt

awk -v "TNAME=blah" '{print "TNAME has value: " TNAME}'

testing.awk -v "TNAME=blah" x.txt