Start a new topic

get multiple output from procedure


I have db2 server 

i am ruuning a procedure with 3 output result how i can get echo them?

with below example i can just get one result that is 0

@call ${STATUS||(null)||String||noshow dir=out}$ = "HR"."GET_STATUS"(1002,${AF||INT(4)||noshow dir=out}$,${AX||INT(4)||noshow dir=out}$,${GHR||DECIMAL(5)||noshow dir=out}$);

@echo ${STATUS};
@echo ${AF};
@echo ${GHR};
@echo ${AX};


last 3 echos will only echo variable type

what can i do?

1 Comment

I answered the ticket you also submitted. Please follow up via the ticket reply.

Kind Regards,


Login or Signup to post a comment