Re: Passing a variable number of search codes as parameter
You can implement it this way.
create table parameters(param decimal);
insert into parameters values(123456.44); :
:
insert into parameters values(678790.00);
Within your ace program you can have table join and with "IN (select *
from parameters)" you should be able to achieve the same.
Vivek Chaudhary
______________________________ Reply Separator _________________________________
Subject: Re: Passing a variable number of search codes as parameter
Author: benj (benj@linuxstart.com) at internet
Date: 5/8/00 7:28 AM
Danny Di Biase <ddibiase@ozemail.com.au> wrote:
>Comand to run is
> sacego -s -d live modmed49 $parameter1 $parameter2 $parameter3 $parameter4
>
>Parameter 3 contains a variable number of search codes built up from a C
>program
>eg "123456.44", "678790.00", etc
>
>all values separated by commas
.....
> where
> mis.daadmno = patmoprf.dmoadmn
> and patmoprf.mocode in ($param3)
How are you building your $parameter3 string in the shell?
Try building it just as shown above and when done stick a single quote at either
end.
carlos
Currently on hiatus from unemployment.
----------------------
Do you do Linux? :)
Get your FREE @linuxstart.com email address at: http://www.linuxstart.com