Start a new topic

get multiple output from procedure

hi

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,

Hans


Login or Signup to post a comment