Shell Programming and Scripting

#!/bin/ksh

if  [[ ${2} = -n && ${#} = 3 ]] ; then
 
test.sql       
 
fi

test.sql $3

select * from table where col1 = 2234
and col2 = '&1'

select * from table where col1 = '$1' and col2 = 'text'; 
 
Method 1execute: dbaccess database my.sql $var

select * from table col1 in (`cat inputfile`) and col2 = 'text';
 
method 2execute: dbaccess database my.sql

x=111
# here
cat <<EOF
select * from table where col1 = '$x' and col2 = 'text';
EOF

# normal command line expansion. ' ' are inside " " = only characters without special meanings
echo "delete from table where col1 = '$x' and col2 = 'text';"

x=111

dbaccess args <<EOF
select * from table where col1 = '$x' and col2 = 'text';
EOF

dbaccess args <<EOF > output.result.file
select * from table where col1 = '$x' and col2 = 'text';
EOF
#or
echo "delete from table where col1 = '$x' and col2 = 'text'  ;  " | dbaccess args  > output.result.file

dbaccess <<EOF
select * from table col1 in (  $(cat inputfile)  ) and col2 = 'text';
EOF