RE: Can i set a paremeter ?

I encapsulate the whole thing in a shell file, as: dbaccess datos <<EOF select * from table001 where campo1 = "$1" and campo2 between"$2" and "$2" EOF Make the file (say, file001.sh) executable and then you can do: file001.sh xxxx yyy zzz > -----Original Message----- > From: pako gomez [SMTP:nostoy@latinmail.com] > Sent: Thursday, November 18, 1999 1:10 PM > To: informix-list@iiug.org > Subject: Can i set a paremeter ? > > hello all > i have no much experience with informix SE 4.x > > my question is : > i have an .sql file created with dbaccess with a instruction like : > select * from table001 where campo1 = "xxxx" and campo2 between "yyy" > and "zzz"> > values "xxxx", "yyy" and "zzz" can be parameters ? > > can i execute an instruction like : ? > # dbaccess datos file001.sql "xxx","yyy","zzz"> > have i any way to do some like this ? > > thanks to all of you. > > ________________________________________________________________ > Para respuestas via e-mail quitar de la direccisn "NOSPAM" > To answer via e-mail you must erase "NOSPAM" into e-mail address > fgomez@NOSPAMfreirehnos.es > fcojgome@NOSPAMworldonline.es >

Demus, Alan <demusa@hastings-ent.com> escribi' en el mensaje de noticias 813pkk$6mp$1@news.xmission.com... > > I encapsulate the whole thing in a shell file, as: > > dbaccess datos <<EOF > select * from table001 where campo1 = "$1" and campo2 between> "$2" > and "$2" > EOF > > Make the file (say, file001.sh) executable and then you can do: > > file001.sh xxxx yyy zzz thanks, i try this and all answers.