ADSO Store Procedure to receive mutiple occurences

yogi.47eie · New User Joined: 16 Aug 2006 Posts: 45 Location: india

Hi Team,
we are developing a Stored procedure to receive set of fields from
external interface(outside of Mainframe).

Ex:

create procedure PP.ADDRESS
(
EMPID CHARACTER(10)
ADDRESSLINE1 CHARACTER(20)
ADDRESSLINE2 CHARACTER(20)
ADDRESSLINE3 CHARACTER(20)
)
external name ADDRESS
protocol ads;

The defined fields will be populated with empID and address lines and processed using ADSO dialogues.

Is that possible to introduce OCCURS clause in this definition ??
Scenario is ,this EMPID can have more than one address & i should be able to receive
more than one addresses at a time.

Note:I have tried to receive ADDRESSLINES as single string CHARACTER(600) and through the program,I am able to handle 10 set of addresses by reading first 60 characters as first occurence of address,next 60 characters as second occurence etc..
Ex:

create procedure PP.ADDRESS
(
EMPID CHARACTER(10)
ADDRESSLINES CHARACTER(600)
)
external name ADDRESS
protocol ads;

Any help from CA ADSO Stored procedure experts is much appreciated.

Rohit Umarjikar · Posted: Fri Aug 21, 2015 8:49 pm

Hello,

yogi.47eie · New User Joined: 16 Aug 2006 Posts: 45 Location: india

Thanks for the suggestion Rohit, ... Yes we are the one defining the Procedure .We tried the possibilities and concluded that array concept is NOT possible within stored procedure.

Yes ,we tried developing the array concept in IDMS work records and its working fine which we tried initially.

Thanks
Yogi