Passing a string to a stored procedure
I have a problem. I need to pass a string from powerbuilder to
populate an IN clause in a stored procedure. Is there any easy way to
do this? Here's the syntax below:
create procedure mem_proc_comp_m(eff_dt date, term_dt date,super_grp_number var
char(10))
returning date, date, integer, integer, float, varchar(10);
define a date;
define b date;
define c integer;
define d integer;
define e float;
define f varchar(10);
set pdqpriority low;
FOREACH
select distinct
smember_date.eff_dt,
smember_date.term_dt,
smember_date.mbr_relatn_rollup,
scontract_date.emp_group_ptr,
smember_date.member_db_num,
sdict501.super_grp_number
into a,b,c,d,e,f
from
smember_date, scontract_date, spatient, sdict501
where
(scontract_date.eff_dt <= eff_dt AND (scontract_date.term_dt >
term_dt or scont
ract_date.term_dt is NULL)) and
(smember_date.eff_dt <= eff_dt AND (smember_date.term_dt > term_dt or
smember_d
ate.term_dt is NULL)) and
scontract_date.contract_db_num = smember_date.contract_db_num and
smember_date.member_db_num = spatient.member_db_num and
scontract_date.emp_group_ptr = sdict501.emp_group_ptr and
sdict501.super_grp_number IN(super_grp_number)
return a,b,c,d,e,f WITH RESUME;
end FOREACH;
end procedure;