Re: data structure input parameter for SPROC

<Where is the data structure input parameter?>

Todd,

We pass it as a string the length of the record format. Or could be
length of another data structure. We are just doing a simple eval from
the data structure to the string that is being passed back and forth. The
real key here is to make sure the string and the data structure match in
size or there will be issues.

Here is the code that the SPROC I originally sent looks like. The only
data structure is the ReturnDS. The rest are strings that match a
specific field or the record format.

d INVMST_Read...
d pi
d Parm1 like(invmst_SP.SP_IMINVN)
d Parm2 like(invmst_SP.SP_IMVBCA)
d Parm3 like(invmst_SP)

d IMINVNkey s like(invmst_SP.SP_iminvn)
d IMVBCAKey s like(invmst_SP.SP_imvbca)
d returnDS ds likeds(invmst_SP)
d returnDta s like(invmst_SP)

/free
iminvnkey = Parm1;
imvbcakey = Parm2;
Parm3 = *blanks;

exec sql select *
into :returnDS
from invmst
where iminvn = :iminvnkey and imvbca = :imvbcakey;

Parm3 = returnDS;

/end-free

Hope this helps
Jack
CBK Ltd.