Pinned topicSOAPHTTPNV on Db2 9.1 zos

‏2013-01-02T16:00:42Z
|Tags:

Answered question
This question has been answered.

Unanswered question
This question has not been answered yet.

I'm calling a webservice from Db2 9.1 on zOS using function SOAPHTTPNV.
The result comes back ok, but the webservice is called multiple times,
once for every row in the resulset (or occurrence of element ROW in the response).
Why is that ?

Re: SOAPHTTPNV on Db2 9.1 zos

since this is a sql function, that is the way it is implemented
if you want it to only be called once, you will need to have all your data in a single row, and that row will be passed to the service.
you have several ways to approach this:
1) write a stored procedure that creates that row
2) write a user defined table function that return a single row table
3) use recursive sql to generate that row

Re: SOAPHTTPNV on Db2 9.1 zos

since this is a sql function, that is the way it is implemented
if you want it to only be called once, you will need to have all your data in a single row, and that row will be passed to the service.
you have several ways to approach this:
1) write a stored procedure that creates that row
2) write a user defined table function that return a single row table
3) use recursive sql to generate that row