Hi
How do we get the Output as an Multiple rows from the file from the below Query using Stored procedure right now I am using Array as an Ouput parametrs for the stored procedure but I am not getting any output for the same
FYI : i am using DB2 Stored procedure with Cursor Method.
SELECT DISTINCT BLAAFA,BLAAFB,FSAA19,EKAA9A,EKAA1Q,c6aa9a, c6aala,
c6aalb, c6aale, c6aalf, c6aalc FROM P0PE0FDVC0.peblr03
join C1PE1CVFD.pec6r01 on BLAAFA = C6AAFA
join C1PE3FD.PEFSR01 on FSAA9A = C6AA9A
join P0PE0FDVC0.peekr01 on EKAA9A = FSAA9A
where
FSAA19 = 'XXX' and BLAAFB= 'XXXXXXXXXXXX'
Any Stored Procedure reference or material is also required which are returning more than one rows with Array or any other way to get the output from Stored procedure with Result set
Thanks
Senthil Kumar R.S.