title: Xpassing command line argument to sybase query inside a shell script
body: <p>This is my script.</p>
  
  <pre><code>#!/usr/bin/sh
  
  
  isql -UXx -Pxxxxxx &lt;&lt;!
  set nocount on
  use xxxx
  go
  select count(*) from BSC  where bsc='$1'
  go
  !
  
  exit
  </code></pre>
  
  <p>i am executing this script as :</p>
  
  <pre><code>temp2.sh 0000
  </code></pre>
  
  <p>the output is 0.
  but when i execute the query manually then the output is 1 which is correct.
  problem here is the command line argument $1 is not passed to the query.</p>
  
  <p>how could i achieve this?
  I have tried all these possiblities:</p>
  
  <pre><code>bsc='$1'- output is 0
  bsc="$1"- output is 0
  bsc=`$1`- Syntax error
  bsc="'$1'"- output is 0
  </code></pre>
  
  <p>I am using solaris unix and DB is sybase.</p>