Re: Using command_line argument
Enquote the date ...
On Wed, 11 Mar 1998 20:22:19 -0600, jjdai@hotmail.com wrote:
>Hi,
> I want to write a script (HP-UX), there is a sql statment to query data
>base , How can i trans the command line argument to sql statement?
>
>Example:
> tst.sh :
> export DBDATE=dmy4/> dbaccess dbname <<EOF
> select * from tbname where buy_date=$1
> EOF>
> run status : $> tst.sh "3/11/1998" result : no rows found
> $> tst.sh '3/11/1998' result : no rows found
> but it does not fit the actural.
>why???
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Ciao,
Manel
-----------------------------------------------------
SEMIC, S.A.
Lleida (Catalunya)
Spain
-----------------------------------------------------
Informix version: Informix SE 5.07 / RDS 4.x
Operating system: Unix SCO V 5.04